SAP ABAP Table DB_WBHK_WBHI_ITM (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure DB_WBHK_WBHI_ITM   Table Relationship Diagram
Short Description Generated Table for View    
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 MANDT MANDT MANDT CLNT 3   0   Client T000
2 TKONN TKONN TKONN CHAR 10   0   Trading Contract: Trading Contract Number  
3 TCTYP TCTYP TCTYP CHAR 4   0   Trading Contract: Trading Contract Type TB2BE
4 KUNNR KUNAG KUNNR CHAR 10   0   Sold-to party KNA1
5 BTBSTA BTBSTA BTBSTA CHAR 1   0   Trading Contract: Application Status TB2BA
6 TKWAERS TKWAERS WAERS CUKY 5   0   Trading Contract: Currency of Trading Contract TCURC
7 TKRATE KURSK KURRF DEC 9   5   Exchange Rate for Pricing and Statistics  
8 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
9 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVKOV
10 TKSACHB TKSACHB UNAME CHAR 12   0   Trading Contract: Person Responsible  
11 BSTNK BSTNK BSTNK CHAR 20   0   Customer purchase order number  
12 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
13 TKRATE_SD TKRATE_SD KURRF DEC 9   5   GT Exchange Rate Sales Order Currency / Local Currency  
14 KURST_SD KURST KURST CHAR 4   0   Exchange Rate Type TCURV
15 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
16 PRSDT_SD PRSDT DATUM DATS 8   0   Date for pricing and exchange rate  
17 KURST KURST KURST CHAR 4   0   Exchange Rate Type TCURV
18 AUGRU AUGRU AUGRU CHAR 3   0   Order reason (reason for the business transaction) TVAU
19 ABSSC ABSSCHE_CM ABSSCHE_CM CHAR 6   0   Payment Guarantee Procedure T691M
20 LCNUM LCNUM LCNUM CHAR 10   0   Financial doc. processing: Internal financial doc. number AKKP
21 AKPRZ AKPRZ PRZ32 DEC 5   2   Depreciation percentage for financial document processing  
22 LOGSYS LOGSYS LOGSYS CHAR 10   0   Logical system TBDLS
23 AUDAT AUDAT DATUM DATS 8   0   Document Date (Date Received/Sent)  
24 EXNUM EXNUM EXNUM CHAR 10   0   Number of foreign trade data in MM and SD documents  
25 FT_HEADER_COM HKCOM FLAG CHAR 1   0   Trading Contract: Document is Complete  
26 ANGDT_SD ANGDT_V DATUM DATS 8   0   Quotation/Inquiry is valid from  
27 BNDDT_SD BNDDT DATUM DATS 8   0   Date until which bid/quotation is binding (valid-to date)  
28 SUBMI_SD SUBMI_SD CHAR10 CHAR 10   0   Collective number (SD)  
29 LIFSK_SD LIFSK LIFSP CHAR 2   0   Delivery block (document header) TVLS
30 FAKSK_SD FAKSK FAKSP CHAR 2   0   Billing block in SD document TVFS
31 NETWR_SD NETWR_AK WERTV8 CURR 15   2   Net Value of the Sales Order in Document Currency  
32 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
33 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVKBZ
34 AUTLF_SD AUTLF XFELD CHAR 1   0   Complete delivery defined for each sales order?  
35 VSBED_SD VSBED VSBED CHAR 2   0   Shipping conditions TVSB
36 BSARK_SD BSARK BSARK CHAR 4   0   Customer Order Type T176
37 BSTZD_SD BSTZD BSTZD CHAR 4   0   Customer purchase order number supplement  
38 IHREZ_SD IHREZ TEXT12 CHAR 12   0   Your Reference  
39 BNAME_SD BNAME_V NAME CHAR 35   0   Name of orderer  
40 TELF1_SD TELF1_VP TELF1 CHAR 16   0   Telephone Number  
41 MAHZA_SD MAHZA PACK2 DEC 3   0   Number of reminder notices, reminders for delivery purchase  
42 MAHDT_SD MAHDT DATUM DATS 8   0   Last Delivery Reminder Notice  
43 TAXK1_SD TAXK1_AK TAXKD CHAR 1   0   Alternative tax classification  
44 TAXK2_SD TAXK2 TAXKD CHAR 1   0   Tax classification 2 for customer  
45 TAXK3_SD TAXK3 TAXKD CHAR 1   0   Tax classification 3 for customer  
46 TAXK4_SD TAXK4 TAXKD CHAR 1   0   Tax classification 4 for customer  
47 TAXK5_SD TAXK5 TAXKD CHAR 1   0   Tax classification 5 for customer  
48 TAXK6_SD TAXK6 TAXKD CHAR 1   0   Tax classification 6 for customer  
49 TAXK7_SD TAXK7 TAXKD CHAR 1   0   Tax classification 7 for customer  
50 TAXK8_SD TAXK8 TAXKD CHAR 1   0   Tax classification 8 for customer  
51 TAXK9_SD TAXK9 TAXKD CHAR 1   0   Tax classification 9 for customer  
52 XBLNR_SD XBLNR_V1 XBLNR1 CHAR 16   0   Reference Document Number  
53 VBTYP_SD VBTYP_V VBTYP CHAR 1   0   Document category of preceding SD document  
54 STCEG_L_SD LAND1TX LAND1 CHAR 3   0   Tax Destination Country T005
55 ANDTX_SD LANDTX LAND1 CHAR 3   0   Tax Departure Country T005
56 KVGR1_SD KVGR1 KVGR1 CHAR 3   0   Customer group 1 TVV1
57 KVGR2_SD KVGR2 KVGR2 CHAR 3   0   Customer group 2 TVV2
58 KVGR3_SD KVGR3 KVGR3 CHAR 3   0   Customer group 3 TVV3
59 KVGR4_SD KVGR4 KVGR4 CHAR 3   0   Customer group 4 TVV4
60 KVGR5_SD KVGR5 KVGR5 CHAR 3   0   Customer group 5 TVV5
61 AUART AUART AUART CHAR 4   0   Sales Document Type  
62 QUAN_COMPLETE HKCOM_QUAN FLAG CHAR 1   0   Trading Contract: Quantities In Document Are Complete  
63 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
64 KKBER KKBER KKBER CHAR 4   0   Credit control area T014
65 KNKLI KNKLI KUNNR CHAR 10   0   Customer's account number with credit limit reference KNA1
66 GRUPP GRUPP_CM GRUPP_CM CHAR 4   0   Customer credit group T691B
67 SBGRP SBGRP_CM SBGRP_CM CHAR 3   0   Credit Representative Group for Credit Management T024B
68 CTLPC CTLPC_CM CTLPC_CM CHAR 3   0   Credit management: Risk category  
69 CMWAE WAERS_CM WAERS CUKY 5   0   Currency key of credit control area TCURC
70 CMFRE CMFRE DATUM DATS 8   0   Release date of the document determined by credit management  
71 CMNUP CMNUP DATUM DATS 8   0   Date of next credit check of document  
72 CMNGV CMNGV DATUM DATS 8   0   Next date  
73 AMTBL AMTBL_CM WERTV8 CURR 15   2   Released credit value of the document  
74 LFSPG WLFSPG WLFSPG CHAR 2   0   Vendor billing document block: Document header TMFS
75 WKURS_DAT WWERT_D DATUM DATS 8   0   Translation date  
76 WBPCH TC_LAST_CHANGED_FLAG TC_LAST_CHANGED_FLAG CHAR 1   0   Trading Contract Last Chngd Flag (Customer, Trader, Vendor)  
77 KURRF KURRF KURRF DEC 9   5   Exchange rate for FI postings  
78 TC_RELEASED TC_RELEASED TC_RELEASED CHAR 1   0   Release Status for Follow-On Document Generation  
79 TKONN_EX TKONN_EX TKONN_EX CHAR 30   0   Trading Contract: External Document Number  
80 TCCAT TCCAT TCCAT CHAR 1   0   Trading Contract: Contract Category  
81 WE_KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
82 STCEG_L LAND1TX LAND1 CHAR 3   0   Tax Destination Country T005
83 LANDTX LANDTX LAND1 CHAR 3   0   Tax Departure Country T005
84 XEGDR XEGDR XFELD CHAR 1   0   Indicator: Triangular deal within the EU ?  
85 USE_CASE WB2_USE_CASE_TYPE WB2_USE_CASE_TYPE CHAR 2   0   Use Case Type  
86 TEW_TYPE WB2_TEW_TYPE WB2_TEW_TYPE CHAR 4   0   Trading Execution Workbench Type TEWTYPE
87 SUCC_ARCH WB2_SUCC_ARCHIVED WB2_SUCC_ARCHIVED CHAR 1   0   Network Archived  
88 ABRVW ABRVW ABRVW CHAR 3   0   Usage Indicator TVLV
89 KNUMV_SD KNUMV KNUMV CHAR 10   0   Number of the document condition  
90 PRICING_TYPE WB2_PRICING_TYPE WB2_PRICING_TYPE CHAR 1   0   Definition of Pricing Procedure in Trading Contract  
91 KALSM_SD KALSM_D KALSM CHAR 6   0   Procedure (Pricing, Output Control, Acct. Det., Costing,...)  
92 TPOSN TPOSN TPOSN NUMC 6   0   Trading Contract: Item Number  
93 TPOSN_SUB TPOSN_SUB TPOSN NUMC 6   0   Trading Contract: Sub-Item Number  
94 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
95 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
96 LGORT LGORT_D LGORT CHAR 4   0   Storage location T001L
97 KWMENG WKWMENG MENG15 QUAN 15   3   Cumulative Order Quantity in Sales Units  
98 VRKME VRKME MEINS UNIT 3   0   Sales unit T006
99 UMVKZ UMVKZ UMBSZ DEC 5   0   Numerator (factor) for conversion of sales quantity into SKU  
100 UMVKN UMVKN UMBSN DEC 5   0   Denominator (divisor) for conversion of sales qty. into SKU  
101 BASIS_MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
102 ARKTX ARKTX TEXT40 CHAR 40   0   Short text for sales order item  
103 BWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type T149D
104 CHARG CHARG_D CHARG CHAR 10   0   Batch Number  
105 GROES GROES CHAR32 CHAR 32   0   Size/dimensions  
106 MENGE BSMNG MENG13 QUAN 13   3   Quantity ordered against this purchase requisition  
107 MEINS BSTME MEINS UNIT 3   0   Order unit T006
108 BPRME_MM BBPRM MEINS UNIT 3   0   Order Price Unit (purchasing) T006
109 BPUMZ_MM BPUMZ UMBSZ DEC 5   0   Numerator for Conversion of Order Price Unit into Order Unit  
110 BPUMN_MM BPUMN UMBSN DEC 5   0   Denominator for Conv. of Order Price Unit into Order Unit  
111 UMREZ_MM UMBSZ UMBSZ DEC 5   0   Numerator for Conversion of Order Unit to Base Unit  
112 UMREN_MM UMREN UMBSN DEC 5   0   Denominator for conversion to base units of measure  
113 PEINH_MM EPEIN DEC5 DEC 5   0   Price unit  
114 NETPR_MM MMBTR WERTV6 CURR 11   2   Trading Contract: Purchase Price  
115 WAERS_MM MMWRS WAERS CUKY 5   0   Trading Contract: Purchasing Currency TCURC
116 NETPR_SD SDBTR WERTV6 CURR 11   2   Trading Contract: Sales Price  
117 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
118 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
119 ERZET ERZET UZEIT TIMS 6   0   Entry time  
120 MATKL MATKL MATKL CHAR 9   0   Material Group  
121 UEBTK_SD UEBTK_V XFELD CHAR 1   0   Unlimited overdelivery allowed  
122 UEBTO_SD UEBTO PRZ21 DEC 3   1   Overdelivery Tolerance Limit  
123 UNTTO_SD UNTTO PRZ21 DEC 3   1   Underdelivery Tolerance Limit  
124 HKPSTP HKPSTP HKPSTP CHAR 4   0   Trading Contract: Item Category TB2BK
125 FT_ITEM_COM HKCOM FLAG CHAR 1   0   Trading Contract: Document is Complete  
126 ABGRU ABGRU_VA ABGRU_VA CHAR 2   0   Reason for rejection of quotations and sales orders TVAG
127 PRODH PRODH_D PRODH CHAR 18   0   Product Hierarchy T179
128 KDMAT MATNR_KU IDNEX CHAR 35   0   Customer Material Number  
129 SPART SPART SPART CHAR 2   0   Division TSPA
130 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
131 BRGEW BRGEW_AP MENG15 QUAN 15   3   Gross weight of item  
132 NTGEW NTGEW_AP MENG15 QUAN 15   3   Net weight of item  
133 GEWEI GEWEI MEINS UNIT 3   0   Weight Unit T006
134 VOLUM VOLUM_AP MENG15 QUAN 15   3   Volume of the item  
135 VOLEH VOLEH MEINS UNIT 3   0   Volume unit T006
136 TAXM1 TAXMT TAXKD CHAR 1   0   Tax classification material  
137 TAXM2 TAXMT TAXKD CHAR 1   0   Tax classification material  
138 TAXM3 TAXMT TAXKD CHAR 1   0   Tax classification material  
139 TAXM4 TAXMT TAXKD CHAR 1   0   Tax classification material  
140 TAXM5 TAXMT TAXKD CHAR 1   0   Tax classification material  
141 TAXM6 TAXMT TAXKD CHAR 1   0   Tax classification material  
142 TAXM7 TAXMT TAXKD CHAR 1   0   Tax classification material  
143 TAXM8 TAXMT TAXKD CHAR 1   0   Tax classification material  
144 TAXM9 TAXMT TAXKD CHAR 1   0   Tax classification material  
145 EAN11 EAN11 EAN11 CHAR 18   0   International Article Number (EAN/UPC)  
146 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center CEPC
147 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
148 MVGR1 MVGR1 MVGR1 CHAR 3   0   Material group 1 TVM1
149 MVGR2 MVGR2 MVGR2 CHAR 3   0   Material group 2 TVM2
150 MVGR3 MVGR3 MVGR3 CHAR 3   0   Material group 3 TVM3
151 MVGR4 MVGR4 MVGR4 CHAR 3   0   Material group 4 TVM4
152 MVGR5 MVGR5 MVGR5 CHAR 3   0   Material group 5 TVM5
153 FAKSP_SD FAKSP_AP FAKSP CHAR 2   0   Billing block for item TVFS
154 ANTLF_SD ANTLF ANTLF DEC 1   0   Maximum number of partial deliveries allowed per item  
155 KZTLF_SD KZTLF KZTLF CHAR 1   0   Partial delivery at item level  
156 VSTEL_SD VSTEL VSTEL CHAR 4   0   Shipping Point/Receiving Point TVST
157 ROUTE_SD ROUTE ROUTE CHAR 6   0   Route TVRO
158 SDWRS WAERK WAERS CUKY 5   0   SD document currency TCURC
159 NETWRT_SD WB2_NETWRT_SD_TC WERTV8 CURR 15   2   Net Value at Retail for Item in Document Currency  
160 WAERS_PURCH WAERS WAERS CUKY 5   0   Currency Key TCURC
161 NETWRT_MM BWERT WERT7 CURR 13   2   Net Order Value in PO Currency  
162 MWSKZ_MM MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code T007A
163 UEBTK_MM UEBTK XFELD CHAR 1   0   Indicator: Unlimited Overdelivery Allowed  
164 UNTTO_MM UNTTO PRZ21 DEC 3   1   Underdelivery Tolerance Limit  
165 BWTTY_MM BWTTY_D BWTTY CHAR 1   0   Valuation Category T149C
166 PSTYP_MM PSTYP PSTYP CHAR 1   0   Item category in purchasing document T163
167 KNTTP_MM KNTTP KNTTP CHAR 1   0   Account assignment category T163K
168 LEWED_MM LEWED DATUM DATS 8   0   Latest Possible Goods Receipt  
169 UEBTO_MM UEBTO PRZ21 DEC 3   1   Overdelivery Tolerance Limit  
170 KPEIN_SD KPEIN KPEIN DEC 5   0   Condition pricing unit  
171 KMEIN_SD KMEIN MEINS UNIT 3   0   Condition Unit T006
172 BPUMZ_SD BPUMZ UMBSZ DEC 5   0   Numerator for Conversion of Order Price Unit into Order Unit  
173 BPUMN_SD BPUMN UMBSN DEC 5   0   Denominator for Conv. of Order Price Unit into Order Unit  
174 LOEKZ WB2_DEL_IND XFELD CHAR 1   0   Deletion Indicator in Trading Contract  
175 KBELN KBELN KBELN CHAR 10   0   Number of pricing document WKBK
176 KBELP KBELP KBELP NUMC 5   0   Item Number of Pricing Document WKBP
177 NTGEW_MM ENTGE MENG13 QUAN 13   3   Net Weight  
178 BRGEW_MM BRGEW MENG13 QUAN 13   3   Gross weight  
179 VOLUM_MM VOLUM MENG13 QUAN 13   3   Volume  
180 PSTYP PSTYP PSTYP CHAR 1   0   Item category in purchasing document T163
181 CUOBJ_CH CUOBJ_CH CUOBJ NUMC 18   0   Internal object number of the batch classification  
182 NETWRT_IN_SDWRS NETWR_AP WERTV8 CURR 15   2   Net value of the order item in document currency  
183 PORTFOLIO WB2_PORTFOLIO KNUMB CHAR 10   0   Global Trade: (Internal) Portfolio Number KONHM
184 PORTFOLIO_DATE WB2_PORTFOLIO_DATE DATUM DATS 8   0   Date for Portfolio Determination  
185 TKONN_FROM TKONN_FROM TKONN CHAR 10   0   Trading Contract: Reference Document  
186 TPOSN_FROM TPOSN_FROM TPOSN NUMC 6   0   Trading Contract: Reference Item  
187 TPOSN_SUB_FROM TPOSN_SUB_FROM TPOSN NUMC 6   0   Trading Contract: Reference Subitem  
188 TCTYP_FROM TCTYP TCTYP CHAR 4   0   Trading Contract: Trading Contract Type  
189 SCENARIO WB2_BUSINESS_SCENARIO WB2_BUSINESS_SCENARIO CHAR 2   0   Business Scenario TEWSCENARIO
190 ASSOC_GROUP WB2_ASSOC_GROUP CHAR4 CHAR 4   0   Assoc. Mngt: Association Group TASSGROUP
191 COMPLETE WB2_DOCUMENT_COMPLETE WB2_DOCUMENT_COMPLETE CHAR 1   0   Trading Contract: Item Is Completed  
192 IDNLF IDNLF IDNEX CHAR 35   0   Material Number Used by Vendor  
193 NETWRT_IN_WAERS NETWRT_MM WERTV8 CURR 15   2   Global Trade: Value in PO Currency  
194 TKONN_FROM_2 TKONN_FROM TKONN CHAR 10   0   Trading Contract: Reference Document  
195 TPOSN_FROM_2 TPOSN_FROM TPOSN NUMC 6   0   Trading Contract: Reference Item  
196 TPOSN_SUB_FROM_2 TPOSN_SUB_FROM TPOSN NUMC 6   0   Trading Contract: Reference Subitem  
197 TCTYP_FROM_2 TCTYP TCTYP CHAR 4   0   Trading Contract: Trading Contract Type  
198 MATWA MATWA MATNR CHAR 18   0   Material entered MARA
199 CHANGE_INFOS CHANGE_INFOS KBFLAG RAW 2   0   Bit Encrypted Flags for WBHI  
200 KZWI1 KZWI1 WERTV7 CURR 13   2   Subtotal 1 from pricing procedure for condition  
201 KZWI2 KZWI2 WERTV7 CURR 13   2   Subtotal 2 from pricing procedure for condition  
202 KZWI3 KZWI3 WERTV7 CURR 13   2   Subtotal 3 from pricing procedure for condition  
203 KZWI4 KZWI4 WERTV7 CURR 13   2   Subtotal 4 from pricing procedure for condition  
204 KZWI5 KZWI5 WERTV7 CURR 13   2   Subtotal 5 from pricing procedure for condition  
205 KZWI6 KZWI6 WERTV7 CURR 13   2   Subtotal 6 from pricing procedure for condition  
206 KZWI1D KZWI1 WERTV7 CURR 13   2   Subtotal 1 from pricing procedure for condition  
207 KZWI2D KZWI2 WERTV7 CURR 13   2   Subtotal 2 from pricing procedure for condition  
208 KZWI3D KZWI3 WERTV7 CURR 13   2   Subtotal 3 from pricing procedure for condition  
209 KZWI4D KZWI4 WERTV7 CURR 13   2   Subtotal 4 from pricing procedure for condition  
210 KZWI5D KZWI5 WERTV7 CURR 13   2   Subtotal 5 from pricing procedure for condition  
211 KZWI6D KZWI6 WERTV7 CURR 13   2   Subtotal 6 from pricing procedure for condition  
212 UEPOS UEPOS POSNR NUMC 6   0   Higher-level item in bill of material structures  
213 WUVPRS WB2UVPRS WB2UVPRS CHAR 1   0   Global Trade: Incompleteness Price Determination  
214 KMPMG KMPMG MENGV13 QUAN 13   3   Component Quantity  
215 FMENG FMENG XFELD CHAR 1   0   Quantity is fixed  
216 STDAT STDAT DATUM DATS 8   0   Date of Bill of Material  
217 STLTY STLTY STLTY CHAR 1   0   BOM Category  
218 STLNR STNUM STNUM CHAR 8   0   Bill of Material  
219 STKEY STKEY STKEY CHAR 1   0   Origin of the bill of material  
220 KMPMG_SD KMPMG MENGV13 QUAN 13   3   Component Quantity  
221 PMATN PMATN MATNR CHAR 18   0   Pricing Reference Material MARA
222 VKAUS ABRVW ABRVW CHAR 3   0   Usage Indicator TVLV
223 POSEX POSEX POSEX CHAR 6   0   Item Number of the Underlying Purchase Order  
224 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) PRPS
225 EFFWR_SD EFFWR WERT7 CURR 13   2   Effective value of item  
226 EFFWR_MM EFFWR WERT7 CURR 13   2   Effective value of item  
227 COMMODITY WCOMMODITY WCOMMODITY CHAR 16   0   Commodity Definition TCOM
228 SKTOF_SD SKTOF XFELD CHAR 1   0   Cash discount indicator  
229 SKTOF_MM SKTOF XFELD CHAR 1   0   Cash discount indicator  
230 MWSBP_MM MWSBP WERTV7 CURR 13   2   Tax amount in document currency  
231 MWSBP_SD MWSBP WERTV7 CURR 13   2   Tax amount in document currency  
232 TXJCD_MM TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
233 CUOBJ_SD WB2B_VC_CUOBJ_SD CUOBJ NUMC 18   0   Configuration in the Trading Contract: CUOBJ SD Side  
234 CUOBJ_MM WB2B_VC_CUOBJ_MM CUOBJ NUMC 18   0   Configuration in the Trading Contract: CUOBJ MM Side  
235 ELIFN ELIFN LIFNR CHAR 10   0   Vendor's account number LFA1
236 EKORG EKORG EKORG CHAR 4   0   Purchasing organization T024E
237 EKGRP EKGRP EKGRP CHAR 3   0   Purchasing group T024
238 IHREZ IHREZ TEXT12 CHAR 12   0   Your Reference  
239 EBDAT EBDAT DATUM DATS 8   0   Purchasing Document Date  
240 EINDT WB2_DELDATE_MM DATUM DATS 8   0   Trading Contract: Delivery Date for Item Purchasing  
241 LPEIN_INT LPEIN_INT PRGRS CHAR 1   0   Date type (day, week, month, interval)  
242 TKRATE_MM TKRATE_MM KURRF DEC 9   5   GT Exchange Rate Order Currency / Local Currency  
243 KURST_MM KURST KURST CHAR 4   0   Exchange Rate Type TCURV
244 ZTERM WB2_DZTERM_MM ZTERM CHAR 4   0   Terms of Payment Key Purchasing  
245 VALDT VALDT DATUM DATS 8   0   Fixed value date  
246 TERMDES_MM TERMDES BEZEI80 CHAR 80   0   Trading Contract: Description of Terms of Payment  
247 PRSDT_MM WB2_PRSDT_MM DATUM DATS 8   0   Date for Pricing and Exchange Rate  
248 WERK_MM WERKS_D WERKS CHAR 4   0   Plant  
249 INCO1_MM WB2_INCO1_MM INCO1 CHAR 3   0   Incoterms Part 1 Purchasing TINC
250 INCO2_MM WB2_INCO2_MM INCO2 CHAR 28   0   Incoterms Part 2 Purchasing  
251 IHRAN IHRAN DATUM DATS 8   0   Quotation Submission Date  
252 EDATU_VBAK WB2_DELDATE_SD DATUM DATS 8   0   Trading Contract: Delivery Date for Item Sales  
253 PRGRS_VBAK PRGRS_VBAK PRGRS CHAR 1   0   Proposed Period for Date  
254 INCO1_SD WB2_INCO1_SD INCO1 CHAR 3   0   Incoterms Part 1 Sales TINC
255 INCO2_SD WB2_INCO2_SD INCO2 CHAR 28   0   Incoterms Part 2 Sales  
256 ZTERM_SALES WB2_DZTERM_SD ZTERM CHAR 4   0   Terms Of Payment Key Sales  
257 TERMDES_SD TERMDES BEZEI80 CHAR 80   0   Trading Contract: Description of Terms of Payment  
258 VALDTD VALDT DATUM DATS 8   0   Fixed value date  
259 ZLSCH SCHZW_BSEG ZLSCH CHAR 1   0   Payment Method T042Z
260 KDATB_MM KDATB DATUM DATS 8   0   Start of Validity Period  
261 KDATE_MM KDATE DATUM DATS 8   0   End of Validity Period  
262 AUSNR_MM AUSCH EBELN CHAR 10   0   Bid invitation number EKKO
263 ANGNR_MM ANGNR ANGNR CHAR 10   0   Quotation Number  
264 VERKF_MM EVERK TEXT30 CHAR 30   0   Responsible Salesperson at Vendor's Office  
265 TELF1_MM TELF0 TEXT16 CHAR 16   0   Vendor's Telephone Number  
266 LLIEF_MM LLIEF LIFNR CHAR 10   0   Supplying Vendor LFA1
267 UNSEZ_MM UNSEZ TEXT12 CHAR 12   0   Our Reference  
268 EVERS_MM EVERS EVERS CHAR 2   0   Shipping Instructions T027A
269 BSTAE_MM BSTAE BSTAE CHAR 4   0   Confirmation Control Key T163L
270 KZABS_MM KZABS XFELD CHAR 1   0   Order Acknowledgment Requirement  
271 LABNR LABNR TEXT20 CHAR 20   0   Order Acknowledgment Number  
272 KZAZU KZAZU_D XFELD CHAR 1   0   Order combination indicator  
273 HKLA HKLA HKLA CHAR 1   0   Trading Contract: Delivery Address Origin  
274 POSPLIT POSPLIT POSPLIT CHAR 10   0   Trading Contract: Manual Purchase Order Split  
275 KUFIX KUFIX XFELD CHAR 1   0   Indicator: Fixing of Exchange Rate  
276 BSTYP BSTYP_TC BSTYP_TC CHAR 1   0   Purchasing Document Category  
277 BSART BSART BSART CHAR 4   0   Order Type (Purchasing)  
278 VSART VSARTTR VERSART CHAR 2   0   Shipping type T173
279 BSTKD_E BSTKD_E BSTKD CHAR 35   0   Ship-to Party's Purchase Order Number  
280 POSEX_E POSEX_E POSEX CHAR 6   0   Item Number of the Underlying Purchase Order  
281 BSTKD BSTKD BSTKD CHAR 35   0   Customer purchase order number  
282 BSTDK_E BSTDK_E DATUM DATS 8   0   Ship-to party's PO date  
283 KALSM_MM KALSM_D KALSM CHAR 6   0   Procedure (Pricing, Output Control, Acct. Det., Costing,...)  
284 KNUMV_MM KNUMV KNUMV CHAR 10   0   Number of the document condition  
285 KURSK_SD KURSK KURRF DEC 9   5   Exchange Rate for Pricing and Statistics  
286 ABSSC_D ABSSCHE_CM ABSSCHE_CM CHAR 6   0   Payment Guarantee Procedure T691M
287 AKPRZ_D AKPRZ PRZ32 DEC 5   2   Depreciation percentage for financial document processing  
288 ERDAT_D ERDAT DATUM DATS 8   0   Date on which the record was created  
289 ERNAM_D ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
290 LCNUM_D LCNUM LCNUM CHAR 10   0   Financial doc. processing: Internal financial doc. number AKKP
291 PRSDT_SD_D PRSDT DATUM DATS 8   0   Date for pricing and exchange rate  
292 BSTDK_D BSTDK DATUM DATS 8   0   Customer purchase order date  
293 ERNAM_K ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
294 ERDAT_K ERDAT DATUM DATS 8   0   Date on which the record was created  
295 ERZEIT_K ERZEIT UHRZT TIMS 6   0   Time, at Which Record Was Added  
296 AENAM_K AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
297 AEDAT_K AEDAT DATUM DATS 8   0   Last Changed On  
298 AEZEIT_K AEZEIT UHRZT TIMS 6   0   Time of Change  
299 SPART_K SPART SPART CHAR 2   0   Division TVTA
300 COMPLETE_K HKCOM FLAG CHAR 1   0   Trading Contract: Document is Complete  
301 ERZET_D ERZET UZEIT TIMS 6   0   Entry time  
302 SDWRS_K WAERK WAERS CUKY 5   0   SD document currency TCURC
303 WAERS_PURCH_D WAERS WAERS CUKY 5   0   Currency Key TCURC
304 TPOSN_D TPOSN TPOSN NUMC 6   0   Trading Contract: Item Number  
305 TPOSN_SUB_D TPOSN_SUB TPOSN NUMC 6   0   Trading Contract: Sub-Item Number  
306 PS_PSP_PNR_K PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) PRPS
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 DB_WBHK_WBHI_ITM ABGRU TVAG ABGRU REF 1 CN
2 DB_WBHK_WBHI_ITM ABRVW TVLV ABRVW REF 1 CN
3 DB_WBHK_WBHI_ITM ABSSC T691M ABSSC REF 1 CN
4 DB_WBHK_WBHI_ITM ABSSC_D T691M ABSSC REF 1 CN
5 DB_WBHK_WBHI_ITM ANDTX_SD T005 LAND1 REF 1 CN
6 DB_WBHK_WBHI_ITM ASSOC_GROUP TASSGROUP ASSOC_GROUP REF 1 CN
7 DB_WBHK_WBHI_ITM AUGRU TVAU AUGRU REF 1 CN
8 DB_WBHK_WBHI_ITM AUSNR_MM EKKO EBELN REF 1 CN
9 DB_WBHK_WBHI_ITM BASIS_MEINS T006 MSEHI REF 1 CN
10 DB_WBHK_WBHI_ITM BPRME_MM T006 MSEHI REF 1 CN
11 DB_WBHK_WBHI_ITM BSARK_SD T176 BSARK REF 1 CN
12 DB_WBHK_WBHI_ITM BSTAE_MM T163L BSTAE REF 1 CN
13 DB_WBHK_WBHI_ITM BTBSTA TB2BA BTBSTA REF 1 CN
14 DB_WBHK_WBHI_ITM BWTAR T149D BWTAR KEY 1 CN
15 DB_WBHK_WBHI_ITM BWTTY_MM T149C BWTTY REF 1 CN
16 DB_WBHK_WBHI_ITM CMWAE TCURC WAERS    
17 DB_WBHK_WBHI_ITM COMMODITY TCOM COMMODITY    
18 DB_WBHK_WBHI_ITM EKGRP T024 EKGRP REF 1 CN
19 DB_WBHK_WBHI_ITM EKORG T024E EKORG REF 1 CN
20 DB_WBHK_WBHI_ITM ELIFN LFA1 LIFNR KEY 1 CN
21 DB_WBHK_WBHI_ITM EVERS_MM T027A EVERS REF 1 CN
22 DB_WBHK_WBHI_ITM FAKSK_SD TVFS FAKSP REF 1 CN
23 DB_WBHK_WBHI_ITM FAKSP_SD TVFS FAKSP REF 1 CN
24 DB_WBHK_WBHI_ITM GEWEI T006 MSEHI REF 1 CN
25 DB_WBHK_WBHI_ITM GRUPP T691B GRUPP    
26 DB_WBHK_WBHI_ITM GSBER TGSB GSBER REF 1 CN
27 DB_WBHK_WBHI_ITM HKPSTP TB2BK HKPSTP REF 1 CN
28 DB_WBHK_WBHI_ITM INCO1_MM TINC INCO1 REF 1 CN
29 DB_WBHK_WBHI_ITM INCO1_SD TINC INCO1 REF 1 CN
30 DB_WBHK_WBHI_ITM KBELN WKBK KBELN KEY 1 CN
31 DB_WBHK_WBHI_ITM KBELP WKBP KBELP KEY 1 CN
32 DB_WBHK_WBHI_ITM KKBER T014 KKBER    
33 DB_WBHK_WBHI_ITM KMEIN_SD T006 MSEHI REF 1 CN
34 DB_WBHK_WBHI_ITM KNKLI KNA1 KUNNR    
35 DB_WBHK_WBHI_ITM KNTTP_MM T163K KNTTP REF 1 CN
36 DB_WBHK_WBHI_ITM KOKRS TKA01 KOKRS REF 1 CN
37 DB_WBHK_WBHI_ITM KOSTL CSKS KOSTL REF 1 CN
38 DB_WBHK_WBHI_ITM KUNNR KNA1 KUNNR REF 1 CN
39 DB_WBHK_WBHI_ITM KURST TCURV KURST REF 1 CN
40 DB_WBHK_WBHI_ITM KURST_MM TCURV KURST REF 1 CN
41 DB_WBHK_WBHI_ITM KURST_SD TCURV KURST REF 1 CN
42 DB_WBHK_WBHI_ITM KVGR1_SD TVV1 KVGR1 REF 1 CN
43 DB_WBHK_WBHI_ITM KVGR2_SD TVV2 KVGR2 REF 1 CN
44 DB_WBHK_WBHI_ITM KVGR3_SD TVV3 KVGR3 REF 1 CN
45 DB_WBHK_WBHI_ITM KVGR4_SD TVV4 KVGR4 REF 1 CN
46 DB_WBHK_WBHI_ITM KVGR5_SD TVV5 KVGR5 REF 1 CN
47 DB_WBHK_WBHI_ITM LANDTX T005 LAND1    
48 DB_WBHK_WBHI_ITM LCNUM AKKP LCNUM REF 1 CN
49 DB_WBHK_WBHI_ITM LCNUM_D AKKP LCNUM REF    
50 DB_WBHK_WBHI_ITM LFSPG TMFS LFSPG 1 CN
51 DB_WBHK_WBHI_ITM LGORT T001L LGORT REF 1 CN
52 DB_WBHK_WBHI_ITM LIFSK_SD TVLS LIFSP REF 1 CN
53 DB_WBHK_WBHI_ITM LLIEF_MM LFA1 LIFNR REF 1 CN
54 DB_WBHK_WBHI_ITM LOGSYS TBDLS LOGSYS KEY 1 CN
55 DB_WBHK_WBHI_ITM MANDT T000 MANDT KEY 1 CN
56 DB_WBHK_WBHI_ITM MATNR MARA MATNR REF 1 CN
57 DB_WBHK_WBHI_ITM MATWA MARA MATNR    
58 DB_WBHK_WBHI_ITM MEINS T006 MSEHI REF 1 CN
59 DB_WBHK_WBHI_ITM MVGR1 TVM1 MVGR1 REF 1 CN
60 DB_WBHK_WBHI_ITM MVGR2 TVM2 MVGR2 REF 1 CN
61 DB_WBHK_WBHI_ITM MVGR3 TVM3 MVGR3 REF 1 CN
62 DB_WBHK_WBHI_ITM MVGR4 TVM4 MVGR4 REF 1 CN
63 DB_WBHK_WBHI_ITM MVGR5 TVM5 MVGR5 REF 1 CN
64 DB_WBHK_WBHI_ITM MWSKZ_MM T007A MWSKZ REF 1 CN
65 DB_WBHK_WBHI_ITM PMATN MARA MATNR REF 1 CN
66 DB_WBHK_WBHI_ITM PORTFOLIO KONHM KNUMH REF 1 CN
67 DB_WBHK_WBHI_ITM PRCTR CEPC PRCTR REF 1 CN
68 DB_WBHK_WBHI_ITM PRODH T179 PRODH REF 1 CN
69 DB_WBHK_WBHI_ITM PSTYP T163 PSTYP    
70 DB_WBHK_WBHI_ITM PSTYP_MM T163 PSTYP REF 1 CN
71 DB_WBHK_WBHI_ITM PS_PSP_PNR PRPS PSPNR REF C CN
72 DB_WBHK_WBHI_ITM PS_PSP_PNR_K PRPS PSPNR REF C CN
73 DB_WBHK_WBHI_ITM ROUTE_SD TVRO ROUTE REF 1 CN
74 DB_WBHK_WBHI_ITM SBGRP T024B SBGRP    
75 DB_WBHK_WBHI_ITM SCENARIO TEWSCENARIO SCENARIO REF 1 CN
76 DB_WBHK_WBHI_ITM SDWRS TCURC WAERS REF 1 CN
77 DB_WBHK_WBHI_ITM SDWRS_K TCURC WAERS REF 1 CN
78 DB_WBHK_WBHI_ITM SPART TSPA SPART REF 1 CN
79 DB_WBHK_WBHI_ITM SPART_K TVTA SPART REF 1 CN
80 DB_WBHK_WBHI_ITM STCEG_L T005 LAND1    
81 DB_WBHK_WBHI_ITM STCEG_L_SD T005 LAND1 REF 1 CN
82 DB_WBHK_WBHI_ITM TCTYP TB2BE TCTYP REF 1 CN
83 DB_WBHK_WBHI_ITM TEW_TYPE TEWTYPE TEW_TYPE REF 1 CN
84 DB_WBHK_WBHI_ITM TKWAERS TCURC WAERS REF 1 CN
85 DB_WBHK_WBHI_ITM TXJCD_MM TTXJ TXJCD 1 CN
86 DB_WBHK_WBHI_ITM VKAUS TVLV ABRVW REF 1 CN
87 DB_WBHK_WBHI_ITM VKBUR TVKBZ VKBUR REF C CN
88 DB_WBHK_WBHI_ITM VKGRP TVBVK VKGRP REF C CN
89 DB_WBHK_WBHI_ITM VKORG TVKO VKORG REF 1 CN
90 DB_WBHK_WBHI_ITM VOLEH T006 MSEHI REF 1 CN
91 DB_WBHK_WBHI_ITM VRKME T006 MSEHI REF 1 CN
92 DB_WBHK_WBHI_ITM VSART T173 VSART REF 1 CN
93 DB_WBHK_WBHI_ITM VSBED_SD TVSB VSBED REF 1 CN
94 DB_WBHK_WBHI_ITM VSTEL_SD TVST VSTEL REF 1 CN
95 DB_WBHK_WBHI_ITM VTWEG TVKOV VTWEG REF 1 CN
96 DB_WBHK_WBHI_ITM WAERS_MM TCURC WAERS REF 1 CN
97 DB_WBHK_WBHI_ITM WAERS_PURCH TCURC WAERS REF 1 CN
98 DB_WBHK_WBHI_ITM WAERS_PURCH_D TCURC WAERS REF 1 CN
99 DB_WBHK_WBHI_ITM WERKS T001W WERKS REF 1 CN
100 DB_WBHK_WBHI_ITM WE_KUNNR KNA1 KUNNR    
101 DB_WBHK_WBHI_ITM ZLSCH T042Z ZLSCH REF 1 CN
History
Last changed by/on SAP  20140122 
SAP Release Created in