SAP ABAP Table WISP_DATF_SAP_K03 (Retail Planning: Key Figs from Field Catalogs for Applic. 03)

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_DATF_SAP_K03	Table Relationship Diagram
Short Description	Retail Planning: Key Figs from Field Catalogs for Applic. 03

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	VKWRT	☐	VKWRT	WERT7	CURR	13	2	Value at sales prices including value-added tax
2	EXVKW	☐	EXVKW	WERT7	CURR	13	2	Externally Entered Sales Value in Local Currency
3	VKWRA	☐	VKWRA	WERT7	CURR	13	2	Value at sales prices excluding value-added tax
4	ERFMG	☐	I_ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry (physical inventory)
5	BUCHM	☐	BUCHM	MENGV13	QUAN	13	3	Book quantity immediately prior to count
6	BUCHW	☐	BUCHW	WERT13N	CURR	13	2	Book value based on sales prices (SP) at time of count
7	WRTZL	☐	WRTZL	WERT7	CURR	13	2	Value of physical inventory count
8	WRTBM	☐	WRTBM	WERT7	CURR	13	2	Value of book quantity
9	VKMZL	☐	VKMZL	WERT7	CURR	13	2	Sales Value of Inv. Differences (with VAT) on Count Entry
10	VKNZL	☐	VKNZL	WERT7	CURR	13	2	Sales Value of Inventory Difference (w/o VAT) on Count Entry
11	IZLMNG	☐	MCW_IZLMNG	MENGV15_3	QUAN	15	3	Quantity of stock, counted in base unit of measure
12	IZLGEO	☐	MCW_IZLGEO	WERTV9	CURR	17	2	Quantity of stock counted at cost
13	IZLGVO	☐	MCW_IZLGVO	WERTV9	CURR	17	2	Quantity of stock counted at retail
14	IZLGVP	☐	MCW_IZLGVP	WERTV9	CURR	17	2	Quantity of stock counted at retail with tax
15	IBUMNG	☐	MCW_IBUMNG	MENGV15_3	QUAN	15	3	Book inventory balance, quantity in base unit of measure
16	IBUGEO	☐	MCW_IBUGEO	WERTV9	CURR	17	2	Book inventory balance at cost
17	IBUGVO	☐	MCW_IBUGVO	WERTV9	CURR	17	2	Book inventory balance at retail
18	IBUGVP	☐	MCW_IBUGVP	WERTV9	CURR	17	2	Book inventory balance at retail with tax
19	IDMMNG	☐	MCW_IDMMNG	MENGV15_3	QUAN	15	3	Minus inventory difference quantity in BUn
20	IDPMNG	☐	MCW_IDPMNG	MENGV15_3	QUAN	15	3	Plus inventory difference quantity in BUn
21	IDPGVP	☐	MCW_IDPGVP	WERTV9	CURR	17	2	Plus inventory difference at retail with tax
22	IDPGVO	☐	MCW_IDPGVO	WERTV9	CURR	17	2	Plus inventory difference at retail
23	IDMGEO	☐	MCW_IDMGEO	WERTV9	CURR	17	2	Minus inventory difference at cost
24	IDMGVP	☐	MCW_IDMGVP	WERTV9	CURR	17	2	Minus inventory difference at retail
25	IDMGVO	☐	MCW_IDMGVO	WERTV9	CURR	17	2	Minus inventory difference at retail
26	IDPGEO	☐	MCW_IDPGEO	WERTV9	CURR	17	2	Plus inventory difference at cost
27	KWART	☐	XWART	XFELD	CHAR	1	0	Indicates that the value-only material is to be inventoried
28	XDIFF	☐	XDIFF	XFELD	CHAR	1	0	Difference posted
29	XNULL	☐	XNULL	XFELD	CHAR	1	0	Zero count
30	XLOEK	☐	I_XLOEK	XFELD	CHAR	1	0	Item is Deleted (Physical Inventory)
31	XZAEL	☐	XZAEL	XFELD	CHAR	1	0	Item has been counted
32	TAAMG	☐	MCWM_TAAMG	MENG15	QUAN	15	3	Stock Removal Quantity from TO Item
33	AEMNG	☐	MCWM_AEMNG	MENG15	QUAN	15	3	Moved quantity between stock removal/placement type
34	DMENG	☐	LTAP_DMENG	MENSH	QUAN	13	3	Quantity of difference posting in stockkeeping unit
35	TAEMG	☐	MCWM_TAEMG	MENG15	QUAN	15	3	Putaway quantity for TO item
36	EDMNG	☐	MCWM_EDMNG	MENG15	QUAN	15	3	Real difference quantity (not on source bin)
37	EXAMG	☐	MCWM_EXAMG	MENG15	QUAN	15	3	External removal quantity (GI interface)
38	EXEMG	☐	MCWM_EXEMG	MENG15	QUAN	15	3	External stock placement quantity (GR interface)
39	TARMG	☐	MCWM_TARMG	MENG15	QUAN	15	3	Return placement quantity from TO item
40	VDMNG	☐	MCWM_VDMNG	MENG15	QUAN	15	3	Difference quantity for the source bin
41	AEGEW	☐	MCWM_AEGEW	MENG15	QUAN	15	3	Moved weight between stock removal/placement type
42	EXAGW	☐	MCWM_EXAGW	MENG15	QUAN	15	3	Weight of external stock removal
43	EXEGW	☐	MCWM_EXEGW	MENG15	QUAN	15	3	Weight of external stock placement
44	TAAGW	☐	MCWM_TAAGW	MENG15	QUAN	15	3	Weight of stock removal
45	TAEGW	☐	MCWM_TAEGW	MENG15	QUAN	15	3	Weight of stock placement item
46	TARGW	☐	MCWM_TARGW	MENG15	QUAN	15	3	Weight of return transfer
47	EXEPC	☐	MCWM_EXEPC	MCZAEHLER	DEC	9	0	Number of external stock placement items
48	EXAPC	☐	MCWM_EXAPC	MCZAEHLER	DEC	9	0	Number of external stock removal items
49	TAAPC	☐	MCWM_TAAPC	MCZAEHLER	DEC	9	0	Number of stock removals
50	NKPSC	☐	MCWM_NKPSC	MCZAEHLER	DEC	9	0	Counter for items with zero stock check
51	AEPSC	☐	MCWM_AEPSC	MCZAEHLER	DEC	9	0	Number of movements between stock removal/placement type
52	VDPSC	☐	MCWM_VDPSC	MCZAEHLER	DEC	9	0	Counter for source bin difference items
53	EDPSC	☐	MCWM_EDPSC	MCZAEHLER	DEC	9	0	Counter of real difference items
54	TAEPC	☐	MCWM_TAEPC	MCZAEHLER	DEC	9	0	Number of stock placement items
55	LFBZC	☐	MCWM_LFBZC	MCZAEHLER	DEC	9	0	Number of items for deliveries
56	RSBZC	☐	MCWM_RSBZC	MCZAEHLER	DEC	9	0	Number with reservation reference
57	TBBZC	☐	MCWM_TBBZC	MCZAEHLER	DEC	9	0	Number with TR reference
58	RGLAC	☐	MCWM_RGLAC	MCZAEHLER	DEC	9	0	Return to stock removal bin
59	RFBZC	☐	MCWM_RFBZC	MCZAEHLER	DEC	9	0	Number of items with reference to reference number
60	TARPC	☐	MCWM_TARPC	MCZAEHLER	DEC	9	0	Number of TO items with return placement
61	AEAQC	☐	MCWM_AEAQC	MCZAEHLER	DEC	9	0	Counter for totals field time diff. TO creat. to TO conf.
62	BEAEC	☐	MCWM_BEAEC	MCZAEHLER	DEC	9	0	Counter for totals field time diff.TR creat. to TO creat.
63	BPAEC	☐	MCWM_BPAEC	MCZAEHLER	DEC	9	0	Counter for totals field time difference TR plng to TO creat
64	LKAEC	☐	MCWM_LKAEC	MCZAEHLER	DEC	9	0	Counter for totals field, time diff. pick.date to TO creat.
65	LK_AE	☐	MCWM_LK_AE	MCWM_TIMEM	QUAN	15	0	Time between delivery note pick date and TO creation
66	AE_AQ	☐	MCWM_AE_AQ	MCWM_TIMEM	QUAN	15	0	Time between TO creation and confirmation in minutes
67	BP_AE	☐	MCWM_BP_AE	MCWM_TIMEM	QUAN	15	0	Time between TR planning data and TO creation
68	BE_AE	☐	MCWM_BE_AE	MCWM_TIMEM	QUAN	15	0	Time between TR creation and TO creation
69	MAGBB	☐	MAGBB	MENGV15	QUAN	15	3	Quantity of valuated stock issues
70	MAGKB	☐	MAGKB	MENGV15	QUAN	15	3	Quantity of consignment stock that has been issued
71	MZUBB	☐	MZUBB	MENGV15	QUAN	15	3	Valuated stock receipts quantity
72	MZUKB	☐	MZUKB	MENGV15	QUAN	15	3	Consignment stock receipts quantity
73	MGVBR	☐	GVBRM	MENGV15	QUAN	15	3	Total usage quantity
74	MUVBR	☐	UVBRM	MENGV15	QUAN	15	3	Unplanned usage quantity
75	WBWBEST	☐	WBWBEST	WERT15	CURR	15	2	Value of valuated stock
76	BWERTV	☐	BWERTV	WERT15	CURR	15	2	Change in value of valuated stock
77	WAGBB	☐	WAGBB	WERT15	CURR	15	2	Value of valuated stock that has been issued
78	WZUBB	☐	WZUBB	WERT15	CURR	15	2	Valuated stock receipts value
79	WGVBR	☐	WGVBR	WERT15	CURR	15	2	Total usage value
80	WUVBR	☐	WUVBR	WERT15	CURR	15	2	Unplanned usage value
81	AZUBB	☐	AZUBB	ANZAHL	DEC	9	0	Number of times that valuated stock has been received
82	AZUKB	☐	AZUKB	ANZAHL	DEC	9	0	Number of times that consignment stock has been received
83	AAGBB	☐	AAGBB	ANZAHL	DEC	9	0	Number of times valuated stock has been issued
84	AAGKB	☐	AAGKB	ANZAHL	DEC	9	0	Number of times consignment stock has been issued
85	BBNULL	☐	BBNULL	ANZAHL	DEC	9	0	Number of times that valuated stock was zero
86	GBNULL	☐	GBNULL	ANZAHL	DEC	9	0	Number of times that total stock was zero
87	KBNULL	☐	KBNULL	ANZAHL	DEC	9	0	Number of times that consignment stock was zero
88	AUVBR	☐	AUVBR	ANZAHL	DEC	9	0	Number of times an unplanned usage has been recorded
89	AGVBR	☐	AGVBR	ANZAHL	DEC	9	0	Number of times that total usage has been updated
90	AMBWG	☐	AMBWG	ANZAHL	DEC	9	0	Number of material movements
91	ASTOR	☐	ASTOR	ANZAHL	DEC	9	0	Number of cancelation documents to date

History

Last changed by/on	SAP	20010221
SAP Release Created in