SAP table OIJLOC (Location table)
SAP table OIJLOC has 2 primary key fields being MANDT,LOCID.
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 | |
| LOCID | Location ID | CHAR | 10 | 0 | OIJ_LOCID | ||
| LOCTYP | OIL-TSW: Location type | CHAR | 4 | 0 | OIJLOCT | OIJ_LOCTYP | |
| LOCNAM | Location name (used by system owner) | CHAR | 60 | 0 | OIJ_LOCNAM | ||
| KNOTE | OIL-TSW: Transport connection point (node reference) | CHAR | 10 | 0 | TVKN | OIJ_KNOTE | |
| PLANLOC | CHAR | 10 | 0 | ||||
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| ERZEIT | Time of creation | TIMS | 6 | 0 | OI0_ERTIM | ||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||
| AEZEIT | Time of day the record was changed | TIMS | 6 | 0 | OI0_AETIM | ||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| BLOIND | Blocking indicator | CHAR | 1 | 0 | OIJ_BLOIND | ||
| DELIND | Deletion indicator | CHAR | 1 | 0 | OIJ_DELIND | ||
| TKTSELECT | Flag to Set Tickets Selectable | CHAR | 1 | 0 | OIJ_TKTSELECT | ||
| RDACT | Stock Projection activation indicator | CHAR | 1 | 0 | OIJ_RDACT | ||
| MAXRATE | Maximum rate per period | QUAN | 13 | 3 | OIJ_MAXRATE | ||
| MINRATE | Minimum rate per period | QUAN | 13 | 3 | OIJ_MINRATE | ||
| OPERATE | Operating rate per period | QUAN | 13 | 3 | OIJ_OPERATE | ||
| RATEUOM | Rate unit | UNIT | 3 | 0 | T006 | OIJ_RATEUOM | |
| RATEPERD | Ttime unit of measurement for rate | UNIT | 3 | 0 | T006 | OIJ_RATEPERD | |
| MAXUSAGE | Maximum volume per period | QUAN | 13 | 3 | OIJ_MAXUSAGE | ||
| MINUSAGE | Minimum volume per period | QUAN | 13 | 3 | OIJ_MINUSAGE | ||
| OPEUSAGE | Operating volume/ weight per period | QUAN | 13 | 3 | OIJ_OPEUSAGE | ||
| USAGEUOM | Usage unit | UNIT | 3 | 0 | T006 | OIJ_USAGEUOM | |
| USAGEPERD | Time unit of measument for usage | UNIT | 3 | 0 | T006 | OIJ_USAGEPERD | |
| SS_RT | Measurement Comparison calculation routine type | CHAR | 12 | 0 | OIJ_SS_RT | OIJ_DE_SS_RT | |
| BSCHFLAG | Berth scheduling flag | CHAR | 1 | 0 | OIJ_BSCHFLAG | ||
| BSCHPERD | Berth scheduling period | QUAN | 5 | 0 | OIJ_BSCHPERD | ||
| BSCHPUOM | Unit of measurement for berth scheduling period | UNIT | 3 | 0 | T006 | OIJ_BSCHPUOM | |
| TANKAGG | Aggregate Tank Constraints | CHAR | 1 | 0 | OIJ_TANKAGG | ||
| PBLNR | Business location identifier (IS-Oil MRN) | CHAR | 10 | 0 | OIFSPBL | OIF_PBLNR | |
| SCHEMA_BUSCONF | Schema | CHAR | 10 | 0 | OIJSCHEMA | OIJ_SCHEMA | |
| SCHEMA_TECHSCH | Schema | CHAR | 10 | 0 | OIJSCHEMA | OIJ_SCHEMA | |
| SCHEMA_ALLOC | Schema | CHAR | 10 | 0 | OIJSCHEMA | OIJ_SCHEMA | |
| EXTERNAL_IND | External Indicator | CHAR | 1 | 0 | OIJ_EXTIND |
OIJLOC foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 OIJLOC | BSCHPUOM | T006 | Units of Measurement | MANDT |
| 1 OIJLOC | KNOTE | TVKN | Routes: Transportation Connection Points | MANDT |
| 1 OIJLOC | KNOTE | TVKN | Routes: Transportation Connection Points | KNOTE |
| 0 OIJLOC | LOCTYP | OIJLOCT | Location type | MANDT |
| 0 OIJLOC | LOCTYP | OIJLOCT | Location type | LOCTYP |
| 1 OIJLOC | MANDT | T000 | Clients | MANDT |
| 0 OIJLOC | PBLNR | OIFSPBL | Physical Location - Master Data | PBLNR |
| 1 OIJLOC | RATEPERD | T006 | Units of Measurement | MANDT |
| 0 OIJLOC | RATEUOM | T006 | Units of Measurement | MANDT |
| 1 OIJLOC | SCHEMA_ALLOC | OIJSCHEMA | Customizing Table For Schema | MANDT |
| 1 OIJLOC | SCHEMA_ALLOC | OIJSCHEMA | Customizing Table For Schema | SCHEMA_ID |
| 0 OIJLOC | SCHEMA_BUSCONF | OIJSCHEMA | Customizing Table For Schema | MANDT |
| 0 OIJLOC | SCHEMA_BUSCONF | OIJSCHEMA | Customizing Table For Schema | SCHEMA_ID |
| 1 OIJLOC | SCHEMA_TECHSCH | OIJSCHEMA | Customizing Table For Schema | MANDT |
| 1 OIJLOC | SCHEMA_TECHSCH | OIJSCHEMA | Customizing Table For Schema | SCHEMA_ID |
| 0 OIJLOC | SS_RT | OIJ_SS_RT | Stores the Shipshore calculation routine types | SS_RT |
| 1 OIJLOC | USAGEPERD | T006 | Units of Measurement | MANDT |
| 0 OIJLOC | USAGEUOM | T006 | Units of Measurement | MANDT |