SAP table OIFSPBL (Physical Location - Master Data)
SAP table OIFSPBL has 2 primary key fields being MANDT,PBLNR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| PBLNR | Business location identifier (IS-Oil MRN) | CHAR | 10 | 0 | OIF_PBLNR | ||
| NAME1 | Internal name field | CHAR | 35 | 0 | OIF_PBNAM1 | ||
| PBLTYP | Business Location Type (IS-Oil MRN) | CHAR | 4 | 0 | OIFSPBLT | OIF_PBLTYP | |
| ADDRNUM | Address No. in ADRC | CHAR | 10 | 0 | OIFSMCADDR | OIF_ADNUM | |
| ERDAT | Date Record Created on (Date) | DATS | 8 | 0 | OIF_ERDAT | ||
| ERZEIT | Time Record Created at (Time) | TIMS | 6 | 0 | OIF_ERZEIT | ||
| ERNAM | User who Created Record | CHAR | 12 | 0 | OIF_ERNAM | ||
| AEDAT | Date Record Changed on (Date) | DATS | 8 | 0 | OIF_AEDAT | ||
| AEZEIT | Time when Record Was Changed | TIMS | 6 | 0 | OIF_AEZEIT | ||
| AENAM | User who Changed Record | CHAR | 12 | 0 | OIF_AENAM | ||
| BLOIND | Block Indicator | CHAR | 1 | 0 | OIF_BLOIND | ||
| DELIND | Deletion indicator | CHAR | 1 | 0 | OIF_DELIND | ||
| BLCODE | Business Location Blocking Indicator (IS-Oil MRN) | CHAR | 2 | 0 | OIFSBLCD | OIF_BLCD | |
| OBJNR | Object number | CHAR | 22 | 0 | * | J_OBJNR | |
| BRAND | Location brand | CHAR | 5 | 0 | OIRBBRAND | OIRB_BRAND | |
| LOCVALUE | Relative location value | CHAR | 2 | 0 | OIRBPBLVAL | OIRB_VAL | |
| LOCVDIFF | Location value differentiator | CHAR | 2 | 0 | OIRBPBLVALD | OIRB_LOCVDIFF | |
| LOCAA | Location area assignment | CHAR | 5 | 0 | OIRBLAA | OIRB_LAA | |
| LOCMP | SSR Pricing - Margins procedure assigned to this location | CHAR | 1 | 0 | OIRCTVKD | OIRC_KALKS | |
| PCGROUP | Process control group | CHAR | 10 | 0 | OIRAPCG | OIRA_PCG | |
| AUTGR | Authorization group | CHAR | 4 | 0 | OIRB_AUTGR | ||
| VALGP | SSR PC: Upload validation group | CHAR | 2 | 0 | OIREVALGP | OIREVALGROUP | |
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| OIRIPGRP | SSR SD/FI Invoice posting group | CHAR | 2 | 0 | OIRI_PGRP | ||
| CONVGR | SSR Interface conversion group definition (IS-Oil, SSR) | CHAR | 4 | 0 | OIRHCVGRDEFC | OIRH_CONVGR | |
| LOGSYS | Logical system for EDI | CHAR | 10 | 0 | TBDLS | OIRH_LOGSYS |
OIFSPBL foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 OIFSPBL | ADDRNUM | OIFSMCADDR | Link Table Between OIFSPBL and ADRC for Matchcode | MANDT |
| 0 OIFSPBL | ADDRNUM | OIFSMCADDR | Link Table Between OIFSPBL and ADRC for Matchcode | PBLNR |
| 1 OIFSPBL | BLCODE | OIFSBLCD | Blocking Indicator for Business Locations | MANDT |
| 1 OIFSPBL | BLCODE | OIFSBLCD | Blocking Indicator for Business Locations | BLCODE |
| 0 OIFSPBL | BRAND | OIRBBRAND | Location Brand (IS-OIL SSR) | MANDT |
| 1 OIFSPBL | BUKRS | T001 | Company Codes | BUKRS |
| 0 OIFSPBL | CONVGR | OIRHCVGRDEFC | Conversion Group Definitions(IS-Oil, SSR) | MANDT |
| 0 OIFSPBL | CONVGR | OIRHCVGRDEFC | Conversion Group Definitions(IS-Oil, SSR) | CONVGR |
| 1 OIFSPBL | LOCAA | OIRBLAA | Location area assignment (IS-OIL SSR) | MANDT |
| 1 OIFSPBL | LOCAA | OIRBLAA | Location area assignment (IS-OIL SSR) | RNBT |
| 1 OIFSPBL | LOCAA | OIRBLAA | Location area assignment (IS-OIL SSR) | LOCAACTRY |
| 0 OIFSPBL | LOCMP | OIRCTVKD | SSR Pricing - Location Margin Procedure | MANDT |
| 1 OIFSPBL | LOCVALUE | OIRBPBLVAL | Relative Location Value (IS-OIL SSR) | MANDT |
| 1 OIFSPBL | LOCVALUE | OIRBPBLVAL | Relative Location Value (IS-OIL SSR) | LOCVALUE |
| 0 OIFSPBL | LOCVDIFF | OIRBPBLVALD | Location Value differentiator (IS-OIL SSR) | MANDT |
| 0 OIFSPBL | LOCVDIFF | OIRBPBLVALD | Location Value differentiator (IS-OIL SSR) | LOCVDIFF |
| 1 OIFSPBL | LOGSYS | TBDLS | Logical system | LOGSYS |
| 0 OIFSPBL | MANDT | T000 | Clients | MANDT |
| 1 OIFSPBL | PBLTYP | OIFSPBLT | Physical Business Location Type | MANDT |
| 1 OIFSPBL | PBLTYP | OIFSPBLT | Physical Business Location Type | PBLTYP |
| 0 OIFSPBL | PCGROUP | OIRAPCG | Process Control Group (IS-OIL SSR) | PCGROUP |
| 1 OIFSPBL | VALGP | OIREVALGP | SSR PC: Upload Validation Group | MANDT |
| 1 OIFSPBL | VALGP | OIREVALGP | SSR PC: Upload Validation Group | VALGP |