1. Home
  2. Resources
  3. SAP Tables
  4. TVLK - Delivery Types

SAP Table TVLK

Delivery Types

TVLK (Delivery Types) 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 TVLK to other SAP tables.

TVLK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LFART Delivery Type LFART CHAR 4 0
KOPGR Screen sequence group for document header & item BIFGR TVHB CHAR 4 0
UEVOR F-code default for overview screen UEVOR_VL CHAR 4 0
NULL Remain on initial screen until a function is selected
UER1 Go to quantity overview by pressing ENTER
UER2 Go to weight overview by pressing ENTER
UEKO Go to the picking overview screen after pressing ENTER
UELG Go to the overview screen for extent delivered after ENTER
UELA Overview for inbound delivery
UEGW Overview for rough goods receipt
TXN08 Number of the standard text TXN08 CHAR 8 0
UMFNG Display Range UMFNG CHAR 20 0
UALL All items
UHAU Main items
UMAR Selected items
NUMKI Number range in the case of internal number assignment NUMKI CHAR 2 0
NUMKE Number range in the case of external number assignment NUMKE CHAR 2 0
NUMKIRULE Rule for Determining Number Ranges for Decentralized LES LESHP_NUMKI_RULE CHAR 1 0
NULL Delivery type interval
A Warehouse number/delivery type interval
INCPO Increment of item number in the SD document INCPO NUMC 6 0
PARGR Partner Determination Procedure PARGR TVPG CHAR 4 0
AUFER A sales order is required as basis for delivery AUFER CHAR 1 0
NULL No preceding documents required
X Sales order required
B Purchase order required
L Delivery for subcontracting
P Project required
U Stock transfer w/o previous activity
R Return delivery to vendor
O Goods movement through inb.deliv. / post.chge /outb. deliv.
W Delivery from PP interface (work order)
H Posting change with delivery
DAART Default order type for deliveries without reference to order DAART TVAK CHAR 4 0
POBED Requirement for item that does not refer to a sales order POBED NUMC 3 0
REGGR Dummy function DUMMY_3 CHAR 3 0
REGLG Rule for determining the storage location for picking REGLG CHAR 4 0
MALA Shipping point / plant / storage condition
RETA Plant / situation (SITUA) / storage condition
MARE MALA, then RETA (backup procedure)
YY User exit in MV50AFZZ
MSRE Advanced Returns Inbound (Considers Follow-Up Activity)
WAAUS Dummy function in length 1 DUMMY CHAR 1 0
ROUTF New route determination: with or without a check? ROUTF CHAR 1 0
NULL No new route determination
A New route determination without check
B New route determination with check
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
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
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
TXTGR Text determination procedure TXTGR TTXG CHAR 2 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
KAPPL Application for output conditions NA_KAPPL T681A CHAR 2 0
KALSM Output determination procedure KALSMB T683 CHAR 6 0
KSCHL Output Type NA_KSCHL T685 CHAR 4 0
STGAK Statistics group for sales document type STGAK TVSF CHAR 2 0
CMGRL Delivery credit group CMGRL T691D CHAR 2 0
CMGRK Credit group for picking CMGRK T691D CHAR 2 0
CMGRW Goods issue credit group CMGRW T691D CHAR 2 0
QHERK Inspection Lot Origin QHERK TQ31 CHAR 2 0
TRSPG Shipment Blocking Reason TRSPG TTSG CHAR 2 0
TDIIX Transportation relevant indicator for delivery TDIIX_LIEF CHAR 1 0
X Yes
NULL No
PROFIDNETZ Network profile PROFIDNZPL TCN41 CHAR 7 0
EXCOK Carry out legal control for sales document type EXCOK CHAR 1 0
NULL Legal control: No check
C Legal control: Check in dispatch and export area
NEUTE Reschedule deliveries NEUTE CHAR 1 0
NULL No rescheduling
X Reschedule if deadlines are in the past
Y Like X or route changed or route schedule changed
A Reschedule after relevant changes
KALSP Shipping: Pricing procedure KALSP T683 CHAR 6 0
FEHGR Incompletion procedure for sales document FEHGR TVUV CHAR 2 0
LNSPL Perform Delivery Split According to Warehouse Number LNSPL CHAR 1 0
X Yes
NULL No
AVERP Automatic packing using packing proposal AVERP CHAR 1 0
X Yes
NULL No
PM_ITEM_GEN Generation of Delivery Items for HU Packaging Materials LESHP_ITEM_GEN CHAR 1 0
NULL No item generation for packaging material
X Generation of packaging material items possible
REGTB Rule for determining door and material staging area REGTB CHAR 4 0
CUST Customer-dependent determination
ROUT Route schedule-dependent determination
YYYA user exit
BZOPS Staging area determination at delivery item level? BZOPS CHAR 1 0
X Yes
NULL No
EXCBC Boycott list check of standard partners f.Foreign Trade - On EXCBC CHAR 1 0
NULL No check during document processing
W Warning message during document processing
E Error message during document processing
EXCEM Embargo check of standard partners for Foreign Trade - On EXCEM CHAR 1 0
NULL No check during document processing
W Warning message during document processing
E Error message during document processing
EXCLG Indicator: Save legal control log EXCLG CHAR 1 0
NULL 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 J_1ADOCCL_ J_1ADOCCLS CHAR 1 0
RFPL_SW Route schedule switch for delivery types RFPL_SW CHAR 1 0
X Yes
NULL No
TSEGTP Event group time segment delivery header TSEGTPLLIK TTSEGTPLH CHAR 10 0
UVEIB Doc. pricing procedure for incomplete export/import data UVEIB T609B CHAR 3 0
DBTCH Distribution Mode for the Delivery DBTCH CHAR 1 0
NULL Distribution Control By Warehouse Number
1 Stop Distribution
2 Distribution at Delivery Creation
DSFAD Delivery Split for Additional Partners TVLK_DSFAD CHAR 1 0
X Yes
NULL No
SPOFI Rules for Shipping Point Determination SPOFI CHAR 1 0
NULL Plant-Specific Shipping Point Determination
L Storage-Location-Specific Shipping Point Determination
OIDELDCM Active flag f. Document Change Management (DCM) f.deliveries OIC_SDP_DDCM CHAR 1 0
X Yes
NULL No
SPE_NUMKT Number Range for Temporary Inbound Deliveries /SPE/INB_NUMKT CHAR 2 0
SPE_NR_RECYCLING Enable Number Reuse for Unchecked/Temporary Deliveries /SPE/NR_RECYCLING CHAR 1 0
X Yes
NULL No
BORGR_LIFEX_MUST Required Entry /SPE/EXID_MUST CHAR 1 0
NULL Not a required entry
X Required entry
BORGR_LIFEX_UNQ Uniqueness of the External ID /SPE/EXID_UNIQUE CHAR 1 0
NULL Do not check
X Check
BORGR_LIFEX_EEDI Error Message Type when ID Transferred by EDI Is Not Unique /SPE/EXID_ERREDI CHAR 1 0
W Warning
E Error
I Information
NULL Undefined
BORGR_LIFEX_EDIA Type of Error Message when Online ID is not Unique /SPE/EXID_ERRDIA CHAR 1 0
W Warning
E Error
I Information
NULL Undefined
BORGR_SODET Automatic PO Determination /SPE/INB_SODET CHAR 1 0
NULL Automatic PO determination: No
1 Automatic PO determination: Yes
HOLD_DATA Indicator Whether Inbound Deliveries on Hold Are Allowed /SPE/HOLD_DATA CHAR 1 0
NULL Deliveries on Hold Not Allowed
X Deliveries on Hold Allowed
I Inb. Del. on Hold Allowed; Always Put on Hold Using EDI
E Inb. Del. on Hold Allowed; always Put on Hold Using EDI/SIC
TDID Text ID TDID TTXS CHAR 4 0
TDSPRAS Language Key SPRAS T002 LANG 1 0
EDI_WEIGHTVOL Adopt Weight and Volume from IDoc BORGR_EDI_WEIGHTVOL CHAR 1 0
X Yes
NULL No
SPE_ENABLE_VALID Enable Validation for All Deliveries within VL60 /SPE/INB_ENABLE_VALIDATION CHAR 1 0
X Yes
NULL No
MSR_FKARA Default Billing Type MSR_FKARA TVFK CHAR 4 0

