SAP ABAP Table MCVTTS (LIS: Stages of Shipment Data)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ LE-TRA (Application Component) Transportation
⤷ MCT (Package) Application Development R/3 Transportation Inform. System
⤷ LE-TRA (Application Component) Transportation
⤷ MCT (Package) Application Development R/3 Transportation Inform. System
Basic Data
Table Category | INTTAB | Structure |
Structure | MCVTTS | Table Relationship Diagram |
Short Description | LIS: Stages of Shipment Data |
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 | Additional Fields: Stages of Shipment for LIS Updating | |||||
78 | TKNOTA | BEZKNOTA | TEXT30 | CHAR | 30 | 0 | Description of departure point | ||
79 | TORT2A | BEZKNOTA | TEXT30 | CHAR | 30 | 0 | Description of departure point | ||
80 | PSTLZA | PSTLZ_BAS | PSTLZ | CHAR | 10 | 0 | Postal code | ||
81 | LAND1A | LAND1A | LAND1 | CHAR | 3 | 0 | Country key for point of departure | * | |
82 | LZONEA | LZONE | ZONE | CHAR | 10 | 0 | Transportation zone to or from which the goods are delivered | * | |
83 | REGIOA | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
84 | TKNOTZ | BEZKNOTZ | TEXT30 | CHAR | 30 | 0 | Description of destination point | ||
85 | TORT2Z | BEZKNOTZ | TEXT30 | CHAR | 30 | 0 | Description of destination point | ||
86 | PSTLZZ | PSTLZ_BAS | PSTLZ | CHAR | 10 | 0 | Postal code | ||
87 | LAND1Z | LAND1Z | LAND1 | CHAR | 3 | 0 | Country key | * | |
88 | LZONEZ | LZONE | ZONE | CHAR | 10 | 0 | Transportation zone to or from which the goods are delivered | * | |
89 | REGIOZ | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
90 | DLNAMT | DLNRNAME | NAME | CHAR | 35 | 0 | Name of the Service Agent | ||
91 | BEZKOMPRA | BEZKOMPR | CHAR60 | CHAR | 60 | 0 | Abbreviated location name | ||
92 | BEZKOMPRZ | BEZKOMPR | CHAR60 | CHAR | 60 | 0 | Abbreviated location name | ||
93 | DURTP | MC_TPDURTPP | TDURAMIN | DEC | 11 | 0 | TIS: planned shipment duration | ||
94 | DURTA | MC_TPDURTPA | TDURAMIN | DEC | 11 | 0 | TIS: actual shipment duration | ||
95 | LATET | MC_TPDURTPU | TDURAMIN | DEC | 11 | 0 | TIS: Amount of time the planned shipment time was exceeded | ||
96 | LATES | MC_TPDURTPV | TDURAMIN | DEC | 11 | 0 | TIS: amount of time shipment start was delayed (planned-act) | ||
97 | LATEE | MC_TPDURTPZ | TDURAMIN | DEC | 11 | 0 | TIS: delay of the actual shipment end (planned - actual) | ||
98 | DURGES | MC_TPDURGES | TDURAMIN | DEC | 11 | 0 | Total duration in minutes | ||
99 | DURFAH | MC_TPDURFAH | TDURAMIN | DEC | 11 | 0 | Travel duration in real travel time (minutes) | ||
100 | DURFAHP | MC_TPDURFAHP | TDURAMIN | DEC | 11 | 0 | Planned travel time in minutes | ||
101 | DURGESP | MC_TPDURGESP | TDURAMIN | DEC | 11 | 0 | Planned total duration in minutes | ||
102 | .INCLUDE | 0 | 0 | Partner Structures for Transport from VBPA | |||||
103 | PKUNAG | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | * | |
104 | PKUNWE | KUNWE | KUNNR | CHAR | 10 | 0 | Ship-to party | * | |
105 | PKUNRE | KUNRE | KUNNR | CHAR | 10 | 0 | Bill-to party | * | |
106 | PKUNRG | KUNRG | KUNNR | CHAR | 10 | 0 | Payer | * | |
107 | PTDLNR | TDLNR | LIFNR | CHAR | 10 | 0 | Number of forwarding agent | * | |
108 | PTFRNR | TFRNR | LIFNR | CHAR | 10 | 0 | Name of carrier in transportation | * | |
109 | PTRFNR | TRFNR | LIFNR | CHAR | 10 | 0 | Number of cleaning company in the shipment | * | |
110 | PTVENR | TVENR | LIFNR | CHAR | 10 | 0 | Number of transportation insurance in the shipment | * | |
111 | PLAAG | PLAAG | LAND1 | CHAR | 3 | 0 | Country of the sold-to party | * | |
112 | PLAWE | PLAWE | LAND1 | CHAR | 3 | 0 | Country of ship-to party | * | |
113 | PLARE | PLARE | LAND1 | CHAR | 3 | 0 | Country of the bill-to party | * | |
114 | PLARG | PLARG | LAND1 | CHAR | 3 | 0 | Country of the payer | * | |
115 | PLASP | PLASP | LAND1 | CHAR | 3 | 0 | Country of the carrier | * | |
116 | PLAFF | PLAFF | LAND1 | CHAR | 3 | 0 | Country of carrier | * | |
117 | PLARF | PLARF | LAND1 | CHAR | 3 | 0 | Country of cleaning company | * | |
118 | PLATV | PLATV | LAND1 | CHAR | 3 | 0 | Country of transportation insurer | * | |
119 | PABLA | PABLA | TEXT25 | CHAR | 25 | 0 | Unloading point of the ship-to party | ||
120 | PZONE | PZONE | ZONE | CHAR | 10 | 0 | Transportation zone of the ship-to party | * | |
121 | .INCLUDE | 0 | 0 | User Section: Additional Partner(s) from VBPA | |||||
122 | PDUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
123 | .INCLUDE | 0 | 0 | User Structure: Stages of Shipment for LIS Updating | |||||
124 | UDUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 |
Foreign Keys
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |