TVTK

Transparent Table Customizing (protected)
69 Fields 1 CDS Views

Shipment Types

TVTK is an SAP database table in S/4HANA. Shipment Types. It contains 69 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_ShipmentTypeVH view_entity from BASIC Shipment Types

Fields (69)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY shtyp SHTYP Shipment Type
vbtyp VBTYPL Document Cat.
numki NUMKI NR of Int. Asst
numke NUMKE NR of Ext. Asst
kopgr KOPGR Scr.seq.group
sterm STERM Determine Legs
abfer ABFER ShpmtComplType
abwst ABWST ProcessControl
bfart BFART Service Level
vsart VERSART Shipping Type
vsavl VSAVL ShTypePrelimLeg
vsanl VSANL SubseqLegShType
laufk LAUFK Leg indicator
kalsm KALSMB OutputDet.Proc.
kappl NA_KAPPL Application
txtgr TXTGR TextDetermProc.
pargr PARGR PartnDet.Proc.
svtra SVTRA Selection var.
profidnetz PROFIDNZPL Network Profile
dtmeg DTMEG Weight unit
dtmev DTMEV Volume unit
kschl NA_KSCHL Output Type
route_vlf ROUTE_VLF Route from del.
spedi_vlf SPEDI_VLF Frwd.agent del.
abf_actprf ABF_ACTPRF At completion
fkart FKART_T Ship. cost type
stgta STGTA Stat.grp,ship.type
frkrl FRKRL_KOP Header
frkrl_str FRKRL_STR Leg
frkrl_ump FRKRL_UMP Load trnsf.pnt
frkrl_grp FRKRL_GRP Border cross.pt
route_stag ROUTE_STAG Adopt Route
chgdoc_shtyp CHGDOC_SHTYP Chge doc. shpmnt
dis_actprf DIS_ACTPRF For planning
reg_actprf REG_ACTPRF At check-in
lbg_actprf LBG_ACTPRF At load. start
len_actprf LEN_ACTPRF At load.finish
tbg_actprf TBG_ACTPRF At shpmt. begin
ten_actprf TEN_ACTPRF At shpmt. end
planning_profile PLANNING_PROFILE Planning prof.
tsegtp TSEGTPLVTT Template
koprf KOPRF Pick check
termin_vlf TERMIN_VLF Deadl.frm deliv.
trinf_ueb TRINF_UEB Routine
pmode_vd LEDSPD_PMODE_TRA1 SplProfBefPlng
pmode_nd LEDSPD_PMODE_TRA2 SplProfAfterPlg
kzhulfr KZHULFR HUs DI-relevant
vtdwm VTDWM DistrbutnDecWMS
borgr_proctyp BORGR_PROCTYP GR-RelevanceInd
borgr_auto_reg BORGR_AUTO_REG AutRegistration
borgr_auto_len BORGR_AUTO_LEN Aut.loading end
borgr_exti1_unq BORGR_EXID_UNIQUE Unique
borgr_exti1_must BORGR_EXID_MUST Required entry
borgr_exti1_eedi BORGR_EXID_ERREDI EDI error type
borgr_exti1_edia BORGR_EXID_ERRDIA Online error
borgr_exti2_unq BORGR_EXID_UNIQUE Unique
borgr_exti2_must BORGR_EXID_MUST Required entry
borgr_exti2_eedi BORGR_EXID_ERREDI EDI error type
borgr_exti2_edia BORGR_EXID_ERRDIA Online error
borgr_signi_unq BORGR_EXID_UNIQUE Unique
borgr_signi_must BORGR_EXID_MUST Required entry
borgr_signi_eedi BORGR_EXID_ERREDI EDI error type
borgr_signi_edia BORGR_EXID_ERRDIA Online error
borgr_tpbez_unq BORGR_EXID_UNIQUE Unique
borgr_tpbez_must BORGR_EXID_MUST Required entry
borgr_tpbez_eedi BORGR_EXID_ERREDI EDI error type
borgr_tpbez_edia BORGR_EXID_ERRDIA Online error
borgr_asn_not_ex BORGR_ASN_NOT_EXIST Delivery Missing

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.

