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