SAP Table OIFSPBL
Physical Location - Master Data
OIFSPBL (Physical Location - Master Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link OIFSPBL to other SAP tables.
OIFSPBL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| PBLNR | Business location identifier (IS-Oil MRN) | OIF_PBLNR | CHAR | 10 | 0 | |||||||||
| NAME1 | Internal name field | OIF_PBNAM1 | CHAR | 35 | 0 | |||||||||
| A1_SGRNDB | Land Register Number (IS-Oil MRN Demo APPEND) | OIF_SGRNDB | NUMC | 8 | 0 | |||||||||
| A1_UTILTP | Usage Type of Property (IS-Oil MRN Demo APPEND) | OIF_UTILTP | CHAR | 2 | 0 | |||||||||
| A1_GRTYP | Property Type (IS-Oil MRN Demo APPEND) | OIF_GRTYP | NUMC | 3 | 0 | |||||||||
| A1_GRQAL | Quality of Business Location (IS-Oil MRN Demo APPEND) | OIF_GRQAL | NUMC | 3 | 0 | |||||||||
| A1_GRFRM | Property Type (IS-Oil MRN Demo APPEND) | OIF_GRFRM | NUMC | 3 | 0 | |||||||||
| A1_GRGZS | Overall Condition of Property (IS-Oil MRN Demo APPEND) | OIF_GRGZS | NUMC | 3 | 0 | |||||||||
| A1_DAKTB | Date Active in Inventory (IS-Oil MRN Demo APPEND) | OIF_DAKTB | DATS | 8 | 0 | |||||||||
| PBLTYP | Business Location Type (IS-Oil MRN) | OIF_PBLTYP | OIFSPBLT | CHAR | 4 | 0 | ||||||||
| ADDRNUM | Address No. in ADRC | OIF_ADNUM | OIFSMCADDR | CHAR | 10 | 0 | ||||||||
| ERDAT | Date Record Created on (Date) | OIF_ERDAT | DATS | 8 | 0 | |||||||||
| ERZEIT | Time Record Created at (Time) | OIF_ERZEIT | TIMS | 6 | 0 | |||||||||
| ERNAM | User who Created Record | OIF_ERNAM | CHAR | 12 | 0 | |||||||||
| AEDAT | Date Record Changed on (Date) | OIF_AEDAT | DATS | 8 | 0 | |||||||||
| AEZEIT | Time when Record Was Changed | OIF_AEZEIT | TIMS | 6 | 0 | |||||||||
| AENAM | User who Changed Record | OIF_AENAM | CHAR | 12 | 0 | |||||||||
| BLOIND | Block Indicator | OIF_BLOIND | CHAR | 1 | 0 |
Possible values
|
||||||||
| DELIND | Deletion indicator | OIF_DELIND | CHAR | 1 | 0 |
Possible values
|
||||||||
| BLCODE | Business Location Blocking Indicator (IS-Oil MRN) | OIF_BLCD | OIFSBLCD | CHAR | 2 | 0 | ||||||||
| OBJNR | Object number | J_OBJNR | CHAR | 22 | 0 | |||||||||
| BRAND | Location brand | OIRB_BRAND | OIRBBRAND | CHAR | 5 | 0 | ||||||||
| LOCVALUE | Relative location value | OIRB_VAL | OIRBPBLVAL | CHAR | 2 | 0 | ||||||||
| LOCVDIFF | Location value differentiator | OIRB_LOCVDIFF | OIRBPBLVALD | CHAR | 2 | 0 | ||||||||
| LOCAA | Location area assignment | OIRB_LAA | OIRBLAA | CHAR | 5 | 0 | ||||||||
| LOCMP | SSR Pricing - Margins procedure assigned to this location | OIRC_KALKS | OIRCTVKD | CHAR | 1 | 0 | ||||||||
| PCGROUP | Process control group | OIRA_PCG | OIRAPCG | CHAR | 10 | 0 | ||||||||
| AUTGR | Authorization group | OIRB_AUTGR | CHAR | 4 | 0 | |||||||||
| VALGP | SSR PC: Upload validation group | OIREVALGROUP | OIREVALGP | CHAR | 2 | 0 | ||||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||
| OIRIPGRP | SSR SD/FI Invoice posting group | OIRI_PGRP | CHAR | 2 | 0 | |||||||||
| CONVGR | SSR Interface conversion group definition (IS-Oil, SSR) | OIRH_CONVGR | OIRHCVGRDEFC | CHAR | 4 | 0 | ||||||||
| LOGSYS | Logical system for EDI | OIRH_LOGSYS | TBDLS | CHAR | 10 | 0 | ||||||||
| TPLST | Transportation planning point | TPLST | TTDS | CHAR | 4 | 0 | ||||||||
| TPLST_TXT | Description of transportation planning point | TPLST_TXT | CHAR | 20 | 0 | |||||||||
| LONGITUDE | Geo location longitude | GEOLON | DEC | 15 | 12 | |||||||||
| LATITUDE | Geo location latitude | GEOLAT | DEC | 15 | 12 | |||||||||
| TIME_TO_ADD | Duration to Add at Base Location (in hours:minutes) | OIO_TIME_TO_ADD | DEC | 11 | 0 | |||||||||
| AVRG_STAYT | Duration of Stay at Remote Location (in hours:minutes) | OIO_AVRG_STAYT | DEC | 11 | 0 | |||||||||
| KNOTE | Transportation Connection Points | KNOTE | TVKN | CHAR | 10 | 0 | ||||||||
| KNOTE_BEZ | Node name | KNOTE_BEZ | CHAR | 30 | 0 | |||||||||
| ROUTE | Shipment route | ROUTR | TVRO | CHAR | 6 | 0 | ||||||||
| TXROU | Description of Route | ROUTBEZ | CHAR | 40 | 0 | |||||||||
| R_CON_POINT | Radiobutton for connection point in RLM VMIS location | OIO_VMIS_C | CHAR | 1 | 0 |
Possible values
|
||||||||
| R_ROUTE | Radiobutton for shipment route in RLM VMIS location | OIO_VMIS_R | CHAR | 1 | 0 |
Possible values
|
||||||||
| XCOOR | X coordinate | OIRB_COOR_X | FLTP | 16 | 16 | |||||||||
| YCOOR | Y coordinate | OIRB_COOR_Y | FLTP | 16 | 16 | |||||||||
OIFSPBL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| OIFSPBL | ADDRNUM | OIFSPBL | ADDRNUM | OIFSMCADDR | Link Table Between OIFSPBL and ADRC for Matchcode | ADDRNUM |
| OIFSPBL | ADDRNUM | OIFSPBL | MANDT | OIFSMCADDR | Link Table Between OIFSPBL and ADRC for Matchcode | MANDT |
| OIFSPBL | ADDRNUM | OIFSPBL | PBLNR | OIFSMCADDR | Link Table Between OIFSPBL and ADRC for Matchcode | PBLNR |
| OIFSPBL | BLCODE | OIFSPBL | MANDT | OIFSBLCD | Blocking Indicator for Business Locations | MANDT |
| OIFSPBL | BLCODE | OIFSPBL | BLCODE | OIFSBLCD | Blocking Indicator for Business Locations | BLCODE |
| OIFSPBL | BRAND | OIFSPBL | BRAND | OIRBBRAND | Location Brand (IS-OIL SSR) | BRANDID |
| OIFSPBL | BRAND | * | OIRBBRAND | Location Brand (IS-OIL SSR) | MANDT | |
| OIFSPBL | BUKRS | * | T001 | Company Codes | MANDT | |
| OIFSPBL | BUKRS | OIFSPBL | BUKRS | T001 | Company Codes | BUKRS |
| OIFSPBL | CONVGR | * | OIRHCVGRDEFC | Conversion Group Definitions(IS-Oil, SSR) | MANDT | |
| OIFSPBL | CONVGR | OIFSPBL | CONVGR | OIRHCVGRDEFC | Conversion Group Definitions(IS-Oil, SSR) | CONVGR |
| OIFSPBL | KNOTE | OIFSPBL | MANDT | TVKN | Routes: Transportation Connection Points | MANDT |
| OIFSPBL | KNOTE | OIFSPBL | KNOTE | TVKN | Routes: Transportation Connection Points | KNOTE |
| OIFSPBL | LOCAA | SY | MANDT | OIRBLAA | Location area assignment (IS-OIL SSR) | MANDT |
| OIFSPBL | LOCAA | ' ' | OIRBLAA | Location area assignment (IS-OIL SSR) | RNBT | |
| OIFSPBL | LOCAA | OIFSPBL | LOCAA | OIRBLAA | Location area assignment (IS-OIL SSR) | LOCAA |
| OIFSPBL | LOCAA | * | OIRBLAA | Location area assignment (IS-OIL SSR) | LOCAACTRY | |
| OIFSPBL | LOCMP | OIFSPBL | LOCMP | OIRCTVKD | SSR Pricing - Location Margin Procedure | KALKS |
| OIFSPBL | LOCMP | * | OIRCTVKD | SSR Pricing - Location Margin Procedure | MANDT | |
| OIFSPBL | LOCVALUE | * | OIRBPBLVAL | Relative Location Value (IS-OIL SSR) | MANDT | |
| OIFSPBL | LOCVALUE | OIFSPBL | LOCVALUE | OIRBPBLVAL | Relative Location Value (IS-OIL SSR) | LOCVALUE |
| OIFSPBL | LOCVDIFF | * | OIRBPBLVALD | Location Value differentiator (IS-OIL SSR) | MANDT | |
| OIFSPBL | LOCVDIFF | OIFSPBL | LOCVDIFF | OIRBPBLVALD | Location Value differentiator (IS-OIL SSR) | LOCVDIFF |
| OIFSPBL | LOGSYS | OIFSPBL | LOGSYS | TBDLS | Logical system | LOGSYS |
| OIFSPBL | MANDT | OIFSPBL | MANDT | T000 | Clients | MANDT |
| OIFSPBL | PBLTYP | OIFSPBL | MANDT | OIFSPBLT | Physical Business Location Type | MANDT |
| OIFSPBL | PBLTYP | OIFSPBL | PBLTYP | OIFSPBLT | Physical Business Location Type | PBLTYP |
| OIFSPBL | PCGROUP | * | OIRAPCG | Process Control Group (IS-OIL SSR) | CLIENT | |
| OIFSPBL | PCGROUP | OIFSPBL | PCGROUP | OIRAPCG | Process Control Group (IS-OIL SSR) | PCGROUP |
| OIFSPBL | ROUTE | OIFSPBL | MANDT | TVRO | Routes | MANDT |
| OIFSPBL | ROUTE | OIFSPBL | ROUTE | TVRO | Routes | ROUTE |
| OIFSPBL | TPLST | OIFSPBL | MANDT | TTDS | Organizational Unit: Transportation Scheduling Point | MANDT |
| OIFSPBL | TPLST | OIFSPBL | TPLST | TTDS | Organizational Unit: Transportation Scheduling Point | TPLST |
| OIFSPBL | VALGP | * | OIREVALGP | SSR PC: Upload Validation Group | MANDT | |
| OIFSPBL | VALGP | OIFSPBL | VALGP | OIREVALGP | SSR PC: Upload Validation Group | VALGP |