-- Shipment Types
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TVTK (
    MANDT,             -- Client [MANDT]
    SHTYP,             -- Shipment Type [SHTYP]
    VBTYP,             -- Document Cat. [VBTYPL]
    NUMKI,             -- NR of Int. Asst [NUMKI]
    NUMKE,             -- NR of Ext. Asst [NUMKE]
    KOPGR,             -- Scr.seq.group [KOPGR]
    STERM,             -- Determine Legs [STERM]
    ABFER,             -- ShpmtComplType [ABFER]
    ABWST,             -- ProcessControl [ABWST]
    BFART,             -- Service Level [BFART]
    VSART,             -- Shipping Type [VERSART]
    VSAVL,             -- ShTypePrelimLeg [VSAVL]
    VSANL,             -- SubseqLegShType [VSANL]
    LAUFK,             -- Leg indicator [LAUFK]
    KALSM,             -- OutputDet.Proc. [KALSMB]
    KAPPL,             -- Application [NA_KAPPL]
    TXTGR,             -- TextDetermProc. [TXTGR]
    PARGR,             -- PartnDet.Proc. [PARGR]
    SVTRA,             -- Selection var. [SVTRA]
    PROFIDNETZ,        -- Network Profile [PROFIDNZPL]
    DTMEG,             -- Weight unit [DTMEG]
    DTMEV,             -- Volume unit [DTMEV]
    KSCHL,             -- Output Type [NA_KSCHL]
    ROUTE_VLF,         -- Route from del. [ROUTE_VLF]
    SPEDI_VLF,         -- Frwd.agent del. [SPEDI_VLF]
    ABF_ACTPRF,        -- At completion [ABF_ACTPRF]
    FKART,             -- Ship. cost type [FKART_T]
    STGTA,             -- Stat.grp,ship.type [STGTA]
    FRKRL,             -- Header [FRKRL_KOP]
    FRKRL_STR,         -- Leg [FRKRL_STR]
    FRKRL_UMP,         -- Load trnsf.pnt [FRKRL_UMP]
    FRKRL_GRP,         -- Border cross.pt [FRKRL_GRP]
    ROUTE_STAG,        -- Adopt Route [ROUTE_STAG]
    CHGDOC_SHTYP,      -- Chge doc. shpmnt [CHGDOC_SHTYP]
    DIS_ACTPRF,        -- For planning [DIS_ACTPRF]
    REG_ACTPRF,        -- At check-in [REG_ACTPRF]
    LBG_ACTPRF,        -- At load. start [LBG_ACTPRF]
    LEN_ACTPRF,        -- At load.finish [LEN_ACTPRF]
    TBG_ACTPRF,        -- At shpmt. begin [TBG_ACTPRF]
    TEN_ACTPRF,        -- At shpmt. end [TEN_ACTPRF]
    PLANNING_PROFILE,  -- Planning prof. [PLANNING_PROFILE]
    TSEGTP,            -- Template [TSEGTPLVTT]
    KOPRF,             -- Pick check [KOPRF]
    TERMIN_VLF,        -- Deadl.frm deliv. [TERMIN_VLF]
    TRINF_UEB,         -- Routine [TRINF_UEB]
    PMODE_VD,          -- SplProfBefPlng [LEDSPD_PMODE_TRA1]
    PMODE_ND,          -- SplProfAfterPlg [LEDSPD_PMODE_TRA2]
    KZHULFR,           -- HUs DI-relevant [KZHULFR]
    VTDWM,             -- DistrbutnDecWMS [VTDWM]
    BORGR_PROCTYP,     -- GR-RelevanceInd [BORGR_PROCTYP]
    BORGR_AUTO_REG,    -- AutRegistration [BORGR_AUTO_REG]
    BORGR_AUTO_LEN,    -- Aut.loading end [BORGR_AUTO_LEN]
    BORGR_EXTI1_UNQ,   -- Unique [BORGR_EXID_UNIQUE]
    BORGR_EXTI1_MUST,  -- Required entry [BORGR_EXID_MUST]
    BORGR_EXTI1_EEDI,  -- EDI error type [BORGR_EXID_ERREDI]
    BORGR_EXTI1_EDIA,  -- Online error [BORGR_EXID_ERRDIA]
    BORGR_EXTI2_UNQ,   -- Unique [BORGR_EXID_UNIQUE]
    BORGR_EXTI2_MUST,  -- Required entry [BORGR_EXID_MUST]
    BORGR_EXTI2_EEDI,  -- EDI error type [BORGR_EXID_ERREDI]
    BORGR_EXTI2_EDIA,  -- Online error [BORGR_EXID_ERRDIA]
    BORGR_SIGNI_UNQ,   -- Unique [BORGR_EXID_UNIQUE]
    BORGR_SIGNI_MUST,  -- Required entry [BORGR_EXID_MUST]
    BORGR_SIGNI_EEDI,  -- EDI error type [BORGR_EXID_ERREDI]
    BORGR_SIGNI_EDIA,  -- Online error [BORGR_EXID_ERRDIA]
    BORGR_TPBEZ_UNQ,   -- Unique [BORGR_EXID_UNIQUE]
    BORGR_TPBEZ_MUST,  -- Required entry [BORGR_EXID_MUST]
    BORGR_TPBEZ_EEDI,  -- EDI error type [BORGR_EXID_ERREDI]
    BORGR_TPBEZ_EDIA,  -- Online error [BORGR_EXID_ERRDIA]
    BORGR_ASN_NOT_EX,  -- Delivery Missing [BORGR_ASN_NOT_EXIST]
    PRIMARY KEY (MANDT, SHTYP)
);

Learn More