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