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