OIFSPBLT
Physical Business Location TypeExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table OIFSPBLT.
SAP table OIFSPBLT has 2 primary key fields: MANDT,PBLTYP.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
OIFSPBLT fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |
|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Key PBLTYP | Business Location Type (IS-Oil MRN) | CHAR | 4 | 0 | OIF_PBLTYP | ||
| NUMRI | ID for Internal Number Range | CHAR | 2 | 0 | OIF_NUMRI | ||
| NUMRE | ID for External Number Range | CHAR | 2 | 0 | OIF_NUMRE | ||
| FLAG1 | Indicator 1 | CHAR | 1 | 0 | OIF_SFLAG1 | ||
| FLAG2 | Indicator 2 | CHAR | 1 | 0 | OIF_SFLAG2 | ||
| FLAG3 | Indicator 3 | CHAR | 1 | 0 | OIF_SFLAG3 | ||
| FLAG4 | Indicator 4 | CHAR | 1 | 0 | OIF_SFLAG4 | ||
| 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 | ||
| FLAG_COMP | Competitor location (flag) | CHAR | 1 | 0 | OIRB_FLAG_COMP | ||
| PLANIND | Planning location flag | CHAR | 1 | 0 | OIJ_PLANIN | ||
| REFIND | OIL-TSW: Refinery indicator | CHAR | 1 | 0 | OIJ_REFIND | ||
| ODINDO | OIL-TSW: Location is origin flag | CHAR | 1 | 0 | OIJ_ODINDO | ||
| ODINDD | OIL-TSW: Location destination flag | CHAR | 1 | 0 | OIJ_ODINDD |
OIFSPBLT relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| OIFSPBLT | MANDT | T000 | Clients | MANDT |