SAP Table

TVTK Shipment Types

SAP table TVTK has 2 primary key fields being MANDT,SHTYP.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

TVTK columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeySHTYP Shipment type CHAR 4 0 SHTYP
VBTYP SD Document Category CHAR 4 0 VBTYPL
NUMKI Number Range of Internal Number Assignment CHAR 2 0 NUMKI
NUMKE Number Range of External Number Assignment CHAR 2 0 NUMKE
KOPGR Screen sequence group in doc. header CHAR 4 0 KOPGR
STERM Leg determination CHAR 1 0 STERM
ABFER Shipment completion type CHAR 1 0 ABFER
ABWST Processing control CHAR 1 0 ABWST
BFART Service Level CHAR 1 0 BFART
VSART Shipping Type CHAR 2 0 T173 VERSART
VSAVL Shipping type of preliminary leg CHAR 2 0 T173 VSAVL
VSANL Shipping type of subsequent leg CHAR 2 0 T173 VSANL
LAUFK Leg Indicator CHAR 1 0 LAUFK
KALSM Output determination procedure CHAR 6 0 T683 KALSMB
KAPPL Application for output conditions CHAR 2 0 T681A NA_KAPPL
TXTGR Text Determination Procedure CHAR 2 0 TTXG TXTGR
PARGR Partner Determination Procedure CHAR 4 0 TVPG PARGR
SVTRA Selection variant for transportation planning CHAR 14 0 SVTRA
PROFIDNETZ Network Profile CHAR 7 0 TCN41 PROFIDNZPL
DTMEG Unit of Weight for Transportation Planning UNIT 3 0 * DTMEG
DTMEV Volume Unit for Transportation Planning UNIT 3 0 * DTMEV
KSCHL Output Type CHAR 4 0 * NA_KSCHL
ROUTE_VLF Indicator: Proposed route from delivery CHAR 1 0 ROUTE_VLF
SPEDI_VLF Indicator: Proposed forwarding agent from delivery CHAR 1 0 SPEDI_VLF
ABF_ACTPRF Actions to be carried out for completing a shipment CHAR 14 0 ABF_ACTPRF
FKART Shipment cost type CHAR 4 0 TVTF FKART_T
STGTA Shipment: statistics group, shipment type CHAR 2 0 VTSGT STGTA
FRKRL Proposal freight costs relevance, Shipment header CHAR 1 0 FRKRL_KOP
FRKRL_STR Proposal freight costs relevance, shipment leg CHAR 1 0 FRKRL_STR
FRKRL_UMP Proposal for shipment costs relevance - Load transfer point CHAR 1 0 FRKRL_UMP
FRKRL_GRP Proposal for freight costs relevance, Border cross.pt CHAR 1 0 FRKRL_GRP
ROUTE_STAG Adopt stages from route into shipment CHAR 1 0 ROUTE_STAG
CHGDOC_SHTYP Indicator: Change document shipment for shipment type CHAR 1 0 CHGDOC_SHTYP
DIS_ACTPRF Activities to be performed for planning a shipment CHAR 14 0 DIS_ACTPRF
REG_ACTPRF Activites to be carried out at shipment check-in CHAR 14 0 REG_ACTPRF
LBG_ACTPRF Activities to be performed at start of shipment loading CHAR 14 0 LBG_ACTPRF
LEN_ACTPRF Activities to be performed at loading finish of shipment CHAR 14 0 LEN_ACTPRF
TBG_ACTPRF Activites to be carried out at the beginning of a shipment CHAR 14 0 TBG_ACTPRF
TEN_ACTPRF Activities to be carried out at the end of a shipment CHAR 14 0 TEN_ACTPRF
PLANNING_PROFILE Planning profile for transportation planning CHAR 14 0 PLANNING_PROFILE
TSEGTP Time segment event group shipment header CHAR 10 0 TTSEGTPLH TSEGTPLVTT
KOPRF Control Indicator for Pick Check in Shipment CHAR 1 0 KOPRF
TERMIN_VLF Indicator: Proposal for deadlines from deliveries CHAR 1 0 TERMIN_VLF
TRINF_UEB Data transfer NUMC 3 0 * TRINF_UEB
PMODE_VD Delivery Split Profile Before Transportation Planning CHAR 4 0 TVDSS LEDSPD_PMODE_TRA1
PMODE_ND Delivery Split Profile after Transportation Planning CHAR 4 0 TVDSS LEDSPD_PMODE_TRA2
KZHULFR Indicator: HUs Relevant for Delivery Item Generation CHAR 1 0 KZHULFR
VTDWM Distribution Control: Decentralized WMS CHAR 1 0 VTDWM
BORGR_PROCTYP GR-Relevance Indicator CHAR 2 0 BORGR_PROCTYP
BORGR_AUTO_REG Automatic Registration for the Status of the Inb. Deliveries CHAR 1 0 BORGR_AUTO_REG
BORGR_AUTO_LEN Aut. "Loading end" From the Status of the Inb. Deliveries CHAR 1 0 BORGR_AUTO_LEN
BORGR_EXTI1_UNQ Uniqueness of the External ID CHAR 1 0 BORGR_EXID_UNIQUE
BORGR_EXTI1_MUST Required Entry CHAR 1 0 BORGR_EXID_MUST
BORGR_EXTI1_EEDI Ty.of Error Message when ID Transferred by EDI is not Unique CHAR 1 0 BORGR_EXID_ERREDI
BORGR_EXTI1_EDIA Type of Error Message when Online ID is not Unique CHAR 1 0 BORGR_EXID_ERRDIA
BORGR_EXTI2_UNQ Uniqueness of the External ID CHAR 1 0 BORGR_EXID_UNIQUE
BORGR_EXTI2_MUST Required Entry CHAR 1 0 BORGR_EXID_MUST
BORGR_EXTI2_EEDI Ty.of Error Message when ID Transferred by EDI is not Unique CHAR 1 0 BORGR_EXID_ERREDI
BORGR_EXTI2_EDIA Type of Error Message when Online ID is not Unique CHAR 1 0 BORGR_EXID_ERRDIA
BORGR_SIGNI_UNQ Uniqueness of the External ID CHAR 1 0 BORGR_EXID_UNIQUE
BORGR_SIGNI_MUST Required Entry CHAR 1 0 BORGR_EXID_MUST
BORGR_SIGNI_EEDI Ty.of Error Message when ID Transferred by EDI is not Unique CHAR 1 0 BORGR_EXID_ERREDI
BORGR_SIGNI_EDIA Type of Error Message when Online ID is not Unique CHAR 1 0 BORGR_EXID_ERRDIA
BORGR_TPBEZ_UNQ Uniqueness of the External ID CHAR 1 0 BORGR_EXID_UNIQUE
BORGR_TPBEZ_MUST Required Entry CHAR 1 0 BORGR_EXID_MUST
BORGR_TPBEZ_EEDI Ty.of Error Message when ID Transferred by EDI is not Unique CHAR 1 0 BORGR_EXID_ERREDI
BORGR_TPBEZ_EDIA Type of Error Message when Online ID is not Unique CHAR 1 0 BORGR_EXID_ERRDIA
BORGR_ASN_NOT_EX Shipments for Non-Existing Inbound Deliveries Allowed CHAR 1 0 BORGR_ASN_NOT_EXIST
/ Relationships