TVLK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TVLK CMGRK TVLK MANDT T691D Credit groups for document types MANDT
TVLK CMGRK TVLK CMGRK T691D Credit groups for document types CRMGR_CM
TVLK CMGRL TVLK MANDT T691D Credit groups for document types MANDT
TVLK CMGRL TVLK CMGRL T691D Credit groups for document types CRMGR_CM
TVLK CMGRW TVLK MANDT T691D Credit groups for document types MANDT
TVLK CMGRW TVLK CMGRW T691D Credit groups for document types CRMGR_CM
TVLK DAART TVLK MANDT TVAK Sales Document Types MANDT
TVLK DAART TVLK DAART TVAK Sales Document Types AUART
TVLK FEHGR TVLK MANDT TVUV Incompletion Control: Procedures MANDT
TVLK FEHGR TVLK FEHGR TVUV Incompletion Control: Procedures FEHGR
TVLK J_1ADOCCLS TVLK MANDT J_1ADOCCLS Official document class for Argentina MANDT
TVLK J_1ADOCCLS TVLK J_1ADOCCLS J_1ADOCCLS Official document class for Argentina J_1ACOCCLS
TVLK KALSM TVLK KALSM T683 Pricing procedures KALSM
TVLK KALSM TVLK MANDT T683 Pricing procedures MANDT
TVLK KALSM 'B' T683 Pricing procedures KVEWE
TVLK KALSM TVLK KAPPL T683 Pricing procedures KAPPL
TVLK KALSP TVLK MANDT T683 Pricing procedures MANDT
TVLK KALSP 'A' T683 Pricing procedures KVEWE
TVLK KALSP 'V ' T683 Pricing procedures KAPPL
TVLK KALSP TVLK KALSP T683 Pricing procedures KALSM
TVLK KAPPL TVLK KAPPL T681A Conditions: Applications KAPPL
TVLK KOPGR TVLK MANDT TVHB Sales Document: Screen Sequence Group MANDT
TVLK KOPGR TTAB OBJEKT_BCF TVHB Sales Document: Screen Sequence Group OBJEKT
TVLK KOPGR TVLK KOPGR TVHB Sales Document: Screen Sequence Group BIFGR
TVLK KSCHL TVLK MANDT T685 Conditions: Types MANDT
TVLK KSCHL 'B' T685 Conditions: Types KVEWE
TVLK KSCHL TVLK KAPPL T685 Conditions: Types KAPPL
TVLK KSCHL TVLK KSCHL T685 Conditions: Types KSCHL
TVLK MANDT TVLK MANDT T000 Clients MANDT
TVLK MSR_FKARA TVLK MANDT TVFK Billing: Document Types MANDT
TVLK MSR_FKARA TVLK MSR_FKARA TVFK Billing: Document Types FKART
TVLK PARGR TVLK MANDT TVPG Partner Function Groups MANDT
TVLK PARGR TVLK PARGR TVPG Partner Function Groups PARGR
TVLK PROFIDNETZ 'S' TCN41 Network Defaults PLNAW
TVLK PROFIDNETZ TVLK PROFIDNETZ TCN41 Network Defaults PROFIDNETZ
TVLK PROFIDNETZ TVLK MANDT TCN41 Network Defaults MANDT
TVLK QHERK TVLK QHERK TQ31 Inspection Lot Origins HERKUNFT
TVLK STGAK TVLK MANDT TVSF SD: Statistics Groups for Document Types and Item Categories MANDT
TVLK STGAK TVLK STGAK TVSF SD: Statistics Groups for Document Types and Item Categories STGVB
TVLK TDID * TTXS Text Processing: Text Type in Text Proc. -> Access Sequence TDOBJECT
TVLK TDID TVLK TXTGR TTXS Text Processing: Text Type in Text Proc. -> Access Sequence TXTGR
TVLK TDID TVLK TDID TTXS Text Processing: Text Type in Text Proc. -> Access Sequence TDID
TVLK TDID TVLK MANDT TTXS Text Processing: Text Type in Text Proc. -> Access Sequence MANDT
TVLK TDSPRAS TVLK TDSPRAS T002 Language Keys (Component BC-I18) SPRAS
TVLK TRSPG TVLK MANDT TTSG Shipment Blocking Reason MANDT
TVLK TRSPG TVLK TRSPG TTSG Shipment Blocking Reason TRSPG
TVLK TSEGTP TVLK MANDT TTSEGTPLH Time Segment Template Header CLIENT
TVLK TSEGTP TVLK TSEGTP TTSEGTPLH Time Segment Template Header TEPL
TVLK TXTGR TVLK MANDT TTXG Text Processing: Text ID Groups MANDT
TVLK TXTGR 'VBBK' TTXG Text Processing: Text ID Groups TDOBJECT
TVLK TXTGR TVLK TXTGR TTXG Text Processing: Text ID Groups TXTGR
TVLK UVEIB TVLK UVEIB T609B FT: Incompleteness: Doc.Pric.Procedure - Header and Item UVEIB
TVLK UVEIB TVLK MANDT T609B FT: Incompleteness: Doc.Pric.Procedure - Header and Item MANDT
TVLK UVEIB 'A' T609B FT: Incompleteness: Doc.Pric.Procedure - Header and Item KPEXI