SAP ABAP Table VTTSVB (Stage of Shipment)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BF (Application Component) Basic Functions
⤷ VTR (Package) SD R/3 transport processing
⤷ CRM-BF (Application Component) Basic Functions
⤷ VTR (Package) SD R/3 transport processing
Basic Data
Table Category | INTTAB | Structure |
Structure | VTTSVB | Table Relationship Diagram |
Short Description | Stage of Shipment |
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 | Stage of Shipment | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | TKNUM | TKNUM | TKNUM | CHAR | 10 | 0 | Shipment Number | VTTK | |
4 | TSNUM | TSNUM | TSNUM | NUMC | 4 | 0 | Stage of transport number | * | |
5 | TSTYP | TSTYP | TSTYP | CHAR | 1 | 0 | Stage category | ||
6 | TSRFO | TSRFO | TSRFO | NUMC | 4 | 0 | Stage of transport sequence | ||
7 | ELUPD | ELUPD | ELUPD | CHAR | 1 | 0 | Change Indicator | ||
8 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
9 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
10 | ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
11 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
12 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
13 | AEZET | 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 | INCO1 | INCO1VTTS | INCO1 | CHAR | 3 | 0 | Incoterms for printout | TINC | |
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 | BELAD | BELAD | TEXT25 | CHAR | 25 | 0 | Point of departure: Additional info (e.g. loading point) | ||
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 | ABLAD | ABLADZ | TEXT25 | CHAR | 25 | 0 | Destination: Additional information (e.g. unloading point) | ||
36 | DPTBG | DPTBGS | DATUM | DATS | 8 | 0 | Stage: Planned date for start of shipment | ||
37 | UPTBG | UPTBGS | UZEIT | TIMS | 6 | 0 | Stage: Planned shipment start time | ||
38 | DATBG | DATBGS | DATUM | DATS | 8 | 0 | Stage: Current date for start of shipment | ||
39 | UATBG | UATBGS | UZEIT | TIMS | 6 | 0 | Stage: Current shipment start time | ||
40 | DPTEN | DPTENS | DATUM | DATS | 8 | 0 | Stage: Planned date for end of shipment | ||
41 | UPTEN | UPTENS | UZEIT | TIMS | 6 | 0 | Stage: Planned shipemnt end time | ||
42 | DATEN | DATENDS | DATUM | DATS | 8 | 0 | Stage: Actual Date for End of Shipment | ||
43 | UATEN | UATENDS | UZEIT | TIMS | 6 | 0 | Stage: Actual shipment end time | ||
44 | TDLNR | TDLNRS | LIFNR | CHAR | 10 | 0 | Number of forwarding agent in the shipment stage | LFA1 | |
45 | DISTZ | DISTZ | MENG13 | QUAN | 13 | 3 | Distance | ||
46 | MEDST | MEDST | MEINS | UNIT | 3 | 0 | Unit of measure for distance | * | |
47 | FAHZT | FAHZT | FAHZT | QUAN | 5 | 2 | Travelling time only between two locations | ||
48 | GESZT | GESZT | FAHZT | QUAN | 5 | 2 | Total travelling time between two locations incl. breaks | ||
49 | MEIZT | MEIZT | MEINS | UNIT | 3 | 0 | Unit of measure for travelling times | * | |
50 | LGNUMA | LGNUMA | LGNUM | CHAR | 3 | 0 | Point of departure: Warehouse number | T300 | |
51 | TORA | LGTORA | LGTOR | CHAR | 3 | 0 | Point of departure: Gate for warehouse number | T30B | |
52 | ADRKNZA | ADRKNZA | ADRKNZ | CHAR | 1 | 0 | Point of departure: Origin indicator of address | ||
53 | KUNABLA | KUNABLA | TEXT25 | CHAR | 25 | 0 | Point of departure: Customer's unloading point | KNVA | |
54 | LGNUMZ | LGNUMZ | LGNUM | CHAR | 3 | 0 | Destination: Warehouse number | T300 | |
55 | TORZ | LGTORZ | LGTOR | CHAR | 3 | 0 | Destination. Gate for warehouse number | T30B | |
56 | ADRKNZZ | ADRKNZZ | ADRKNZ | CHAR | 1 | 0 | Destination: Origin indicator of address | ||
57 | KUNABLZ | KUNABLZ | TEXT25 | CHAR | 25 | 0 | Destination: Customer's unloading point | KNVA | |
58 | GESZTD | AB_GESZTDP | TSTRDURAG | DEC | 11 | 0 | Planned total time at stage level (in days) | ||
59 | FAHZTD | AB_EFFZTDP | TSTRDURAN | DEC | 11 | 0 | Plan: Actual duration at stage level (in hours:minutes) | ||
60 | GESZTDA | AB_GESZTDA | TSTRDURAG | DEC | 11 | 0 | Actual total time at stage of shipment (in days) | ||
61 | FAHZTDA | AB_EFFZTDA | TSTRDURAN | DEC | 11 | 0 | Actual duration of shipment stage (in hours:minutes) | ||
62 | SDABW | SDABW | SDABW | CHAR | 4 | 0 | Special Processing Indicator | TVSAK | |
63 | FRKRL | FRKRL | FRKRL | CHAR | 1 | 0 | Shipment costs relevance | ||
64 | SKALSM | KALSM_TRAB | KALSM | CHAR | 6 | 0 | Pricing procedure in stage of shipment | T683 | |
65 | FBSTA | FBSTA | FBSTA | CHAR | 1 | 0 | Status of shipment costs calculation | ||
66 | ARSTA | ARSTA | ARSTA | CHAR | 1 | 0 | Status of shipment costs settlement | ||
67 | STAFO | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | * | |
68 | CONT_DG | ADGE_SCDG | X | CHAR | 1 | 0 | Indicator: Section contains dangerous goods | ||
69 | WARZTD | AB_WARZTDP | TSTRDURAN | DEC | 11 | 0 | Planned waiting time in shipment stage (in hrs:min) | ||
70 | WARZTDA | AB_WARZTDA | TSTRDURAN | DEC | 11 | 0 | Current waiting time in shipment stage (in hrs:min) | ||
71 | ABLAND1 | ABLAND1 | LAND1 | CHAR | 3 | 0 | Country of departure | T005 | |
72 | ABPSTLZ | ABPSTLZ | PSTLZ | CHAR | 10 | 0 | Departure postal code | ||
73 | ABORT01 | ABORT01 | ORT01 | CHAR | 35 | 0 | Point of departure | ||
74 | EDLAND1 | EDLAND1 | LAND1 | CHAR | 3 | 0 | Destination Country | T005 | |
75 | EDPSTLZ | EDPSTLZ | PSTLZ | CHAR | 10 | 0 | Destination Postal Code | ||
76 | EDORT01 | EDORT01 | ORT01 | CHAR | 35 | 0 | Destination | ||
77 | .INCLUDE | 0 | 0 | Stage of Transport: Dynamic Part | |||||
78 | UPDKZ | UPDKZ_D | UPDKZ | CHAR | 1 | 0 | Update indicator | ||
79 | DLNAMT | DLNRNAME | NAME | CHAR | 35 | 0 | Name of the Service Agent | ||
80 | VSBEDT | VSBED_BEZ | TEXT20 | CHAR | 20 | 0 | Description of the shipping conditions | ||
81 | ADRNAD | ADRNA | ADRNR | CHAR | 10 | 0 | Departure point: Address | * | |
82 | ADRHNDA | ADRHNDA | TEXT10 | CHAR | 10 | 0 | Point of departure: Handle of an address | ||
83 | UPDADA | UPDKZA | UPDKZ | CHAR | 1 | 0 | Point of departure: Update indicator of address | ||
84 | TKNOTA | BEZKNOTA | TEXT30 | CHAR | 30 | 0 | Description of departure point | ||
85 | TORT2A | BEZKNOTA2 | TEXT30 | CHAR | 30 | 0 | Description of departure point - Part 2 | ||
86 | PSTLZA | PSTLZ_A | PSTLZ | CHAR | 10 | 0 | Departure point: Postal code | ||
87 | LAND1A | LAND1_A | LAND1 | CHAR | 3 | 0 | Point of departure: Country key | * | |
88 | LZONEA | LZONE_A | ZONE | CHAR | 10 | 0 | Point of departure: Transportation zone | * | |
89 | REGIOA | REGIO_A | REGIO | CHAR | 3 | 0 | Dep.point: Region (state, Federal county, province etc.) | * | |
90 | BEZKOMPRA | BEZKOMPRA | CHAR60 | CHAR | 60 | 0 | Departure point: Description of location (compressed) | ||
91 | ADRNZD | ADRNZ | ADRNR | CHAR | 10 | 0 | Destination address | * | |
92 | ADRHNDZ | ADRHNDZ | TEXT10 | CHAR | 10 | 0 | Destination: Handle of an address | ||
93 | UPDADZ | UPDKZZ | UPDKZ | CHAR | 1 | 0 | Destination: Update indicator of address | ||
94 | TKNOTZ | BEZKNOTZ | TEXT30 | CHAR | 30 | 0 | Description of destination point | ||
95 | TORT2Z | BEZKNOTZ2 | TEXT30 | CHAR | 30 | 0 | Description of destination - Part 2 | ||
96 | PSTLZZ | PSTLZ_Z | PSTLZ | CHAR | 10 | 0 | Destination: Postal code | ||
97 | LAND1Z | LAND1_Z | LAND1 | CHAR | 3 | 0 | Destination: Country key | * | |
98 | LZONEZ | LZONE_Z | ZONE | CHAR | 10 | 0 | Destination: Transportation zone | * | |
99 | REGIOZ | REGIO_Z | REGIO | CHAR | 3 | 0 | Destination: Region (state, Federal county, province) | * | |
100 | BEZKOMPRZ | BEZKOMPRZ | CHAR60 | CHAR | 60 | 0 | Destination: Description of Location (Compressed) | ||
101 | ADRNRDL | ADRNR_SP | ADRNR | CHAR | 10 | 0 | Address no. of forwarding agent | * | |
102 | ADRDADL | ADRDA | ADRDA | CHAR | 1 | 0 | Address indicator |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VTTSVB | ABLAND1 | T005 | LAND1 | |||
2 | VTTSVB | EDLAND1 | T005 | LAND1 | |||
3 | VTTSVB | INCO1 | TINC | INCO1 | |||
4 | VTTSVB | KNOTA | TVKN | KNOTE | |||
5 | VTTSVB | KNOTZ | TVKN | KNOTE | |||
6 | VTTSVB | KUNABLA | KNVA | ABLAD | |||
7 | VTTSVB | KUNABLZ | KNVA | ABLAD | |||
8 | VTTSVB | KUNNA | KNA1 | KUNNR | REF | C | CN |
9 | VTTSVB | KUNNZ | KNA1 | KUNNR | REF | C | CN |
10 | VTTSVB | LGNUMA | T300 | LGNUM | |||
11 | VTTSVB | LGNUMZ | T300 | LGNUM | |||
12 | VTTSVB | LGORTA | T001L | LGORT | |||
13 | VTTSVB | LGORTZ | T001L | LGORT | |||
14 | VTTSVB | LIFNA | LFA1 | LIFNR | REF | C | CN |
15 | VTTSVB | LIFNZ | LFA1 | LIFNR | REF | C | CN |
16 | VTTSVB | LSTEL | TVLA | LSTEL | |||
17 | VTTSVB | LSTEZ | TVLA | LSTEL | REF | C | CN |
18 | VTTSVB | MANDT | T000 | MANDT | |||
19 | VTTSVB | ROUTE | TVRO | ROUTE | |||
20 | VTTSVB | SDABW | TVSAK | SDABW | |||
21 | VTTSVB | SKALSM | T683 | KALSM | |||
22 | VTTSVB | TDLNR | LFA1 | LIFNR | REF | C | C |
23 | VTTSVB | TKNUM | VTTK | TKNUM | |||
24 | VTTSVB | TORA | T30B | LGTOR | |||
25 | VTTSVB | TORZ | T30B | LGTOR | |||
26 | VTTSVB | VSART | T173 | VSART | |||
27 | VTTSVB | VSTEL | TVST | VSTEL | |||
28 | VTTSVB | VSTEZ | TVST | VSTEL | REF | C | CN |
29 | VTTSVB | WERKA | T001W | WERKS | |||
30 | VTTSVB | WERKZ | T001W | WERKS |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |