VTTK

Transparent Table Application Table
134 Fields 1 CDS Views

Shipment Header

VTTK is an SAP database table in S/4HANA. Shipment Header. It contains 134 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_ShipmentHeader view_entity from BASIC Shipment Header

Fields (134)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY tknum TKNUM Shipment Number
vbtyp VBTYPL Document Cat.
shtyp SHTYP Shipment Type
tplst TPLST TransportPlanPt
ernam ERNAM Created By
erdat ERDAT Created On
erzet ERZET Time
aenam AENAM Changed By
aedat AEDAT Changed On
aezet AEZET Time of change
sterm STERM Determine Legs
abfer ABFER ShpmtComplType
abwst ABWST ProcessControl
bfart BFART Service Level
vsart VSARTTR Shipping Type
vsavl VSAVL ShTypePrelimLeg
vsanl VSANL SubseqLegShType
laufk LAUFK Leg indicator
vsbed VSBED Shipping Conditions
route ROUTR Shipment Route
signi SIGNI Container ID
exti1 EXTI1 External ID 1
exti2 EXTI2 External ID 2
tpbez TPBEZ Description
stdis STDIS Planned
dtdis DTDIS Planning end
uzdis UZDIS Scheduling end
streg STREG Check-In
dpreg DPREG PlanCheckInDate
upreg UPREG PlannedTimeChIn
dareg DAREG Act.Date ChkIn
uareg UAREG CurrentTmeChkIn
stlbg STLBG Loading Start
dplbg DPLBG PlanLoadStart
uplbg UPLBG PlanLoadStTime
dalbg DALBG Curr.load.start
ualbg UALBG ActLoadStrtTime
stlad STLAD Loading End
dplen DPLEND PlanLoadingEnd
uplen UPLEND PlanLoadEndTime
dalen DALEND Act. load. end
ualen UALEND ActLoadEndTime
stabf STABF Shpmt Compl.
dpabf DPABF PlanShpCmplDte
upabf UPABF Pl. Time Proc.
dtabf DTABF DateShpmntCmpl.
uzabf UZABF TimeTrspProcess
sttbg STTBG Shipment Start
dptbg DPTBG PlanShipStart
uptbg UPTBG PlanTransStTime
datbg DATBG CurrShipmtStart
uatbg UATBG ActTranspStrtTm
stten STTEN Shipment End
dpten DPTEN PlanShipmentEnd
upten UPTEN PlanTransEndTim
daten DATEND Act.ShipmentEnd
uaten UATEND ActShipmtEndTim
sttrg STTRG Overall Status
tdlnr TDLNR Service Agent
ternr AUFNR Order
pkstk PKSTK_VTTK Handling units
dtmeg DTMEG Weight unit
dtmev DTMEV Volume unit
distz DISTZ Distance
medst MEDST UoM-Distance
fahzt FAHZT Travel time
geszt GESZT Total Time
meizt MEIZT Trav. times
stafo STAFO Update Group
fbsta FBSTA Shipm.Csts Cal
fbgst FBGST OvSts.ShCostCal
arsta ARSTA Shpmt Costs Set
argst ARGST Tot.Shp.Cst Stm
sterm_done STERM_DONE Legs determined
vse_frk VSE_FRK Ship.units-ShpCostD
kkalsm KALSM_KOPF Procedure
sdabw SDABW Spec.Processing
frkrl KFRKRL ShpmntCostsRel.
gesztd KP_GESZTDP Planned total time
fahztd KP_EFFZTDP Planned act. durat.
gesztda KP_GESZTDA Actual total time
fahztda KP_EFFZTDA Actual duration
rocpy_done ROCPY_DONE Route from del.
handle TSEGGUID Handle
tsegfl TSEGEXISTS TSegment exists
tsegtp TSEGTPLVTT Template
add01 VTTK_ADD01 Suppl. 1
add02 VTTK_ADD02 Suppl. 2
add03 VTTK_ADD03 Suppl. 3
add04 VTTK_ADD04 Suppl. 4
text1 VTTK_TEXT1 Addit. Text 1
text2 VTTK_TEXT2 Addit. Text 2
text3 VTTK_TEXT3 Addit. Text 3
text4 VTTK_TEXT4 Addit. Text 4
proli ADGE_PROLI DG Mgmt Profile
dgtlock ADGE_TLOCK Block Ind. DG
dgmddat ADGE_MDDAT Selection Date
cont_dg ADGE_NCDG Contains DG
warztd KP_WARZTDP Planned Waiting Time
warztda KP_WARZTDA Curr. waiting time
aulwe AULWE Route Schedule
tndrst TNDRST Tender Status
tndrrc TNDRRC AccCnd/RjctRsn
tndr_text TNDR_TEXT Tendering Text
tndrdat TNDRDAT Date tender st.
tndrzet TNDRZET Time tender
tndr_maxp TNDR_MAXP Maximum Price
tndr_maxc TNDR_MAXC Currency
tndr_actp TNDR_ACTP Actual Costs
tndr_actc TNDR_ACTC Currency
tndr_carr TNDR_CARR From Fdwg Agent
tndr_crnm TNDR_CRNM Name of carrier
tndr_trkid TNDR_TRKID FA Tracking ID
tndr_expd TNDR_EXPD Valid to
tndr_expt TNDR_EXPT To Time
tndr_erpd TNDR_ERPD EarlyPickupDate
tndr_erpt TNDR_ERPT Pickup time
tndr_ltpd TNDR_LTPD Latest Pickup
tndr_ltpt TNDR_LTPT Time
tndr_erdd TNDR_ERDD Earl. Del. Date
tndr_erdt TNDR_ERDT Time
tndr_ltdd TNDR_LTDD Latest Del.Date
tndr_ltdt TNDR_LTDT Time
tndr_ldlg TNDR_LDLG LgthLoadingPltf
tndr_ldlu TNDR_LDLU UoM load length
kzhulfr KZHULFR HUs DI-relevant
allowed_twgt ALLOWED_TWGT Allow.Tot. Wght
vlstk VLSTK StatDecntrlWhse
verursys TRA_VERURSYS Original System
cm_ident CMIDENTIFIER Identification
cm_sequence CMSEQUENCE Sequence
ext_freight_ord EXT_FREIGHT_ORDER Frg. Ord. ID
ext_tm_sys SLD_BSKEY Business System

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 Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VTTK (
    MANDT,            -- Client [MANDT]
    TKNUM,            -- Shipment Number [TKNUM]
    VBTYP,            -- Document Cat. [VBTYPL]
    SHTYP,            -- Shipment Type [SHTYP]
    TPLST,            -- TransportPlanPt [TPLST]
    ERNAM,            -- Created By [ERNAM]
    ERDAT,            -- Created On [ERDAT]
    ERZET,            -- Time [ERZET]
    AENAM,            -- Changed By [AENAM]
    AEDAT,            -- Changed On [AEDAT]
    AEZET,            -- Time of change [AEZET]
    STERM,            -- Determine Legs [STERM]
    ABFER,            -- ShpmtComplType [ABFER]
    ABWST,            -- ProcessControl [ABWST]
    BFART,            -- Service Level [BFART]
    VSART,            -- Shipping Type [VSARTTR]
    VSAVL,            -- ShTypePrelimLeg [VSAVL]
    VSANL,            -- SubseqLegShType [VSANL]
    LAUFK,            -- Leg indicator [LAUFK]
    VSBED,            -- Shipping Conditions [VSBED]
    ROUTE,            -- Shipment Route [ROUTR]
    SIGNI,            -- Container ID [SIGNI]
    EXTI1,            -- External ID 1 [EXTI1]
    EXTI2,            -- External ID 2 [EXTI2]
    TPBEZ,            -- Description [TPBEZ]
    STDIS,            -- Planned [STDIS]
    DTDIS,            -- Planning end [DTDIS]
    UZDIS,            -- Scheduling end [UZDIS]
    STREG,            -- Check-In [STREG]
    DPREG,            -- PlanCheckInDate [DPREG]
    UPREG,            -- PlannedTimeChIn [UPREG]
    DAREG,            -- Act.Date ChkIn [DAREG]
    UAREG,            -- CurrentTmeChkIn [UAREG]
    STLBG,            -- Loading Start [STLBG]
    DPLBG,            -- PlanLoadStart [DPLBG]
    UPLBG,            -- PlanLoadStTime [UPLBG]
    DALBG,            -- Curr.load.start [DALBG]
    UALBG,            -- ActLoadStrtTime [UALBG]
    STLAD,            -- Loading End [STLAD]
    DPLEN,            -- PlanLoadingEnd [DPLEND]
    UPLEN,            -- PlanLoadEndTime [UPLEND]
    DALEN,            -- Act. load. end [DALEND]
    UALEN,            -- ActLoadEndTime [UALEND]
    STABF,            -- Shpmt Compl. [STABF]
    DPABF,            -- PlanShpCmplDte [DPABF]
    UPABF,            -- Pl. Time Proc. [UPABF]
    DTABF,            -- DateShpmntCmpl. [DTABF]
    UZABF,            -- TimeTrspProcess [UZABF]
    STTBG,            -- Shipment Start [STTBG]
    DPTBG,            -- PlanShipStart [DPTBG]
    UPTBG,            -- PlanTransStTime [UPTBG]
    DATBG,            -- CurrShipmtStart [DATBG]
    UATBG,            -- ActTranspStrtTm [UATBG]
    STTEN,            -- Shipment End [STTEN]
    DPTEN,            -- PlanShipmentEnd [DPTEN]
    UPTEN,            -- PlanTransEndTim [UPTEN]
    DATEN,            -- Act.ShipmentEnd [DATEND]
    UATEN,            -- ActShipmtEndTim [UATEND]
    STTRG,            -- Overall Status [STTRG]
    TDLNR,            -- Service Agent [TDLNR]
    TERNR,            -- Order [AUFNR]
    PKSTK,            -- Handling units [PKSTK_VTTK]
    DTMEG,            -- Weight unit [DTMEG]
    DTMEV,            -- Volume unit [DTMEV]
    DISTZ,            -- Distance [DISTZ]
    MEDST,            -- UoM-Distance [MEDST]
    FAHZT,            -- Travel time [FAHZT]
    GESZT,            -- Total Time [GESZT]
    MEIZT,            -- Trav. times [MEIZT]
    STAFO,            -- Update Group [STAFO]
    FBSTA,            -- Shipm.Csts Cal [FBSTA]
    FBGST,            -- OvSts.ShCostCal [FBGST]
    ARSTA,            -- Shpmt Costs Set [ARSTA]
    ARGST,            -- Tot.Shp.Cst Stm [ARGST]
    STERM_DONE,       -- Legs determined [STERM_DONE]
    VSE_FRK,          -- Ship.units-ShpCostD [VSE_FRK]
    KKALSM,           -- Procedure [KALSM_KOPF]
    SDABW,            -- Spec.Processing [SDABW]
    FRKRL,            -- ShpmntCostsRel. [KFRKRL]
    GESZTD,           -- Planned total time [KP_GESZTDP]
    FAHZTD,           -- Planned act. durat. [KP_EFFZTDP]
    GESZTDA,          -- Actual total time [KP_GESZTDA]
    FAHZTDA,          -- Actual duration [KP_EFFZTDA]
    ROCPY_DONE,       -- Route from del. [ROCPY_DONE]
    HANDLE,           -- Handle [TSEGGUID]
    TSEGFL,           -- TSegment exists [TSEGEXISTS]
    TSEGTP,           -- Template [TSEGTPLVTT]
    ADD01,            -- Suppl. 1 [VTTK_ADD01]
    ADD02,            -- Suppl. 2 [VTTK_ADD02]
    ADD03,            -- Suppl. 3 [VTTK_ADD03]
    ADD04,            -- Suppl. 4 [VTTK_ADD04]
    TEXT1,            -- Addit. Text 1 [VTTK_TEXT1]
    TEXT2,            -- Addit. Text 2 [VTTK_TEXT2]
    TEXT3,            -- Addit. Text 3 [VTTK_TEXT3]
    TEXT4,            -- Addit. Text 4 [VTTK_TEXT4]
    PROLI,            -- DG Mgmt Profile [ADGE_PROLI]
    DGTLOCK,          -- Block Ind. DG [ADGE_TLOCK]
    DGMDDAT,          -- Selection Date [ADGE_MDDAT]
    CONT_DG,          -- Contains DG [ADGE_NCDG]
    WARZTD,           -- Planned Waiting Time [KP_WARZTDP]
    WARZTDA,          -- Curr. waiting time [KP_WARZTDA]
    AULWE,            -- Route Schedule [AULWE]
    TNDRST,           -- Tender Status [TNDRST]
    TNDRRC,           -- AccCnd/RjctRsn [TNDRRC]
    TNDR_TEXT,        -- Tendering Text [TNDR_TEXT]
    TNDRDAT,          -- Date tender st. [TNDRDAT]
    TNDRZET,          -- Time tender [TNDRZET]
    TNDR_MAXP,        -- Maximum Price [TNDR_MAXP]
    TNDR_MAXC,        -- Currency [TNDR_MAXC]
    TNDR_ACTP,        -- Actual Costs [TNDR_ACTP]
    TNDR_ACTC,        -- Currency [TNDR_ACTC]
    TNDR_CARR,        -- From Fdwg Agent [TNDR_CARR]
    TNDR_CRNM,        -- Name of carrier [TNDR_CRNM]
    TNDR_TRKID,       -- FA Tracking ID [TNDR_TRKID]
    TNDR_EXPD,        -- Valid to [TNDR_EXPD]
    TNDR_EXPT,        -- To Time [TNDR_EXPT]
    TNDR_ERPD,        -- EarlyPickupDate [TNDR_ERPD]
    TNDR_ERPT,        -- Pickup time [TNDR_ERPT]
    TNDR_LTPD,        -- Latest Pickup [TNDR_LTPD]
    TNDR_LTPT,        -- Time [TNDR_LTPT]
    TNDR_ERDD,        -- Earl. Del. Date [TNDR_ERDD]
    TNDR_ERDT,        -- Time [TNDR_ERDT]
    TNDR_LTDD,        -- Latest Del.Date [TNDR_LTDD]
    TNDR_LTDT,        -- Time [TNDR_LTDT]
    TNDR_LDLG,        -- LgthLoadingPltf [TNDR_LDLG]
    TNDR_LDLU,        -- UoM load length [TNDR_LDLU]
    KZHULFR,          -- HUs DI-relevant [KZHULFR]
    ALLOWED_TWGT,     -- Allow.Tot. Wght [ALLOWED_TWGT]
    VLSTK,            -- StatDecntrlWhse [VLSTK]
    VERURSYS,         -- Original System [TRA_VERURSYS]
    CM_IDENT,         -- Identification [CMIDENTIFIER]
    CM_SEQUENCE,      -- Sequence [CMSEQUENCE]
    EXT_FREIGHT_ORD,  -- Frg. Ord. ID [EXT_FREIGHT_ORDER]
    EXT_TM_SYS,       -- Business System [SLD_BSKEY]
    PRIMARY KEY (MANDT, TKNUM)
);

Learn More