SAP ABAP Table OIJ_STAGES (TSW (&TD) Shipment Stages)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
⤷ OIJ (Package) TSW Traders and Schedulers Workbench
⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
⤷ OIJ (Package) TSW Traders and Schedulers Workbench
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | OIJ_STAGES | Table Relationship Diagram |
Short Description | TSW (&TD) Shipment Stages |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | STAGES_ID | OIJ_STAGES_ID | SYSUUID_22 | CHAR | 22 | 0 | Stages ID | ||
3 | TSNUM | TSNUM | TSNUM | NUMC | 4 | 0 | Stage of transport number | * | |
4 | .INCLUDE | 0 | 0 | TSW / TD Shipment stages | |||||
5 | TSTYP | TSTYP | TSTYP | CHAR | 1 | 0 | Stage category | ||
6 | TSRFO | TSRFO | TSRFO | NUMC | 4 | 0 | Stage of transport sequence | ||
7 | VEH_NR | OIG_VEHNR | OIG_VEHNR | NUMC | 3 | 0 | Vehicle Sequence Number in Shipment | * | |
8 | ELUPD | ELUPD | ELUPD | CHAR | 1 | 0 | Change Indicator | ||
9 | CRE_NAME | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
10 | CRE_DATE | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
11 | CRE_TIME | OI0_ERTIM | UZEIT | TIMS | 6 | 0 | Time of creation | ||
12 | CHA_NAME | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
13 | CHA_DATE | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
14 | CHA_TIME | OI0_AETIM | UZEIT | TIMS | 6 | 0 | Time of day the record was changed | ||
15 | ROUTE | ROUTES | ROUTE | CHAR | 6 | 0 | Route for shipment stage | TVRO | |
16 | VSART | VERSARTS | VERSART | CHAR | 2 | 0 | Shipping type for shipment stage | T173 | |
17 | LAUFK | LAUFS | LAUFK | CHAR | 1 | 0 | Leg indicator for shipment stage | ||
18 | ADRNA | ADRNA | ADRNR | CHAR | 10 | 0 | Departure point: Address | * | |
19 | KNOTA | KNOTA | KNOTN | CHAR | 10 | 0 | Departure Point | TVKN | |
20 | VSTEL | VSTELA | VSTEL | CHAR | 4 | 0 | Shipping point at point of departure | TVST | |
21 | LSTEL | LSTELA | LSTEL | CHAR | 2 | 0 | Point of departure: Loading point at shipping point | TVLA | |
22 | WERKA | WERKSA | WERKS | CHAR | 4 | 0 | Plant at point of departure | T001W | |
23 | LGORTA | LGORTA | LGORT | CHAR | 4 | 0 | Departure point: Storage location in plant | T001L | |
24 | KUNNA | KUNNA | KUNNR | CHAR | 10 | 0 | Departure point: Customer | KNA1 | |
25 | LIFNA | LIFNA | LIFNR | CHAR | 10 | 0 | Vendor number of departure point | LFA1 | |
26 | ADRNZ | ADRNZ | ADRNR | CHAR | 10 | 0 | Destination address | * | |
27 | KNOTZ | KNOTZ | KNOTN | CHAR | 10 | 0 | Destination point | TVKN | |
28 | VSTEZ | VSTELZ | VSTEL | CHAR | 4 | 0 | Shipping point at destination | TVST | |
29 | LSTEZ | LSTELZ | LSTEL | CHAR | 2 | 0 | Destination: Loading point at shipping point | TVLA | |
30 | WERKZ | WERKSZ | WERKS | CHAR | 4 | 0 | Plant at destination point | T001W | |
31 | LGORTZ | LGORTZ | LGORT | CHAR | 4 | 0 | Destination: Storage location in plant | T001L | |
32 | KUNNZ | KUNNZ | KUNNR | CHAR | 10 | 0 | Customer number for destination point | KNA1 | |
33 | LIFNZ | LIFNZ | LIFNR | CHAR | 10 | 0 | Vendor number of destination point | LFA1 | |
34 | TDLNR | TDLNRS | LIFNR | CHAR | 10 | 0 | Number of forwarding agent in the shipment stage | LFA1 | |
35 | DISTZ | DISTZ | MENG13 | QUAN | 13 | 3 | Distance | ||
36 | MEDST | MEDST | MEINS | UNIT | 3 | 0 | Unit of measure for distance | T006 | |
37 | OIG_GESZTD | OIG_GESZTD | OIG_GESZT | QUAN | 13 | 2 | Total time for stage | ||
38 | OIG_FAHZTD | OIG_FAHZTD | OIG_GESZT | QUAN | 13 | 2 | Total travel time for stage | ||
39 | MEIZT | MEIZT | MEINS | UNIT | 3 | 0 | Unit of measure for travelling times | T006 | |
40 | ADRKNZA | ADRKNZA | ADRKNZ | CHAR | 1 | 0 | Point of departure: Origin indicator of address | ||
41 | KUNABLA | KUNABLA | TEXT25 | CHAR | 25 | 0 | Point of departure: Customer's unloading point | KNVA | |
42 | ADRKNZZ | ADRKNZZ | ADRKNZ | CHAR | 1 | 0 | Destination: Origin indicator of address | ||
43 | KUNABLZ | KUNABLZ | TEXT25 | CHAR | 25 | 0 | Destination: Customer's unloading point | KNVA | |
44 | FRKRL | FRKRL | FRKRL | CHAR | 1 | 0 | Shipment costs relevance | ||
45 | SKALSM | KALSM_TRAB | KALSM | CHAR | 6 | 0 | Pricing procedure in stage of shipment | T683 | |
46 | FBSTA | FBSTA | FBSTA | CHAR | 1 | 0 | Status of shipment costs calculation | ||
47 | ARSTA | ARSTA | ARSTA | CHAR | 1 | 0 | Status of shipment costs settlement | ||
48 | VEH_IND | OIG_VEHIND | OIG_VEHIND | CHAR | 1 | 0 | TD-F: Vehicle stage indicator with first and last node | ||
49 | CARR_ROUT | OIG_CRROUT | XFELD | CHAR | 1 | 0 | TD-F carrier is copied from route / stage table | ||
50 | GESZTD | OIGGESZTDP | TSTRDURAG | DEC | 11 | 0 | TD Planned total time for stage (in days) | ||
51 | FAHZTD | OIGEFFZTDP | TSTRDURAN | DEC | 11 | 0 | TD - planned duration for stage (in hours:minutes) | ||
52 | GESZTDA | OIGGESZTDA | TSTRDURAG | DEC | 11 | 0 | TD - actual total time for shipment stage (in days) | ||
53 | FAHZTDA | OIGEFFZTDA | TSTRDURAN | DEC | 11 | 0 | TD - actual duration for shipment stage (in hours:minutes) | ||
54 | VEL_AVG | OIJ_VEL_AVG | MENG13 | QUAN | 13 | 3 | Average Velocity | ||
55 | VEL_UOM | OIJ_VEL_UOM | MEINS | UNIT | 3 | 0 | Velocity UoM | T006 | |
56 | VEL_UOMT | OIJ_VEL_UOMT | MEINS | UNIT | 3 | 0 | Velocity - Time | T006 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OIJ_STAGES | KNOTA | TVKN | KNOTE | |||
2 | OIJ_STAGES | KNOTZ | TVKN | KNOTE | |||
3 | OIJ_STAGES | KUNABLA | KNVA | ABLAD | |||
4 | OIJ_STAGES | KUNABLZ | KNVA | ABLAD | |||
5 | OIJ_STAGES | KUNNA | KNA1 | KUNNR | |||
6 | OIJ_STAGES | KUNNZ | KNA1 | KUNNR | |||
7 | OIJ_STAGES | LGORTA | T001L | LGORT | |||
8 | OIJ_STAGES | LGORTZ | T001L | LGORT | |||
9 | OIJ_STAGES | LIFNA | LFA1 | LIFNR | |||
10 | OIJ_STAGES | LIFNZ | LFA1 | LIFNR | |||
11 | OIJ_STAGES | LSTEL | TVLA | LSTEL | |||
12 | OIJ_STAGES | LSTEZ | TVLA | LSTEL | |||
13 | OIJ_STAGES | MEDST | T006 | MSEHI | |||
14 | OIJ_STAGES | MEIZT | T006 | MSEHI | |||
15 | OIJ_STAGES | ROUTE | TVRO | ROUTE | |||
16 | OIJ_STAGES | SKALSM | T683 | KALSM | |||
17 | OIJ_STAGES | TDLNR | LFA1 | LIFNR | |||
18 | OIJ_STAGES | VEL_UOM | T006 | MSEHI | |||
19 | OIJ_STAGES | VEL_UOMT | T006 | MSEHI | |||
20 | OIJ_STAGES | VSART | T173 | VSART | |||
21 | OIJ_STAGES | VSTEL | TVST | VSTEL | |||
22 | OIJ_STAGES | VSTEZ | TVST | VSTEL | |||
23 | OIJ_STAGES | WERKA | T001W | WERKS | |||
24 | OIJ_STAGES | WERKZ | T001W | WERKS |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 46C |