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