1. Home
  2. Resources
  3. SAP Tables
  4. MCVTTS - LIS: Stages of Shipment Data

SAP Table MCVTTS

LIS: Stages of Shipment Data

MCVTTS (LIS: Stages of Shipment Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MCVTTS to other SAP tables.

MCVTTS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
TKNUM Shipment Number TKNUM VTTK CHAR 10 0
TSNUM Stage of transport number TSNUM NUMC 4 0
TSTYP Stage category TSTYP CHAR 1 0
1 Transportation
2 Load transfer
3 Border
TSRFO Stage of transport sequence TSRFO NUMC 4 0
ELUPD Change Indicator ELUPD CHAR 1 0
1 Created automatically
2 Created automatically, changed manually
3 Created manually
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AEZET Time last change was made AEZET TIMS 6 0
ROUTE Route for shipment stage ROUTES TVRO CHAR 6 0
VSART Shipping type for shipment stage VERSARTS T173 CHAR 2 0
INCO1 Incoterms for printout INCO1VTTS TINC CHAR 3 0
LAUFK Leg indicator for shipment stage LAUFS CHAR 1 0
1 Preliminary leg
2 Main leg
3 Subsequent leg
4 Direct leg
5 Return leg
ADRNA Departure point: Address ADRNA CHAR 10 0
KNOTA Departure Point KNOTA TVKN CHAR 10 0
VSTEL Shipping point at point of departure VSTELA TVST CHAR 4 0
LSTEL Point of departure: Loading point at shipping point LSTELA TVLA CHAR 2 0
WERKA Plant at point of departure WERKSA T001W CHAR 4 0
LGORTA Departure point: Storage location in plant LGORTA T001L CHAR 4 0
KUNNA Departure point: Customer KUNNA KNA1 CHAR 10 0
LIFNA Vendor number of departure point LIFNA LFA1 CHAR 10 0
BELAD Point of departure: Additional info (e.g. loading point) BELAD CHAR 25 0
ADRNZ Destination address ADRNZ CHAR 10 0
KNOTZ Destination point KNOTZ TVKN CHAR 10 0
VSTEZ Shipping point at destination VSTELZ TVST CHAR 4 0
LSTEZ Destination: Loading point at shipping point LSTELZ TVLA CHAR 2 0
WERKZ Plant at destination point WERKSZ T001W CHAR 4 0
LGORTZ Destination: Storage location in plant LGORTZ T001L CHAR 4 0
KUNNZ Customer number for destination point KUNNZ KNA1 CHAR 10 0
LIFNZ Vendor number of destination point LIFNZ LFA1 CHAR 10 0
ABLAD Destination: Additional information (e.g. unloading point) ABLADZ CHAR 25 0
DPTBG Stage: Planned date for start of shipment DPTBGS DATS 8 0
UPTBG Stage: Planned shipment start time UPTBGS TIMS 6 0
DATBG Stage: Current date for start of shipment DATBGS DATS 8 0
UATBG Stage: Current shipment start time UATBGS TIMS 6 0
DPTEN Stage: Planned date for end of shipment DPTENS DATS 8 0
UPTEN Stage: Planned shipemnt end time UPTENS TIMS 6 0
DATEN Stage: Actual Date for End of Shipment DATENDS DATS 8 0
UATEN Stage: Actual shipment end time UATENDS TIMS 6 0
TDLNR Number of forwarding agent in the shipment stage TDLNRS LFA1 CHAR 10 0
DISTZ Distance DISTZ QUAN 13 3
MEDST Unit of measure for distance MEDST UNIT 3 0
FAHZT Travelling time only between two locations FAHZT QUAN 5 2
GESZT Total travelling time between two locations incl. breaks GESZT QUAN 5 2
MEIZT Unit of measure for travelling times MEIZT UNIT 3 0
LGNUMA Point of departure: Warehouse number LGNUMA T300 CHAR 3 0
TORA Point of departure: Gate for warehouse number LGTORA T30B CHAR 3 0
ADRKNZA Point of departure: Origin indicator of address ADRKNZA CHAR 1 0
A Address from master data (SADR, ADRC, KNA1, LFA1)
B Address entered manually in current document (ADRC)
C Address entered manually in preceding document (SADR)
D Address entered manually in preceding document (ADRC)
KUNABLA Point of departure: Customer's unloading point KUNABLA KNVA CHAR 25 0
LGNUMZ Destination: Warehouse number LGNUMZ T300 CHAR 3 0
TORZ Destination. Gate for warehouse number LGTORZ T30B CHAR 3 0
ADRKNZZ Destination: Origin indicator of address ADRKNZZ CHAR 1 0
A Address from master data (SADR, ADRC, KNA1, LFA1)
B Address entered manually in current document (ADRC)
C Address entered manually in preceding document (SADR)
D Address entered manually in preceding document (ADRC)
KUNABLZ Destination: Customer's unloading point KUNABLZ KNVA CHAR 25 0
GESZTD Planned total time at stage level (in days) AB_GESZTDP DEC 11 0
FAHZTD Plan: Actual duration at stage level (in hours:minutes) AB_EFFZTDP DEC 11 0
GESZTDA Actual total time at stage of shipment (in days) AB_GESZTDA DEC 11 0
FAHZTDA Actual duration of shipment stage (in hours:minutes) AB_EFFZTDA DEC 11 0
SDABW Special processing indicator SDABW TVSAK CHAR 4 0
FRKRL Shipment costs relevance FRKRL CHAR 1 0
X Relevant for freight costs
NULL Not relevant for freight costs
SKALSM Pricing procedure in stage of shipment KALSM_TRAB T683 CHAR 6 0
FBSTA Status of shipment costs calculation FBSTA CHAR 1 0
NULL Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
ARSTA Status of shipment costs settlement ARSTA CHAR 1 0
NULL Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
STAFO Update group for statistics update STAFO CHAR 6 0
CONT_DG Indicator: Section contains dangerous goods ADGE_SCDG CHAR 1 0
X Yes
NULL No
WARZTD Planned waiting time in shipment stage (in hrs:min) AB_WARZTDP DEC 11 0
WARZTDA Current waiting time in shipment stage (in hrs:min) AB_WARZTDA DEC 11 0
ABLAND1 Country of departure ABLAND1 T005 CHAR 3 0
ABPSTLZ Departure postal code ABPSTLZ CHAR 10 0
ABORT01 Point of departure ABORT01 CHAR 35 0
EDLAND1 Destination Country EDLAND1 T005 CHAR 3 0
EDPSTLZ Destination Postal Code EDPSTLZ CHAR 10 0
EDORT01 Destination EDORT01 CHAR 35 0
OIGVEH_NR Vehicle Sequence Number in Shipment OIG_VEHNR NUMC 3 0
OIGVEH_IND TD-F: Vehicle stage indicator with first and last node OIG_VEHIND CHAR 1 0
OIGVEHICLE TD Vehicle Number OIG_VHLNMR CHAR 10 0
OIGROUTEV TD-F vehicle route OIG_ROUTEV CHAR 6 0
OIG_GESZTD Total time for stage OIG_GESZTD QUAN 13 2
OIG_FAHZTD Total travel time for stage OIG_FAHZTD QUAN 13 2
OIG_MEIZT Unit of measure for travelling times MEIZT T006 UNIT 3 0
TKNOTA Description of departure point BEZKNOTA CHAR 30 0
TORT2A Description of departure point BEZKNOTA CHAR 30 0
PSTLZA Postal code PSTLZ_BAS CHAR 10 0
LAND1A Country key for point of departure LAND1A CHAR 3 0
LZONEA Transportation zone to or from which the goods are delivered LZONE CHAR 10 0
REGIOA Region (State, Province, County) REGIO CHAR 3 0
TKNOTZ Description of destination point BEZKNOTZ CHAR 30 0
TORT2Z Description of destination point BEZKNOTZ CHAR 30 0
PSTLZZ Postal code PSTLZ_BAS CHAR 10 0
LAND1Z Country key LAND1Z CHAR 3 0
LZONEZ Transportation zone to or from which the goods are delivered LZONE CHAR 10 0
REGIOZ Region (State, Province, County) REGIO CHAR 3 0
DLNAMT Name of the Service Agent DLNRNAME CHAR 35 0
BEZKOMPRA Abbreviated location name BEZKOMPR CHAR 60 0
BEZKOMPRZ Abbreviated location name BEZKOMPR CHAR 60 0
DURTP TIS: planned shipment duration MC_TPDURTPP DEC 11 0
DURTA TIS: actual shipment duration MC_TPDURTPA DEC 11 0
LATET TIS: Amount of time the planned shipment time was exceeded MC_TPDURTPU DEC 11 0
LATES TIS: amount of time shipment start was delayed (planned-act) MC_TPDURTPV DEC 11 0
LATEE TIS: delay of the actual shipment end (planned - actual) MC_TPDURTPZ DEC 11 0
DURGES Total duration in minutes MC_TPDURGES DEC 11 0
DURFAH Travel duration in real travel time (minutes) MC_TPDURFAH DEC 11 0
DURFAHP Planned travel time in minutes MC_TPDURFAHP DEC 11 0
DURGESP Planned total duration in minutes MC_TPDURGESP DEC 11 0
PKUNAG Sold-to party KUNAG CHAR 10 0
PKUNWE Ship-to party KUNWE CHAR 10 0
PKUNRE Bill-to party KUNRE CHAR 10 0
PKUNRG Payer KUNRG CHAR 10 0
PTDLNR Number of forwarding agent TDLNR CHAR 10 0
PTFRNR Name of carrier in transportation TFRNR CHAR 10 0
PTRFNR Number of cleaning company in the shipment TRFNR CHAR 10 0
PTVENR Number of transportation insurance in the shipment TVENR CHAR 10 0
PLAAG Country of the sold-to party PLAAG CHAR 3 0
PLAWE Country of ship-to party PLAWE CHAR 3 0
PLARE Country of the bill-to party PLARE CHAR 3 0
PLARG Country of the payer PLARG CHAR 3 0
PLASP Country of the carrier PLASP CHAR 3 0
PLAFF Country of carrier PLAFF CHAR 3 0
PLARF Country of cleaning company PLARF CHAR 3 0
PLATV Country of transportation insurer PLATV CHAR 3 0
PABLA Unloading point of the ship-to party PABLA CHAR 25 0
PZONE Transportation zone of the ship-to party PZONE CHAR 10 0
PDUMMY Dummy function in length 1 DUMMY CHAR 1 0
UDUMMY Dummy function in length 1 DUMMY CHAR 1 0

MCVTTS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MCVTTS ABLAND1 MCVTTS MANDT T005 Countries MANDT
MCVTTS ABLAND1 MCVTTS ABLAND1 T005 Countries LAND1
MCVTTS EDLAND1 MCVTTS EDLAND1 T005 Countries LAND1
MCVTTS EDLAND1 MCVTTS MANDT T005 Countries MANDT
MCVTTS INCO1 MCVTTS MANDT TINC Customers: Incoterms MANDT
MCVTTS INCO1 MCVTTS INCO1 TINC Customers: Incoterms INCO1
MCVTTS KNOTA MCVTTS MANDT TVKN Routes: Transportation Connection Points MANDT
MCVTTS KNOTA MCVTTS KNOTA TVKN Routes: Transportation Connection Points KNOTE
MCVTTS KNOTZ MCVTTS MANDT TVKN Routes: Transportation Connection Points MANDT
MCVTTS KNOTZ MCVTTS KNOTZ TVKN Routes: Transportation Connection Points KNOTE
MCVTTS KUNABLA MCVTTS MANDT KNVA Customer Master Unloading Points MANDT
MCVTTS KUNABLA MCVTTS KUNNA KNVA Customer Master Unloading Points KUNNR
MCVTTS KUNABLA MCVTTS KUNABLA KNVA Customer Master Unloading Points ABLAD
MCVTTS KUNABLZ MCVTTS KUNNZ KNVA Customer Master Unloading Points KUNNR
MCVTTS KUNABLZ MCVTTS KUNABLZ KNVA Customer Master Unloading Points ABLAD
MCVTTS KUNABLZ MCVTTS MANDT KNVA Customer Master Unloading Points MANDT
MCVTTS KUNNA MCVTTS MANDT KNA1 General Data in Customer Master MANDT
MCVTTS KUNNA MCVTTS KUNNA KNA1 General Data in Customer Master KUNNR
MCVTTS KUNNZ MCVTTS KUNNZ KNA1 General Data in Customer Master KUNNR
MCVTTS KUNNZ MCVTTS MANDT KNA1 General Data in Customer Master MANDT
MCVTTS LGNUMA MCVTTS MANDT T300 WM Warehouse Numbers MANDT
MCVTTS LGNUMA MCVTTS LGNUMA T300 WM Warehouse Numbers LGNUM
MCVTTS LGNUMZ MCVTTS MANDT T300 WM Warehouse Numbers MANDT
MCVTTS LGNUMZ MCVTTS LGNUMZ T300 WM Warehouse Numbers LGNUM
MCVTTS LGORTA MCVTTS LGORTA T001L Storage Locations LGORT
MCVTTS LGORTA MCVTTS MANDT T001L Storage Locations MANDT
MCVTTS LGORTA MCVTTS WERKA T001L Storage Locations WERKS
MCVTTS LGORTZ MCVTTS MANDT T001L Storage Locations MANDT
MCVTTS LGORTZ MCVTTS WERKZ T001L Storage Locations WERKS
MCVTTS LGORTZ MCVTTS LGORTZ T001L Storage Locations LGORT
MCVTTS LIFNA MCVTTS MANDT LFA1 Vendor Master (General Section) MANDT
MCVTTS LIFNA MCVTTS LIFNA LFA1 Vendor Master (General Section) LIFNR
MCVTTS LIFNZ MCVTTS MANDT LFA1 Vendor Master (General Section) MANDT
MCVTTS LIFNZ MCVTTS LIFNZ LFA1 Vendor Master (General Section) LIFNR
MCVTTS LSTEL MCVTTS VSTEL TVLA Org.unit: Loading points per shipping point VSTEL
MCVTTS LSTEL MCVTTS LSTEL TVLA Org.unit: Loading points per shipping point LSTEL
MCVTTS LSTEL MCVTTS MANDT TVLA Org.unit: Loading points per shipping point MANDT
MCVTTS LSTEZ MCVTTS MANDT TVLA Org.unit: Loading points per shipping point MANDT
MCVTTS LSTEZ MCVTTS VSTEZ TVLA Org.unit: Loading points per shipping point VSTEL
MCVTTS LSTEZ MCVTTS LSTEZ TVLA Org.unit: Loading points per shipping point LSTEL
MCVTTS MANDT MCVTTS MANDT T000 Clients MANDT
MCVTTS OIG_MEIZT SY MANDT T006 Units of Measurement MANDT
MCVTTS OIG_MEIZT MCVTTS OIG_MEIZT T006 Units of Measurement MSEHI
MCVTTS ROUTE MCVTTS ROUTE TVRO Routes ROUTE
MCVTTS ROUTE MCVTTS MANDT TVRO Routes MANDT
MCVTTS SDABW MCVTTS MANDT TVSAK Special Processing Indicator MANDT
MCVTTS SDABW MCVTTS SDABW TVSAK Special Processing Indicator SDABW
MCVTTS SKALSM 'A' T683 Pricing procedures KVEWE
MCVTTS SKALSM 'F ' T683 Pricing procedures KAPPL
MCVTTS SKALSM MCVTTS SKALSM T683 Pricing procedures KALSM
MCVTTS SKALSM MCVTTS MANDT T683 Pricing procedures MANDT
MCVTTS TDLNR MCVTTS MANDT LFA1 Vendor Master (General Section) MANDT
MCVTTS TDLNR MCVTTS TDLNR LFA1 Vendor Master (General Section) LIFNR
MCVTTS TKNUM MCVTTS MANDT VTTK Shipment Header MANDT
MCVTTS TKNUM MCVTTS TKNUM VTTK Shipment Header TKNUM
MCVTTS TORA MCVTTS LGNUMA T30B WM Gates LGNUM
MCVTTS TORA MCVTTS TORA T30B WM Gates LGTOR
MCVTTS TORA MCVTTS MANDT T30B WM Gates MANDT
MCVTTS TORZ MCVTTS MANDT T30B WM Gates MANDT
MCVTTS TORZ MCVTTS LGNUMZ T30B WM Gates LGNUM
MCVTTS TORZ MCVTTS TORZ T30B WM Gates LGTOR
MCVTTS VSART MCVTTS MANDT T173 Routes: Mode of Transport for Each Shipping Type MANDT
MCVTTS VSART MCVTTS VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
MCVTTS VSTEL MCVTTS MANDT TVST Organizational Unit: Shipping Points MANDT
MCVTTS VSTEL MCVTTS VSTEL TVST Organizational Unit: Shipping Points VSTEL
MCVTTS VSTEZ MCVTTS MANDT TVST Organizational Unit: Shipping Points MANDT
MCVTTS VSTEZ MCVTTS VSTEZ TVST Organizational Unit: Shipping Points VSTEL
MCVTTS WERKA MCVTTS WERKA T001W Plants/Branches WERKS
MCVTTS WERKA MCVTTS MANDT T001W Plants/Branches MANDT
MCVTTS WERKZ MCVTTS MANDT T001W Plants/Branches MANDT
MCVTTS WERKZ MCVTTS WERKZ T001W Plants/Branches WERKS