VTTK

Shipment Header | #header | Component: Transportation
Column Name Description
MANDT FK Client
TKNUM Shipment Number
Column Name Description
💲 Currency of Maximum Price (TNDR_MAXC):
TNDR_MAXP Maximum Price for Shipment
💲 Currency of Actual Shipment Costs (TNDR_ACTC):
TNDR_ACTP Actual Shipment Costs for Shipment
Column Name Description
📏 Distance Unit of Measure (MEDST):
DISTZ Distance
📏 Unit of measure for travelling times (MEIZT):
FAHZT Travelling time only between two locations
GESZT Total travelling time between two locations incl. breaks
📏 Unit of Measure for Load Length (TNDR_LDLU):
TNDR_LDLG Length of Loading Platform
📏 Unit of Weight for Transportation Planning (DTMEG):
ALLOWED_TWGT Allowed total weight of shipment
Column Name Description
ERDAT Date on which the record was created
ERZET Entry time
AEDAT Last Changed On
AEZET Time last change was made
DTDIS Date of end of planning
UZDIS Scheduling end time
DPREG Planned date of check-in
UPREG Planned check-in time
DAREG Actual date of check-in
UAREG Current time of check-in
DPLBG Planned date for start of loading
UPLBG Planned loading start time
DALBG Current date for start of loading
UALBG Actual loading start time
DPLEN Planned date for end of loading
UPLEN Planned loading end time
DALEN Actual date for end of loading
UALEN Actual loading end time
DPABF Planned date for shipment completion
UPABF Planned time for processing
DTABF Current date of shipment completion
UZABF Time of transportation processing
DPTBG Planned date for start of shipment
UPTBG Planned transport start time
DATBG Current date for start of shipment
UATBG Actual transport start time
DPTEN Planned date for end of shipment
UPTEN Planned transport end time
DATEN Actual Date for End of Shipment
UATEN Actual shipment end time
DGMDDAT Selection date dangerous goods master data
TNDRDAT Date of tender status
TNDRZET Time of tender status
TNDR_EXPD Date on Which Offer Expires
TNDR_EXPT Time at Which Quotation Expires
TNDR_ERPD Earliest Pickup Date
TNDR_ERPT Earliest Pickup Time
TNDR_LTPD Latest Pickup Date
TNDR_LTPT Latest Pickup Time
TNDR_ERDD Earliest Delivery Date
TNDR_ERDT Earliest Delivery Time
TNDR_LTDD Latest Delivery Date
TNDR_LTDT Latest Delivery Time
Column Name Description
VBTYP SD Document Category Show values
STERM Leg determination Show values
ABFER Shipment completion type Show values
ABWST Processing control Show values
BFART Service Level Show values
LAUFK Leg Indicator Show values
STDIS Status of transportation planning Show values
STREG Status of check-in Show values
STLBG Status for start of loading Show values
STLAD Status for end of loading Show values
STABF Status of shipment completion Show values
STTBG Status for start of shipment Show values
STTEN Status for end of shipment Show values
STTRG Overall transportation status Show values
PKSTK Shipment Contains Handling Units Show values
FBSTA Status of shipment costs calculation Show values
FBGST Overall status of calculation of shipment costs for shipment Show values
ARSTA Status of shipment costs settlement Show values
ARGST Total status of shipment costs settlement for shipment Show values
STERM_DONE Leg determination complete Show values
VSE_FRK Handling Unit Data are Referred in Shipment Cost Document Show values
FRKRL Shipment costs relevance Show values
ROCPY_DONE Route copied from delivery Show values
TSEGFL Time segment exists Show values
DGTLOCK Block Indicator for Dangerous Goods Show values
CONT_DG Indicator: Document contains dangerous goods Show values
TNDRST Tender Status Show values
TNDRRC Acceptance Condition/Rejection Reason Show values
KZHULFR Indicator: HUs Relevant for Delivery Item Generation Show values
VLSTK Distribution Status (Decentralized Warehouse Processing) Show values
/VSO/R_STATUS Status of Vehicle Space Optimization Show values
Column Name Description Domain name
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
SIGNI Container ID TEXT20
EXTI1 External identification 1 TEXT20
EXTI2 External identification 2 TEXT20
TPBEZ Description of Shipment TEXT20
TERNR Order Number AUFNR
STAFO Update Group for statistics update STAFO
GESZTD Planned total time of transportation (in days) TSTRDURAG
FAHZTD Planned duration of transportation (in hours:minutes) TSTRDURAN
GESZTDA Actual total time of shipment (in days) TSTRDURAG
FAHZTDA Actual time needed for transporation (in hours:minutes) TSTRDURAN
HANDLE Globally unique identifier (linked to time segment, etc) SYSUUID_22
TSEGTP Time segment event group shipment header TSEGTEMPLA
TEXT1 Addit.text 1 TEXT40
TEXT2 Addit.text 2 TEXT40
TEXT3 Addit.text 3 TEXT40
TEXT4 Addit.text 4 TEXT40
WARZTD Planned waiting time of shipment (in hours:minutes) TSTRDURAN
WARZTDA Current waiting time of shipment (in hours:minutes) TSTRDURAN
AULWE Route Schedule AULWE
TNDR_TEXT Tendering Text TEXT80
TNDR_CARR Forwarding Agent Who Accepted the Shipment TEXT10
TNDR_CRNM Name of Carrier Who Accepted the Shipment NAME
TNDR_TRKID Forwarding Agent Tracking ID TEXT35
VERURSYS Shipment Distribution: Original System LOGSYS
CM_IDENT Identification Number for Continuous Moves CHAR12
CM_SEQUENCE Sequence of Transports in Connecting Traffice SEQUENCE1
EXT_FREIGHT_ORD External Freight Order ID EXT_FREIGHT_ORDER
EXT_TM_SYS Key Name of Business System SLD_BSKEY
/BEV1/RPMOWA Vehicle EQUNR
/BEV1/RPANHAE Trailer EQUNR
/BEV1/RPFLGNR Loading Sequence Number in the Tour /DSD/RP_SEQUENCENR
Master Data Relations Join Conditions
Driver master (Route Planning)
  • VTTK.MANDT == KNA1.MANDT
  • VTTK./BEV1/RPFAR1 == KNA1.KUNNR
