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