SAP ABAP Table WISP_KEYS_SAP_M01 (Retail Planning: Plng Char. from Field Catalogs for App. 01)

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_M01	Table Relationship Diagram
Short Description	Retail Planning: Plng Char. from Field Catalogs for App. 01

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	ITEMNUM	☐	ITEMNUM	CHAR18	CHAR	18	0	SAP number for an item
2	NODENUM	☐	NODENUM	CHAR18	CHAR	18	0	Identification nodes for DRP network
3	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	MARA
4	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
5	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
6	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
7	KDMAT	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
8	GRKOR	☐	GRKOR	GRKOR	NUMC	3	0	Delivery group (items are delivered together)
9	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
10	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
11	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
12	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
13	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
14	TAXM1	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
15	TAXM2	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
16	TAXM3	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
17	TAXM4	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
18	TAXM5	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
19	TAXM6	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
20	TAXM7	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
21	TAXM8	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
22	TAXM9	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
23	KONDM	☐	KONDM	KONDM	CHAR	2	0	Material Pricing Group	T178
24	KTGRM	☐	KTGRM	KTGRM	CHAR	2	0	Account assignment group for this material	TVKM
25	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
26	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	TVM1
27	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	TVM2
28	MVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	TVM3
29	MVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	TVM4
30	MVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	TVM5
31	BDART	☐	BDART	BDART	CHAR	2	0	Requirement type
32	PLART	☐	PLART	PLART	CHAR	1	0	Planning type	*
33	KONOB	☐	KONOB	KONOB	CHAR	18	0	Product allocation object	*
34	LGPLA	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin	LAGP
35	LGPBE	☐	LGPBE	CHAR10	CHAR	10	0	Storage Bin
36	VPMAT	☐	VPMAT	MATNR	CHAR	18	0	Planning material	MARA
37	VPWRK	☐	VPWRK	WERKS	CHAR	4	0	Planning plant	T001W
38	VKGRU	☐	VKGRU	RMA_VORGA	CHAR	3	0	Repair processing: Classify items	TVRMAVK
39	VKAUS	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	TVLV
40	STKEY	☐	STKEY	STKEY	CHAR	1	0	Origin of the bill of material
41	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
42	AWAHR	☐	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
43	GRSTR	☐	GRSTR	GRSTR	NUMC	3	0	Group definition for structure data
44	KNUMH	☐	KNUMH	KNUMB	CHAR	10	0	Condition record number
45	KOPOS	☐	KOPOS	NUM02	NUMC	2	0	Sequential number of the condition
46	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
47	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
48	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
49	ZIEME	☐	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	T006
50	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
51	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
52	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
53	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
54	PRBME	☐	PRBME	MEINS	UNIT	3	0	Base unit of measure for product group	T006
55	APWAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
56	GSKST	☐	GSKST	GSBER	CHAR	4	0	Business area from cost center	TGSB
57	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
58	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
59	RKFKF	☐	RKFKF	RKFKF	CHAR	1	0	Form of Billing for CO/PPC Orders
60	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
61	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
62	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
63	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
64	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
65	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
66	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
67	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
68	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	TVV2
69	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	TVV3
70	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	TVV4
71	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	TVV5
72	PKUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
73	PKUNRE	☐	KUNRE	KUNNR	CHAR	10	0	Bill-to party	*
74	PKUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
75	PSPDNR	☐	SPDNR	LIFNR	CHAR	10	0	Carrier	*
76	PABLA	☐	PABLA	TEXT25	CHAR	25	0	Unloading point of the ship-to party
77	SBGRP	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	T024B
78	PLARE	☐	PLARE	LAND1	CHAR	3	0	Country of the bill-to party	*
79	PLASP	☐	PLASP	LAND1	CHAR	3	0	Country of the carrier	*
80	PLAVE	☐	PLAVE	LAND1	CHAR	3	0	Country of the representative	*
81	PLAWE	☐	PLAWE	LAND1	CHAR	3	0	Country of ship-to party	*
82	PZONE	☐	PZONE	ZONE	CHAR	10	0	Transportation zone of the ship-to party	*
83	PVRTNR	☐	VRTNR	PERNR	NUMC	8	0	Sales employee
84	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
85	VBELN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
86	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
87	TRVOG	☐	TRVOG	TRVOG	CHAR	1	0	Transaction group
88	VBKLA	☐	VBKLA	CHAR9	CHAR	9	0	unused (sales doocument class)
89	VBKLT	☐	VBKLT	VBKLT	CHAR	1	0	SD document indicator
90	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
91	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
92	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
93	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	TVPT
94	POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
95	LFREL	☐	LFREL_AP	XFELD	CHAR	1	0	Item is relevant for delivery
96	FKREL	☐	FKREL	FKREL	CHAR	1	0	Relevant for Billing
97	ETENR	☐	ETENR	ETENR	NUMC	4	0	Schedule line	*
98	ETTYP	☐	ETTYP	ETTYP	CHAR	2	0	Item Cat. in Schedule Line	TVEP
99	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
100	BSART	☐	BSART	BSART	CHAR	4	0	Order Type (Purchasing)	T161
101	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
102	ABART	☐	ABART	ABART	CHAR	1	0	Release type
103	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
104	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
105	POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
106	FKTYP	☐	FKTYP	FKTYP	CHAR	1	0	Billing Category
107	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
108	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
109	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
110	VGTYP	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
111	BONUS	☐	BONUS	BONUS	CHAR	2	0	Volume rebate group	TVBO
112	PROVG	☐	PROVG	PROVG	CHAR	2	0	Commission group	TVPR
113	ROUTA	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
114	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
115	VERUR	☐	VERUR_VL	CHAR35	CHAR	35	0	Distribution delivery
116	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	EIKP
117	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
118	KUNIV	☐	KUNIV	KUNNR	CHAR	10	0	Customer number for intercompany billing	KNA1
119	POSNV	☐	POSNV	POSNR	NUMC	6	0	Originating item	VBUP
120	VBELV	☐	VBELV	VBELN	CHAR	10	0	Originating document	VBUK
121	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	VBUP
122	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures	VBUP
123	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
124	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
125	APABSTA	☐	ABSTA_VB	STATV	CHAR	1	0	Rejection status for SD item
126	APLFSTA	☐	LFSTA	STATV	CHAR	1	0	Delivery status
127	APLFGSA	☐	LFGSA	STATV	CHAR	1	0	Overall Delivery Status of the Item
128	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
129	KTAAR	☐	KTAAR	KTAAR	CHAR	4	0	Sales Activity Type for Sales Support	*
130	KTAST	☐	KTAST	KTAST	CHAR	1	0	Status of sales activity	*
131	KTAGR	☐	KTAGR	KTAGR	CHAR	3	0	Reason for sales activity	*
132	KTAER	☐	KTAER	KTAER	CHAR	3	0	Outcome of sales activities	*
133	KTAEB	☐	KTAEB	KTAEB	CHAR	3	0	Analysis of sales activity outcome	*
134	PARNR_AP	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
135	DIRECTION	☐	ACT_DIRECTION	ACT_DIRECTION	CHAR	1	0	Direction of sales activity: Inbound / outbound
136	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	*
137	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	*
138	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	*
139	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	*
140	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	*
141	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	*
142	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	*
143	PAFKT	☐	PAFKT	PAFKT	CHAR	2	0	Contact person function	*
144	PSTL_LIS	☐	PSTL_LIS	PSTLZ	CHAR	10	0	Postal code of city or PO box
145	REGIO_LIS	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
146	DEAR1	☐	DEAR1	XFELD	CHAR	1	0	Indicator: Competitor
147	KATR1	☐	KATR1	ATTR1	CHAR	2	0	Attribute 1	*
148	PARH1	☐	PAAT1	PARHO	CHAR	2	0	Contact Partner: Attribute 1	*
149	PARH2	☐	PAAT2	PAAT2	CHAR	2	0	Contact person: Attribute 2	*
150	KATR2	☐	KATR2	ATTR2	CHAR	2	0	Attribute 2	*
151	VERSION	☐	CASVERSION	NUM04	NUMC	4	0	Version number
152	PRODH1	☐	PRODH1	PRODH1	CHAR	5	0	Standard data element PRODH1
153	PRODH2	☐	PRODH2	PRODH2	CHAR	5	0	Standard data element PRODH2
154	PRODH3	☐	PRODH3	PRODH3	CHAR	8	0	Standard data element PRODH3
155	WETTB	☐	WETTB	KUNNR	CHAR	10	0	Competitor	*
156	PMNUX	☐	PMNUX	MATNR	CHAR	18	0	Product group/material in planning hierarchy	MARA
157	WENUX	☐	WENUX	WERKS	CHAR	4	0	Plant	T001W
158	RFGSK	☐	RFGSK	STATV	CHAR	1	0	Total reference status of all items
159	BESTK	☐	BESTK	STATV	CHAR	1	0	Confirmation status
160	LFSTK	☐	LFSTK	STATV	CHAR	1	0	Delivery status
161	LFGSK	☐	LKGSK	STATV	CHAR	1	0	Overall delivery status for all items
162	WBSTK	☐	WBSTK	STATV	CHAR	1	0	Total goods movement status
163	FKSTK	☐	FKSTK	STATV	CHAR	1	0	Billing status
164	FKSAK	☐	FKSAK	STATV	CHAR	1	0	Billing status (order-related billing document)
165	BUCHK	☐	BUCHK	STATV	CHAR	1	0	Posting Status of Billing Document
166	ABSTK	☐	ABSTK	STATV	CHAR	1	0	Overall rejection status of all sales document items
167	GBSTK	☐	GBSTK	STATV	CHAR	1	0	Overall processing status of document
168	KOSTK	☐	KOSTK	STATV	CHAR	1	0	Overall picking / putaway status
169	LVSTK	☐	LVSTK	STATV	CHAR	1	0	Overall status of warehouse management activities
170	UVALS	☐	UVALL_SU	STATV	CHAR	1	0	Total incompletion status of all items in general
171	UVVLS	☐	UVVLS_SU	STATV	CHAR	1	0	Total incompletion status of all items: Delivery
172	UVFAS	☐	UVFAK_SU	STATV	CHAR	1	0	Total incompletion status of all items: Billing
173	UVALL	☐	UVALL_UK	STATV	CHAR	1	0	General incompletion status of the header
174	UVVLK	☐	UVVLK_UK	STATV	CHAR	1	0	Header incompletion status concerning delivery
175	UVFAK	☐	UVFAK_UK	STATV	CHAR	1	0	Header incompletion status with respect to billing
176	UVPRS	☐	UVPRS_UK	STATV	CHAR	1	0	Document is incomplete with respect to pricing
177	VBOBJ	☐	VBOBJ	VBOBJ	CHAR	1	0	SD document object
178	RFSTA	☐	RFSTA	STATV	CHAR	1	0	Reference status
179	RFGSA	☐	RFGSA	STATV	CHAR	1	0	Overall Status of Reference
180	BESTA	☐	BESTA	STATV	CHAR	1	0	Confirmation status of the document item
181	LFSTA	☐	LFSTA	STATV	CHAR	1	0	Delivery status
182	LFGSA	☐	LFGSA	STATV	CHAR	1	0	Overall Delivery Status of the Item
183	WBSTA	☐	WBSTA	STATV	CHAR	1	0	Goods movement status
184	FKSTA	☐	FKSTA	STATV	CHAR	1	0	Billing status of delivery-related billing documents
185	FKSAA	☐	FKSAA	STATV	CHAR	1	0	Billing Status for Order-Related Billing Documents
186	ABSTA	☐	ABSTA_VB	STATV	CHAR	1	0	Rejection status for SD item
187	GBSTA	☐	GBSTA	STATV	CHAR	1	0	Overall Processing Status of the SD Document Item
188	KOSTA	☐	KOSTA	STATV	CHAR	1	0	Picking Status/Putaway Status
189	LVSTA	☐	LVSTA	STATV	CHAR	1	0	Status of warehouse management activities
190	LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	TVLS
191	FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	TVFS
192	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
193	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
194	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	TVAG
195	FMENG	☐	FMENG	XFELD	CHAR	1	0	Quantity is fixed
196	UEBTK	☐	UEBTK_V	XFELD	CHAR	1	0	Unlimited overdelivery allowed
197	FAKSP	☐	FAKSP_AP	FAKSP	CHAR	2	0	Billing block for item	TVFS
198	ATPKZ	☐	ATPKZ	ATPKZ	CHAR	1	0	Replacement part
199	KZTLF	☐	KZTLF	KZTLF	CHAR	1	0	Partial delivery at item level
200	CHSPL	☐	CHSPL	XFELD	CHAR	1	0	Batch split allowed
201	VOREF	☐	VOREF	XFELD	CHAR	1	0	Complete reference indicator
202	UPFLU	☐	UPFLV	UPFLV	CHAR	1	0	Update indicator for sales document document flow
203	ERLRE	☐	ERLRE	ERLRE	CHAR	1	0	Completion rule for quotation / contract
204	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
205	VGREF	☐	VGREF	XFELD	CHAR	1	0	Preceding document has resulted from reference
206	SKTOF	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
207	BWTEX	☐	BWTEX	XFELD	CHAR	1	0	Indicator: Separate valuation
208	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
209	FIXMG	☐	FIXMG	XFELD	CHAR	1	0	Delivery date and quantity fixed
210	SUGRD	☐	SUGRD	SUGRD	CHAR	4	0	Reason for material substitution	TVSU
211	WEPOS	☐	WEPOS_A	ECOST	CHAR	1	0	Confirmation status of schedule line (incl.ALE)
212	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
213	LIFSP	☐	LIFSP_EP	LIFSP	CHAR	2	0	Schedule line blocked for delivery	TVLS
214	VERFP	☐	VERFP_MAS	XFELD	CHAR	1	0	Availability confirmed automatically
215	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
216	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
217	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
218	RFBSK	☐	RFBSK	RFBSK	CHAR	1	0	Status for transfer to accounting
219	CPKUR	☐	CPKUR	CPKUR	CHAR	1	0	ID:Exchange rate setting (no new rate determ.in bill.doc.)
220	TAXK1	☐	TAXK1	TAXKD	CHAR	1	0	Tax classification 1 for customer	*
221	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer	*
222	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer	*
223	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer	*
224	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer	*
225	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer	*
226	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer	*
227	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer	*
228	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer	*
229	AUREF	☐	AUREF	XFELD	CHAR	1	0	Sales document was created from reference
230	EXPKZ	☐	EXPKZ	EXPKZ	CHAR	1	0	Export indicator
231	KNFAK	☐	KNFAK	WFCID	CHAR	2	0	Customer factory calendar	TFACD
232	TPQUA	☐	TPQUA	TPQUA	CHAR	1	0	not currently in use
233	TPGRP	☐	TPGRP	TPGRP	CHAR	2	0	not currently in use
234	GRULG	☐	GRULG	GRULG	CHAR	4	0	Weight group for delivery (To group)	TVLG
235	FKARV	☐	FKARV	FKART	CHAR	4	0	Proposed billing type for a delivery-related billing doc.	TVFK
236	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	T683
237	ZUKRL	☐	DZUKRL	CHAR40	CHAR	40	0	Combination criteria for delivery
238	COMMN	☐	COMMN	COMMN	CHAR	5	0	Communication number for Q-API interface	TQCOM
239	FKAIV	☐	FKAIV	FKART	CHAR	4	0	Billing type for intercompany billing	TVFK
240	LLAND	☐	LLAND	LAND1	CHAR	3	0	Destination Country	*
241	KOMKZ	☐	KOMKZ	KOMKZ	CHAR	1	0	Indicator for picking control
242	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	T301
243	BWLVS	☐	BWLVS	BWLVS	NUMC	3	0	Movement Type for Warehouse Management	T333
244	KZDLG	☐	LVS_KZDLG	XFELD	CHAR	1	0	Indicator: dynamic storage bin in warehouse management
245	XCHAR	☐	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
246	SUMBD	☐	SUMBD	SUMBD	CHAR	1	0	Summing up of requirements
247	MTVFP	☐	MTVFP	MTVFP	CHAR	2	0	Checking Group for Availability Check	TMVF
248	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
249	VPZUO	☐	VPZUO	ZUVKZ	CHAR	1	0	Allocation Indicator
250	AKVBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
251	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
252	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
253	PCKPF	☐	PCKPF	PCKPF	CHAR	1	0	Packing control
254	BEDAR_LF	☐	BEDAR	BEDAR	CHAR	3	0	Requirements class	T459K
255	ATINN	☐	ATINN	ATINN	NUMC	10	0	Internal characteristic	*
256	KLART	☐	KLASSENART	KLASSENART	CHAR	3	0	Class Type	*
257	ATWRT	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
258	MCUPD	☐	MCUPD	X	CHAR	1	0	Indicator whether statistical record was updated
259	CUOBJ	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
260	LNPOS	☐	CHCOMBKEY	NUM05	NUMC	5	0	Combination value key
261	CLINT	☐	CHKEYGRP	VTINT	NUMC	10	0	Characteristics combination
262	ALAND	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	T005
263	WKREG	☐	WKREG	REGIO	CHAR	3	0	Region in which plant is located	T005S
264	WKCOU	☐	WKCOU	CHAR3	CHAR	3	0	County in which plant is located
265	WKCTY	☐	WKCTY	CHAR4	CHAR	4	0	City in which plant is located
266	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
267	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
268	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
269	BEROT	☐	BEROT	BEROT	CHAR	20	0	Picked items location
270	LSTEL	☐	LSTEL	LSTEL	CHAR	2	0	Loading Point	TVLA
271	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	TTGR
272	VKOIV	☐	VKOIV	VKORG	CHAR	4	0	Sales organization for intercompany billing	TVKO
273	VTWIV	☐	VTWIV	VTWEG	CHAR	2	0	Distribution channel for intercompany billing	TVTW
274	SPAIV	☐	SPAIV	SPART	CHAR	2	0	Division for intercompany billing	TSPA

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WISP_KEYS_SAP_M01	ABGRU	TVAG	ABGRU
2	WISP_KEYS_SAP_M01	ALAND	T005	LAND1
3	WISP_KEYS_SAP_M01	AUFNR	AUFK	AUFNR
4	WISP_KEYS_SAP_M01	BEDAR_LF	T459K	BEDAR
5	WISP_KEYS_SAP_M01	BONUS	TVBO	BONUS
6	WISP_KEYS_SAP_M01	BSARK	T176	BSARK
7	WISP_KEYS_SAP_M01	BSART	T161	BSART
8	WISP_KEYS_SAP_M01	BWART	T156	BWART
9	WISP_KEYS_SAP_M01	BWLVS	T333	BWLVS
10	WISP_KEYS_SAP_M01	BWTAR	T149D	BWTAR
11	WISP_KEYS_SAP_M01	CHARG	MCHA	CHARG
12	WISP_KEYS_SAP_M01	CITYC	T005G	CITYC
13	WISP_KEYS_SAP_M01	COMMN	TQCOM	COMMN
14	WISP_KEYS_SAP_M01	COUNC	T005E	COUNC
15	WISP_KEYS_SAP_M01	ETTYP	TVEP	ETTYP
16	WISP_KEYS_SAP_M01	EXNUM	EIKP	EXNUM
17	WISP_KEYS_SAP_M01	FAKSK	TVFS	FAKSP
18	WISP_KEYS_SAP_M01	FAKSP	TVFS	FAKSP
19	WISP_KEYS_SAP_M01	FKAIV	TVFK	FKART
20	WISP_KEYS_SAP_M01	FKARV	TVFK	FKART
21	WISP_KEYS_SAP_M01	GEWEI	T006	MSEHI
22	WISP_KEYS_SAP_M01	GRULG	TVLG	GRULG
23	WISP_KEYS_SAP_M01	GSBER	TGSB	GSBER
24	WISP_KEYS_SAP_M01	GSKST	TGSB	GSBER
25	WISP_KEYS_SAP_M01	INCO1	TINC	INCO1
26	WISP_KEYS_SAP_M01	KALSM	T683	KALSM
27	WISP_KEYS_SAP_M01	KMEIN	T006	MSEHI
28	WISP_KEYS_SAP_M01	KNFAK	TFACD	IDENT
29	WISP_KEYS_SAP_M01	KNTTP	T163K	KNTTP
30	WISP_KEYS_SAP_M01	KOKRS	TKA01	KOKRS
31	WISP_KEYS_SAP_M01	KONDM	T178	KONDM
32	WISP_KEYS_SAP_M01	KTGRD	TVKT	KTGRD
33	WISP_KEYS_SAP_M01	KTGRM	TVKM	KTGRM
34	WISP_KEYS_SAP_M01	KUNIV	KNA1	KUNNR
35	WISP_KEYS_SAP_M01	KVGR1	TVV1	KVGR1
36	WISP_KEYS_SAP_M01	KVGR2	TVV2	KVGR2
37	WISP_KEYS_SAP_M01	KVGR3	TVV3	KVGR3
38	WISP_KEYS_SAP_M01	KVGR4	TVV4	KVGR4
39	WISP_KEYS_SAP_M01	KVGR5	TVV5	KVGR5
40	WISP_KEYS_SAP_M01	LGNUM	T300	LGNUM
41	WISP_KEYS_SAP_M01	LGORT	T001L	LGORT
42	WISP_KEYS_SAP_M01	LGPLA	LAGP	LGPLA
43	WISP_KEYS_SAP_M01	LGTYP	T301	LGTYP
44	WISP_KEYS_SAP_M01	LIFSK	TVLS	LIFSP
45	WISP_KEYS_SAP_M01	LIFSP	TVLS	LIFSP
46	WISP_KEYS_SAP_M01	LPRIO	TPRIO	LPRIO
47	WISP_KEYS_SAP_M01	LSTEL	TVLA	LSTEL
48	WISP_KEYS_SAP_M01	MABER	T047M	MABER
49	WISP_KEYS_SAP_M01	MATWA	MARA	MATNR
50	WISP_KEYS_SAP_M01	MTVFP	TMVF	MTVFP
51	WISP_KEYS_SAP_M01	MVGR1	TVM1	MVGR1
52	WISP_KEYS_SAP_M01	MVGR2	TVM2	MVGR2
53	WISP_KEYS_SAP_M01	MVGR3	TVM3	MVGR3
54	WISP_KEYS_SAP_M01	MVGR4	TVM4	MVGR4
55	WISP_KEYS_SAP_M01	MVGR5	TVM5	MVGR5
56	WISP_KEYS_SAP_M01	PLTYP	T189	PLTYP
57	WISP_KEYS_SAP_M01	PMATN	MARA	MATNR
58	WISP_KEYS_SAP_M01	PMNUX	MARA	MATNR
59	WISP_KEYS_SAP_M01	POSNR	VBUP	POSNR
60	WISP_KEYS_SAP_M01	POSNV	VBUP	POSNR
61	WISP_KEYS_SAP_M01	PRBME	T006	MSEHI
62	WISP_KEYS_SAP_M01	PRODH	T179	PRODH
63	WISP_KEYS_SAP_M01	PROVG	TVPR	PROVG
64	WISP_KEYS_SAP_M01	PSTYV	TVPT	PSTYV
65	WISP_KEYS_SAP_M01	REGIO	T005S	BLAND
66	WISP_KEYS_SAP_M01	REGIO_LIS	T005S	BLAND
67	WISP_KEYS_SAP_M01	ROUTA	TVRO	ROUTE
68	WISP_KEYS_SAP_M01	ROUTE	TVRO	ROUTE
69	WISP_KEYS_SAP_M01	SBGRP	T024B	SBGRP
70	WISP_KEYS_SAP_M01	SOBKZ	T148	SOBKZ
71	WISP_KEYS_SAP_M01	SPAIV	TSPA	SPART
72	WISP_KEYS_SAP_M01	SPART	TSPA	SPART
73	WISP_KEYS_SAP_M01	STWAE	TCURC	WAERS
74	WISP_KEYS_SAP_M01	SUGRD	TVSU	SUGRD
75	WISP_KEYS_SAP_M01	TRAGR	TTGR	TRAGR
76	WISP_KEYS_SAP_M01	UEPOS	VBUP	POSNR
77	WISP_KEYS_SAP_M01	VBELN	VBUK	VBELN
78	WISP_KEYS_SAP_M01	VBELV	VBUK	VBELN
79	WISP_KEYS_SAP_M01	VGPOS	VBUP	POSNR
80	WISP_KEYS_SAP_M01	VKAUS	TVLV	ABRVW		C	CN
81	WISP_KEYS_SAP_M01	VKGRU	TVRMAVK	VORGA	KEY	1	CN
82	WISP_KEYS_SAP_M01	VKOIV	TVKO	VKORG
83	WISP_KEYS_SAP_M01	VOLEH	T006	MSEHI
84	WISP_KEYS_SAP_M01	VPMAT	MARA	MATNR
85	WISP_KEYS_SAP_M01	VPWRK	T001W	WERKS
86	WISP_KEYS_SAP_M01	VSBED	TVSB	VSBED
87	WISP_KEYS_SAP_M01	VSTEL	TVST	VSTEL
88	WISP_KEYS_SAP_M01	VTWIV	TVTW	VTWEG
89	WISP_KEYS_SAP_M01	WAERK	TCURC	WAERS
90	WISP_KEYS_SAP_M01	WENUX	T001W	WERKS
91	WISP_KEYS_SAP_M01	WKREG	T005S	BLAND
92	WISP_KEYS_SAP_M01	ZIEME	T006	MSEHI

History

Last changed by/on	SAP	20140121
SAP Release Created in