SAP table TVLK (Delivery Types)

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

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

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
LFART 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
Remain on initial screen until a function is selected
UEGW Overview for rough goods receipt
UEKO Go to the picking overview screen after pressing ENTER
UELA Overview for inbound delivery
UELG Go to the overview screen for extent delivered after ENTER
UER1 Go to quantity overview by pressing ENTER
UER2 Go to weight overview by pressing ENTER
TXN08 Number of the Standard Text CHAR 8 0 TXN08
UMFNG Display Range CHAR 20 0 UMFNG
UALL All items
UHAU Main items
UMAR Selected items
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
Delivery type interval
A Warehouse number/delivery type interval
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
MALA Shipping point / plant / storage condition
MARE MALA, then RETA (backup procedure)
MSRE Advanced Returns Inbound (Considers Follow-Up Activity)
RETA Plant / situation (SITUA) / storage condition
YY Custom Rules
WAAUS Dummy function in length 1 CHAR 1 0 DUMMY
ROUTF New route determination: with or without a check? CHAR 1 0 ROUTF
No new route determination
A New route determination without check
B New route determination with check
C New route determination for inbound deliveries
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
0 Master Contract
1 Sales Activities (CAS)
2 External Transaction
3 Invoice List
4 Credit Memo List
5 Intercompany Invoice
6 Intercompany Credit Memo
7 Delivery/Shipping Notification
8 Shipment
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
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
Legal control: No check
C Legal control: Check in dispatch and export area
NEUTE Reschedule Deliveries CHAR 1 0 NEUTE
No rescheduling
A Reschedule after relevant changes
X Reschedule if deadlines are in the past
Y Like X or route changed or route schedule changed
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
CUST Customer-dependent determination
ROUT Route schedule-dependent determination
YYYA user exit
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
Legal control log is not saved
1 Saving log level 1 of legal control
2 Saving log level 2 of legal control
3 Saving log level 3 of legal control
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
Distribution Control By Warehouse Number
1 Stop Distribution
2 Distribution at Delivery Creation
DSFAD Delivery Split for Additional Partners CHAR 1 0 TVLK_DSFAD
SPOFI Rules for Shipping Point Determination CHAR 1 0 SPOFI
Plant-Specific Shipping Point Determination
L Storage-Location-Specific Shipping Point Determination
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
Not a required entry
X Required entry
BORGR_LIFEX_UNQ Uniqueness of the External ID CHAR 1 0 /SPE/EXID_UNIQUE
Do not check
X Check
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
Automatic PO determination: No
1 Automatic PO determination: Yes
HOLD_DATA Indicator Whether Inbound Deliveries on Hold Are Allowed CHAR 1 0 /SPE/HOLD_DATA
Deliveries on Hold Not Allowed
E Inb. Del. on Hold Allowed; always Put on Hold Using EDI/SIC
I Inb. Del. on Hold Allowed; Always Put on Hold Using EDI
X Deliveries on Hold Allowed
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
Not Active
X Active
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
Indicator is not set
X Indicator is set
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
No correlation
A Correlation with restoration of assignment
B Correlation with deallocation of assignment
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

TVLK foreign key relationships

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