Driver master (Route Planning)
  • VTTK.MANDT == KNA1.MANDT
  • VTTK./BEV1/RPFAR2 == KNA1.KUNNR
Suppl. 1
  • Suppl. 1
  • Client
Suppl. 2
Suppl. 3
Suppl. 4
Pricing procedure in shipment header
  • ?
  • Pricing procedure in shipment header
  • ?
  • VTTK.MANDT == T683.MANDT
  • VTTK.[column in domain "KAPPL"] == T683.KAPPL
  • VTTK.KKALSM == T683.KALSM
  • VTTK.[column in domain "KVEWE"] == T683.KVEWE
Client VTTK.MANDT == T000.MANDT
Dangerous Goods Management Profile in SD Documents
  • Dangerous Goods Management Profile in SD Documents
  • Client
  • VTTK.PROLI == TDGC5.PROLI
  • VTTK.MANDT == TDGC5.MANDT
Shipment route
  • VTTK.MANDT == TVRO.MANDT
  • VTTK.ROUTE == TVRO.ROUTE
Special Processing Indicator
  • VTTK.MANDT == TVSAK.MANDT
  • VTTK.SDABW == TVSAK.SDABW
Shipment type
  • VTTK.MANDT == TVTK.MANDT
  • VTTK.SHTYP == TVTK.SHTYP
Number of forwarding agent
  • VTTK.MANDT == LFA1.MANDT
  • VTTK.TDLNR == LFA1.LIFNR
Currency of Actual Shipment Costs
  • VTTK.MANDT == TCURC.MANDT
  • VTTK.TNDR_ACTC == TCURC.WAERS
Currency of Maximum Price
  • VTTK.MANDT == TCURC.MANDT
  • VTTK.TNDR_MAXC == TCURC.WAERS
Transportation planning point
  • Transportation planning point
  • Client
  • VTTK.TPLST == TTDS.TPLST
  • VTTK.MANDT == TTDS.MANDT
Shipping type of subsequent leg
  • Shipping type of subsequent leg
  • Client
  • VTTK.VSANL == T173.VSART
  • VTTK.MANDT == T173.MANDT
Shipping Type
  • Shipping Type
  • Client
  • VTTK.VSART == T173.VSART
  • VTTK.MANDT == T173.MANDT
Shipping type of preliminary leg
  • Shipping type of preliminary leg
  • Client
  • VTTK.VSAVL == T173.VSART
  • VTTK.MANDT == T173.MANDT
Shipping Conditions
  • VTTK.MANDT == TVSB.MANDT
  • VTTK.VSBED == TVSB.VSBED