TVTK foreign keys.

Table Field Check Table Description Check Field
TVTK FKART TVTF Shipment Cost Types MANDT
TVTK FKART TVTF Shipment Cost Types FKART
TVTK KALSM T683 Pricing procedures KAPPL
TVTK KALSM T683 Pricing procedures KALSM
TVTK KAPPL T681A Conditions: Applications KAPPL
TVTK PARGR TVPG Partner Function Groups PARGR
TVTK PMODE_ND TVDSS Profiles for Subsequent Outbound Delivery Split MANDT
TVTK PMODE_ND TVDSS Profiles for Subsequent Outbound Delivery Split PMODE
TVTK PMODE_VD TVDSS Profiles for Subsequent Outbound Delivery Split MANDT
TVTK PMODE_VD TVDSS Profiles for Subsequent Outbound Delivery Split PMODE
TVTK PROFIDNETZ TCN41 Network Defaults MANDT
TVTK PROFIDNETZ TCN41 Network Defaults PLNAW
TVTK STGTA VTSGT Shipment: Statistic Groups, Shipment Types MANDT
TVTK TSEGTP TTSEGTPLH Time Segment Template Header TEPL
TVTK TXTGR TTXG Text Processing: Text ID Groups MANDT
TVTK VSANL T173 Routes: Mode of Transport for Each Shipping Type MANDT
TVTK VSANL T173 Routes: Mode of Transport for Each Shipping Type VSART
TVTK VSART T173 Routes: Mode of Transport for Each Shipping Type MANDT
TVTK VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
TVTK VSAVL T173 Routes: Mode of Transport for Each Shipping Type MANDT
TVTK VSAVL T173 Routes: Mode of Transport for Each Shipping Type VSART
Back to SAP tables