SAP Table OIFSPBL
Physischer Standort - Stammdaten
Unsere Literaturempfehlung
SAP – Der technische Einstieg: SAP-Technologien und Konzepte
Sind Sie neu in der SAP-Welt und möchten schnell mitreden? Mit diesem Buch finden Sie sich erfolgreich im SAP-Umfeld zurecht! Sie steigen direkt in die Konzepte und Technologien der SAP-Software ein und lernen die unterschiedlichen Systeme und Prozesse kennen. Schritt für Schritt zeigen die Autoren Ihnen die wichtigsten technischen Aufgaben und die Zusammenhänge zwischen den Objekten. Dank der vielen Beispiele und Abbildungen finden Sie sich schnell im SAP-Umfeld zurecht und können direkt in SAP ERP oder SAP S/4HANA anfangen.
Bei amazon.de ansehen →
The table OIFSPBL (Physischer Standort - Stammdaten) is a standard table in SAP ERP. It belongs to the package OILF.
Technical Information
| Table | OIFSPBL |
| Short Text | Physischer Standort - Stammdaten |
| Package | OILF |
| Table Type | Transparent Table |
Fields for Table OIFSPBL
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| PBLNR | ✔ | Business location identifier (IS-Oil MRN) | OIF_PBLNR | CHAR | 10 | |
| NAME1 | Internal name field | OIF_PBNAM1 | CHAR | 35 | ||
| A1_SGRNDB | Land Register Number (IS-Oil MRN Demo APPEND) | OIF_SGRNDB | NUMC | 8 | ||
| A1_UTILTP | Usage Type of Property (IS-Oil MRN Demo APPEND) | OIF_UTILTP | CHAR | 2 | ||
| A1_GRTYP | Property Type (IS-Oil MRN Demo APPEND) | OIF_GRTYP | NUMC | 3 | ||
| A1_GRQAL | Quality of Business Location (IS-Oil MRN Demo APPEND) | OIF_GRQAL | NUMC | 3 | ||
| A1_GRFRM | Property Type (IS-Oil MRN Demo APPEND) | OIF_GRFRM | NUMC | 3 | ||
| A1_GRGZS | Overall Condition of Property (IS-Oil MRN Demo APPEND) | OIF_GRGZS | NUMC | 3 | ||
| A1_DAKTB | Date Active in Inventory (IS-Oil MRN Demo APPEND) | OIF_DAKTB | DATS | 8 | ||
| PBLTYP | Business Location Type (IS-Oil MRN) | OIF_PBLTYP | CHAR | 4 | OIFSPBLT | |
| ADDRNUM | Address No. in ADRC | OIF_ADNUM | CHAR | 10 | OIFSMCADDR | |
| ERDAT | Date Record Created on (Date) | OIF_ERDAT | DATS | 8 | ||
| ERZEIT | Time Record Created at (Time) | OIF_ERZEIT | TIMS | 6 | ||
| ERNAM | User who Created Record | OIF_ERNAM | CHAR | 12 | ||
| AEDAT | Date Record Changed on (Date) | OIF_AEDAT | DATS | 8 | ||
| AEZEIT | Time when Record Was Changed | OIF_AEZEIT | TIMS | 6 | ||
| AENAM | User who Changed Record | OIF_AENAM | CHAR | 12 | ||
| BLOIND | Block Indicator | OIF_BLOIND | CHAR | 1 | ||
| DELIND | Deletion indicator | OIF_DELIND | CHAR | 1 | ||
| BLCODE | Business Location Blocking Indicator (IS-Oil MRN) | OIF_BLCD | CHAR | 2 | OIFSBLCD | |
| OBJNR | Object number | J_OBJNR | CHAR | 22 | * | |
| BRAND | Location brand | OIRB_BRAND | CHAR | 5 | OIRBBRAND | |
| LOCVALUE | Relative location value | OIRB_VAL | CHAR | 2 | OIRBPBLVAL | |
| LOCVDIFF | Location value differentiator | OIRB_LOCVDIFF | CHAR | 2 | OIRBPBLVALD | |
| LOCAA | Location area assignment | OIRB_LAA | CHAR | 5 | OIRBLAA | |
| LOCMP | SSR Pricing - Margins procedure assigned to this location | OIRC_KALKS | CHAR | 1 | OIRCTVKD | |
| PCGROUP | Process control group | OIRA_PCG | CHAR | 10 | OIRAPCG | |
| AUTGR | Authorization group | OIRB_AUTGR | CHAR | 4 | ||
| VALGP | SSR PC: Upload validation group | OIREVALGROUP | CHAR | 2 | OIREVALGP | |
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | |
| OIRIPGRP | SSR SD/FI Invoice posting group | OIRI_PGRP | CHAR | 2 | ||
| CONVGR | SSR Interface conversion group definition (IS-Oil, SSR) | OIRH_CONVGR | CHAR | 4 | OIRHCVGRDEFC | |
| LOGSYS | Logical system for EDI | OIRH_LOGSYS | CHAR | 10 | TBDLS | |
| TPLST | Transportation planning point | TPLST | CHAR | 4 | TTDS | |
| TPLST_TXT | Description of transportation planning point | TPLST_TXT | CHAR | 20 | ||
| LONGITUDE | Geo location longitude | GEOLON | DEC | 15 | ||
| LATITUDE | Geo location latitude | GEOLAT | DEC | 15 | ||
| TIME_TO_ADD | Duration to Add at Base Location (in hours:minutes) | OIO_TIME_TO_ADD | DEC | 11 | ||
| AVRG_STAYT | Duration of Stay at Remote Location (in hours:minutes) | OIO_AVRG_STAYT | DEC | 11 | ||
| KNOTE | Transportation Connection Points | KNOTE | CHAR | 10 | TVKN | |
| KNOTE_BEZ | Node name | KNOTE_BEZ | CHAR | 30 | ||
| ROUTE | Shipment route | ROUTR | CHAR | 6 | TVRO | |
| TXROU | Description of Route | ROUTBEZ | CHAR | 40 | ||
| R_CON_POINT | Radiobutton for connection point in RLM VMIS location | OIO_VMIS_C | CHAR | 1 | ||
| R_ROUTE | Radiobutton for shipment route in RLM VMIS location | OIO_VMIS_R | CHAR | 1 | ||
| XCOOR | X coordinate | OIRB_COOR_X | FLTP | 16 | ||
| YCOOR | Y coordinate | OIRB_COOR_Y | FLTP | 16 |