SAP Table OIJTSLOC
OIL-TSW: transport system/location assignment table
OIJTSLOC (OIL-TSW: transport system/location assignment 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 OIJTSLOC to other SAP tables.
OIJTSLOC table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| TSYST | Transport system | OIJ_TSYST | OIJTS | CHAR | 10 | 0 | ||||||
| LOCID | Location ID | OIJ_LOCID | OIJLOC | CHAR | 10 | 0 | ||||||
| LOCNAM | Location name (used by system owner) | OIJ_LOCNAM | CHAR | 60 | 0 | |||||||
| TSLOCID | OIL-TSW: Transport system location ID | OIJ_TSLCID | CHAR | 10 | 0 | |||||||
| TSLOCNAM | OIL-TSW: Name of location in transport system | OIJ_TSLCNM | CHAR | 60 | 0 | |||||||
| ODINDO | OIL-TSW: Location is origin flag | OIJ_ODINDO | CHAR | 1 | 0 |
Possible values
|
||||||
| ODINDD | OIL-TSW: Location destination flag | OIJ_ODINDD | CHAR | 1 | 0 |
Possible values
|
||||||
| CONSIND | OIL-TSW: Location bunker consumption dummy location flag | OIJ_CONSIND | CHAR | 1 | 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
|
||||||
| LOCID_PARENT | OIL-TSW: Parent Location of Bifurcation Branch | OIJ_LOCID_PARENT | CHAR | 10 | 0 | |||||||
| BRANCH_NR | OIL-TSW: Number of Bifurcation Branch | OIJ_BRANCH_NR | NUMC | 5 | 0 | |||||||
| BRANCH_SEQ | TSW: Sequence number | OIJ_SEQNR | NUMC | 5 | 0 | |||||||
OIJTSLOC foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| OIJTSLOC | LOCID | OIJTSLOC | MANDT | OIJLOC | Location table | MANDT |
| OIJTSLOC | LOCID | OIJTSLOC | LOCID | OIJLOC | Location table | LOCID |
| OIJTSLOC | MANDT | OIJTSLOC | MANDT | T000 | Clients | MANDT |
| OIJTSLOC | TSYST | OIJTSLOC | MANDT | OIJTS | Transport system (IS-Oil TSW standard/core object ) | MANDT |
| OIJTSLOC | TSYST | OIJTSLOC | TSYST | OIJTS | Transport system (IS-Oil TSW standard/core object ) | TSYST |
