SAP ABAP Table WISP_KEYS_SAP (Retail Planning: SAP Include for WISP_KEYS)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   LO-MAP (Application Component) Merchandise and Assortment Planning
     WIS_PLAN (Package) Retail: Planning
Basic Data
Table Category INTTAB    Structure 
Structure WISP_KEYS_SAP   Table Relationship Diagram
Short Description Retail Planning: SAP Include for WISP_KEYS    
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   Retail Planning: Special Characteristics  
2 VRSIO WISP_VRSIO WISP_VRSIO CHAR 3   0   Version Number in the Info Structure *
3 SPMON WISP_SPMON JAHRPER NUMC 7   0   7-Character Calendar Month Month/Year  
4 SPWOC WISP_SPWOC JAHRPER NUMC 7   0   7-Character Calendar Week Week/Year  
5 SPBUP WISP_SPBUP JAHRPER NUMC 7   0   7-Character Posting Period Period/Year  
6 SPBUP3 WISP_SPBUP3 POPER NUMC 3   0   3-Character Posting Period  
7 SPWOC3 WISP_SPWOC3 POPER NUMC 3   0   3-Character Calendar Week  
8 SPMON3 WISP_SPMON3 POPER NUMC 3   0   3-Character Calendar Month  
9 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
10 SPTAG WISP_SPTAG JAHRPER NUMC 7   0   7-Character Calendar Day No./Year  
11 SPTAG3 WISP_SPTAG3 POPER NUMC 3   0   3-Character Calendar Day  
12 .INCLUDE       0   0   Retail Planning: Plng Char. from Field Catalogs for App. 40  
13 AVGWS WISP_AVGWS WAERS CUKY 5   0   Currency Key for Average Retail *
14 LIFLWK MCW_LIFLWK LIFNR CHAR 10   0   RIS/Reporting Server - vendor/supplying plant *
15 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
16 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
17 AKTNR WAKTION WAKTION CHAR 10   0   Promotion WAKH
18 BSTTYP MCW_BSTTYP MCW_BSTTYP NUMC 2   0   RIS/Reporting Server - order category  
19 EINKVG MCW_EINKVG MCW_EINKVG NUMC 2   0   RIS/Reporting Server - transaction key: Purchasing  
20 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
21 GRUND MB_GRUND NUMC4 NUMC 4   0   Reason for goods movment  
22 BESTVG MCW_BESTVG MCW_BESTVG NUMC 2   0   RIS/Reporting Server - transaction key: Inventory Mgmt  
23 BSTAUS BSTAUS BSTAUS CHAR 1   0   Stock Values in the Logistics Information System  
24 BEDAT MCW_BELDAT DATUM DATS 8   0   Document date  
25 BRELEV MCW_BRELEV MCW_BRELEV CHAR 1   0   RIS/Reporting Server - stock relevance  
26 PKUNAG KUNAG KUNNR CHAR 10   0   Sold-to party *
27 AUGRU AUGRU AUGRU CHAR 3   0   Order reason (reason for the business transaction) TVAU
28 PV_GRUND PV_GRUND PV_GRUND CHAR 4   0   Reason for retail price change TWBN
29 MEINS BSTME MEINS UNIT 3   0   Order unit T006
30 VRKME VRKME MEINS UNIT 3   0   Sales unit T006
31 WMINR WMINR WMINR CHAR 10   0   Product catalog number WWMI
32 EKORG EKORG EKORG CHAR 4   0   Purchasing organization T024E
33 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
34 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
35 BZIRK BZIRK BZIRK CHAR 6   0   Sales district T171
36 EKSGB EKSGB EKSGB CHAR 4   0   Purchasing area T026
37 EKGRP EKGRP EKGRP CHAR 3   0   Purchasing group T024
38 DISPO DISPO DISPO CHAR 3   0   MRP controller T024D
39 LIFNR ELIFN LIFNR CHAR 10   0   Vendor's account number *
40 LTSNR LTSNR LTSNR CHAR 6   0   Vendor Subrange WYT1
41 BTRKZ VLFKZ VLFKZ CHAR 1   0   Plant category  
42 ABTNR ABTNR ABTNR CHAR 4   0   Department number TSAB
43 WGRU2 MCW_WGRU2 KLASSE CHAR 18   0   Material group hierarchy 2  
44 WGRU1 MCW_WGRU1 KLASSE CHAR 18   0   Material group hierarchy 1  
45 MATKL MATKL MATKL CHAR 9   0   Material Group T023
46 PRDHA PRODH_D PRODH CHAR 18   0   Product Hierarchy T179
47 SATNR SATNR MATNR CHAR 18   0   Cross-Plant Configurable Material MARA
48 MERK1 MCW_MERK1 ATWRT CHAR 30   0   Characteristic 1  
49 MERK2 MCW_MERK2 ATWRT CHAR 30   0   Characteristic 2  
50 AKTHE W_AKTHE THEMA CHAR 4   0   Promotion theme TWAT
51 AKTHE_01 W_AKTHE THEMA CHAR 4   0   Promotion theme TWAT
52 AKTYP W_AKTYP AKTTY CHAR 4   0   Promotion Category TWTY
53 PLGTP PLGTP PLGTP CHAR 2   0   Price band category TWPT
54 SAISO SAISO SAISO CHAR 4   0   Season Category T6WSP
55 SAISJ SAISJ CJAHR CHAR 4   0   Season Year  
56 BWSCL BWSCL BQSCL CHAR 1   0   Source of Supply T6WP2
57 BWVOR BWVOR BWVOR CHAR 1   0   Procurement rule T6WP1
58 SERVG W_SERVGRD W_SERVGRD CHAR 1   0   IS-R service level TWSG
59 KDGRP KDGRP KDGRP CHAR 2   0   Customer group T151
60 KUNAG KUNAG KUNNR CHAR 10   0   Sold-to party KNA1
61 ZLSCH SCHZW_BSEG ZLSCH CHAR 1   0   Payment Method T042Z
62 BKGRND MCW_BKGRND MCW_CHAR01 CHAR 1   0   Stock adjustment reason  
63 LANDLF MCW_LANDLF LAND1 CHAR 3   0   Country of vendor T005
64 WRKGR2 MCW_WRKGR2 KLASSE CHAR 18   0   Plant group hierarchy 2  
65 WRKGR1 MCW_WRKGR1 KLASSE CHAR 18   0   Plant group hierarchy 1  
66 KUNRG KUNRG KUNNR CHAR 10   0   Payer KNA1
67 HIEZU01 HIEZU01 KUNNR CHAR 10   0   Customer hierarchy Level 1 KNA1
68 HIEZU02 HIEZU02 KUNNR CHAR 10   0   Customer hierarchy Level 2 KNA1
69 HIEZU03 HIEZU03 KUNNR CHAR 10   0   Customer hierarchy Level 3 KNA1
70 HIEZU04 HIEZU04 KUNNR CHAR 10   0   Customer hierarchy Level 4 KNA1
71 HIEZU05 HIEZU05 KUNNR CHAR 10   0   Customer hierarchy Level 5 KNA1
72 HIEZU06 HIEZU06 KUNNR CHAR 10   0   Customer hierarchy Level 6 KNA1
73 HIEZU07 HIEZU07 KUNNR CHAR 10   0   Customer hierarchy Level 7 KNA1
74 HIEZU08 HIEZU08 KUNNR CHAR 10   0   Customer hierarchy Level 8 KNA1
75 HIEZU09 HIEZU09 KUNNR CHAR 10   0   Customer hierarchy Level 9 KNA1
76 HIEZU10 HIEZU10 KUNNR CHAR 10   0   Customer hierarchy Level 10 KNA1
77 MTART MTART MTART CHAR 4   0   Material type T134
78 AUART AUART AUART CHAR 4   0   Sales Document Type TVAK
79 LFART LFART LFART CHAR 4   0   Delivery Type TVLK
80 FKART FKART FKART CHAR 4   0   Billing Type TVFK
81 PLAAG PLAAG LAND1 CHAR 3   0   Country of the sold-to party *
82 PLARG PLARG LAND1 CHAR 3   0   Country of the payer *
83 RLIFN MCW_RLIFN LIFNR CHAR 10   0   Account number of regular vendor LFA1
84 LAND1 MCW_LANDRL LAND1 CHAR 3   0   Country of regular vendor T005
85 ASCAR ASORT ASORT CHAR 10   0   Assortment *
86 WMAKG WMAK WMAK CHAR 1   0   Material type ID  
87 KOLIF KOLIF LIFNR CHAR 10   0   Prior Vendor *
88 IDNLF IDNLF IDNEX CHAR 35   0   Material Number Used by Vendor  
89 EAN11 EAN11 EAN11 CHAR 18   0   International Article Number (EAN/UPC)  
90 ATINM1 MCW_ATINM1 ATINN NUMC 10   0   Internal characteristic number, characteristic 1 *
91 ATINM2 MCW_ATINM2 ATINN NUMC 10   0   Internal characteristic number, characteristic 2 *
92 ATINM3 MCW_ATINM3 ATINN NUMC 10   0   Internal characteristic number, characteristic 3 *
93 STRNR STRNR MATNR CHAR 18   0   Structured material MARA
94 RIDNLF MCW_IDNLF IDNEX CHAR 35   0   Material number at regular vendor  
95 RLTSNR MCW_LTSNR LTSNR CHAR 6   0   Vendor sub-range at regular vendor *
96 RKOLIF MCW_KOLIF LIFNR CHAR 10   0   Prior vendor of regular vendor *
97 GLVOR GLVOR CHAR4 CHAR 4   0   Business Transaction  
98 ATTYP ATTYP ATTYP CHAR 2   0   Material Category  
99 ADDIAPPL ADDI_APPL ADDI_APPL CHAR 2   0   Application for triggering follow-up actions for additionals  
100 ADDI1 MCW_ADDI1 MATNR CHAR 18   0   Additional 1 *
101 ADDI2 MCW_ADDI2 MATNR CHAR 18   0   Additional 2 *
102 ADDI3 MCW_ADDI3 MATNR CHAR 18   0   Additional 3 *
103 BONNR W_BONNR W_BONNR NUMC 15   0   Transaction number (till receipt)  
104 ERFTAG MCW_ERFTAG DATUM DATS 8   0   Current date  
105 KALWOC MCW_KALWOC NUM02 NUMC 2   0   Calendar week  
106 VKSTD W_VKSTD W_VKSTD NUMC 2   0   Hour of sale  
107 UHZEIT MCW_UHZEIT UZEIT TIMS 6   0   Time sale was entered  
108 TGZTKL MCW_TGZTKL MCW_TGZTKL CHAR 4   0   Time of day class *
109 WOCHTG MCW_WOCHTG DAYS17 NUMC 1   0   Weekday  
110 KMONAT MCW_MONAT AM_MONAT NUMC 2   0   Calendar month  
111 QUARTAL MCW_QUARTL NUM01 NUMC 1   0   Quarter  
112 JAHR MCJAHR GJAHR NUMC 4   0   Year  
113 AFLAG MCW_AFLAG MCW_AFLAG NUMC 1   0   Promotion indicator  
114 MAKTX MAKTX TEXT40 CHAR 40   0   Material description  
115 KUNNR KUND1 KUNNR CHAR 10   0   Customer No. *
116 CCNUM CCNUM CCNUM CHAR 25   0   Payment cards: Card number *
117 CCINS CCINS CCINS CHAR 4   0   Payment cards: Card type *
118 ZMTTL W_ZAHLART KSCHL CHAR 4   0   Payment method as condition *
119 KUNDK W_KUNDK W_KUNDK CHAR 1   0   Customer ID  
120 EANNR EAN11 EAN11 CHAR 18   0   International Article Number (EAN/UPC)  
121 KSKRS W_KSKRS W_KSKRS NUMC 5   0   POS controller  
122 KASNR W_KASNR KASNR NUMC 10   0   POS number  
123 KBDNR W_KBDNR PERNR NUMC 8   0   Cashier number  
124 KSCHL V_KSCHA KSCHL CHAR 4   0   Condition type, sales T685
125 UMART W_UMART CHAR1 CHAR 1   0   Sales type (sales/returns/empties)  
126 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVKGR
127 VKFNR W_VKFNR PERNR NUMC 8   0   Salesperson number  
128 CONDNR MCW_CONDNR NUMC6 NUMC 6   0   Consecutive condition number  
129 FILNR FILIALE KUNNR CHAR 10   0   Assortment owner KNA1
130 KASNAM W_KASNAM CHAR35 CHAR 35   0   Cashier name  
131 KKENN W_KKENN W_KKENN CHAR 1   0   Condition type identification  
132 KVORG POSUVORG POSUVORG CHAR 4   0   Transact. type *
133 KTONR BANKN BANKN CHAR 18   0   Bank account number  
134 BNKLZ BANKK BANKK CHAR 15   0   Bank Keys  
135 KRFNR POSKARFNR CHAR15 CHAR 15   0   Card Sequence Number  
136 FILGRP WISP_FILGRP WISP_FILGRP NUMC 2   0   Store Group TWISPC_FILGRP
137 SSTUF SSTUF SSTUF CHAR 2   0   Assortment grade TWSS
138 .INCLUDE       0   0   Retail Planning: Plng Dates from Field Catalogs for App. 40  
139 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
140 EZEIT ERZET UZEIT TIMS 6   0   Entry time  
141 AMDZT W_AMDZT DEC17_5 DEC 17   5   Logon time  
142 BUDATK W_BUDATK DATUM DATS 8   0   Posting date: cashier  
143 REGZT W_REGZT DEC17_5 DEC 17   5   Register time  
144 EZEITK W_EZEITK UZEIT TIMS 6   0   Entry time: cashier  
145 BUDATZ W_BUDATZ DATUM DATS 8   0   Posting date payment method  
146 EZEITZ W_EZEITZ UZEIT TIMS 6   0   Entry time: payment method  
147 BUDATC W_BUDATC DATUM DATS 8   0   Posting date: condition  
148 EZEITC W_EZEITC UZEIT TIMS 6   0   Entry time conditions  
149 .INCLUDE       0   0   Retail Planning: Customer-generation SAP Characteristics  
150 MANDT MANDT MANDT CLNT 3   0   Client T000
151 .INCLUDE       0   0   Retail Planning: Plng Char. from Field Catalogs for App. 01  
152 ITEMNUM ITEMNUM CHAR18 CHAR 18   0   SAP number for an item  
153 NODENUM NODENUM CHAR18 CHAR 18   0   Identification nodes for DRP network  
154 MATWA MATWA MATNR CHAR 18   0   Material entered MARA
155 PMATN PMATN MATNR CHAR 18   0   Pricing Reference Material MARA
156 CHARG CHARG_D CHARG CHAR 10   0   Batch Number MCHA
157 PRODH PRODH_D PRODH CHAR 18   0   Product Hierarchy T179
158 KDMAT MATNR_KU IDNEX CHAR 35   0   Customer Material Number  
159 GRKOR GRKOR GRKOR NUMC 3   0   Delivery group (items are delivered together)  
160 SPART SPART SPART CHAR 2   0   Division TSPA
161 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
162 LGORT LGORT_D LGORT CHAR 4   0   Storage location T001L
163 VSTEL VSTEL VSTEL CHAR 4   0   Shipping Point/Receiving Point TVST
164 ROUTE ROUTE ROUTE CHAR 6   0   Route TVRO
165 TAXM1 TAXMT TAXKD CHAR 1   0   Tax classification material *
166 TAXM2 TAXMT TAXKD CHAR 1   0   Tax classification material *
167 TAXM3 TAXMT TAXKD CHAR 1   0   Tax classification material *
168 TAXM4 TAXMT TAXKD CHAR 1   0   Tax classification material *
169 TAXM5 TAXMT TAXKD CHAR 1   0   Tax classification material *
170 TAXM6 TAXMT TAXKD CHAR 1   0   Tax classification material *
171 TAXM7 TAXMT TAXKD CHAR 1   0   Tax classification material *
172 TAXM8 TAXMT TAXKD CHAR 1   0   Tax classification material *
173 TAXM9 TAXMT TAXKD CHAR 1   0   Tax classification material *
174 KONDM KONDM KONDM CHAR 2   0   Material Pricing Group T178
175 KTGRM KTGRM KTGRM CHAR 2   0   Account assignment group for this material TVKM
176 BWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type T149D
177 MVGR1 MVGR1 MVGR1 CHAR 3   0   Material group 1 TVM1
178 MVGR2 MVGR2 MVGR2 CHAR 3   0   Material group 2 TVM2
179 MVGR3 MVGR3 MVGR3 CHAR 3   0   Material group 3 TVM3
180 MVGR4 MVGR4 MVGR4 CHAR 3   0   Material group 4 TVM4
181 MVGR5 MVGR5 MVGR5 CHAR 3   0   Material group 5 TVM5
182 BDART BDART BDART CHAR 2   0   Requirement type  
183 PLART PLART PLART CHAR 1   0   Planning type *
184 KONOB KONOB KONOB CHAR 18   0   Product allocation object *
185 LGPLA LGPLA LGPLA CHAR 10   0   Storage Bin LAGP
186 LGPBE LGPBE CHAR10 CHAR 10   0   Storage Bin  
187 VPMAT VPMAT MATNR CHAR 18   0   Planning material MARA
188 VPWRK VPWRK WERKS CHAR 4   0   Planning plant T001W
189 VKGRU VKGRU RMA_VORGA CHAR 3   0   Repair processing: Classify items TVRMAVK
190 VKAUS ABRVW ABRVW CHAR 3   0   Usage Indicator TVLV
191 STKEY STKEY STKEY CHAR 1   0   Origin of the bill of material  
192 STLNR STNUM STNUM CHAR 8   0   Bill of Material  
193 AWAHR AWAHR AWAHR NUMC 3   0   Order probability of the item  
194 GRSTR GRSTR GRSTR NUMC 3   0   Group definition for structure data  
195 KNUMH KNUMH KNUMB CHAR 10   0   Condition record number  
196 KOPOS KOPOS NUM02 NUMC 2   0   Sequential number of the condition  
197 VBTYP VBTYP VBTYP CHAR 1   0   SD document category  
198 STWAE STWAE WAERS CUKY 5   0   Statistics currency TCURC
199 HWAER HWAER WAERS CUKY 5   0   Local Currency *
200 ZIEME DZIEME MEINS UNIT 3   0   Target quantity UoM T006
201 GEWEI GEWEI MEINS UNIT 3   0   Weight Unit T006
202 VOLEH VOLEH MEINS UNIT 3   0   Volume unit T006
203 KMEIN KMEIN MEINS UNIT 3   0   Condition Unit T006
204 WAERK WAERK WAERS CUKY 5   0   SD document currency TCURC
205 PRBME PRBME MEINS UNIT 3   0   Base unit of measure for product group T006
206 APWAERK WAERK WAERS CUKY 5   0   SD document currency *
207 GSKST GSKST GSBER CHAR 4   0   Business area from cost center TGSB
208 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
209 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
210 RKFKF RKFKF RKFKF CHAR 1   0   Form of Billing for CO/PPC Orders  
211 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
212 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
213 KTGRD KTGRD KTGRD CHAR 2   0   Account assignment group for this customer TVKT
214 MABER MABER MABER CHAR 2   0   Dunning Area T047M
215 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
216 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
217 BNAME BNAME_V NAME CHAR 35   0   Name of orderer  
218 KVGR1 KVGR1 KVGR1 CHAR 3   0   Customer group 1 TVV1
219 KVGR2 KVGR2 KVGR2 CHAR 3   0   Customer group 2 TVV2
220 KVGR3 KVGR3 KVGR3 CHAR 3   0   Customer group 3 TVV3
221 KVGR4 KVGR4 KVGR4 CHAR 3   0   Customer group 4 TVV4
222 KVGR5 KVGR5 KVGR5 CHAR 3   0   Customer group 5 TVV5
223 PKUNWE KUNWE KUNNR CHAR 10   0   Ship-to party *
224 PKUNRE KUNRE KUNNR CHAR 10   0   Bill-to party *
225 PKUNRG KUNRG KUNNR CHAR 10   0   Payer *
226 PSPDNR SPDNR LIFNR CHAR 10   0   Carrier *
227 PABLA PABLA TEXT25 CHAR 25   0   Unloading point of the ship-to party  
228 SBGRP SBGRP_CM SBGRP_CM CHAR 3   0   Credit Representative Group for Credit Management T024B
229 PLARE PLARE LAND1 CHAR 3   0   Country of the bill-to party *
230 PLASP PLASP LAND1 CHAR 3   0   Country of the carrier *
231 PLAVE PLAVE LAND1 CHAR 3   0   Country of the representative *
232 PLAWE PLAWE LAND1 CHAR 3   0   Country of ship-to party *
233 PZONE PZONE ZONE CHAR 10   0   Transportation zone of the ship-to party *
234 PVRTNR VRTNR PERNR NUMC 8   0   Sales employee  
235 ABLAD ABLAD TEXT25 CHAR 25   0   Unloading Point  
236 VBELN VBELN_VA VBELN CHAR 10   0   Sales Document VBUK
237 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
238 TRVOG TRVOG TRVOG CHAR 1   0   Transaction group  
239 VBKLA VBKLA CHAR9 CHAR 9   0   unused (sales doocument class)  
240 VBKLT VBKLT VBKLT CHAR 1   0   SD document indicator  
241 BSTNK BSTNK BSTNK CHAR 20   0   Customer purchase order number  
242 BSARK BSARK BSARK CHAR 4   0   Customer Order Type T176
243 BSTZD BSTZD BSTZD CHAR 4   0   Customer purchase order number supplement  
244 PSTYV PSTYV PSTYV CHAR 4   0   Sales document item category TVPT
245 POSAR POSAR POSAR CHAR 1   0   Item type  
246 LFREL LFREL_AP XFELD CHAR 1   0   Item is relevant for delivery  
247 FKREL FKREL FKREL CHAR 1   0   Relevant for Billing  
248 ETENR ETENR ETENR NUMC 4   0   Schedule line *
249 ETTYP ETTYP ETTYP CHAR 2   0   Item Cat. in Schedule Line TVEP
250 BANFN BANFN BANFN CHAR 10   0   Purchase requisition number  
251 BSART BSART BSART CHAR 4   0   Order Type (Purchasing) T161
252 BSTYP BSTYP BSTYP CHAR 1   0   Purchasing document category  
253 ABART ABART ABART CHAR 1   0   Release type  
254 BWART BWART BWART CHAR 3   0   Movement type (inventory management) T156
255 PLTYP PLTYP PLTYP CHAR 2   0   Price list type T189
256 POSNR POSNR_VA POSNR NUMC 6   0   Sales Document Item VBUP
257 FKTYP FKTYP FKTYP CHAR 1   0   Billing Category  
258 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
259 INCO1 INCO1 INCO1 CHAR 3   0   Incoterms (part 1) TINC
260 INCO2 INCO2 INCO2 CHAR 28   0   Incoterms (part 2)  
261 VGTYP VBTYP_V VBTYP CHAR 1   0   Document category of preceding SD document  
262 BONUS BONUS BONUS CHAR 2   0   Volume rebate group TVBO
263 PROVG PROVG PROVG CHAR 2   0   Commission group TVPR
264 ROUTA ROUTE ROUTE CHAR 6   0   Route TVRO
265 KNUMV KNUMV KNUMV CHAR 10   0   Number of the document condition  
266 VERUR VERUR_VL CHAR35 CHAR 35   0   Distribution delivery  
267 EXNUM EXNUM EXNUM CHAR 10   0   Number of foreign trade data in MM and SD documents EIKP
268 LGNUM LGNUM LGNUM CHAR 3   0   Warehouse Number / Warehouse Complex T300
269 KUNIV KUNIV KUNNR CHAR 10   0   Customer number for intercompany billing KNA1
270 POSNV POSNV POSNR NUMC 6   0   Originating item VBUP
271 VBELV VBELV VBELN CHAR 10   0   Originating document VBUK
272 VGPOS VGPOS POSNR NUMC 6   0   Item number of the reference item VBUP
273 UEPOS UEPOS POSNR NUMC 6   0   Higher-level item in bill of material structures VBUP
274 PAOBJNR RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
275 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
276 APABSTA ABSTA_VB STATV CHAR 1   0   Rejection status for SD item  
277 APLFSTA LFSTA STATV CHAR 1   0   Delivery status  
278 APLFGSA LFGSA STATV CHAR 1   0   Overall Delivery Status of the Item  
279 VKBUR VKBUR VKBUR CHAR 4   0   Sales office *
280 KTAAR KTAAR KTAAR CHAR 4   0   Sales Activity Type for Sales Support *
281 KTAST KTAST KTAST CHAR 1   0   Status of sales activity *
282 KTAGR KTAGR KTAGR CHAR 3   0   Reason for sales activity *
283 KTAER KTAER KTAER CHAR 3   0   Outcome of sales activities *
284 KTAEB KTAEB KTAEB CHAR 3   0   Analysis of sales activity outcome *
285 PARNR_AP PARNR PARNR NUMC 10   0   Number of contact person  
286 DIRECTION ACT_DIRECTION ACT_DIRECTION CHAR 1   0   Direction of sales activity: Inbound / outbound  
287 KTOKD KTOKD KTOKD CHAR 4   0   Customer Account Group *
288 NIELS NIELS NIELS CHAR 2   0   Nielsen ID *
289 BRSCH BRSCH BRSCH CHAR 4   0   Industry key *
290 BRAN1 BRAN1_D BRACO CHAR 10   0   Industry code 1 *
291 BRAN2 BRAN2 BRACO CHAR 10   0   Industry code 2 *
292 BRAN3 BRAN3 BRACO CHAR 10   0   Industry code 3 *
293 KUKLA KUKLA KUKLA CHAR 2   0   Customer classification *
294 PAFKT PAFKT PAFKT CHAR 2   0   Contact person function *
295 PSTL_LIS PSTL_LIS PSTLZ CHAR 10   0   Postal code of city or PO box  
296 REGIO_LIS REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
297 DEAR1 DEAR1 XFELD CHAR 1   0   Indicator: Competitor  
298 KATR1 KATR1 ATTR1 CHAR 2   0   Attribute 1 *
299 PARH1 PAAT1 PARHO CHAR 2   0   Contact Partner: Attribute 1 *
300 PARH2 PAAT2 PAAT2 CHAR 2   0   Contact person: Attribute 2 *
301 KATR2 KATR2 ATTR2 CHAR 2   0   Attribute 2 *
302 VERSION CASVERSION NUM04 NUMC 4   0   Version number  
303 PRODH1 PRODH1 PRODH1 CHAR 5   0   Standard data element PRODH1  
304 PRODH2 PRODH2 PRODH2 CHAR 5   0   Standard data element PRODH2  
305 PRODH3 PRODH3 PRODH3 CHAR 8   0   Standard data element PRODH3  
306 WETTB WETTB KUNNR CHAR 10   0   Competitor *
307 PMNUX PMNUX MATNR CHAR 18   0   Product group/material in planning hierarchy MARA
308 WENUX WENUX WERKS CHAR 4   0   Plant T001W
309 RFGSK RFGSK STATV CHAR 1   0   Total reference status of all items  
310 BESTK BESTK STATV CHAR 1   0   Confirmation status  
311 LFSTK LFSTK STATV CHAR 1   0   Delivery status  
312 LFGSK LKGSK STATV CHAR 1   0   Overall delivery status for all items  
313 WBSTK WBSTK STATV CHAR 1   0   Total goods movement status  
314 FKSTK FKSTK STATV CHAR 1   0   Billing status  
315 FKSAK FKSAK STATV CHAR 1   0   Billing status (order-related billing document)  
316 BUCHK BUCHK STATV CHAR 1   0   Posting Status of Billing Document  
317 ABSTK ABSTK STATV CHAR 1   0   Overall rejection status of all sales document items  
318 GBSTK GBSTK STATV CHAR 1   0   Overall processing status of document  
319 KOSTK KOSTK STATV CHAR 1   0   Overall picking / putaway status  
320 LVSTK LVSTK STATV CHAR 1   0   Overall status of warehouse management activities  
321 UVALS UVALL_SU STATV CHAR 1   0   Total incompletion status of all items in general  
322 UVVLS UVVLS_SU STATV CHAR 1   0   Total incompletion status of all items: Delivery  
323 UVFAS UVFAK_SU STATV CHAR 1   0   Total incompletion status of all items: Billing  
324 UVALL UVALL_UK STATV CHAR 1   0   General incompletion status of the header  
325 UVVLK UVVLK_UK STATV CHAR 1   0   Header incompletion status concerning delivery  
326 UVFAK UVFAK_UK STATV CHAR 1   0   Header incompletion status with respect to billing  
327 UVPRS UVPRS_UK STATV CHAR 1   0   Document is incomplete with respect to pricing  
328 VBOBJ VBOBJ VBOBJ CHAR 1   0   SD document object  
329 RFSTA RFSTA STATV CHAR 1   0   Reference status  
330 RFGSA RFGSA STATV CHAR 1   0   Overall Status of Reference  
331 BESTA BESTA STATV CHAR 1   0   Confirmation status of the document item  
332 LFSTA LFSTA STATV CHAR 1   0   Delivery status  
333 LFGSA LFGSA STATV CHAR 1   0   Overall Delivery Status of the Item  
334 WBSTA WBSTA STATV CHAR 1   0   Goods movement status  
335 FKSTA FKSTA STATV CHAR 1   0   Billing status of delivery-related billing documents  
336 FKSAA FKSAA STATV CHAR 1   0   Billing Status for Order-Related Billing Documents  
337 ABSTA ABSTA_VB STATV CHAR 1   0   Rejection status for SD item  
338 GBSTA GBSTA STATV CHAR 1   0   Overall Processing Status of the SD Document Item  
339 KOSTA KOSTA STATV CHAR 1   0   Picking Status/Putaway Status  
340 LVSTA LVSTA STATV CHAR 1   0   Status of warehouse management activities  
341 LIFSK LIFSK LIFSP CHAR 2   0   Delivery block (document header) TVLS
342 FAKSK FAKSK FAKSP CHAR 2   0   Billing block in SD document TVFS
343 AUTLF AUTLF XFELD CHAR 1   0   Complete delivery defined for each sales order?  
344 VSBED VSBED VSBED CHAR 2   0   Shipping conditions TVSB
345 ABGRU ABGRU_VA ABGRU_VA CHAR 2   0   Reason for rejection of quotations and sales orders TVAG
346 FMENG FMENG XFELD CHAR 1   0   Quantity is fixed  
347 UEBTK UEBTK_V XFELD CHAR 1   0   Unlimited overdelivery allowed  
348 FAKSP FAKSP_AP FAKSP CHAR 2   0   Billing block for item TVFS
349 ATPKZ ATPKZ ATPKZ CHAR 1   0   Replacement part  
350 KZTLF KZTLF KZTLF CHAR 1   0   Partial delivery at item level  
351 CHSPL CHSPL XFELD CHAR 1   0   Batch split allowed  
352 VOREF VOREF XFELD CHAR 1   0   Complete reference indicator  
353 UPFLU UPFLV UPFLV CHAR 1   0   Update indicator for sales document document flow  
354 ERLRE ERLRE ERLRE CHAR 1   0   Completion rule for quotation / contract  
355 LPRIO LPRIO LPRIO NUMC 2   0   Delivery priority TPRIO
356 VGREF VGREF XFELD CHAR 1   0   Preceding document has resulted from reference  
357 SKTOF SKTOF XFELD CHAR 1   0   Cash discount indicator  
358 BWTEX BWTEX XFELD CHAR 1   0   Indicator: Separate valuation  
359 XCHPF XCHPF XFELD CHAR 1   0   Batch management requirement indicator  
360 FIXMG FIXMG XFELD CHAR 1   0   Delivery date and quantity fixed  
361 SUGRD SUGRD SUGRD CHAR 4   0   Reason for material substitution TVSU
362 WEPOS WEPOS_A ECOST CHAR 1   0   Confirmation status of schedule line (incl.ALE)  
363 REPOS REPOS XFELD CHAR 1   0   Invoice receipt indicator  
364 LIFSP LIFSP_EP LIFSP CHAR 2   0   Schedule line blocked for delivery TVLS
365 VERFP VERFP_MAS XFELD CHAR 1   0   Availability confirmed automatically  
366 KZAZU KZAZU_D XFELD CHAR 1   0   Order combination indicator  
367 MRNKZ MRNKZ XFELD CHAR 1   0   Manual invoice maintenance  
368 XCPDK XCPDK XFELD CHAR 1   0   Indicator: Is the account a one-time account?  
369 RFBSK RFBSK RFBSK CHAR 1   0   Status for transfer to accounting  
370 CPKUR CPKUR CPKUR CHAR 1   0   ID:Exchange rate setting (no new rate determ.in bill.doc.)  
371 TAXK1 TAXK1 TAXKD CHAR 1   0   Tax classification 1 for customer *
372 TAXK2 TAXK2 TAXKD CHAR 1   0   Tax classification 2 for customer *
373 TAXK3 TAXK3 TAXKD CHAR 1   0   Tax classification 3 for customer *
374 TAXK4 TAXK4 TAXKD CHAR 1   0   Tax classification 4 for customer *
375 TAXK5 TAXK5 TAXKD CHAR 1   0   Tax classification 5 for customer *
376 TAXK6 TAXK6 TAXKD CHAR 1   0   Tax classification 6 for customer *
377 TAXK7 TAXK7 TAXKD CHAR 1   0   Tax classification 7 for customer *
378 TAXK8 TAXK8 TAXKD CHAR 1   0   Tax classification 8 for customer *
379 TAXK9 TAXK9 TAXKD CHAR 1   0   Tax classification 9 for customer *
380 AUREF AUREF XFELD CHAR 1   0   Sales document was created from reference  
381 EXPKZ EXPKZ EXPKZ CHAR 1   0   Export indicator  
382 KNFAK KNFAK WFCID CHAR 2   0   Customer factory calendar TFACD
383 TPQUA TPQUA TPQUA CHAR 1   0   not currently in use  
384 TPGRP TPGRP TPGRP CHAR 2   0   not currently in use  
385 GRULG GRULG GRULG CHAR 4   0   Weight group for delivery (To group) TVLG
386 FKARV FKARV FKART CHAR 4   0   Proposed billing type for a delivery-related billing doc. TVFK
387 KALSM KALSM_D KALSM CHAR 6   0   Procedure (Pricing, Output Control, Acct. Det., Costing,...) T683
388 ZUKRL DZUKRL CHAR40 CHAR 40   0   Combination criteria for delivery  
389 COMMN COMMN COMMN CHAR 5   0   Communication number for Q-API interface TQCOM
390 FKAIV FKAIV FKART CHAR 4   0   Billing type for intercompany billing TVFK
391 LLAND LLAND LAND1 CHAR 3   0   Destination Country *
392 KOMKZ KOMKZ KOMKZ CHAR 1   0   Indicator for picking control  
393 LGTYP LGTYP LGTYP CHAR 3   0   Storage Type T301
394 BWLVS BWLVS BWLVS NUMC 3   0   Movement Type for Warehouse Management T333
395 KZDLG LVS_KZDLG XFELD CHAR 1   0   Indicator: dynamic storage bin in warehouse management  
396 XCHAR XCHAR XFELD CHAR 1   0   Batch management indicator (internal)  
397 SUMBD SUMBD SUMBD CHAR 1   0   Summing up of requirements  
398 MTVFP MTVFP MTVFP CHAR 2   0   Checking Group for Availability Check TMVF
399 SOBKZ SOBKZ SOBKZ CHAR 1   0   Special Stock Indicator T148
400 VPZUO VPZUO ZUVKZ CHAR 1   0   Allocation Indicator  
401 AKVBTYP VBTYP VBTYP CHAR 1   0   SD document category  
402 KNTTP KNTTP KNTTP CHAR 1   0   Account assignment category T163K
403 KZVBR KZVBR KZVBR CHAR 1   0   Consumption posting  
404 PCKPF PCKPF PCKPF CHAR 1   0   Packing control  
405 BEDAR_LF BEDAR BEDAR CHAR 3   0   Requirements class T459K
406 ATINN ATINN ATINN NUMC 10   0   Internal characteristic *
407 KLART KLASSENART KLASSENART CHAR 3   0   Class Type *
408 ATWRT ATWRT ATWRT CHAR 30   0   Characteristic Value  
409 MCUPD MCUPD X CHAR 1   0   Indicator whether statistical record was updated  
410 CUOBJ CUOBJ_VA CUOBJ NUMC 18   0   Configuration  
411 LNPOS CHCOMBKEY NUM05 NUMC 5   0   Combination value key  
412 CLINT CHKEYGRP VTINT NUMC 10   0   Characteristics combination  
413 ALAND ALAND LAND1 CHAR 3   0   Departure country (country from which the goods are sent) T005
414 WKREG WKREG REGIO CHAR 3   0   Region in which plant is located T005S
415 WKCOU WKCOU CHAR3 CHAR 3   0   County in which plant is located  
416 WKCTY WKCTY CHAR4 CHAR 4   0   City in which plant is located  
417 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
418 COUNC COUNC COUNC CHAR 3   0   County Code T005E
419 CITYC CITYC CITYC CHAR 4   0   City Code T005G
420 BEROT BEROT BEROT CHAR 20   0   Picked items location  
421 LSTEL LSTEL LSTEL CHAR 2   0   Loading Point TVLA
422 TRAGR TRAGR TRAGR CHAR 4   0   Transportation Group TTGR
423 VKOIV VKOIV VKORG CHAR 4   0   Sales organization for intercompany billing TVKO
424 VTWIV VTWIV VTWEG CHAR 2   0   Distribution channel for intercompany billing TVTW
425 SPAIV SPAIV SPART CHAR 2   0   Division for intercompany billing TSPA
426 .INCLUDE       0   0   Retail Planning: Plng Dates from Field Catalogs for App. 01  
427 BNDDT BNDDT DATUM DATS 8   0   Date until which bid/quotation is binding (valid-to date)  
428 ANGDT ANGDT_V DATUM DATS 8   0   Quotation/Inquiry is valid from  
429 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
430 AUDAT AUDAT DATUM DATS 8   0   Document Date (Date Received/Sent)  
431 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
432 GWLDT GWLDT DATUM DATS 8   0   Guarantee date  
433 GUEBG GUEBG DATUM DATS 8   0   Valid-from date (outline agreements, product proposals)  
434 GUEEN GUEEN DATUM DATS 8   0   Valid-to date (outline agreements, product proposals)  
435 MAHDT MAHDT DATUM DATS 8   0   Last Delivery Reminder Notice  
436 ERZET ERZET UZEIT TIMS 6   0   Entry time  
437 VDATU EDATU_VBAK DATUM DATS 8   0   Requested delivery date  
438 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
439 ABDAT ABDAT DATUM DATS 8   0   Reconciliation date for agreed cumulative quantity  
440 STDAT STDAT DATUM DATS 8   0   Date of Bill of Material  
441 FKDAT_RL FKDAT_RL DATUM DATS 8   0   Billing date for the invoice list  
442 FKDAT FKDAT DATUM DATS 8   0   Billing date for billing index and printout  
443 VALDT VALDT DATUM DATS 8   0   Fixed value date  
444 FBUDA FBUDA DATUM DATS 8   0   Date When Services Rendered  
445 PRSDT PRSDT DATUM DATS 8   0   Date for pricing and exchange rate  
446 WADAT WADAK DATUM DATS 8   0   Planned goods movement date  
447 FKDIV FKDIV DATUM DATS 8   0   Billing date for intercompany billing  
448 KODAT KODAT DATUM DATS 8   0   Picking Date  
449 LDDAT LDDAT DATUM DATS 8   0   Loading Date  
450 LFDAT LFDAT_V DATUM DATS 8   0   Delivery Date  
451 TDDAT TDDAT_D DATUM DATS 8   0   Transportation Planning Date  
452 APERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
453 MBDAT MBDAT DATUM DATS 8   0   Material Staging/Availability Date  
454 LFUHR LFUHR LFUHR TIMS 6   0   Time of delivery  
455 KDATU KDATU DATUM DATS 8   0   Condition pricing date  
456 BDDAT BDDAT DATUM DATS 8   0   Requirement date (deadline for procurement)  
457 LRGDT LRGDT DATUM DATS 8   0   Return date for returnable packaging  
458 EDATU EDATU DATUM DATS 8   0   Schedule line date  
459 RSDAT RSDAT DATUM DATS 8   0   Earliest possible reservation date  
460 .INCLUDE       0   0   Retail Planning: Plng Char. from Field Catalogs for App. 02  
461 BOLIF BOGEW LIFNR CHAR 10   0   Condition granter LFA1
462 KNUMA KNUMA KNUMA CHAR 10   0   Agreement (various conditions grouped together) KONA
463 DATBI MC_DATBI DATUM DATS 8   0   End date of validity period of an arrangement  
464 WAERS BSTWA WAERS CUKY 5   0   Purchase order currency TCURC
465 LMEIN LAGME MEINS UNIT 3   0   Base Unit of Measure T006
466 LNRZB W_LIFZE LIFNR CHAR 10   0   Agency business: Payee LFA1
467 MWSKZ MWSKZ_LF MWSKZ CHAR 2   0   Agency business: Tax code (input tax) T007A
468 LANDL LANDL LAND1 CHAR 3   0   Supplying Country T005
469 LFTYP WFTYP WFTYP CHAR 2   0   Agency business: Billing category  
470 NPLNR NPLNR AUFNR CHAR 12   0   Network Number for Account Assignment AUFK
471 SAKTO SAKNR SAKNR CHAR 10   0   G/L Account Number SKA1
472 KAPPL KAPPL KAPPL CHAR 2   0   Application *
473 DATUM DATUM DATUM DATS 8   0   Date  
474 KOTABNR KOTABNR KOTABNR NUMC 3   0   Condition table *
475 VARKEY VAKEY VAKEY CHAR 100   0   Variable key 100 bytes  
476 KVEWE KVEWE KVEWE CHAR 1   0   Usage of the Condition Table *
477 BLTYP BLTYP BLTYP CHAR 2   0   Document category for document index updates  
478 LIFEX LIFEX TEXT35 CHAR 35   0   External Identification of Delivery Note  
479 LGTOR LGTOR LGTOR CHAR 3   0   Door for Warehouse Number T30B
480 TRATY TRATY TRATY CHAR 4   0   Means-of-Transport Type TVTY
481 TRAID TRAID TRAID CHAR 20   0   Means-of-transport ID  
482 BOLNR BOLNR CHAR35 CHAR 35   0   Bill of lading  
483 MFRGR MFRGR MFRGR CHAR 8   0   Material freight group TMFG
484 VGBEL EBELN EBELN CHAR 10   0   Purchasing Document Number EKKO
485 KONZS KONZS KONZS CHAR 10   0   Group key  
486 LLIEF LLIEF LIFNR CHAR 10   0   Supplying Vendor LFA1
487 RESWK RESWK WERKS CHAR 4   0   Supplying (issuing) plant in case of stock transport order T001W
488 LIFRE LIFRE LIFNR CHAR 10   0   Different Invoicing Party LFA1
489 INFNR INFNR INFNR CHAR 10   0   Number of purchasing info record EINA
490 KUNRE KUNRE KUNNR CHAR 10   0   Bill-to party KNA1
491 MWSK2 MWSKZ_RB MWSKZ CHAR 2   0   Agency business: Tax code (output tax) T007A
492 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number EKKO
493 SUBMI SUBMI CHAR10 CHAR 10   0   Collective Number  
494 ESOKZ ESOKZ ESOKZ CHAR 1   0   Purchasing info record category  
495 PSTYP PSTYP PSTYP CHAR 1   0   Item category in purchasing document T163
496 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document EKPO
497 SRVPOS ASNUM ASNUM CHAR 18   0   Activity Number *
498 LBNUM LBNUM CHAR3 CHAR 3   0   Short Description of Service Type  
499 AUSGB AUSGB NUMC4 NUMC 4   0   Edition of Service Type  
500 STLVPOS STLVPOS CHAR18 CHAR 18   0   Standard Service Catalog Item  
501 ASTYP ASTYP ASTYP CHAR 4   0   Service Category *
502 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
503 .INCLUDE       0   0   Retail Planning: Plng Char. from Field Catalogs for App. 03  
504 LGBER MCWM_LGBER LGBER CHAR 3   0   Storage section for stock removal, placement, return T302
505 ALTYP MCWM_ALTYP LGTYP CHAR 3   0   Stock removal storage type T301
506 ALBER MCWM_ALBER LGBER CHAR 3   0   Stock removal storage section T302
507 ELTYP MCWM_ELTYP LGTYP CHAR 3   0   Stock placement storage type T301
508 ELBER MCWM_ELBER LGBER CHAR 3   0   Stock placement storage section T302
509 LETYP LVS_LETYP LVS_LETYP CHAR 3   0   Storage Unit Type T307
510 MG_LAGKL LVS_LAGKL MGEF_LAGKL CHAR 5   0   Storage class T646L
511 MBLNR MBLNR BELNR CHAR 10   0   Number of Material Document  
512 DISMM DISMM DISMM CHAR 2   0   MRP Type T438A
513 BKLAS BKLAS BKLAS CHAR 4   0   Valuation Class T025
514 USNAZ USNAZ USNAM CHAR 12   0   Counted By  
515 USNAM USNAA USNAM CHAR 12   0   Changed by  
516 PLPLA PLPLA PLPLA CHAR 10   0   Distribution of Differences  
517 USNAD USNAD USNAM CHAR 12   0   Adjustment posting made by  
518 XZAEL XZAEL XFELD CHAR 1   0   Item has been counted  
519 XLOEK I_XLOEK XFELD CHAR 1   0   Item is Deleted (Physical Inventory)  
520 ZEILE MBLPO MBLPO NUMC 4   0   Item in material document  
521 ZEILI DZEILE ZEILE NUMC 3   0   Line Number  
522 XNULL XNULL XFELD CHAR 1   0   Zero count  
523 XNZAE XNZAE XFELD CHAR 1   0   Item will be recounted  
524 XDIFF XDIFF XFELD CHAR 1   0   Difference posted  
525 KDEIN KDEIN NUM04 NUMC 4   0   Delivery schedule for sales order  
526 BSTAR I_BSTAR BSTAR CHAR 1   0   Stock Type (Physical Inventory T064B
527 INVNU INVNU1 XBLNR1 CHAR 16   0   Physical inventory number  
528 IVSTAT IVSTATUS IVSTATUS NUMC 2   0   Statistical status of physical inventory  
529 .INCLUDE       0   0   Retail Planning: Plng Dates from Field Catalogs for App. 03  
530 SYDAT SYDATUM SYDATS DATS 8   0   System Date  
531 BLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
532 GIDAT GIDAT DATUM DATS 8   0   Planned date of inventory count  
533 ZLDAT DZLDAT DATUM DATS 8   0   Date of last count  
534 TB_BDATU LTBK_BDATU DATUM DATS 8   0   Creation Date of Transfer Request  
535 BDATU LTAK_BDATU DATUM DATS 8   0   Creation Date of Transfer Order  
536 BZEIT LTAK_BZEIT UZEIT TIMS 6   0   Creation time of transfer order  
537 QDATU LTAP_QDATU DATUM DATS 8   0   Date of confirmation  
538 QZEIT LTAP_QZEIT UZEIT TIMS 6   0   Time of confirmation  
539 .INCLUDE       0   0    
540 .INCLUDE       0   0   Characteristics for Category Management  
541 CDT1 CM_CDT1 CM_CDT CHAR 18   0   Category CMMD_CDT1
542 CDT2 CM_CDT2 CM_CDT CHAR 18   0   Subcategory CMMD_CDT2
543 CDT3 CM_CDT3 CM_CDT CHAR 18   0   Segment CMMD_CDT3
544 CDT4 CM_CDT4 CM_CDT CHAR 18   0   Subsegment CMMD_CDT4
545 CDT5 CM_CDT5 CM_CDT CHAR 18   0   Sub-Subsegment CMMD_CDT5
546 CDT6 CM_CDT6 CM_CDT CHAR 18   0   Product Group CMMD_CDT6
547 CDT7 CM_CDT7 CM_CDT CHAR 18   0   Brand CMMD_CDT7
548 CM_LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
549 HIER_ID HIER_CNT HIERCNT CHAR 2   0   Hierarchy ID MATGRP_HIER
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 WISP_KEYS_SAP ABGRU TVAG ABGRU    
2 WISP_KEYS_SAP ABTNR TSAB ABTNR    
3 WISP_KEYS_SAP AKTHE TWAT AKTHE    
4 WISP_KEYS_SAP AKTHE_01 TWAT AKTHE    
5 WISP_KEYS_SAP AKTNR WAKH AKTNR    
6 WISP_KEYS_SAP AKTYP TWTY AKTYP    
7 WISP_KEYS_SAP ALAND T005 LAND1    
8 WISP_KEYS_SAP ALBER T302 LGBER    
9 WISP_KEYS_SAP ALTYP T301 LGTYP    
10 WISP_KEYS_SAP AUART TVAK AUART    
11 WISP_KEYS_SAP AUFNR AUFK AUFNR    
12 WISP_KEYS_SAP AUGRU TVAU AUGRU    
13 WISP_KEYS_SAP BEDAR_LF T459K BEDAR    
14 WISP_KEYS_SAP BKLAS T025 BKLAS    
15 WISP_KEYS_SAP BOLIF LFA1 LIFNR    
16 WISP_KEYS_SAP BONUS TVBO BONUS    
17 WISP_KEYS_SAP BSARK T176 BSARK    
18 WISP_KEYS_SAP BSART T161 BSART    
19 WISP_KEYS_SAP BSTAR T064B BSTAR REF C CN
20 WISP_KEYS_SAP BWART T156 BWART    
21 WISP_KEYS_SAP BWLVS T333 BWLVS    
22 WISP_KEYS_SAP BWSCL T6WP2 BWSCL    
23 WISP_KEYS_SAP BWTAR T149D BWTAR    
24 WISP_KEYS_SAP BWVOR T6WP1 BWVOR    
25 WISP_KEYS_SAP BZIRK T171 BZIRK    
26 WISP_KEYS_SAP CDT1 CMMD_CDT1 CDT1 KEY    
27 WISP_KEYS_SAP CDT2 CMMD_CDT2 CDT2 KEY    
28 WISP_KEYS_SAP CDT3 CMMD_CDT3 CDT3 KEY    
29 WISP_KEYS_SAP CDT4 CMMD_CDT4 CDT4 KEY    
30 WISP_KEYS_SAP CDT5 CMMD_CDT5 CDT5 KEY    
31 WISP_KEYS_SAP CDT6 CMMD_CDT6 CDT6 KEY    
32 WISP_KEYS_SAP CDT7 CMMD_CDT7 CDT7 KEY    
33 WISP_KEYS_SAP CHARG MCHA CHARG    
34 WISP_KEYS_SAP CITYC T005G CITYC    
35 WISP_KEYS_SAP CM_LAND1 T005 LAND1    
36 WISP_KEYS_SAP COMMN TQCOM COMMN    
37 WISP_KEYS_SAP COUNC T005E COUNC    
38 WISP_KEYS_SAP DISMM T438A DISMM    
39 WISP_KEYS_SAP DISPO T024D DISPO    
40 WISP_KEYS_SAP EBELN EKKO EBELN    
41 WISP_KEYS_SAP EBELP EKPO EBELP    
42 WISP_KEYS_SAP EKGRP T024 EKGRP    
43 WISP_KEYS_SAP EKORG T024E EKORG    
44 WISP_KEYS_SAP EKSGB T026 EKSGB    
45 WISP_KEYS_SAP ELBER T302 LGBER    
46 WISP_KEYS_SAP ELTYP T301 LGTYP    
47 WISP_KEYS_SAP ETTYP TVEP ETTYP    
48 WISP_KEYS_SAP EXNUM EIKP EXNUM    
49 WISP_KEYS_SAP FAKSK TVFS FAKSP    
50 WISP_KEYS_SAP FAKSP TVFS FAKSP    
51 WISP_KEYS_SAP FILGRP TWISPC_FILGRP FILGRP    
52 WISP_KEYS_SAP FILNR KNA1 KUNNR KEY 1 1
53 WISP_KEYS_SAP FKAIV TVFK FKART    
54 WISP_KEYS_SAP FKART TVFK FKART    
55 WISP_KEYS_SAP FKARV TVFK FKART    
56 WISP_KEYS_SAP GEWEI T006 MSEHI    
57 WISP_KEYS_SAP GRULG TVLG GRULG    
58 WISP_KEYS_SAP GSBER TGSB GSBER    
59 WISP_KEYS_SAP GSKST TGSB GSBER    
60 WISP_KEYS_SAP HIER_ID MATGRP_HIER HIER_ID    
61 WISP_KEYS_SAP HIEZU01 KNA1 KUNNR    
62 WISP_KEYS_SAP HIEZU02 KNA1 KUNNR    
63 WISP_KEYS_SAP HIEZU03 KNA1 KUNNR    
64 WISP_KEYS_SAP HIEZU04 KNA1 KUNNR    
65 WISP_KEYS_SAP HIEZU05 KNA1 KUNNR    
66 WISP_KEYS_SAP HIEZU06 KNA1 KUNNR    
67 WISP_KEYS_SAP HIEZU07 KNA1 KUNNR    
68 WISP_KEYS_SAP HIEZU08 KNA1 KUNNR    
69 WISP_KEYS_SAP HIEZU09 KNA1 KUNNR    
70 WISP_KEYS_SAP HIEZU10 KNA1 KUNNR    
71 WISP_KEYS_SAP INCO1 TINC INCO1    
72 WISP_KEYS_SAP INFNR EINA INFNR    
73 WISP_KEYS_SAP KALSM T683 KALSM    
74 WISP_KEYS_SAP KDGRP T151 KDGRP    
75 WISP_KEYS_SAP KMEIN T006 MSEHI    
76 WISP_KEYS_SAP KNFAK TFACD IDENT    
77 WISP_KEYS_SAP KNTTP T163K KNTTP    
78 WISP_KEYS_SAP KNUMA KONA KNUMA    
79 WISP_KEYS_SAP KOKRS TKA01 KOKRS    
80 WISP_KEYS_SAP KONDM T178 KONDM    
81 WISP_KEYS_SAP KSCHL T685 KSCHL C 1
82 WISP_KEYS_SAP KTGRD TVKT KTGRD    
83 WISP_KEYS_SAP KTGRM TVKM KTGRM    
84 WISP_KEYS_SAP KUNAG KNA1 KUNNR    
85 WISP_KEYS_SAP KUNIV KNA1 KUNNR    
86 WISP_KEYS_SAP KUNRE KNA1 KUNNR KEY C CN
87 WISP_KEYS_SAP KUNRG KNA1 KUNNR    
88 WISP_KEYS_SAP KVGR1 TVV1 KVGR1    
89 WISP_KEYS_SAP KVGR2 TVV2 KVGR2    
90 WISP_KEYS_SAP KVGR3 TVV3 KVGR3    
91 WISP_KEYS_SAP KVGR4 TVV4 KVGR4    
92 WISP_KEYS_SAP KVGR5 TVV5 KVGR5    
93 WISP_KEYS_SAP LAND1 T005 LAND1    
94 WISP_KEYS_SAP LANDL T005 LAND1 REF 1 CN
95 WISP_KEYS_SAP LANDLF T005 LAND1    
96 WISP_KEYS_SAP LETYP T307 LETYP    
97 WISP_KEYS_SAP LFART TVLK LFART    
98 WISP_KEYS_SAP LGBER T302 LGBER    
99 WISP_KEYS_SAP LGNUM T300 LGNUM    
100 WISP_KEYS_SAP LGORT T001L LGORT    
101 WISP_KEYS_SAP LGPLA LAGP LGPLA    
102 WISP_KEYS_SAP LGTOR T30B LGTOR    
103 WISP_KEYS_SAP LGTYP T301 LGTYP    
104 WISP_KEYS_SAP LIFRE LFA1 LIFNR    
105 WISP_KEYS_SAP LIFSK TVLS LIFSP    
106 WISP_KEYS_SAP LIFSP TVLS LIFSP    
107 WISP_KEYS_SAP LLIEF LFA1 LIFNR    
108 WISP_KEYS_SAP LMEIN T006 MSEHI    
109 WISP_KEYS_SAP LNRZB LFA1 LIFNR KEY C CN
110 WISP_KEYS_SAP LPRIO TPRIO LPRIO    
111 WISP_KEYS_SAP LSTEL TVLA LSTEL    
112 WISP_KEYS_SAP LTSNR WYT1 LTSNR    
113 WISP_KEYS_SAP MABER T047M MABER    
114 WISP_KEYS_SAP MANDT T000 MANDT    
115 WISP_KEYS_SAP MATKL T023 MATKL    
116 WISP_KEYS_SAP MATNR MARA MATNR    
117 WISP_KEYS_SAP MATWA MARA MATNR    
118 WISP_KEYS_SAP MEINS T006 MSEHI    
119 WISP_KEYS_SAP MFRGR TMFG MFRGR    
120 WISP_KEYS_SAP MG_LAGKL T646L LAGKL    
121 WISP_KEYS_SAP MTART T134 MTART    
122 WISP_KEYS_SAP MTVFP TMVF MTVFP    
123 WISP_KEYS_SAP MVGR1 TVM1 MVGR1    
124 WISP_KEYS_SAP MVGR2 TVM2 MVGR2    
125 WISP_KEYS_SAP MVGR3 TVM3 MVGR3    
126 WISP_KEYS_SAP MVGR4 TVM4 MVGR4    
127 WISP_KEYS_SAP MVGR5 TVM5 MVGR5    
128 WISP_KEYS_SAP MWSK2 T007A MWSKZ REF 1 CN
129 WISP_KEYS_SAP MWSKZ T007A MWSKZ REF 1 CN
130 WISP_KEYS_SAP NPLNR AUFK AUFNR    
131 WISP_KEYS_SAP PLGTP TWPT PLGTP    
132 WISP_KEYS_SAP PLTYP T189 PLTYP    
133 WISP_KEYS_SAP PMATN MARA MATNR    
134 WISP_KEYS_SAP PMNUX MARA MATNR    
135 WISP_KEYS_SAP POSNR VBUP POSNR    
136 WISP_KEYS_SAP POSNV VBUP POSNR    
137 WISP_KEYS_SAP PRBME T006 MSEHI    
138 WISP_KEYS_SAP PRDHA T179 PRODH    
139 WISP_KEYS_SAP PRODH T179 PRODH    
140 WISP_KEYS_SAP PROVG TVPR PROVG    
141 WISP_KEYS_SAP PSTYP T163 PSTYP    
142 WISP_KEYS_SAP PSTYV TVPT PSTYV    
143 WISP_KEYS_SAP PV_GRUND TWBN PV_GRUND    
144 WISP_KEYS_SAP REGIO T005S BLAND    
145 WISP_KEYS_SAP REGIO_LIS T005S BLAND    
146 WISP_KEYS_SAP RESWK T001W WERKS    
147 WISP_KEYS_SAP RLIFN LFA1 LIFNR    
148 WISP_KEYS_SAP ROUTA TVRO ROUTE    
149 WISP_KEYS_SAP ROUTE TVRO ROUTE    
150 WISP_KEYS_SAP SAISO T6WSP SAISO    
151 WISP_KEYS_SAP SAKTO SKA1 SAKNR    
152 WISP_KEYS_SAP SATNR MARA MATNR    
153 WISP_KEYS_SAP SBGRP T024B SBGRP    
154 WISP_KEYS_SAP SERVG TWSG SERVG    
155 WISP_KEYS_SAP SOBKZ T148 SOBKZ    
156 WISP_KEYS_SAP SPAIV TSPA SPART    
157 WISP_KEYS_SAP SPART TSPA SPART    
158 WISP_KEYS_SAP SSTUF TWSS SSTUF    
159 WISP_KEYS_SAP STRNR MARA MATNR    
160 WISP_KEYS_SAP STWAE TCURC WAERS    
161 WISP_KEYS_SAP SUGRD TVSU SUGRD    
162 WISP_KEYS_SAP TRAGR TTGR TRAGR    
163 WISP_KEYS_SAP TRATY TVTY TRATY    
164 WISP_KEYS_SAP UEPOS VBUP POSNR    
165 WISP_KEYS_SAP VBELN VBUK VBELN    
166 WISP_KEYS_SAP VBELV VBUK VBELN    
167 WISP_KEYS_SAP VGBEL EKKO EBELN    
168 WISP_KEYS_SAP VGPOS VBUP POSNR    
169 WISP_KEYS_SAP VKAUS TVLV ABRVW C CN
170 WISP_KEYS_SAP VKGRP TVKGR VKGRP C 1
171 WISP_KEYS_SAP VKGRU TVRMAVK VORGA KEY 1 CN
172 WISP_KEYS_SAP VKOIV TVKO VKORG    
173 WISP_KEYS_SAP VKORG TVKO VKORG    
174 WISP_KEYS_SAP VOLEH T006 MSEHI    
175 WISP_KEYS_SAP VPMAT MARA MATNR    
176 WISP_KEYS_SAP VPWRK T001W WERKS    
177 WISP_KEYS_SAP VRKME T006 MSEHI    
178 WISP_KEYS_SAP VSBED TVSB VSBED    
179 WISP_KEYS_SAP VSTEL TVST VSTEL    
180 WISP_KEYS_SAP VTWEG TVTW VTWEG    
181 WISP_KEYS_SAP VTWIV TVTW VTWEG    
182 WISP_KEYS_SAP WAERK TCURC WAERS    
183 WISP_KEYS_SAP WAERS TCURC WAERS    
184 WISP_KEYS_SAP WENUX T001W WERKS    
185 WISP_KEYS_SAP WERKS T001W WERKS    
186 WISP_KEYS_SAP WKREG T005S BLAND    
187 WISP_KEYS_SAP WMINR WWMI WMINR    
188 WISP_KEYS_SAP ZIEME T006 MSEHI    
189 WISP_KEYS_SAP ZLSCH T042Z ZLSCH    
History
Last changed by/on SAP  20140121 
SAP Release Created in