SE11 ABAP Dictionary SE11 VTTK

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

VTTK

Shipment Header
SAP SAP Transparent Table 138 Fields
Primary Key:
MANDT TKNUM

Dictionary Fields Fields

(138 dari 138 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
TKNUM
KEY Shipment CHAR 10 - - Shipment Number
3
VBTYP
- Doc.cat. CHAR 1 - - SD document category
4
SHTYP
- ShipmntTyp CHAR 4 - - Shipment type
5
TPLST
- TrspPlanPt CHAR 4 - - Transportation planning point
6
ERNAM
- Created CHAR 12 - - Name of Person who Created the Object
7
ERDAT
- On DATS 8 - - Date on Which Record Was Created
8
ERZET
- Time TIMS 6 - - Entry time
9
AENAM
- By CHAR 12 - - Name of Person Who Changed Object
10
AEDAT
- Chngd DATS 8 - - Changed On
11
AEZET
- TimeOfChng TIMS 6 - - Time last change was made
12
STERM
- Determ.Leg CHAR 1 - - Leg determination
13
ABFER
- Compl.type CHAR 1 - - Shipment completion type
14
ABWST
- ProcContrl CHAR 1 - - Processing control
15
BFART
- Serv.level CHAR 1 - - Service Level
16
VSART
- Ship.type CHAR 2 - - Shipping type
17
VSAVL
- ShpTypPrel CHAR 2 - - Shipping type of preliminary leg
18
VSANL
- SubLgShpTy CHAR 2 - - Shipping type of subsequent leg
19
LAUFK
- LegIndictr CHAR 1 - - Leg Indicator
20
VSBED
- Shpg Cond. CHAR 2 - - Shipping Conditions
21
ROUTE
- ShpmtRoute CHAR 6 - - Shipment route
22
SIGNI
- Contnr ID CHAR 20 - - Container ID
23
EXTI1
- Ext. ID 1 CHAR 20 - - External identification 1
24
EXTI2
- Ext. ID 2 CHAR 20 - - External identification 2
25
TPBEZ
- Descriptn. CHAR 20 - - Description of Shipment
26
STDIS
- Planned CHAR 1 - - Status of transportation planning
27
DTDIS
- PlanEnd DATS 8 - - Date of end of planning
28
UZDIS
- SchedulEnd TIMS 6 - - Scheduling end time
29
STREG
- Check-in CHAR 1 - - Status of check-in
30
DPREG
- PlDat.ChIn DATS 8 - - Planned date of check-in
31
UPREG
- Pl.TmeChIn TIMS 6 - - Planned check-in time
32
DAREG
- ActDteChIn DATS 8 - - Actual date of check-in
33
UAREG
- CurTmeChIn TIMS 6 - - Current time of check-in
34
STLBG
- LoadStart CHAR 1 - - Status for start of loading
35
DPLBG
- PlanLoadSt DATS 8 - - Planned date for start of loading
36
UPLBG
- PlLoadStTm TIMS 6 - - Planned loading start time
37
DALBG
- CurrLoadSt DATS 8 - - Current date for start of loading
38
UALBG
- ActLoadStT TIMS 6 - - Actual loading start time
39
STLAD
- LoadEnd CHAR 1 - - Status for end of loading
40
DPLEN
- PlanLoadEn DATS 8 - - Planned date for end of loading
41
UPLEN
- PlLoadEnTm TIMS 6 - - Planned loading end time
42
DALEN
- ActLoadEnd DATS 8 - - Actual date for end of loading
43
UALEN
- AcLoadEnTm TIMS 6 - - Actual loading end time
44
STABF
- Completion CHAR 1 - - Status of shipment completion
45
DPABF
- PlShpCmplD DATS 8 - - Planned date for shipment completion
46
UPABF
- Pl.Tm.Proc TIMS 6 - - Planned time for processing
47
DTABF
- ShpCmplDte DATS 8 - - Current date of shipment completion
48
UZABF
- TimeTrProc TIMS 6 - - Time of transportation processing
49
STTBG
- ShpmtStart CHAR 1 - - Status for start of shipment
50
DPTBG
- PlanShipSt DATS 8 - - Planned date for start of shipment
51
UPTBG
- PlanTrStTm TIMS 6 - - Planned transport start time
52
DATBG
- CurrShipSt DATS 8 - - Current date for start of shipment
53
UATBG
- ActTrStTim TIMS 6 - - Actual transport start time
54
STTEN
- Shpmt.end CHAR 1 - - Status for end of shipment
55
DPTEN
- PlanShipEn DATS 8 - - Planned date for end of shipment
56
UPTEN
- PlTrEndTim TIMS 6 - - Planned transport end time
57
DATEN
- ActShipEnd DATS 8 - - Actual Date for End of Shipment
58
UATEN
- ActShEndTm TIMS 6 - - Actual shipment end time
59
STTRG
- OverallSta CHAR 1 - - Overall transportation status
60
TDLNR
- ServcAgent CHAR 10 - - Number of forwarding agent
61
TERNR
- Order CHAR 12 - - Order Number
62
PKSTK
- HUs CHAR 1 - - Shipment Contains Handling Units
63
DTMEG
- Unit UNIT 3 - - Unit of Weight for Transportation Planning
64
DTMEV
- VolumeUnit UNIT 3 - - Volume Unit for Transportation Planning
65
DISTZ
- Distance QUAN 13 3 - Distance
66
MEDST
- UoM-dist. UNIT 3 - - Unit of measure for distance
67
FAHZT
- Travl time QUAN 5 2 - Travelling time only between two locations
68
GESZT
- Total time QUAN 5 2 - Total travelling time between two locations incl. breaks
69
MEIZT
- Trav.times UNIT 3 - - Unit of measure for travelling times
70
STAFO
- Update grp CHAR 6 - - Update group for statistics update
71
FBSTA
- ShCoCalSts CHAR 1 - - Status of shipment costs calculation
72
FBGST
- Ov.shp.co. CHAR 1 - - Overall status of calculation of shipment costs for shipment
73
ARSTA
- ShCstSetSt CHAR 1 - - Status of shipment costs settlement
74
ARGST
- Tot.Sh.Stl CHAR 1 - - Total status of shipment costs settlement for shipment
75
STERM_DONE
- Legs dtrmd CHAR 1 - - Leg determination complete
76
VSE_FRK
- ShUn-ShCos CHAR 1 - - Handling Unit Data are Referred in Shipment Cost Document
77
KKALSM
- Procedure CHAR 6 - - Pricing procedure in shipment header
78
SDABW
- SpecProcId CHAR 4 - - Special processing indicator
79
FRKRL
- ShCstsRel CHAR 1 - - Shipment costs relevance
80
GESZTD
- PTotalTime DEC 11 - - Planned total time of transportation (in days)
81
FAHZTD
- Plnd dur. DEC 11 - - Planned duration of transportation (in hours:minutes)
82
GESZTDA
- ActTotTime DEC 11 - - Actual total time of shipment (in days)
83
FAHZTDA
- Act.durat. DEC 11 - - Actual time needed for transporation (in hours:minutes)
84
ROCPY_DONE
- Route Dlv. CHAR 1 - - Route copied from delivery
85
HANDLE
- Handle CHAR 22 - - Globally unique identifier (linked to time segment, etc)
86
TSEGFL
- TS exists CHAR 1 - - Time segment exists
87
TSEGTP
- Template CHAR 10 - - Time segment event group shipment header
88
ADD01
- Suppl. 1 CHAR 10 - - Suppl. 1
89
ADD02
- Suppl. 2 CHAR 10 - - Suppl. 2
90
ADD03
- Suppl. 3 CHAR 10 - - Suppl. 3
91
ADD04
- Suppl. 4 CHAR 10 - - Suppl. 4
92
TEXT1
- Text 1 CHAR 40 - - Addit.text 1
93
TEXT2
- Text 2 CHAR 40 - - Addit.text 2
94
TEXT3
- Text 3 CHAR 40 - - Addit.text 3
95
TEXT4
- Text 4 CHAR 40 - - Addit.text 4
96
PROLI
- DGMgmtProf CHAR 3 - - Dangerous Goods Management Profile in SD Documents
97
DGTLOCK
- Block Ind. CHAR 1 - - Block Indicator for Dangerous Goods
98
DGMDDAT
- Selec.date DATS 8 - - Selection date dangerous goods master data
99
CONT_DG
- ContainsDG CHAR 1 - - Indicator: Document contains dangerous goods
100
WARZTD
- Pl.wait.tm DEC 11 - - Planned waiting time of shipment (in hours:minutes)
101
WARZTDA
- CurrWaitTm DEC 11 - - Current waiting time of shipment (in hours:minutes)
102
AULWE
- RouteSched CHAR 10 - - Route Schedule
103
TNDRST
- Tndr stat. CHAR 2 - - Tender Status
104
TNDRRC
- Acc/RjcRsn CHAR 2 - - Acceptance Condition/Rejection Reason
105
TNDR_TEXT
- Tndg text CHAR 80 - - Tendering Text
106
TNDRDAT
- Date DATS 8 - - Date of tender status
107
TNDRZET
- TimeTender TIMS 6 - - Time of tender status
108
TNDR_MAXP
- Max. price CURR 15 2 - Maximum Price for Shipment
109
TNDR_MAXC
- Currency CUKY 5 - - Currency of Maximum Price
110
TNDR_ACTP
- Act. price CURR 15 2 - Actual Shipment Costs for Shipment
111
TNDR_ACTC
- Currency CUKY 5 - - Currency of Actual Shipment Costs
112
TNDR_CARR
- FwdAgent CHAR 10 - - Forwarding Agent Who Accepted the Shipment
113
TNDR_CRNM
- Name CHAR 35 - - Name of Carrier Who Accepted the Shipment
114
TNDR_TRKID
- TrackingID CHAR 35 - - Forwarding Agent Tracking ID
115
TNDR_EXPD
- Valid to DATS 8 - - Date on Which Offer Expires
116
TNDR_EXPT
- Time TIMS 6 - - Time at Which Quotation Expires
117
TNDR_ERPD
- EarlPickup DATS 8 - - Earliest Pickup Date
118
TNDR_ERPT
- Time TIMS 6 - - Earliest Pickup Time
119
TNDR_LTPD
- LatePickup DATS 8 - - Latest Pickup Date
120
TNDR_LTPT
- Time TIMS 6 - - Latest Pickup Time
121
TNDR_ERDD
- Earl. DD DATS 8 - - Earliest Delivery Date
122
TNDR_ERDT
- Time TIMS 6 - - Earliest Delivery Time
123
TNDR_LTDD
- Latest DD DATS 8 - - Latest Delivery Date
124
TNDR_LTDT
- Time TIMS 6 - - Latest Delivery Time
125
TNDR_LDLG
- LoadLength QUAN 13 3 - Length of Loading Platform
126
TNDR_LDLU
- UoM LdLnth UNIT 3 - - Unit of Measure for Load Length
127
KZHULFR
- HUs DI-rel CHAR 1 - - Indicator: HUs Relevant for Delivery Item Generation
128
ALLOWED_TWGT
- AlwdTotWgt QUAN 8 - - Allowed total weight of shipment
129
VLSTK
- Stat.Whse CHAR 1 - - Distribution Status (Decentralized Warehouse Processing)
130
VERURSYS
- Orig.syst. CHAR 10 - - Shipment Distribution: Original System
131
CM_IDENT
- Identity CHAR 12 - - Identification Number for Continuous Moves
132
CM_SEQUENCE
- Sequence NUMC 4 - - Sequence of Transports in Connecting Traffice
133
/BEV1/RPFAR1
- Driver 1 CHAR 10 - - Driver 1
134
/BEV1/RPFAR2
- Driver 2 CHAR 10 - - Driver 2
135
/BEV1/RPMOWA
- Vehicle CHAR 18 - - Vehicle
136
/BEV1/RPANHAE
- Trailer CHAR 18 - - Trailer
137
/BEV1/RPFLGNR
- Seq. No. NUMC 5 - - Loading Sequence Number in the Tour
138
/VSO/R_STATUS
- VSO Status CHAR 1 - - Status of Vehicle Space Optimization

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk VTTK.

Interactive ERD Diagrams
SAP SD - Shipping Tables Relation → SAP SD Table Mapping & Document Flow →
Standard T-Codes
SE11 SE16
Related Tables
LIKP LIPS VTTP VBLK VEPO VEKP VTFA VBFA
ANSI SQL Query 
SELECT a.TKNUM,
       a.VBTYP,
       a.SHTYP,
       a.TPLST,
       a.ERNAM,
       a.ERDAT
FROM VTTK AS a
WHERE a.TKNUM = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~tknum,
       a~vbtyp,
       a~shtyp,
       a~tplst,
       a~ernam,
       a~erdat
  FROM vttk AS a
  WHERE a~tknum = '0001'
  INTO TABLE @DATA(lt_vttk)
  UP TO 100 ROWS.