TVLK

Transparent Table Customizing (protected)
77 Fields 2 CDS Views

Delivery Types

TVLK is an SAP database table in S/4HANA. Delivery Types. It contains 77 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_DeliveryDocumentType view from BASIC Delivery Document Type
Mmim_MatDocDocFlow view inner Material Documents Document Flow

Fields (77)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY lfart lfart Delivery Type
kopgr bifgr Screen seq.grp
uevor uevor_vl FCode-OvervScrn
txn08 txn08 Standard Text
umfng umfng Display Range
numki numki NR of Int. Asst
numke numke NR of Ext. Asst
numkirule leshp_numki_rule NmbrRngeDetrmin
incpo incpo ItemNoIncrement
pargr pargr PartnDet.Proc.
aufer aufer Order Required
daart daart Default Ord.Ty.
pobed pobed ItemRequirement
reggr dummy_3 Dummy
reglg reglg Stor. Loc. Rule
waaus dummy Dummy function in length 1
routf routf Route Determin.
vbtyp vbtypl Document Cat.
txtgr txtgr TextDetermProc.
ernam ernam Created By
kappl na_kappl Application
kalsm kalsmb OutputDet.Proc.
kschl na_kschl Output Type
stgak stgak Doc.stats.group
cmgrl cmgrl Credit group
cmgrk cmgrk Credit group
cmgrw cmgrw Credit group
qherk qherk Insp. Lot Orig.
trspg trspg ShpmtBlReason
tdiix tdiix_lief Rel.transport
profidnetz profidnzpl Network Profile
excok excok Legal Control
neute neute Rescheduling
kalsp kalsp Procedure
fehgr fehgr Incompl.Proced.
lnspl lnspl Delivery Split
averp averp Autom. packing
pm_item_gen leshp_item_gen GenPackMatlItem
regtb regtb Rule dr/MS area
bzops bzops StAreaDet.Item
excbc excbc Boycott list
excem excem Embargo check
exclg exclg Legal ctrl log
j_1adoccls j_1adoccl_ Document Class
rfpl_sw rfpl_sw Rte sched. act.
tsegtp tsegtpllik Template
uveib uveib DocPricingProc.
dbtch dbtch Distrbtn Mode
dsfad tvlk_dsfad Deliv.Split Par
spofi spofi ShpPntDeterm.
oideldcm oic_sdp_ddcm Active DCM
spe_numkt /spe/inb_numkt No. Range for Tmp ID
spe_nr_recycling /spe/nr_recycling No. Reuse
borgr_lifex_must /spe/exid_must Required Entry
borgr_lifex_unq /spe/exid_unique Unique
borgr_lifex_eedi /spe/exid_erredi EDI Error Type
borgr_lifex_edia /spe/exid_errdia Online Error
borgr_sodet /spe/inb_sodet Auto PO Determ.
hold_data /spe/hold_data Hold Inb. Delivery
tdid tdid Text ID
tdspras spras Language
edi_weightvol borgr_edi_weightvol Wt/Vol frm IDoc
spe_enable_valid /spe/inb_enable_validation Valid. All Dlv.
msr_fkara msr_fkara Billing Type
fsh_audeloc fsh_audeloc Auto Deallocation
fsh_vass_act fsh_vass_act VAS Active
fsh_vass_kalsm fsh_vass_kalsm Determination Proc.
fsh_vass_corr fsh_vass_corr_l VAS Correlation
restore_alloc arun_restore_alloc Restore Assignments
itmac /sapsll/itmac Trade Compliance
sgt_ignore_seg sgt_ignore_seg Ignore Seg
rfm_bom_corr rfm_bom_corr BOM Correlation
rfm_vas_qty_corr rfm_vas_qty_corr Quantity Corrleation
rfm_main_item_corr rfm_main_item_corr Main Correlation
flexnum_routine_no le_shp_flexnum_routine_no Flexible Routine No.
sgt_ignore_batch_split sgt_ignore_batch_split Ignore Batch

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Delivery Types
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TVLK (
    MANDT,                   -- Client [mandt]
    LFART,                   -- Delivery Type [lfart]
    KOPGR,                   -- Screen seq.grp [bifgr]
    UEVOR,                   -- FCode-OvervScrn [uevor_vl]
    TXN08,                   -- Standard Text [txn08]
    UMFNG,                   -- Display Range [umfng]
    NUMKI,                   -- NR of Int. Asst [numki]
    NUMKE,                   -- NR of Ext. Asst [numke]
    NUMKIRULE,               -- NmbrRngeDetrmin [leshp_numki_rule]
    INCPO,                   -- ItemNoIncrement [incpo]
    PARGR,                   -- PartnDet.Proc. [pargr]
    AUFER,                   -- Order Required [aufer]
    DAART,                   -- Default Ord.Ty. [daart]
    POBED,                   -- ItemRequirement [pobed]
    REGGR,                   -- Dummy [dummy_3]
    REGLG,                   -- Stor. Loc. Rule [reglg]
    WAAUS,                   -- Dummy function in length 1 [dummy]
    ROUTF,                   -- Route Determin. [routf]
    VBTYP,                   -- Document Cat. [vbtypl]
    TXTGR,                   -- TextDetermProc. [txtgr]
    ERNAM,                   -- Created By [ernam]
    KAPPL,                   -- Application [na_kappl]
    KALSM,                   -- OutputDet.Proc. [kalsmb]
    KSCHL,                   -- Output Type [na_kschl]
    STGAK,                   -- Doc.stats.group [stgak]
    CMGRL,                   -- Credit group [cmgrl]
    CMGRK,                   -- Credit group [cmgrk]
    CMGRW,                   -- Credit group [cmgrw]
    QHERK,                   -- Insp. Lot Orig. [qherk]
    TRSPG,                   -- ShpmtBlReason [trspg]
    TDIIX,                   -- Rel.transport [tdiix_lief]
    PROFIDNETZ,              -- Network Profile [profidnzpl]
    EXCOK,                   -- Legal Control [excok]
    NEUTE,                   -- Rescheduling [neute]
    KALSP,                   -- Procedure [kalsp]
    FEHGR,                   -- Incompl.Proced. [fehgr]
    LNSPL,                   -- Delivery Split [lnspl]
    AVERP,                   -- Autom. packing [averp]
    PM_ITEM_GEN,             -- GenPackMatlItem [leshp_item_gen]
    REGTB,                   -- Rule dr/MS area [regtb]
    BZOPS,                   -- StAreaDet.Item [bzops]
    EXCBC,                   -- Boycott list [excbc]
    EXCEM,                   -- Embargo check [excem]
    EXCLG,                   -- Legal ctrl log [exclg]
    J_1ADOCCLS,              -- Document Class [j_1adoccl_]
    RFPL_SW,                 -- Rte sched. act. [rfpl_sw]
    TSEGTP,                  -- Template [tsegtpllik]
    UVEIB,                   -- DocPricingProc. [uveib]
    DBTCH,                   -- Distrbtn Mode [dbtch]
    DSFAD,                   -- Deliv.Split Par [tvlk_dsfad]
    SPOFI,                   -- ShpPntDeterm. [spofi]
    OIDELDCM,                -- Active DCM [oic_sdp_ddcm]
    SPE_NUMKT,               -- No. Range for Tmp ID [/spe/inb_numkt]
    SPE_NR_RECYCLING,        -- No. Reuse [/spe/nr_recycling]
    BORGR_LIFEX_MUST,        -- Required Entry [/spe/exid_must]
    BORGR_LIFEX_UNQ,         -- Unique [/spe/exid_unique]
    BORGR_LIFEX_EEDI,        -- EDI Error Type [/spe/exid_erredi]
    BORGR_LIFEX_EDIA,        -- Online Error [/spe/exid_errdia]
    BORGR_SODET,             -- Auto PO Determ. [/spe/inb_sodet]
    HOLD_DATA,               -- Hold Inb. Delivery [/spe/hold_data]
    TDID,                    -- Text ID [tdid]
    TDSPRAS,                 -- Language [spras]
    EDI_WEIGHTVOL,           -- Wt/Vol frm IDoc [borgr_edi_weightvol]
    SPE_ENABLE_VALID,        -- Valid. All Dlv. [/spe/inb_enable_validation]
    MSR_FKARA,               -- Billing Type [msr_fkara]
    FSH_AUDELOC,             -- Auto Deallocation [fsh_audeloc]
    FSH_VASS_ACT,            -- VAS Active [fsh_vass_act]
    FSH_VASS_KALSM,          -- Determination Proc. [fsh_vass_kalsm]
    FSH_VASS_CORR,           -- VAS Correlation [fsh_vass_corr_l]
    RESTORE_ALLOC,           -- Restore Assignments [arun_restore_alloc]
    ITMAC,                   -- Trade Compliance [/sapsll/itmac]
    SGT_IGNORE_SEG,          -- Ignore Seg [sgt_ignore_seg]
    RFM_BOM_CORR,            -- BOM Correlation [rfm_bom_corr]
    RFM_VAS_QTY_CORR,        -- Quantity Corrleation [rfm_vas_qty_corr]
    RFM_MAIN_ITEM_CORR,      -- Main Correlation [rfm_main_item_corr]
    FLEXNUM_ROUTINE_NO,      -- Flexible Routine No. [le_shp_flexnum_routine_no]
    SGT_IGNORE_BATCH_SPLIT,  -- Ignore Batch [sgt_ignore_batch_split]
    PRIMARY KEY (MANDT, LFART)
);

Learn More