VTTK is a standard Transportation Transparent Table in SAP Logistics Execution application, which stores Shipment Header data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for VTTK. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
VTTK — Meta Data
Description: | Shipment Header |
Main Category: | Logistics Execution |
Sub Category: | Transportation |
Table type: | Transparent Table (TRANSP) |
VTTK — Table Structure, Fields(Columns) and Definitions
Position | Column Name | Description | Primary Key | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
1 | MANDT | Client | X | CLNT | 3 | T000 |
2 | TKNUM | Shipment Number | X | CHAR | 10 | |
3 | VBTYP | Document cat. | CHAR | 4 | ||
4 | SHTYP | Shipment type | CHAR | 4 | TVTK | |
5 | TPLST | Transportation planning point | CHAR | 4 | TTDS | |
6 | ERNAM | Created by | CHAR | 12 | ||
7 | ERDAT | Created on | DATS | 8 | ||
8 | ERZET | Time | TIMS | 6 | ||
9 | AENAM | Name of Person Who Changed Object | CHAR | 12 | ||
10 | AEDAT | Changed on | DATS | 8 | ||
11 | AEZET | Time last change was made | TIMS | 6 | ||
12 | STERM | Leg determination | CHAR | 1 | ||
13 | ABFER | Shipment completion type | CHAR | 1 | ||
14 | ABWST | Processing control | CHAR | 1 | ||
15 | BFART | Service Level | CHAR | 1 | ||
16 | VSART | Shipping type | CHAR | 2 | T173 | |
17 | VSAVL | Shipping type of preliminary leg | CHAR | 2 | T173 | |
18 | VSANL | Shipping type of subsequent leg | CHAR | 2 | T173 | |
19 | LAUFK | Leg Indicator | CHAR | 1 | ||
20 | VSBED | Shipping Cond. | CHAR | 2 | TVSB | |
21 | ROUTE | Route | CHAR | 6 | TVRO | |
22 | SIGNI | Significance for Collection of Statistics | CHAR | 20 | ||
23 | EXTI1 | External identification 1 | CHAR | 20 | ||
24 | EXTI2 | External identification 2 | CHAR | 20 | ||
25 | TPBEZ | Description of Shipment | CHAR | 20 | ||
26 | STDIS | Status of transportation planning | CHAR | 1 | ||
27 | DTDIS | Difference :Total Distr.ind. | DATS | 8 | ||
28 | UZDIS | Scheduling end time | TIMS | 6 | ||
29 | STREG | Status of check-in | CHAR | 1 | ||
30 | DPREG | Planned date of check-in | DATS | 8 | ||
31 | UPREG | Planned check-in time | TIMS | 6 | ||
32 | DAREG | Actual date of check-in | DATS | 8 | ||
33 | UAREG | Current time of check-in | TIMS | 6 | ||
34 | STLBG | Status for start of loading | CHAR | 1 | ||
35 | DPLBG | Planned date for start of loading | DATS | 8 | ||
36 | UPLBG | Planned loading start time | TIMS | 6 | ||
37 | DALBG | Current date for start of loading | DATS | 8 | ||
38 | UALBG | Actual loading start time | TIMS | 6 | ||
39 | STLAD | Status for end of loading | CHAR | 1 | ||
40 | DPLEN | Planned date for end of loading | DATS | 8 | ||
41 | UPLEN | Planned loading end time | TIMS | 6 | ||
42 | DALEN | Actual date for end of loading | DATS | 8 | ||
43 | UALEN | Actual loading end time | TIMS | 6 | ||
44 | STABF | Status of shipment completion | CHAR | 1 | ||
45 | DPABF | Planned date for shipment completion | DATS | 8 | ||
46 | UPABF | Planned time for processing | TIMS | 6 | ||
47 | DTABF | Current date of shipment completion | DATS | 8 | ||
48 | UZABF | Time of transportation processing | TIMS | 6 | ||
49 | STTBG | Status for start of shipment | CHAR | 1 | ||
50 | DPTBG | Planned date for start of shipment | DATS | 8 | ||
51 | UPTBG | Planned transport start time | TIMS | 6 | ||
52 | DATBG | Current date for start of shipment | DATS | 8 | ||
53 | UATBG | Actual transport start time | TIMS | 6 | ||
54 | STTEN | Status for end of shipment | CHAR | 1 | ||
55 | DPTEN | Planned date for end of shipment | DATS | 8 | ||
56 | UPTEN | Planned transport end time | TIMS | 6 | ||
57 | DATEN | Data | DATS | 8 | ||
58 | UATEN | Actual shipment end time | TIMS | 6 | ||
59 | STTRG | Overall transportation status | CHAR | 1 | ||
60 | TDLNR | Number of forwarding agent | CHAR | 10 | LFA1 | |
61 | TERNR | Order Number | CHAR | 12 | * | |
62 | PKSTK | Shipment Contains Handling Units | CHAR | 1 | ||
63 | DTMEG | Unit of Weight for Transportation Planning | UNIT | 3 | * | |
64 | DTMEV | Volume Unit for Transportation Planning | UNIT | 3 | * | |
65 | DISTZ | Distance | QUAN | 13 | ||
66 | MEDST | Unit of measure for distance | UNIT | 3 | * | |
67 | FAHZT | Travelling time only between two locations | QUAN | 5 | ||
68 | GESZT | Total travelling time between two locations incl. breaks | QUAN | 5 | ||
69 | MEIZT | Unit of measure for travelling times | UNIT | 3 | * | |
70 | STAFO | Update group for statistics update | CHAR | 6 | * | |
71 | FBSTA | FPF: System Status of a Form Bundle | CHAR | 1 | ||
72 | FBGST | Overall status of calculation of shipment costs for shipment | CHAR | 1 | ||
73 | ARSTA | Status of shipment costs settlement | CHAR | 1 | ||
74 | ARGST | Total status of shipment costs settlement for shipment | CHAR | 1 | ||
75 | STERM_DONE | Leg determination complete | CHAR | 1 | ||
76 | VSE_FRK | Handling Unit Data are Referred in Shipment Cost Document | CHAR | 1 | ||
77 | KKALSM | Pricing procedure in shipment header | CHAR | 6 | T683 | |
78 | SDABW | Special processing indicator | CHAR | 4 | TVSAK | |
79 | FRKRL | Shipment costs relevance | CHAR | 1 | ||
80 | GESZTD | Planned total time of transportation (in days) | DEC | 11 | ||
81 | FAHZTD | Planned duration of transportation (in hours:minutes) | DEC | 11 | ||
82 | GESZTDA | Actual total time of shipment (in days) | DEC | 11 | ||
83 | FAHZTDA | Actual time needed for transporation (in hours:minutes) | DEC | 11 | ||
84 | ROCPY_DONE | Route copied from delivery | CHAR | 1 | ||
85 | HANDLE | Worldwide unique key for LIKP-VBELN | CHAR | 22 | ||
86 | TSEGFL | Time segment exists | CHAR | 1 | ||
87 | TSEGTP | Event group time segment delivery header | CHAR | 10 | * | |
88 | ADD01 | Suppl. 1 | CHAR | 10 | VTADD01 | |
89 | ADD02 | Suppl. 2 | CHAR | 10 | VTADD02 | |
90 | ADD03 | Suppl. 3 | CHAR | 10 | VTADD03 | |
91 | ADD04 | Suppl. 4 | CHAR | 10 | VTADD04 | |
92 | TEXT1 | Description | CHAR | 40 | ||
93 | TEXT2 | Excerpt from infotype text module | CHAR | 40 | ||
94 | TEXT3 | Excerpt from infotype text module | CHAR | 40 | ||
95 | TEXT4 | Addit.text 4 | CHAR | 40 | ||
96 | PROLI | Dangerous Goods Management Profile in SD Documents | CHAR | 3 | TDGC5 | |
97 | DGTLOCK | Block Indicator for Dangerous Goods | CHAR | 1 | ||
98 | DGMDDAT | Selection date dangerous goods master data | DATS | 8 | ||
99 | CONT_DG | Indicator: Document contains dangerous goods | CHAR | 1 | ||
100 | WARZTD | Planned waiting time of shipment (in hours:minutes) | DEC | 11 | ||
101 | WARZTDA | Current waiting time of shipment (in hours:minutes) | DEC | 11 | ||
102 | AULWE | Route Schedule | CHAR | 10 | * | |
103 | TNDRST | Tender Status | CHAR | 2 | ||
104 | TNDRRC | Acceptance Condition/Rejection Reason | CHAR | 2 | ||
105 | TNDR_TEXT | Tendering Text | CHAR | 80 | ||
106 | TNDRDAT | Date of tender status | DATS | 8 | ||
107 | TNDRZET | Time of tender status | TIMS | 6 | ||
108 | TNDR_MAXP | Maximum Price for Shipment | CURR | 15 | ||
109 | TNDR_MAXC | Currency of Maximum Price | CUKY | 5 | TCURC | |
110 | TNDR_ACTP | Actual Shipment Costs for Shipment | CURR | 15 | ||
111 | TNDR_ACTC | Currency of Actual Shipment Costs | CUKY | 5 | TCURC | |
112 | TNDR_CARR | Forwarding Agent Who Accepted the Shipment | CHAR | 10 | ||
113 | TNDR_CRNM | Name of Carrier Who Accepted the Shipment | CHAR | 35 | ||
114 | TNDR_TRKID | Forwarding Agent Tracking ID | CHAR | 35 | ||
115 | TNDR_EXPD | Date on Which Offer Expires | DATS | 8 | ||
116 | TNDR_EXPT | Time at Which Quotation Expires | TIMS | 6 | ||
117 | TNDR_ERPD | Earliest Pickup Date | DATS | 8 | ||
118 | TNDR_ERPT | Earliest Pickup Time | TIMS | 6 | ||
119 | TNDR_LTPD | Latest Pickup Date | DATS | 8 | ||
120 | TNDR_LTPT | Latest Pickup Time | TIMS | 6 | ||
121 | TNDR_ERDD | Earliest Delivery Date | DATS | 8 | ||
122 | TNDR_ERDT | Earliest Delivery Time | TIMS | 6 | ||
123 | TNDR_LTDD | Latest Delivery Date | DATS | 8 | ||
124 | TNDR_LTDT | Latest Delivery Time | TIMS | 6 | ||
125 | TNDR_LDLG | Length of Loading Platform | QUAN | 13 | ||
126 | TNDR_LDLU | Unit of Measure for Load Length | UNIT | 3 | * | |
127 | KZHULFR | Indicator: HUs Relevant for Delivery Item Generation | CHAR | 1 | ||
128 | ALLOWED_TWGT | Allowed total weight of shipment | QUAN | 8 | ||
129 | VLSTK | Distribution Status (Decentralized Warehouse Processing) | CHAR | 1 | ||
130 | VERURSYS | Distribution delivery: Original system | CHAR | 10 | * | |
131 | CM_IDENT | Identification Number for Continuous Moves | CHAR | 12 | ||
132 | CM_SEQUENCE | Sequence of Transports in Connecting Traffice | NUMC | 4 | ||
133 | EXT_FREIGHT_ORD | External Freight Order ID | CHAR | 20 | ||
134 | EXT_TM_SYS | Key Name of Business System | CHAR | 60 | ||
135 | .INCLU--AP | 0 | ||||
136 | .INCLUDE | 0 | ||||
137 | /BEV1/RPFAR1 | Driver 1 | CHAR | 10 | KNA1 | |
138 | /BEV1/RPFAR2 | Driver 2 | CHAR | 10 | KNA1 | |
139 | /BEV1/RPMOWA | Vehicle | CHAR | 18 | * | |
140 | /BEV1/RPANHAE | Trailer | CHAR | 18 | * | |
141 | /BEV1/RPFLGNR | Loading Sequence Number in the Tour | NUMC | 5 | ||
142 | .INCLU--AP | 0 | ||||
143 | .INCLUDE | 0 | ||||
144 | /VSO/R_STATUS | Status of Vehicle Space Optimization | CHAR | 1 |
SAP Help, Wiki Resources, and Forum Discussions on VTTK
Click the above link for the full list of resources and help pages, only the first few are posted below
-
Regarding Adding Custom Fields to VTTK and VT01n transaction.
Also, these fields should be reflected in 'Additional Data' tab of transaction VT01n/VT02n for editing and should be available for display in VT03n.
http://scn.sap.com/message/10490145
-
Need link between VBAK LIKP VBPA and VTTK | SCN
Hi Venkat,
For VBPA,LIKP,VBAP will have order number as the key.
VTTP has order number and TKNUM(Shipment number)
VTTK has shipment number as key field.
Hope it is useful.
Regards,
Sravanthi Chilal
http://scn.sap.com/message/7992459
-
Delta Extractor on VTTK, VTTP, LIKP, VBPA, ADRC | SCN
I need to capture all the shipments that were created or captured. There is a standad datasource 2LIS_08TRTK ( Shipment Header Data ) but the data for my case is being filled up by IDOC in these tables sent from third party TMS application. And its differentiated with others via Shipment type.
http://scn.sap.com/message/13122682
-
How to grey the field VTTK-SIGNI in Tcode VT02N | SCN
My requirment is while creating shipment order we enter value in fied VTTK-SIGNI and save it.
http://scn.sap.com/message/9038750
-
Function module for updating the values in table VTTK
It seems that you'll need to populate the field HEADERDATA-SERVICE_AGENT_ID (structure BAPISHIPMENTHEADER) with the value that has to be assigned to the VTTK-TDLNR field and the field HEADERDATAACTION-SERVICE_AGENT_ID = 'C' (for Change). Naturally, the field SHIPMENT_NUM should have the shipment number (VTTK-TKNUM) in both structures.
http://scn.sap.com/message/2911894
-
Problem in updating Shipment status VTTK-STTRG with given time zone
But the problem is the update should consider the given time zone not the system date & time.
http://scn.sap.com/message/5949065
-
How to use "Read_text" to extract data in VTTK | SCN
Hi, I am new to ABAP, I know a FM"read_text",can somebody show me a sample code?
http://scn.sap.com/message/1744812
-
Inconsistency between Dictionary types "VTTK_TAB" and "VTTK"
Hi Guru's,
must be 1090 bytes long. However, the Dictionary description of "VTTK", the
http://scn.sap.com/message/6430824
-
VTTK, VTTP,LIPS LIKP | SCN
Create delivery, system generate TO - > it will link to VBAP-VBELN and VBAP-POSNR, update document flow.
http://scn.sap.com/message/3587828
-
Link between VTTK-TKNUM and VFKK-FKNUM? | SCN
Am trying to get the relationship between VTTK-TKNUM (Shipment Header-Shipment Number) and VFKK-FKNUM (Shipment Costs: Header Data-Shipment Cost Number), i saw VFKP, VFKN, VFSI, VTTP tables, views, FMs but no use!
http://scn.sap.com/message/9898644
-
How to connect vbrk,VTTK,vbrp | SCN
could you tell me how would I connect vbrk ,VTTK, vbrp ..i am very new to sap..i dont know how would I connect them in my where clause and which field do I need to select. I need to show all these fields: in vbrk i need the fkdat,vbeln VTTK i need the tknum,exti1,exti2 vbrp i need the fkimg in my selection-screen fields are from vbrk ,vbrp and kna1. i have to make a report based on bill...
http://scn.sap.com/message/13232837
Related Tables
TABLE | Description | Functional Area |
---|---|---|
VTTP | Shipment Item | Logistics Execution - Transportation |
LIKP | SD Document: Delivery Header Data | Logistics Execution - Shipping |
LIPS | SD document: Delivery: Item data | Logistics Execution - Shipping |
VBAK | Sales Document: Header Data | SD - Sales |
VBFA | Sales Document Flow | SD - Basic Functions |
VBRK | Billing Document: Header Data | SD - Billing |
VTTS | Stage of Shipment | Logistics Execution - Transportation |
Transaction Codes for SAP Table VTTK
TCODE | Description | Functional Area |
---|---|---|
SPRO | Customizing - Edit Project | Basis - Customizing Project Management (IMG) |
VTFA | Order to bill copying control | SD - Basic Functions |
SE11 | ABAP Dictionary Maintenance | Basis - Dictionary Maintenance |
VT01N | Create Shipment | Logistics Execution - Transportation |
VT02N | Change Shipment | LE - Transportation |
VBKD | Bonus Buy: Condition Types | SD - Free Goods |
SLIS | FI-SL Spec.Purpose Ledg. Info.System | FI - Information System |
MIGO | Goods Movement | MM - Inventory Management |
FMs for SAP Table VTTK
FM | Description | Functional Area |
---|---|---|
REUSE_ALV_FIELDCATALOG_MERGE | Create field catalog from dictionary structure or internal table | BC - SAP List Viewer |
REUSE_ALV_GRID_DISPLAY | Output of a simple list (single-line) | Basis - SAP List Viewer |
REUSE_ALV_LIST_DISPLAY | Output a simple list (single line or several lines) | BC - SAP List Viewer |
BAPI_SHIPMENT_CHANGE | Change Shipment | Logistics Execution - Transportation |
REUSE_ALV_EVENTS_GET | Returns table of possible events for a list type | BC - SAP List Viewer |
READ_TEXT | SAPscript: Read text | BC - SAPscript |
REUSE_ALV_COMMENTARY_WRITE | List body comment block output | BC - SAP List Viewer |
REUSE_ALV_HIERSEQ_LIST_DISPLAY | Hierarchical sequential list output | BC - SAP List Viewer |
ABAP Reports for SAP Table VTTK
ABAP REPORT | Description | Functional Area |
---|---|---|
SAPMV56A | Module Pool Transport General | Logistics Execution - Transportation |
CL_ABAP_TYPEDESCR=============CP | Include LDMEE1_ABACIH | |
BCALV_TEST_HIERSEQ_LIST | Program BCALV_TEST_HIERSEQ_LIST | Basis - SAP List Viewer |
RSNASTED | Analysis of NAST Record for Output Type 6 (EDI) | Basis - ALE Integration Technology |
CL_ALV_CHECK_THIRD_PARTY======CP | Transport module for list tool display variants | |
RV56TRSL | Check in Shipments | Logistics Execution - Transportation |
RSAP0001 | Program for object type SAP0001 : BapiService | Basis - BW Service API |
IDATA | Include IDATA | FI - Localization |
BW Datasources for SAP Table VTTK
BW DATASOURCE | Description | Functional Area |
---|---|---|
2LIS_08TRTLP | Shipment: Delivery Item Data by Section | SD - Sales and Distribution |
2LIS_08TRTK | Shipment: Header Data | SD - Sales and Distribution |
2LIS_08TRFKZ | Shipment Costs at Delivery Item Level | SD - Sales and Distribution |
2LIS_08TRFKP | Shipment Costs at Item Level | SD - Sales and Distribution |
2LIS_08TRTS | Shipment: Section Data | SD - Sales and Distribution |
2LIS_11_VAITM | Sales Document Item Data | SD - Sales and Distribution |
2LIS_11_V_SCL | Sales-Shipping Allocation Schedule Line | SD - Sales and Distribution |
2LIS_11_V_ITM | Sales-Shipping Allocation Item Data | SD - Sales and Distribution |
Authorization Objects for SAP Table VTTK
AUTHORIZATION OBJECT | Description | Functional Area |
---|---|---|
E_VARIANT | Authorization Object for Variants | |
V_VTTK_TDS | Shipment Processing: Auth. for Transport. Planning Points | |
S_TABU_DIS | Table Maintenance (via standard tools such as SM30) | |
S_RS_AUTH | BI Analysis Authorizations in Role | |
V_VTTK_TSA | Transportation Proc.: Authorization for Shipment Type Status | |
I_FCODE | WCM: Function Codes (e.g. Operational Cycle) | |
S_TCODE | Transaction Code Check at Transaction Start | |
S_RS_COMP1 | Business Explorer - Components: Enhancements to the Owner |
Most searched SAP Logistics Execution Tables
- Shipping Point Tables
- Shipment Tables
- Inbound Delivery Tables
- Storage Type Tables
- Storage Bin Tables
- Warehouse Number Tables
- Shipment Cost Tables
- Transfer Order Tables
- Route Tables
- Route Determination Tables
- Routes Tables
- Deliver Tables
- Warehouse Tables
- Freight Tables
- Material Wm Tables
- Storage Unit Tables
- Shipment Type Tables
- Transfer Requirement Tables
- Storage Section Tables
- Shipping Point Determination Tables
- Picking Tables
- Storage Unit Type Tables