SAP Table

TVLK Delivery Types

SAP table TVLK has 2 primary key fields being MANDT,LFART.

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

TVLK columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyLFART Delivery Type CHAR 4 0 LFART
KOPGR Screen sequence group for document header & item CHAR 4 0 TVHB BIFGR
UEVOR F-code default for overview screen CHAR 4 0 UEVOR_VL
TXN08 Number of the Standard Text CHAR 8 0 TXN08
UMFNG Display Range CHAR 20 0 UMFNG
NUMKI Number Range of Internal Number Assignment CHAR 2 0 NUMKI
NUMKE Number Range of External Number Assignment CHAR 2 0 NUMKE
NUMKIRULE Rule for Determining Number Ranges for Decentralized LES CHAR 1 0 LESHP_NUMKI_RULE
INCPO Item Number Increment of SD Documents NUMC 6 0 INCPO
PARGR Partner Determination Procedure CHAR 4 0 TVPG PARGR
AUFER A sales order is required as basis for delivery CHAR 1 0 AUFER
DAART Default Order Type for Deliveries Without Order Reference CHAR 4 0 TVAK DAART
POBED Requirement for item that does not refer to a sales order NUMC 3 0 POBED
REGGR Dummy function CHAR 3 0 DUMMY_3
REGLG Rule for determining the storage location for picking CHAR 4 0 REGLG
WAAUS Dummy function in length 1 CHAR 1 0 DUMMY
ROUTF New route determination: with or without a check? CHAR 1 0 ROUTF
VBTYP SD Document Category CHAR 4 0 VBTYPL
TXTGR Text Determination Procedure CHAR 2 0 TTXG TXTGR
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
KAPPL Application for output conditions CHAR 2 0 T681A NA_KAPPL
KALSM Output determination procedure CHAR 6 0 T683 KALSMB
KSCHL Output Type CHAR 4 0 T685 NA_KSCHL
STGAK Statistics group for sales document type CHAR 2 0 TVSF STGAK
CMGRL Delivery credit group CHAR 2 0 T691D CMGRL
CMGRK Credit group for picking CHAR 2 0 T691D CMGRK
CMGRW Goods issue credit group CHAR 2 0 T691D CMGRW
QHERK Inspection Lot Origin CHAR 2 0 TQ31 QHERK
TRSPG Shipment Blocking Reason CHAR 2 0 TTSG TRSPG
TDIIX Transportation relevant indicator for delivery CHAR 1 0 TDIIX_LIEF
PROFIDNETZ Network Profile CHAR 7 0 TCN41 PROFIDNZPL
EXCOK Carry out legal control for sales document type CHAR 1 0 EXCOK
NEUTE Reschedule Deliveries CHAR 1 0 NEUTE
KALSP Shipping: Pricing procedure CHAR 6 0 T683 KALSP
FEHGR Incompleteness Procedure for Sales Document CHAR 2 0 TVUV FEHGR
LNSPL Perform Delivery Split According to Warehouse Number CHAR 1 0 LNSPL
AVERP Automatic packing using packing proposal CHAR 1 0 AVERP
PM_ITEM_GEN Generation of Delivery Items for HU Packaging Materials CHAR 1 0 LESHP_ITEM_GEN
REGTB Rule for determining door and material staging area CHAR 4 0 REGTB
BZOPS Staging area determination at delivery item level? CHAR 1 0 BZOPS
EXCBC Boycott list check of standard partners f.Foreign Trade - On CHAR 1 0 EXCBC
EXCEM Embargo check of standard partners for Foreign Trade - On CHAR 1 0 EXCEM
EXCLG Indicator: Save legal control log CHAR 1 0 EXCLG
J_1ADOCCLS Document Class CHAR 1 0 J_1ADOCCLS J_1ADOCCL_
RFPL_SW Route schedule switch for delivery types CHAR 1 0 RFPL_SW
TSEGTP Event group time segment delivery header CHAR 10 0 TTSEGTPLH TSEGTPLLIK
UVEIB Doc. pricing procedure for incomplete export/import data CHAR 3 0 T609B UVEIB
DBTCH Distribution Mode for the Delivery CHAR 1 0 DBTCH
DSFAD Delivery Split for Additional Partners CHAR 1 0 TVLK_DSFAD
SPOFI Rules for Shipping Point Determination CHAR 1 0 SPOFI
OIDELDCM Active flag f. Document Change Management (DCM) f.deliveries CHAR 1 0 OIC_SDP_DDCM
SPE_NUMKT Number Range for Temporary Inbound Deliveries CHAR 2 0 /SPE/INB_NUMKT
SPE_NR_RECYCLING Enable Number Reuse for Unchecked/Temporary Deliveries CHAR 1 0 /SPE/NR_RECYCLING
BORGR_LIFEX_MUST Required Entry CHAR 1 0 /SPE/EXID_MUST
BORGR_LIFEX_UNQ Uniqueness of the External ID CHAR 1 0 /SPE/EXID_UNIQUE
BORGR_LIFEX_EEDI Error Message Type when ID Transferred by EDI Is Not Unique CHAR 1 0 /SPE/EXID_ERREDI
BORGR_LIFEX_EDIA Type of Error Message when Online ID is not Unique CHAR 1 0 /SPE/EXID_ERRDIA
BORGR_SODET Automatic PO Determination CHAR 1 0 /SPE/INB_SODET
HOLD_DATA Indicator Whether Inbound Deliveries on Hold Are Allowed CHAR 1 0 /SPE/HOLD_DATA
TDID Text ID CHAR 4 0 TTXERN TDID
TDSPRAS Language Key LANG 1 0 T002 SPRAS
EDI_WEIGHTVOL Adopt Weight and Volume from IDoc CHAR 1 0 BORGR_EDI_WEIGHTVOL
SPE_ENABLE_VALID Enable Validation for All Deliveries within VL60 CHAR 1 0 /SPE/INB_ENABLE_VALIDATION
MSR_FKARA Default Billing Type CHAR 4 0 TVFK MSR_FKARA
FSH_AUDELOC Automatic Deallocation for Delivery Changes CHAR 1 0 FSH_AUDELOC
FSH_VASS_ACT VAS Active Indicator in SD CHAR 1 0 FSH_VASS_ACT
FSH_VASS_KALSM VAS Determination Procedure in Sales and Distribution CHAR 6 0 FSH_VASS_KALSM
FSH_VASS_CORR VAS Correlation in Deliveries CHAR 1 0 FSH_VASS_CORR_L
RESTORE_ALLOC Restore Assignments in Delivery Documents CHAR 1 0 ARUN_RESTORE_ALLOC
ITMAC Trade Compliance is active CHAR 1 0 /SAPSLL/ITMAC
SGT_IGNORE_SEG Ignore Segmentation Rules in Delivery Document CHAR 1 0 SGT_IGNORE_SEG
RFM_BOM_CORR BOM Quantity Correlation CHAR 1 0 RFM_BOM_CORR
RFM_VAS_QTY_CORR Quantity Correlation in Delivery CHAR 1 0 RFM_VAS_QTY_CORR
RFM_MAIN_ITEM_CORR Main Item Delivery Correlation CHAR 1 0 RFM_MAIN_ITEM_CORR
FLEXNUM_ROUTINE_NO Enhancement Routine No. for Flexible Delivery Doc. Numbering NUMC 7 0 LE_SHP_FLEXNUM_ROUTINE_NO
SGT_IGNORE_BATCH_SPLIT Ignore Batch Split in Delivery Document CHAR 1 0 SGT_IGNORE_BATCH_SPLIT
INT_TOCD_OFFSET Offset for Internal Transfer of Control Dates DEC 3 0 INT_TOCD_OFFSET
INT_TOCD_OFFSET_UNIT Offset Unit for Internal Transfer of Control Dates UNIT 3 0 T006 INT_TOCD_OFFSET_UNIT
EXT_TOCD_OFFSET Offset for External Transfer of Control Dates DEC 3 0 EXT_TOCD_OFFSET
EXT_TOCD_OFFSET_UNIT Offset Unit for External Transfer of Control Dates UNIT 3 0 T006 EXT_TOCD_OFFSET_UNIT
RFM_VAS_PLANT_CHECK Enable VAS Plant Capability Check CHAR 1 0 RFM_VAS_PLANT_CHECK
/ Relationships

