SAP ABAP Table BAPI_WRF_PPW_PPD_DET_ITEM_STY (Item Data for the Detail Data of a Price Plan)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ LO-MD-PPW (Application Component) Price Planning Workbench
     ⤷ WRF_PPW_BAPI (Package) Price Planning Workbench - BAPIs

Basic Data

Table Category	INTTAB	Structure
Structure	BAPI_WRF_PPW_PPD_DET_ITEM_STY	Table Relationship Diagram
Short Description	Item Data for the Detail Data of a Price Plan

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	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
2	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
3	SALES_UNIT_ISO	☐	W_VRKME_ISO	ISOCD_UNIT	CHAR	3	0	Sales unit ISO code	*
4	SALESORG	☐	WRF_PPW_VKORG	VKORG	CHAR	4	0	Sales Organization	*
5	DISTR_CHANNEL	☐	WRF_PPW_VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
6	PRICE_LIST	☐	WRF_PPW_PLTYP	PLTYP	CHAR	2	0	Price List Category	*
7	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
8	PLANT_GROUP	☐	W_FILGR	KLASSE	CHAR	18	0	Plant grouping, sales promotion
9	FINAL_PRICE	☐	WRF_PPW_ENDPR_BAPI	WRF_PPW_DEC_BAPI_11_2	DEC	11	2	Final Price for BAPIs
10	GROSS_SALES_PRICE	☐	WRF_PPW_VKPBR_BAPI	WRF_PPW_DEC_BAPI_11_2	DEC	11	2	Sales Price (Gross) for BAPIs
11	PERC_CHANGE_CURR_PRICE	☐	WRF_PPW_MPROZ_BAPI	WRF_PPW_DEC_BAPI_10_3	DEC	10	3	Percentage Price Change to Current Final Price for BAPIs
12	PERC_CHANGE_INITIAL_PRICE	☐	WRF_PPW_IPROZ_BAPI	WRF_PPW_DEC_BAPI_10_3	DEC	10	3	Percentage Price Change Compared to Original Price for BAPIs
13	ABSOLUTE_CHANGE_CURR_PRICE	☐	WRF_PPW_MABSO_BAPI	WRF_PPW_DEC_BAPI_11_2	DEC	11	2	Absolute Price Change to Current Final Price for BAPIs
14	ABSOLUTE_CHANGE_INITIAL_PRICE	☐	WRF_PPW_IABSO_BAPI	WRF_PPW_DEC_BAPI_11_2	DEC	11	2	Absolute Price Change Compared to Original Price for BAPIs
15	PRICEPLANNERGROUP	☐	WRF_PPWD_USRGRP	WRF_PPWD_USRGRP	CHAR	4	0	Price Planner Group
16	SP_CHANGE_REASON	☐	PV_GRUND	PV_GRUND	CHAR	4	0	Reason for retail price change	*
17	PRICE_POINT_GROUP	☐	EPRGR	EPRGR	CHAR	6	0	Price point group	*
18	SEASON	☐	WRF_PPW_SAISO_BAPI	SAISO	CHAR	4	0	Season	*
19	SEASONYEAR	☐	WRF_PPW_SAISJ	CJAHR	CHAR	4	0	Season Year
20	HIERARCHY	☐	WRF_HIER_CNT	WRF_HIERCNT	CHAR	2	0	Hierarchy
21	GEN_MATL	☐	WRF_PPW_SATNR	MATNR	CHAR	18	0	Generic Material	*
22	BUDGET	☐	WRF_PPW_BUDGET_NR		NUMC	16	0	Budget Number
23	BUDGET_ID	☐	WRF_BUDG_PROC_ID	WRF_BUDG_PROC_ID	NUMC	2	0	Budget ID
24	FASH_GRADE	☐	WRF_PPW_FASHGRD		CHAR	4	0	Fashion Grade
25	ROLLOUT	☐	WRF_PPW_SAITY		CHAR	2	0	Rollout
26	ORGSET	☐	WRF_PPW_ORGSET_ID		INT4	10	0	Number of an Organization Set in a Price Plan
27	HIER_DATE	☐	WRF_PPW_CREATIONDATE	DATS	DATS	8	0	Date of Hierarchy Determination
28	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
29	HIERNODE_1	☐	WRF_HIER_NODE1	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 1
30	HIERNODE_2	☐	WRF_HIER_NODE2	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 2
31	HIERNODE_3	☐	WRF_HIER_NODE3	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 3
32	HIERNODE_4	☐	WRF_HIER_NODE4	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 4
33	HIERNODE_5	☐	WRF_HIER_NODE5	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 5
34	HIERNODE_6	☐	WRF_HIER_NODE6	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 6
35	HIERNODE_7	☐	WRF_HIER_NODE7	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 7
36	HIERNODE_8	☐	WRF_HIER_NODE8	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 8
37	HIERNODE_9	☐	WRF_HIER_NODE9	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 9
38	HIERNODE_10	☐	WRF_HIER_NODE10	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 10
39	MATL_CAT	☐	WRF_PPW_ATTYP	ATTYP	CHAR	2	0	Material Category
40	MATL_DESC	☐	MAKTX	TEXT40	CHAR	40	0	Material description
41	MATL_TYPE	☐	MTART	MTART	CHAR	4	0	Material type	*
42	PLAN_BUDG	☐	WRF_PPW_BUDGET_VP_BAPI	BAPICURR	DEC	23	4	Committed Budget of a Price Planning Item for BAPIs
43	BUDG_CURR	☐	WRF_PPW_BGWAER	WAERS	CUKY	5	0	Budget Currency	*
44	BUDG_CURR_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
45	BG_VAL_FRM	☐	WRF_PPW_DATE_FROM	DATUM	DATS	8	0	Validity Start Date of Budget Period
46	BG_VAL_TO	☐	WRF_PPW_DATE_TO	DATUM	DATS	8	0	Validity End Date of Budget Period
47	STOCK	☐	WRF_PPW_STOCK	WRF_PPW_STOCK	QUAN	17	3	Current Stock
48	INCL_STOCK_QTY	☐	WRF_PPW_STOCK_IA		QUAN	17	3	Included Stock Quantity
49	NONINCL_STOCK_QTY	☐	WRF_PPW_STOCK_NIA		QUAN	17	3	Non-Included Stock Quantity
50	STOCK_UNIT	☐	WRF_PPW_STOCKUNIT	MEINS	UNIT	3	0	Base Unit of Measure	*
51	STOCK_UNIT_ISO	☐	WRF_PPW_STOCKUNIT_ISO	ISOCD_UNIT	CHAR	3	0	Base Unit of Measure ISO Code	*
52	TARG_SALES	☐	WRF_PPW_TARGSLSRTIO	WRF_PPW_PROCENT	DEC	5	2	Target Sales Ratio
53	ACT_SLSRT	☐	WRF_PPW_ACTSLSRTIO	WRF_PPW_PROCENT	DEC	5	2	Actual Sales Ratio
54	PERC_MP	☐	WRF_PPW_MDPRC	WRF_PPW_PROCENT	DEC	5	2	Price Reduction as Percentage of Initial Price
55	ANALYSISVP	☐	WRF_PPW_SELLPER		NUMC	4	0	Validity Period of Material According to Markdown Profile
56	PROFVALPER	☐	WRF_PPW_MAXPER		NUMC	4	0	Validity Period of Markdown Profile
57	MARKD_PRFL	☐	WRF_PPW_MDPROF	WRF_SSMPROF	CHAR	10	0	Markdown Profile
58	PR_VAR_EX	☐	WRF_PPW_DEVI_PRICE_EXIST	CHAR1	CHAR	1	0	Flag: Price Variances Exist
59	BDGTSTATUS	☐	WRF_PPW_BUDGET_STAT		CHAR	1	0	Budget Status
60	SP_VALID_FROM	☐	VKKAB	DATUM	DATS	8	0	Sales conditions valid from
61	SP_VALID_TO	☐	VKKBI	DATUM	DATS	8	0	Sales conditions valid to
62	SP_VALID_AT	☐	VKKAM	DATUM	DATS	8	0	Key date for sales price conditions
63	SALES_P_UNIT	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
64	REFERENCE_PLANT	☐	VLGWK	WERKS	CHAR	4	0	Sales Pricing: Reference Plant	*
65	PURCH_ORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
66	LOC_CURRCY	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
67	LOC_CURRCY_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
68	VENDOR_NO	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
69	INFO_REC	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
70	EXCHG_RATE	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
71	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
72	CURRENCY_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
73	BASIC_PURCHASE_PRICE	☐	EKPGR_BAPI	BAPICURR	DEC	23	4	Purchase Price (Basic Purchase Price) for BAPIs
74	PRICING_CURRENCY	☐	KAWAER	WAERS	CUKY	5	0	Sales Pricing: Pricing Currency	*
75	PRICING_CURRENCY_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
76	NET_NET_PURCHASE_PRICE	☐	EKPNN_BAPI	BAPICURR	DEC	23	4	Purchase Price (Net/Net) for BAPIs
77	CURRENT_MARKUP	☐	AUFSG_BAPI	BAPICURR	DEC	23	4	Markup in Sales Price Calculation for BAPIs
78	PLANNED_MARKUP	☐	PAUFS_BAPI	BAPICURR	DEC	23	4	Planned Markup for BAPIs
79	PLND_PR	☐	WRF_PPW_PENDP_BAPI	BAPICURR	DEC	23	4	Sales Price Costing: Planned Sales Price w/o Rndg for BAPIs
80	NET_SALES_PRICE	☐	VKPNE_BAPI	BAPICURR	DEC	23	4	Sales Price (Net) for BAPIs
81	SALES_CURRENCY	☐	VWAER	WAERS	CUKY	5	0	Sales currency	*
82	SALES_CURRENCY_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
83	PRICING_LEVEL	☐	KALEB	KALEB	CHAR	2	0	Sales Pricing: Pricing level
84	NET_MARGIN	☐	SPANE_BAPI	BAPICURR	DEC	23	4	Margin (Net) in the Sales Price Calculation for BAPIs
85	GROSS_MARGIN	☐	SPABR_BAPI	BAPICURR	DEC	23	4	Margin (Gross) in the Sales Price Calculation for BAPIs
86	CURRENT_SALES_PRICE	☐	ENDPA_BAPI	BAPICURR	DEC	23	4	Current Final Price for BAPIs
87	CURRENT_PRICING_LEVEL	☐	WRF_RPC_KALEA	KALEB	CHAR	2	0	Pricing Level of Current Final Price
88	CURRENT_NET_MARGIN	☐	SPANA_BAPI	BAPICURR	DEC	23	4	Current (Net) Margin for BAPIs
89	CURRENT_GROSS_MARGIN	☐	SPABA_BAPI	BAPICURR	DEC	23	4	Current Margin (Gross) for BAPIs
90	REDUCED_FROM_PRICE	☐	ROTPR_BAPI	BAPICURR	DEC	23	4	Sales Price Calculation: Reduced-From Price for BAPIs
91	CASH_PRICE	☐	MITPR_BAPI	BAPICURR	DEC	23	4	Sales Price Calculation: Cash Price for BAPIs
92	RECOMMENDED_PRICE	☐	EMPPR_BAPI	BAPICURR	DEC	23	4	Sales Price Calulation: Recommended Price for BAPIs
93	SUGGESTED_PRICE	☐	W_VORPR_BAPI	BAPICURR	DEC	23	4	Sales Price Calculation: Suggested Price for BAPIs
94	VAR_SP_1	☐	WRF_PPW_VKP01_BAPI	BAPICURR	DEC	23	4	Variable Sales Price 1 for BAPIs
95	VAR_SP_2	☐	WRF_PPW_VKP02_BAPI	BAPICURR	DEC	23	4	Variable Sales Price 2 for BAPIs
96	VAR_SP_3	☐	WRF_PPW_VKP03_BAPI	BAPICURR	DEC	23	4	Variable Sales Price 3 for BAPIs
97	VAR_PERC_1	☐	WRF_PPW_PROZ1_BAPI	BAPICURR	DEC	23	4	Sales Price Calculation: Variable Percentage 1 for BAPIs
98	VAR_PERC_2	☐	WRF_PPW_PROZ2_BAPI	BAPICURR	DEC	23	4	Sales Price Calculation: Variable Percentage 2 for BAPIs
99	BANK_DELETE	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
100	PP_DETERM_SEQUENCE	☐	EKERV_M	EKERV	CHAR	2	0	Purchase price determination sequence	*
101	PP_DETERM_TYPE	☐	EKERA	EKERA	CHAR	1	0	Purchase price determination type
102	SP_DETERM_SEQUENCE	☐	EKERV_V	EKERV	CHAR	2	0	Sales price determination sequence	*
103	SP_DETERM_TYPE	☐	VKERA	VKERA	CHAR	1	0	Sales price determination type
104	PRPNT_CAT	☐	EPTYP	EPTYP	CHAR	2	0	Price Point Category
105	RANK_TYPE	☐	WRF_RPC_RKTYP	WRF_RPC_RKTYP	CHAR	1	0	Price Point Groups: Ranking Type
106	FINAL_PRICE_NET	☐	WRF_PPW_ENDNE_BAPI	BAPICURR	DEC	23	4	Final Price (Net) for BAPIs
107	FINAL_PRICE_GROSS	☐	WRF_PPW_ENDBR_BAPI	BAPICURR	DEC	23	4	Final Price (Gross) for BAPIs
108	CURRENT_SALES_PRICE_NET	☐	WRF_PPW_ENDNA_BAPI	BAPICURR	DEC	23	4	Current Final Price (Net) for BAPIs
109	CURRENT_SALES_PRICE_GROSS	☐	WRF_PPW_ENDBA_BAPI	BAPICURR	DEC	23	4	Current Final Price (Gross) for BAPIs
110	INITIAL_PRICE	☐	WRF_PPW_INIPR_BAPI	BAPICURR	DEC	23	4	Original Price for BAPIs
111	NEW_PRCLVL	☐	WRF_PPW_NWLEV	XFELD	CHAR	1	0	Flag: New Pricing Level
112	HIER_NODE1_NAME	☐	WRF_MATGRP_TEXT1	TEXT40	CHAR	40	0	Short Text 1
113	HIER_NODE2_NAME	☐	WRF_MATGRP_TEXT02	TEXT40	CHAR	40	0	Name of a Node in an Article Hierarchy
114	HIER_NODE3_NAME	☐	WRF_MATGRP_TEXT3	TEXT40	CHAR	40	0	Description 3
115	HIER_NODE4_NAME	☐	WRF_MATGRP_TEXT4	TEXT40	CHAR	40	0	Name 4
116	HIER_NODE5_NAME	☐	WRF_MATGRP_TEXT5	TEXT40	CHAR	40	0	Name 5
117	HIER_NODE6_NAME	☐	WRF_MATGRP_TEXT6	TEXT40	CHAR	40	0	Name 6
118	HIER_NODE7_NAME	☐	WRF_MATGRP_TEXT7	TEXT40	CHAR	40	0	Name 7
119	HIER_NODE8_NAME	☐	WRF_MATGRP_TEXT8	TEXT40	CHAR	40	0	Name 8
120	HIER_NODE9_NAME	☐	WRF_MATGRP_TEXT9	TEXT40	CHAR	40	0	Name 9
121	HIER_NODE10_NAME	☐	WRF_MATGRP_TEXT10	TEXT40	CHAR	40	0	Name 10
122	ORD_DATE_VENDOR	☐	W_BEDAT	DATUM	DATS	8	0	Order date with vendor
123	REL_MPS	☐	WRF_PPW_SISTER	XFELD	CHAR	1	0	Related Markdown Proposals Exist
124	NO_DEP_MAT	☐	WRF_PPW_NO_OF_DEP_ART	NUMC3	NUMC	3	0	Number of Materials Dependent on Pricing Reference Material
125	NO_PLANTS	☐	WRF_PPW_NO_OF_STORES		DEC	6	0	Number of Plants Affected by a Price Change
126	REFERENCE_PRICE	☐	WRF_PPW_REFERENCE_PRICE_BAPI	BAPICURR	DEC	23	4	Reference Price to Calculate Budget in Prom. Proc. for BAPIs
127	MIN_PRICE	☐	WRF_PPW_MIN_VK_BAPI	BAPICURR	DEC	23	4	Minimum Price of Dependent Stores for BAPIs
128	PROCESSED	☐	WRF_PPW_AKTIV	XFELD	CHAR	1	0	Processed by Activation Report and Budgets (if Used) Updated
129	MG_DESCR_SHORT	☐	WGBEZ	TEXT20	CHAR	20	0	Material Group Description
130	DOC_NO	☐	KBELN	KBELN	CHAR	10	0	Number of pricing document	*
131	DOC_ITEM	☐	KBELP	KBELP	NUMC	5	0	Item Number of Pricing Document	*

History

Last changed by/on	SAP	20110901
SAP Release Created in	600