SAP ABAP Table TDS_HEAD_COM (Lean Order - Header Data)
Hierarchy
☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-SLS (Application Component) Sales
     ⤷ ERP_SALES_LORD (Package) ERP Sales Lean Order
Basic Data
Table Category INTTAB    Structure 
Structure TDS_HEAD_COM   Table Relationship Diagram
Short Description Lean Order - Header Data    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 .INCLUDE       0   0   Lean Order - Header Data (Values)  
2 HANDLE GUID_32 SYSUUID_C CHAR 32   0   GUID in 'CHAR' Format in Uppercase  
3 AUART AUART AUART CHAR 4   0   Sales Document Type *
4 VKORG VKORG VKORG CHAR 4   0   Sales Organization *
5 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel *
6 SPART SPART SPART CHAR 2   0   Division *
7 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVKBZ
8 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
9 VBELN VBELN_VA VBELN CHAR 10   0   Sales Document *
10 KUNAG KUNAG KUNNR CHAR 10   0   Sold-to party *
11 KUNWE KUNWE KUNNR CHAR 10   0   Ship-to party *
12 BSTKD BSTKD BSTKD CHAR 35   0   Customer purchase order number  
13 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
14 VDATU EDATU_VBAK DATUM DATS 8   0   Requested delivery date  
15 KETDAT KETDAT ETDAT CHAR 10   0   Requested delivery date of the document  
16 KPRGBZ KPRGBZ PRGBZ CHAR 1   0   Date type of the requested delivery date *
17 DWERK DWERK_EXT WERKS CHAR 4   0   Delivering Plant (Own or External) *
18 AUGRU AUGRU AUGRU CHAR 3   0   Order reason (reason for the business transaction) *
19 LIFSK LIFSK LIFSP CHAR 2   0   Delivery block (document header) TVLS
20 FAKSK FAKSK FAKSP CHAR 2   0   Billing block in SD document *
21 PRSDT PRSDT DATUM DATS 8   0   Date for pricing and exchange rate  
22 WAERK WAERK WAERS CUKY 5   0   SD document currency TCURC
23 KURSK_INT KURSK KURRF DEC 9   5   Exchange Rate for Pricing and Statistics  
24 KURSK_EXT     CHAR 12   0    
25 INCO1 INCO1 INCO1 CHAR 3   0   Incoterms (part 1) TINC
26 INCO2 INCO2 INCO2 CHAR 28   0   Incoterms (part 2)  
27 FKDAT FKDAT DATUM DATS 8   0   Billing date for billing index and printout  
28 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
29 AUTLF AUTLF XFELD CHAR 1   0   Complete delivery defined for each sales order?  
30 AUDAT AUDAT DATUM DATS 8   0   Document Date (Date Received/Sent)  
31 ANGDT ANGDT_V DATUM DATS 8   0   Quotation/Inquiry is valid from  
32 BNDDT BNDDT DATUM DATS 8   0   Date until which bid/quotation is binding (valid-to date)  
33 GUEBG GUEBG DATUM DATS 8   0   Valid-from date (outline agreements, product proposals)  
34 GUEEN GUEEN DATUM DATS 8   0   Valid-to date (outline agreements, product proposals)  
35 VSBED VSBED VSBED CHAR 2   0   Shipping conditions *
36 ZLSCH SCHZW_BSEG ZLSCH CHAR 1   0   Payment Method *
37 DELCO DELCO DELCO CHAR 3   0   Agreed delivery time  
38 VBEGDAT VBDAT_VEDA DATUM DATS 8   0   Contract start date  
39 VENDDAT VNDAT_VEDA DATUM DATS 8   0   Contract End Date  
40 VBEGREG VBREG_VEDA VDREG_VEDA CHAR 2   0   Rule for calculating contract start date *
41 VENDREG RGVTE VDREG_VEDA CHAR 2   0   Rule for contract end date *
42 KTEXT KTEXT_V TEXT40 CHAR 40   0   Search term for product proposal  
43 PLTYP PLTYP PLTYP CHAR 2   0   Price list type *
44 KONDA KONDA KONDA CHAR 2   0   Price Group (Customer) *
45 BZIRK BZIRK BZIRK CHAR 6   0   Sales district *
46 KDGRP KDGRP KDGRP CHAR 2   0   Customer group *
47 BSARK BSARK BSARK CHAR 4   0   Customer Order Type *
48 VSART VSARTTR VERSART CHAR 2   0   Shipping type T173
49 ABLAD ABLAD TEXT25 CHAR 25   0   Unloading Point  
50 EMPST EMPST TEXT25 CHAR 25   0   Receiving point  
51 CPD_NAME NAME1_GP NAME CHAR 35   0   Name 1  
52 CPD_STREET STRAS_GP TEXT35 CHAR 35   0   House number and street  
53 CPD_HNUM HSNMR NUMC6 NUMC 6   0   House Number  
54 CPD_PCODE PSTLZ PSTLZ CHAR 10   0   Postal Code  
55 CPD_CITY ORT01_GP TEXT35 CHAR 35   0   City  
56 CPD_COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
57 CPD_LANGU_INT SPRAS SPRAS LANG 1   0   Language Key *
58 CPD_LANGU_EXT SPRAS_ISO LAISO CHAR 2   0   ISO code for language key  
59 KVGR1 KVGR1 KVGR1 CHAR 3   0   Customer group 1 *
60 KVGR2 KVGR2 KVGR2 CHAR 3   0   Customer group 2 *
61 KVGR3 KVGR3 KVGR3 CHAR 3   0   Customer group 3 *
62 KVGR4 KVGR4 KVGR4 CHAR 3   0   Customer group 4 *
63 KVGR5 KVGR5 KVGR5 CHAR 3   0   Customer group 5 *
64 KDKG1 KDKG1 KDKGR CHAR 2   0   Customer condition group 1 *
65 KDKG2 KDKG2 KDKGR CHAR 2   0   Customer condition group 2 *
66 KDKG3 KDKG3 KDKGR CHAR 2   0   Customer condition group 3 *
67 KDKG4 KDKG4 KDKGR CHAR 2   0   Customer condition group 4 *
68 KDKG5 KDKG5 KDKGR CHAR 2   0   Customer condition group 5 *
69 VBELN_GRP VBELN_GRP VBELN CHAR 10   0   Group Master Contract *
70 CCINS CCINS CCINS CHAR 4   0   Payment cards: Card type *
71 CCNUM CCNUM CCNUM CHAR 25   0   Payment cards: Card number *
72 CCDATBI EXDATBI_CC CHAR10 CHAR 10   0   Payment cards: Expiration date  
73 VALDT VALDT DATUM DATS 8   0   Fixed value date  
74 VALTG VALTG TAGE2 NUMC 2   0   Additional value days  
75 TAXK1 TAXK1_AK TAXKD CHAR 1   0   Alternative tax classification *
76 WAKTION WAKTION WAKTION CHAR 10   0   Promotion *
77 GSBER GSBER GSBER CHAR 4   0   Business Area *
78 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
79 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
80 CVVAL CVVAL CVVAL CHAR 6   0   Card Verification Value  
81 CCNAME CCNAME TEXT40 CHAR 40   0   Payment Cards: Name of Cardholder  
82 ABRUF_PART ABRUF_PART ABRUF_PART CHAR 1   0   Check partner authorizations  
83 XBLNR XBLNR_V1 XBLNR1 CHAR 16   0   Reference Document Number  
84 SPPAYM SPPAYM SPPAYM CHAR 2   0   Payment Form for Special Payment Method  
85 SCHEME_GRP SCHEME_GRP SCHEME_GRP CHAR 4   0   Referencing requirement: Procedure *
86 MNDID SEPA_MNDID ID035 CHAR 35   0   Unique Referene to Mandate per Payment Recipient  
87 PAY_TYPE SEPA_PAY_TYPE SEPA_PAY_TYPE CHAR 1   0   SEPA: Payment Type  
88 SEPON SD_SEPA_FLAG SD_SEPA_FLAG CHAR 1   0   SEPA-Relevance  
89 CPD_HNUM_LONG STRAS_GP TEXT35 CHAR 35   0   House number and street  
90 CPD_ADRNR ADRNR ADRNR CHAR 10   0   Address *
91 .INCLU-_I       0   0   Lean Order - Header Data (CHAR)  
92 HANDLE_I GUID_32 SYSUUID_C CHAR 32   0   GUID in 'CHAR' Format in Uppercase  
93 AUART_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
94 VKORG_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
95 VTWEG_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
96 SPART_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
97 VKBUR_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
98 VKGRP_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
99 VBELN_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
100 KUNAG_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
101 KUNWE_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
102 BSTKD_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
103 BSTDK_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
104 VDATU_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
105 KETDAT_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
106 KPRGBZ_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
107 DWERK_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
108 AUGRU_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
109 LIFSK_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
110 FAKSK_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
111 PRSDT_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
112 WAERK_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
113 KURSK_INT_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
114 KURSK_EXT_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
115 INCO1_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
116 INCO2_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
117 FKDAT_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
118 ZTERM_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
119 AUTLF_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
120 AUDAT_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
121 ANGDT_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
122 BNDDT_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
123 GUEBG_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
124 GUEEN_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
125 VSBED_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
126 ZLSCH_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
127 DELCO_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
128 VBEGDAT_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
129 VENDDAT_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
130 VBEGREG_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
131 VENDREG_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
132 KTEXT_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
133 PLTYP_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
134 KONDA_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
135 BZIRK_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
136 KDGRP_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
137 BSARK_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
138 VSART_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
139 ABLAD_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
140 EMPST_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
141 CPD_NAME_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
142 CPD_STREET_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
143 CPD_HNUM_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
144 CPD_PCODE_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
145 CPD_CITY_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
146 CPD_COUNTRY_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
147 CPD_LANGU_INT_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
148 CPD_LANGU_EXT_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
149 KVGR1_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
150 KVGR2_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
151 KVGR3_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
152 KVGR4_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
153 KVGR5_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
154 KDKG1_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
155 KDKG2_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
156 KDKG3_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
157 KDKG4_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
158 KDKG5_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
159 VBELN_GRP_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
160 CCINS_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
161 CCNUM_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
162 CCDATBI_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
163 VALDT_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
164 VALTG_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
165 TAXK1_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
166 WAKTION_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
167 GSBER_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
168 PS_PSP_PNR_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
169 KOSTL_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
170 CVVAL_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
171 CCNAME_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
172 ABRUF_PART_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
173 XBLNR_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
174 SPPAYM_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
175 SCHEME_GRP_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
176 MNDID_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
177 PAY_TYPE_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
178 SEPON_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
179 CPD_HNUM_LONG_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
180 CPD_ADRNR_I CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
181 .INCLU-_R       0   0   Lean Order - Header Data (Values, Read Only)  
182 HANDLE_R GUID_32 SYSUUID_C CHAR 32   0   GUID in 'CHAR' Format in Uppercase  
183 AUART_T_R BEZEI20 TEXT20 CHAR 20   0   Description  
184 VKORG_T_R VTXTK TEXT20 CHAR 20   0   Name  
185 VTWEG_T_R VTXTK TEXT20 CHAR 20   0   Name  
186 SPART_T_R VTXTK TEXT20 CHAR 20   0   Name  
187 VKBUR_T_R BEZEI20 TEXT20 CHAR 20   0   Description  
188 VKGRP_T_R BEZEI20 TEXT20 CHAR 20   0   Description  
189 VTBER_T_R TXT_VTRBER TXT_VTRBER CHAR 64   0   Sales area  
190 KUNAG_T_R TXTPA TXTPA CHAR 255   0   Display text for partners (name, city, country, street)  
191 KUNWE_T_R TXTPA TXTPA CHAR 255   0   Display text for partners (name, city, country, street)  
192 LIFSK_T_R BEZEI_LIFSP TEXT20 CHAR 20   0   Description  
193 FAKSK_T_R BEZEI_FAKSP TEXT20 CHAR 20   0   Description  
194 DWERK_T_R NAME1 TEXT30 CHAR 30   0   Name  
195 ERNAM_R_R ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
196 ERDAT_R_R ERDAT DATUM DATS 8   0   Date on which the record was created  
197 ZLSCH_T_R TEXT1_042Z TEXT30 CHAR 30   0   Name of Payment Method in Language of the Country  
198 ZTERM_T_R DZTERM_BEZ TEXT30 CHAR 30   0   Description of terms of payment  
199 WAERK_R_R WAERK WAERS CUKY 5   0   SD document currency *
200 ENDBK_R_R ENDBK WERTV8 CURR 15   2   Total amount of document  
201 NETWR_R_R NETWR_AK WERTV8 CURR 15   2   Net Value of the Sales Order in Document Currency  
202 BTGEW_R_R BRGEW_AP MENG15 QUAN 15   3   Gross weight of item  
203 NTGEW_R_R NTGEW_AP MENG15 QUAN 15   3   Net weight of item  
204 GEWEI_R_R GEWEI MEINS UNIT 3   0   Weight Unit *
205 VOLUM_R_R VOLUM_AP MENG15 QUAN 15   3   Volume of the item  
206 VOLEH_R_R VOLEH MEINS UNIT 3   0   Volume unit *
207 TRVOG_R_R TRVOG_VA TRVOG_VA CHAR 1   0   Transaction group  
208 PLTYP_T_R BEZEI20 TEXT20 CHAR 20   0   Description  
209 KONDA_T_R BEZEI20 TEXT20 CHAR 20   0   Description  
210 BZIRK_T_R BEZEI20 TEXT20 CHAR 20   0   Description  
211 KDGRP_T_R BEZEI20 TEXT20 CHAR 20   0   Description  
212 BSARK_T_R BEZEI20 TEXT20 CHAR 20   0   Description  
213 VSART_T_R BEZEI20 TEXT20 CHAR 20   0   Description  
214 AEDAT_R_R AEDAT DATUM DATS 8   0   Last Changed On  
215 KALSM_R_R KALSMASD KALSM CHAR 6   0   Sales and Distribution: Pricing Procedure in Pricing *
216 AUFNR_R_R AUFNR AUFNR CHAR 12   0   Order Number *
217 QMNUM_R_R QMNUM QMNUM CHAR 12   0   Message Number *
218 KALSM_T_R VTXTM TEXT30 CHAR 30   0   Description  
219 WAKTION_T_R AKTBEZ TEXT40 CHAR 40   0   Promotion description  
220 MWSBK_R_R MWSBP WERTV7 CURR 13   2   Tax amount in document currency  
221 VSBED_T_R VSBED_BEZ TEXT20 CHAR 20   0   Description of the shipping conditions  
222 AUGRU_T_R BEZEI40 TEXT40 CHAR 40   0   Description  
223 UPD_TMSTMP_R_R TIMESTAMPL TZNTSTMPL DEC 21   7   UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)  
224 GSBER_T_R GTEXT TEXT30 CHAR 30   0   Business area description  
225 PS_PSP_PNR_T_R PS_POST1 TEXT40 CHAR 40   0   PS: Short description (first text line)  
226 KOSTL_T_R KTEXT TEXT20 CHAR 20   0   General Name  
227 KURST_R_R KURST KURST CHAR 4   0   Exchange Rate Type *
228 OBJNR_R_R J_OBJNR J_OBJNR CHAR 22   0   Object number *
229 ABRUF_PART_T_R VAL_TEXT DDTEXT CHAR 60   0   Short Text for Fixed Values  
230 SPPAYM_T_R VAL_TEXT DDTEXT CHAR 60   0   Short Text for Fixed Values  
231 SCHEME_GRP_T_R BEZEI40 TEXT40 CHAR 40   0   Description  
232 KOPGR_R_R BIFGR BIFGR CHAR 4   0   Screen sequence group for document header & item *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 TDS_HEAD_COM CPD_COUNTRY T005 LAND1 REF C CN
2 TDS_HEAD_COM INCO1 TINC INCO1 REF C CN
3 TDS_HEAD_COM LIFSK TVLS LIFSP    
4 TDS_HEAD_COM VKBUR TVKBZ VKBUR REF C CN
5 TDS_HEAD_COM VKGRP TVBVK VKGRP REF C CN
6 TDS_HEAD_COM VSART T173 VSART    
7 TDS_HEAD_COM WAERK TCURC WAERS REF C CN
History
Last changed by/on SAP  20131127 
SAP Release Created in