TVLK foreign keys.

Table Field Check Table Description Check Field
TVLK CMGRK T691D Credit groups for document types MANDT
TVLK CMGRL T691D Credit groups for document types MANDT
TVLK CMGRW T691D Credit groups for document types MANDT
TVLK DAART TVAK Sales Document Types MANDT
TVLK DAART TVAK Sales Document Types AUART
TVLK EXT_TOCD_OFFSET_UNIT T006 Units of Measurement MANDT
TVLK FEHGR TVUV Incompletion Control: Procedures MANDT
TVLK FEHGR TVUV Incompletion Control: Procedures FEHGR
TVLK INT_TOCD_OFFSET_UNIT T006 Units of Measurement MANDT
TVLK J_1ADOCCLS J_1ADOCCLS Official document class for Argentina MANDT
TVLK J_1ADOCCLS J_1ADOCCLS Official document class for Argentina J_1ACOCCLS
TVLK KALSM T683 Pricing procedures KAPPL
TVLK KALSM T683 Pricing procedures KALSM
TVLK KALSP T683 Pricing procedures KAPPL
TVLK KALSP T683 Pricing procedures KALSM
TVLK KAPPL T681A Conditions: Applications KAPPL
TVLK KOPGR TVHB Sales Document: Screen Sequence Group MANDT
TVLK KOPGR TVHB Sales Document: Screen Sequence Group OBJEKT
TVLK KOPGR TVHB Sales Document: Screen Sequence Group BIFGR
TVLK KSCHL T685 Conditions: Types KAPPL
TVLK KSCHL T685 Conditions: Types KSCHL
TVLK MSR_FKARA TVFK Billing: Document Types MANDT
TVLK MSR_FKARA TVFK Billing: Document Types FKART
TVLK PARGR TVPG Partner Function Groups PARGR
TVLK PROFIDNETZ TCN41 Network Defaults MANDT
TVLK PROFIDNETZ TCN41 Network Defaults PLNAW
TVLK QHERK TQ31 Inspection Lot Origins HERKUNFT
TVLK STGAK TVSF SD: Statistics Groups for Document Types and Item Categories MANDT
TVLK TDID TTXERN Text Processing: Text ID Groups covers ttxs & ttxer TXTGR
TVLK TDSPRAS T002 Language Keys (Component BC-I18) SPRAS
TVLK TRSPG TTSG Shipment Blocking Reason MANDT
TVLK TSEGTP TTSEGTPLH Time Segment Template Header TEPL
TVLK TXTGR TTXG Text Processing: Text ID Groups MANDT
TVLK UVEIB T609B FT: Incompleteness: Doc.Pric.Procedure - Header and Item KPEXI
Back to SAP tables