TVLK SAP (Delivery Types) Table details
Dictionary Type: Table
Description: Delivery Types
Description: Delivery Types
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 UpdateDisplay/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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
LFART | Delivery Type | LFART | CHAR | 4 | LFART | ALT | |||
KOPGR | Screen sequence group for document header & item | BIFGR | CHAR | 4 | TVHB | BIFGR | |||
UEVOR | F-code default for overview screen | UEVOR_VL | CHAR | 4 | UEVOR_VL | ||||
TXN08 | Number of the standard text | TXN08 | CHAR | 8 | TXN08 | ||||
UMFNG | Display Range | UMFNG | CHAR | 20 | UMFNG | ||||
NUMKI | Number range in the case of internal number assignment | NUMKI | CHAR | 2 | NUMKR | ||||
NUMKE | Number range in the case of external number assignment | NUMKE | CHAR | 2 | NUMKR | ||||
NUMKIRULE | Rule for Determining Number Ranges for Decentralized LES | LESHP_NUMKI_RULE | CHAR | 1 | LESHP_NUMKI_RULE | ||||
INCPO | Increment of item number in the SD document | INCPO | NUMC | 6 | NUM6 | ||||
PARGR | Partner Determination Procedure | PARGR | CHAR | 4 | TVPG | PARGR | |||
AUFER | A sales order is required as basis for delivery | AUFER | CHAR | 1 | VOERF | ||||
DAART | Default order type for deliveries without reference to order | DAART | CHAR | 4 | TVAK | AUART | AUART | ||
POBED | Requirement for item that does not refer to a sales order | POBED | NUMC | 3 | BEDNG | ||||
REGGR | Dummy function | DUMMY_3 | CHAR | 3 | CHAR3 | ||||
REGLG | Rule for determining the storage location for picking | REGLG | CHAR | 4 | REGLG | ||||
WAAUS | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
ROUTF | New route determination: with or without a check? | ROUTF | CHAR | 1 | ROUTF | ||||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
TXTGR | Text determination procedure | TXTGR | CHAR | 2 | TTXG | TXTGR | |||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
KAPPL | Application for output conditions | NA_KAPPL | CHAR | 2 | T681A | KAPPL | NA_KAPPL | ||
KALSM | Output determination procedure | KALSMB | CHAR | 6 | T683 | KALSM | |||
KSCHL | Output Type | NA_KSCHL | CHAR | 4 | T685 | KSCHL | NAC | CSH_NA_KSCHL | |
STGAK | Statistics group for sales document type | STGAK | CHAR | 2 | TVSF | ALPHA | STGVB | ||
CMGRL | Delivery credit group | CMGRL | CHAR | 2 | T691D | CRMGR_CM | |||
CMGRK | Credit group for picking | CMGRK | CHAR | 2 | T691D | CRMGR_CM | |||
CMGRW | Goods issue credit group | CMGRW | CHAR | 2 | T691D | CRMGR_CM | |||
QHERK | Inspection Lot Origin | QHERK | CHAR | 2 | TQ31 | QHERK | QHK | ||
TRSPG | Shipment Blocking Reason | TRSPG | CHAR | 2 | TTSG | TRSPG | |||
TDIIX | Transportation relevant indicator for delivery | TDIIX_LIEF | CHAR | 1 | XFELD | ||||
PROFIDNETZ | Network profile | PROFIDNZPL | CHAR | 7 | TCN41 | PROFILID | PNW | ||
EXCOK | Carry out legal control for sales document type | EXCOK | CHAR | 1 | EXCOK | ||||
NEUTE | Reschedule deliveries | NEUTE | CHAR | 1 | NEUTE | ||||
KALSP | Shipping: Pricing procedure | KALSP | CHAR | 6 | T683 | KALSM | |||
FEHGR | Incompletion procedure for sales document | FEHGR | CHAR | 2 | TVUV | FEHGR | |||
LNSPL | Perform Delivery Split According to Warehouse Number | LNSPL | CHAR | 1 | XFELD | ||||
AVERP | Automatic packing using packing proposal | AVERP | CHAR | 1 | XFELD | ||||
PM_ITEM_GEN | Generation of Delivery Items for HU Packaging Materials | LESHP_ITEM_GEN | CHAR | 1 | LESHP_ITEM_GEN_DOM | ||||
REGTB | Rule for determining door and material staging area | REGTB | CHAR | 4 | REGTB | ||||
BZOPS | Staging area determination at delivery item level? | BZOPS | CHAR | 1 | XFELD | ||||
EXCBC | Boycott list check of standard partners f.Foreign Trade - On | EXCBC | CHAR | 1 | DIAEX | ||||
EXCEM | Embargo check of standard partners for Foreign Trade - On | EXCEM | CHAR | 1 | DIAEX | ||||
EXCLG | Indicator: Save legal control log | EXCLG | CHAR | 1 | EXCLG | ||||
J_1ADOCCLS | Document Class | J_1ADOCCL_ | CHAR | 1 | J_1ADOCCLS | J_1ADOCCLS | |||
RFPL_SW | Route schedule switch for delivery types | RFPL_SW | CHAR | 1 | XFELD | ||||
TSEGTP | Event group time segment delivery header | TSEGTPLLIK | CHAR | 10 | TTSEGTPLH | TMPLA | TSEGTEMPLA | ||
UVEIB | Doc. pricing procedure for incomplete export/import data | UVEIB | CHAR | 3 | T609B | UVEIB | |||
DBTCH | Distribution Mode for the Delivery | DBTCH | CHAR | 1 | DBTCH | ||||
DSFAD | Delivery Split for Additional Partners | TVLK_DSFAD | CHAR | 1 | XFELD | ||||
SPOFI | Rules for Shipping Point Determination | SPOFI | CHAR | 1 | SPOFI | ||||
OIDELDCM | Active flag f. Document Change Management (DCM) f.deliveries | OIC_SDP_DDCM | CHAR | 1 | XFELD | ||||
SPE_NUMKT | Number Range for Temporary Inbound Deliveries | /SPE/INB_NUMKT | CHAR | 2 | NUMKR | ||||
SPE_NR_RECYCLING | Enable Number Reuse for Unchecked/Temporary Deliveries | /SPE/NR_RECYCLING | CHAR | 1 | XFELD | ||||
BORGR_LIFEX_MUST | Required Entry | /SPE/EXID_MUST | CHAR | 1 | /SPE/EXID_MUST | ||||
BORGR_LIFEX_UNQ | Uniqueness of the External ID | /SPE/EXID_UNIQUE | CHAR | 1 | /SPE/EXID_UNIQUE | ||||
BORGR_LIFEX_EEDI | Error Message Type when ID Transferred by EDI Is Not Unique | /SPE/EXID_ERREDI | CHAR | 1 | /SPE/EXID_ERRTYP | ||||
BORGR_LIFEX_EDIA | Type of Error Message when Online ID is not Unique | /SPE/EXID_ERRDIA | CHAR | 1 | /SPE/EXID_ERRTYP | ||||
BORGR_SODET | Automatic PO Determination | /SPE/INB_SODET | CHAR | 1 | /SPE/INB_SODET | ||||
HOLD_DATA | Indicator Whether Inbound Deliveries on Hold Are Allowed | /SPE/HOLD_DATA | CHAR | 1 | /SPE/HOLD_DATA | ||||
TDID | Text ID | TDID | CHAR | 4 | TTXS | TDID | |||
TDSPRAS | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
EDI_WEIGHTVOL | Adopt Weight and Volume from IDoc | BORGR_EDI_WEIGHTVOL | CHAR | 1 | XFELD | ||||
SPE_ENABLE_VALID | Enable Validation for All Deliveries within VL60 | /SPE/INB_ENABLE_VALIDATION | CHAR | 1 | XFELD | ||||
MSR_FKARA | Default Billing Type | MSR_FKARA | CHAR | 4 | TVFK | FKART |
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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects