TVLK SAP (Delivery Types) Table details

Dictionary Type: Table
Description: Delivery Types




ABAP Code to SELECT data from TVLK
Related tables to TVLK
Access table TVLK




Table field list including key, data, relationships and ABAP select examples

TVLK is a standard SAP Table which is used to store Delivery Types data and is available within R/3 SAP systems depending on the version and release level.

The TVLK table consists of various fields, each holding specific information or linking keys about Delivery Types data available in SAP. These include LFART (Delivery Type), KOPGR (Screen sequence group for document header & item), UEVOR (F-code default for overview screen), TXN08 (Number of the standard text).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: G - Customising table which is protected against SAP Update
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)

Text table = TVLKT


SAP TVLK table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
LFARTDelivery Type LFARTCHAR4LFARTALT
KOPGRScreen sequence group for document header & item BIFGRCHAR4TVHBBIFGR
UEVORF-code default for overview screen UEVOR_VLCHAR4UEVOR_VL
TXN08Number of the standard text TXN08CHAR8TXN08
UMFNGDisplay Range UMFNGCHAR20UMFNG
NUMKINumber range in the case of internal number assignment NUMKICHAR2NUMKR
NUMKENumber range in the case of external number assignment NUMKECHAR2NUMKR
NUMKIRULERule for Determining Number Ranges for Decentralized LES LESHP_NUMKI_RULECHAR1LESHP_NUMKI_RULE
INCPOIncrement of item number in the SD document INCPONUMC6NUM6
PARGRPartner Determination Procedure PARGRCHAR4TVPGPARGR
AUFERA sales order is required as basis for delivery AUFERCHAR1VOERF
DAARTDefault order type for deliveries without reference to order DAARTCHAR4TVAKAUARTAUART
POBEDRequirement for item that does not refer to a sales order POBEDNUMC3BEDNG
REGGRDummy function DUMMY_3CHAR3CHAR3
REGLGRule for determining the storage location for picking REGLGCHAR4REGLG
WAAUSDummy function in length 1 DUMMYCHAR1DUMMY
ROUTFNew route determination: with or without a check? ROUTFCHAR1ROUTF
VBTYPSD document category VBTYPCHAR1VBTYP
TXTGRText determination procedure TXTGRCHAR2TTXGTXTGR
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
KAPPLApplication for output conditions NA_KAPPLCHAR2T681AKAPPLNA_KAPPL
KALSMOutput determination procedure KALSMBCHAR6T683KALSM
KSCHLOutput Type NA_KSCHLCHAR4T685KSCHLNACCSH_NA_KSCHL
STGAKStatistics group for sales document type STGAKCHAR2TVSFALPHASTGVB
CMGRLDelivery credit group CMGRLCHAR2T691DCRMGR_CM
CMGRKCredit group for picking CMGRKCHAR2T691DCRMGR_CM
CMGRWGoods issue credit group CMGRWCHAR2T691DCRMGR_CM
QHERKInspection Lot Origin QHERKCHAR2TQ31QHERKQHK
TRSPGShipment Blocking Reason TRSPGCHAR2TTSGTRSPG
TDIIXTransportation relevant indicator for delivery TDIIX_LIEFCHAR1XFELD
PROFIDNETZNetwork profile PROFIDNZPLCHAR7TCN41PROFILIDPNW
EXCOKCarry out legal control for sales document type EXCOKCHAR1EXCOK
NEUTEReschedule deliveries NEUTECHAR1NEUTE
KALSPShipping: Pricing procedure KALSPCHAR6T683KALSM
FEHGRIncompletion procedure for sales document FEHGRCHAR2TVUVFEHGR
LNSPLPerform Delivery Split According to Warehouse Number LNSPLCHAR1XFELD
AVERPAutomatic packing using packing proposal AVERPCHAR1XFELD
PM_ITEM_GENGeneration of Delivery Items for HU Packaging Materials LESHP_ITEM_GENCHAR1LESHP_ITEM_GEN_DOM
REGTBRule for determining door and material staging area REGTBCHAR4REGTB
BZOPSStaging area determination at delivery item level? BZOPSCHAR1XFELD
EXCBCBoycott list check of standard partners f.Foreign Trade - On EXCBCCHAR1DIAEX
EXCEMEmbargo check of standard partners for Foreign Trade - On EXCEMCHAR1DIAEX
EXCLGIndicator: Save legal control log EXCLGCHAR1EXCLG
J_1ADOCCLSDocument Class J_1ADOCCL_CHAR1J_1ADOCCLSJ_1ADOCCLS
RFPL_SWRoute schedule switch for delivery types RFPL_SWCHAR1XFELD
TSEGTPEvent group time segment delivery header TSEGTPLLIKCHAR10TTSEGTPLHTMPLATSEGTEMPLA
UVEIBDoc. pricing procedure for incomplete export/import data UVEIBCHAR3T609BUVEIB
DBTCHDistribution Mode for the Delivery DBTCHCHAR1DBTCH
DSFADDelivery Split for Additional Partners TVLK_DSFADCHAR1XFELD
SPOFIRules for Shipping Point Determination SPOFICHAR1SPOFI
OIDELDCMActive flag f. Document Change Management (DCM) f.deliveries OIC_SDP_DDCMCHAR1XFELD
SPE_NUMKTNumber Range for Temporary Inbound Deliveries /SPE/INB_NUMKTCHAR2NUMKR
SPE_NR_RECYCLINGEnable Number Reuse for Unchecked/Temporary Deliveries /SPE/NR_RECYCLINGCHAR1XFELD
BORGR_LIFEX_MUSTRequired Entry /SPE/EXID_MUSTCHAR1/SPE/EXID_MUST
BORGR_LIFEX_UNQUniqueness of the External ID /SPE/EXID_UNIQUECHAR1/SPE/EXID_UNIQUE
BORGR_LIFEX_EEDIError Message Type when ID Transferred by EDI Is Not Unique /SPE/EXID_ERREDICHAR1/SPE/EXID_ERRTYP
BORGR_LIFEX_EDIAType of Error Message when Online ID is not Unique /SPE/EXID_ERRDIACHAR1/SPE/EXID_ERRTYP
BORGR_SODETAutomatic PO Determination /SPE/INB_SODETCHAR1/SPE/INB_SODET
HOLD_DATAIndicator Whether Inbound Deliveries on Hold Are Allowed /SPE/HOLD_DATACHAR1/SPE/HOLD_DATA
TDIDText ID TDIDCHAR4TTXSTDID
TDSPRASLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
EDI_WEIGHTVOLAdopt Weight and Volume from IDoc BORGR_EDI_WEIGHTVOLCHAR1XFELD
SPE_ENABLE_VALIDEnable Validation for All Deliveries within VL60 /SPE/INB_ENABLE_VALIDATIONCHAR1XFELD
MSR_FKARADefault Billing Type MSR_FKARACHAR4TVFKFKART

Key field Non-key field



How do I retrieve data from SAP table TVLK using ABAP code

The following ABAP code Example will allow you to do a basic selection on TVLK to SELECT all data from the table
DATA: WA_TVLK TYPE TVLK.

SELECT SINGLE *
FROM TVLK
INTO CORRESPONDING FIELDS OF WA_TVLK
WHERE...

How to access SAP table TVLK

Within an ECC or HANA version of SAP you can also view further information about TVLK and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!