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