SAP Table OIJTS
Transport system (IS-Oil TSW standard/core object )
OIJTS (Transport system (IS-Oil TSW standard/core object )) 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 OIJTS to other SAP tables.
OIJTS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| TSYST | Transport system | OIJ_TSYST | CHAR | 10 | 0 | |||||||
| TSNAM | OIL-TSW: Transport system name | OIJ_TSNAM | CHAR | 60 | 0 | |||||||
| BOOKTS | Book TS indicator | OIJ_BOOKTS | CHAR | 1 | 0 |
Possible values
|
||||||
| VSART | Shipping type | VERSART | T173 | CHAR | 2 | 0 | ||||||
| VKTRA | Mode of transport | VKTRA | TVTR | CHAR | 2 | 0 | ||||||
| SHTYPE | TD shipment type | OIG_TDSTYP | TOIGS | CHAR | 4 | 0 | ||||||
| VEHID | Default vehicle number | OIJ_DEFVEH | OIGV | CHAR | 10 | 0 | ||||||
| TSSUOMV | TS standard volume UoM | OIJ_TSUOMV | T006 | UNIT | 3 | 0 | ||||||
| TSSUOMM | TS standard weight UoM | OIJ_TSUOMM | T006 | UNIT | 3 | 0 | ||||||
| CYCPERD | TS cycle duration | OIJ_CYCDUR | QUAN | 10 | 0 | |||||||
| CYCPUOM | TS cycle duration UoM | OIJ_CYDUOM | T006 | UNIT | 3 | 0 | ||||||
| CARRIER | Transport system Carrier | OIJ_CARRNR | LFA1 | CHAR | 10 | 0 | ||||||
| WERK | Transport system In-transit Plant | OIJ_WERK | T001W | CHAR | 4 | 0 | ||||||
| LGORT | Transport system In-transit Storage Location | OIJ_LGORT | T001L | CHAR | 4 | 0 | ||||||
| NOMMSK | Nomination mask | OIJ_NOMMSK | CHAR | 10 | 0 | |||||||
| SHIPPER | Default TS shipper code | OIJ_SHPPER | CHAR | 10 | 0 | |||||||
| CONLTM | Carrier lead time | OIJ_CONLTM | QUAN | 3 | 0 | |||||||
| CONLUOM | Confirmation lead time UoM | OIJ_CONTUM | T006 | UNIT | 3 | 0 | ||||||
| TPLST | Transportation planning point | TPLST | TTDS | CHAR | 4 | 0 | ||||||
| BOTOL | Quantity tolerance over (percentage) | OIJ_BOTOL | DEC | 4 | 1 | |||||||
| BUTOL | Quantity tolerance under (%) | OIJ_BUTOL | DEC | 4 | 1 | |||||||
| BOTOLABS | Absolute tolerance qty over | OIJ_TOLABO | QUAN | 13 | 3 | |||||||
| BUTOLABS | Absolute tolerance qty under | OIJ_TOLABS | QUAN | 13 | 3 | |||||||
| BULTOLUOM | Absolute tolerance UoM | OIJ_TOLUOM | T006 | UNIT | 3 | 0 | ||||||
| UNLIMITED | Indicator: Unlimited Overdelivery Allowed | UEBTK | CHAR | 1 | 0 |
Possible values
|
||||||
| BALCH | Balance check indicator (default) | OIJ_BALCH | CHAR | 1 | 0 |
Possible values
|
||||||
| CLIPLGORT | Transport System In-transit Temporary Storage Location | OIJ_CLIPLGORT | CHAR | 4 | 0 | |||||||
| SHTYP | Shipment type | SHTYP | TVTK | CHAR | 4 | 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
|
||||||
| KALSM | Output determination procedure for nominations | OIJ_KALSM | T683 | CHAR | 6 | 0 | ||||||
| KAPPL | Application in output determination for nominations | OIJ_KAPPL | T681A | CHAR | 2 | 0 | ||||||
| KSCHL | Output determination/output type for nominations | OIJ_KSCHL | T685 | CHAR | 4 | 0 | ||||||
| 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 | ||||||
| SEQIND | Location sequence index | OIJ_TSSEQIND | CHAR | 1 | 0 |
Possible values
|
||||||
| MAXUSAGE | Maximum volume per period | OIJ_MAXUSAGE | QUAN | 13 | 3 | |||||||
| MINUSAGE | Minimum volume per period | OIJ_MINUSAGE | 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 | ||||||
| PIPE_BATCH | Pipeline Batching active | OIJ_PIPE_BATCH | CHAR | 1 | 0 |
Possible values
|
||||||
| VEL_AVG | Average Velocity | OIJ_VEL_AVG | QUAN | 13 | 3 | |||||||
| VEL_MAX | Maximum Velocity | OIJ_VEL_MAX | QUAN | 13 | 3 | |||||||
| VEL_MIN | Minimum Velocity | OIJ_VEL_MIN | QUAN | 13 | 3 | |||||||
| BUSTYP | Business type | OIRA_RNBT | OIRARNBT | CHAR | 4 | 0 | ||||||
| VEL_UOM | Velocity UoM | OIJ_VEL_UOM | T006 | UNIT | 3 | 0 | ||||||
| VEL_UOMT | Velocity - Time | OIJ_VEL_UOMT | UNIT | 3 | 0 | |||||||
| ROUTE_TOLERANCE | Tolerance in percent for stage duration for timestamp check | OIJ_ROUTE_TOLERANCE | INT1 | 3 | 0 | |||||||
| RDTSACT | Stock Projection activation indicator | OIJ_RDACT | CHAR | 1 | 0 |
Possible values
|
||||||
| ACT_SUBITEM | TSW-Ticket Actualization at Subitem Indicator | OIJ_ACT_SUBITEM_FLAG | CHAR | 1 | 0 |
Possible values
|
||||||
OIJTS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| OIJTS | BULTOLUOM | SYST | MANDT | T006 | Units of Measurement | MANDT |
| OIJTS | BULTOLUOM | OIJTS | BULTOLUOM | T006 | Units of Measurement | MSEHI |
| OIJTS | BUSTYP | OIJTS | MANDT | OIRARNBT | Retail Network Business Types | MANDT |
| OIJTS | BUSTYP | OIJTS | BUSTYP | OIRARNBT | Retail Network Business Types | RNBT |
| OIJTS | CARRIER | SYST | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| OIJTS | CARRIER | OIJTS | CARRIER | LFA1 | Vendor Master (General Section) | LIFNR |
| OIJTS | CONLUOM | SYST | MANDT | T006 | Units of Measurement | MANDT |
| OIJTS | CONLUOM | OIJTS | CONLUOM | T006 | Units of Measurement | MSEHI |
| OIJTS | CYCPUOM | SYST | MANDT | T006 | Units of Measurement | MANDT |
| OIJTS | CYCPUOM | OIJTS | CYCPUOM | T006 | Units of Measurement | MSEHI |
| OIJTS | KALSM | OIJTS | KALSM | T683 | Pricing procedures | KALSM |
| OIJTS | KALSM | OIJTS | MANDT | T683 | Pricing procedures | MANDT |
| OIJTS | KALSM | 'B' | T683 | Pricing procedures | KVEWE | |
| OIJTS | KALSM | OIJTS | KAPPL | T683 | Pricing procedures | KAPPL |
| OIJTS | KAPPL | OIJTS | KAPPL | T681A | Conditions: Applications | KAPPL |
| OIJTS | KSCHL | OIJTS | MANDT | T685 | Conditions: Types | MANDT |
| OIJTS | KSCHL | 'B' | T685 | Conditions: Types | KVEWE | |
| OIJTS | KSCHL | OIJTS | KAPPL | T685 | Conditions: Types | KAPPL |
| OIJTS | KSCHL | OIJTS | KSCHL | T685 | Conditions: Types | KSCHL |
| OIJTS | LGORT | SYST | MANDT | T001L | Storage Locations | MANDT |
| OIJTS | LGORT | OIJTS | WERK | T001L | Storage Locations | WERKS |
| OIJTS | LGORT | OIJTS | LGORT | T001L | Storage Locations | LGORT |
| OIJTS | MANDT | OIJTS | MANDT | T000 | Clients | MANDT |
| OIJTS | RATEPERD | SYST | MANDT | T006 | Units of Measurement | MANDT |
| OIJTS | RATEPERD | OIJTS | RATEPERD | T006 | Units of Measurement | MSEHI |
| OIJTS | RATEUOM | SYST | MANDT | T006 | Units of Measurement | MANDT |
| OIJTS | RATEUOM | OIJTS | RATEUOM | T006 | Units of Measurement | MSEHI |
| OIJTS | SHTYP | OIJTS | SHTYP | TVTK | Shipment Types | SHTYP |
| OIJTS | SHTYP | SYST | MANDT | TVTK | Shipment Types | MANDT |
| OIJTS | SHTYPE | SYST | MANDT | TOIGS | TD Shipment Types | CLIENT |
| OIJTS | SHTYPE | OIJTS | SHTYPE | TOIGS | TD Shipment Types | SHTYP |
| OIJTS | TPLST | SYST | MANDT | TTDS | Organizational Unit: Transportation Scheduling Point | MANDT |
| OIJTS | TPLST | OIJTS | TPLST | TTDS | Organizational Unit: Transportation Scheduling Point | TPLST |
| OIJTS | TSSUOMM | SYST | MANDT | T006 | Units of Measurement | MANDT |
| OIJTS | TSSUOMM | OIJTS | TSSUOMM | T006 | Units of Measurement | MSEHI |
| OIJTS | TSSUOMV | SYST | MANDT | T006 | Units of Measurement | MANDT |
| OIJTS | TSSUOMV | OIJTS | TSSUOMV | T006 | Units of Measurement | MSEHI |
| OIJTS | USAGEPERD | OIJTS | USAGEPERD | T006 | Units of Measurement | MSEHI |
| OIJTS | USAGEPERD | OIJTS | MANDT | T006 | Units of Measurement | MANDT |
| OIJTS | USAGEUOM | OIJTS | MANDT | T006 | Units of Measurement | MANDT |
| OIJTS | USAGEUOM | OIJTS | USAGEUOM | T006 | Units of Measurement | MSEHI |
| OIJTS | VEHID | SYST | MANDT | OIGV | TD Vehicle Header | CLIENT |
| OIJTS | VEHID | OIJTS | VEHID | OIGV | TD Vehicle Header | VEHICLE |
| OIJTS | VEL_UOM | OIJTS | MANDT | T006 | Units of Measurement | MANDT |
| OIJTS | VEL_UOM | OIJTS | VEL_UOM | T006 | Units of Measurement | MSEHI |
| OIJTS | VKTRA | SYST | MANDT | TVTR | Routes: Modes of Transport | MANDT |
| OIJTS | VKTRA | OIJTS | VKTRA | TVTR | Routes: Modes of Transport | VKTRA |
| OIJTS | VSART | SYST | MANDT | T173 | Routes: Mode of Transport for Each Shipping Type | MANDT |
| OIJTS | VSART | OIJTS | VSART | T173 | Routes: Mode of Transport for Each Shipping Type | VSART |
| OIJTS | WERK | OIJTS | WERK | T001W | Plants/Branches | WERKS |
| OIJTS | WERK | SYST | MANDT | T001W | Plants/Branches | MANDT |
