SAP table WRF_PPW_PPDPA_STY (PA Level Representation of a PPD)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
GUID Unique, Generated Key RAW 16 0 WRF_PPW_GUID
PARENT Parent RAW 16 0 WRF_PPW_PARENT
REFERENCE RAW 16 0
DEVI_PRICE Price Variance CHAR 1 0 WRF_PPW_DEVI_PRICE
SISTER Related Markdown Proposals Exist CHAR 1 0 WRF_PPW_SISTER
NO_OF_STORES Number of Plants Affected by a Price Change DEC 6 0 WRF_PPW_NO_OF_STORES
GUID_BG RAW 16 0
BUDGET_VP_ACCU Planned Budget for an Item in Price Planning CURR 13 2 WRF_PPW_BUDGET_VP
BG STRU 0 0 WRF_PPW_PPDBGPA_STY
BUDGET_NR Budget Number NUMC 16 0 WRF_PPW_BUDGET_NR
PROCESS_ID Budget ID NUMC 2 0 WRF_BUDG_PROC_ID
01 Budget ID 1
02 Budget ID 2
03 Budget ID 3
BUDGET_VP Planned Budget for an Item in Price Planning CURR 13 2 WRF_PPW_BUDGET_VP
DATE_FROM Validity Start Date of Budget Period DATS 8 0 WRF_PPW_DATE_FROM
DATE_TO Validity End Date of Budget Period DATS 8 0 WRF_PPW_DATE_TO
WAERS_BG Budget Currency CUKY 5 0 WRF_PPW_BGWAER
BUDGET_VP_REL Internally Released Budget CURR 13 2 WRF_PPW_BUDGET_VP_REL
BUDGET_VP_SOLD Budget from Sold Articles CURR 13 2 WRF_PPW_BUDGET_VP_SOLD
BG_TAB TTYP 0 0 WRF_PPW_PPDBGPA_TTY
GUID_STOCK RAW 16 0
STOCK STRU 0 0 WRF_PPW_PPDSTOCK_STY
STOCK Current Stock QUAN 17 3 WRF_PPW_STOCK
STOCK_IA Included Stock Quantity QUAN 17 3 WRF_PPW_STOCK_IA
STOCK_NIA Non-Included Stock Quantity QUAN 17 3 WRF_PPW_STOCK_NIA
STOCKUNIT Base Unit of Measure UNIT 3 0 WRF_PPW_STOCKUNIT
PLND_SALES_QTY Planned Quantity QUAN 13 3 WRF_PPW_PLAN_MENGE
STOCK_DIFF Stock Difference for Postprocessed Promotion PA Items QUAN 17 3 WRF_PPW_STOCK_DIFFERENCE
PLND_QTY_COMPL Total Planned Quantity QUAN 13 3 WRF_PPW_PLND_QTY_COMPLETE
GUID_MDP RAW 16 0
MDP STRU 0 0 WRF_PPW_PPDMDP_STY
ABV_SOLL Target Sales Ratio DEC 5 2 WRF_PPW_TARGSLSRTIO
ABV_IST Actual Sales Ratio DEC 5 2 WRF_PPW_ACTSLSRTIO
MDPRC Price Reduction as Percentage of Initial Price DEC 5 2 WRF_PPW_MDPRC
SELLPER Validity Period of Material According to Markdown Profile NUMC 4 0 WRF_PPW_SELLPER
MAXPER Validity Period of Markdown Profile NUMC 4 0 WRF_PPW_MAXPER
MDPROF Markdown Profile CHAR 10 0 WRF_PPW_MDPROF
GUID_AV Worklist GUID RAW 16 0 WRF_PPW_GUID_AV
RUN_NO Run Number RAW 16 0 WRF_PPW_RUN_NO
CALCITEM STRU 0 0 WRF_PPW_PPDCALCITEM_STY
GUID_CALC Unique, Generated Key RAW 16 0 WRF_PPW_GUID
MATNR Material Number CHAR 40 0 MATNR
VRKME Sales Unit UNIT 3 0 W_VRKME_VKP
EAN11 International Article Number (EAN/UPC) CHAR 18 0 EAN11
VKORG Sales Organization CHAR 4 0 VKORG
VTWEG Distribution Channel CHAR 2 0 VTWEG
WERKS Plant CHAR 4 0 WERKS_D
PLTYP Price List Type CHAR 2 0 PLTYP
BGINT Internal Class Number NUMC 10 0 CLINT
VKKAB Sales conditions valid from DATS 8 0 VKKAB
VKKBI Sales conditions valid to DATS 8 0 VKKBI
VKKAM Key date for sales price conditions DATS 8 0 VKKAM
VRKPE Sales price unit DEC 5 0 VRKPE
VLGWK Sales Pricing: Reference Plant CHAR 4 0 VLGWK
EKORG Purchasing organization CHAR 4 0 EKORG
HWAER Local Currency CUKY 5 0 HWAER
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
INFNR Number of purchasing info record CHAR 10 0 INFNR
KURST Exchange Rate Type CHAR 4 0 KURST
WAERS Currency Key CUKY 5 0 WAERS
EKPGR Purchase Price Calculation: (Basic Purchase Price) CURR 11 2 EKPGR
KWAER Sales Pricing: Pricing Currency CUKY 5 0 KAWAER
EKPNN Sales Pricing: Purchase Price (Net/Net) CURR 11 2 EKPNN
AUFSG Actual Markup in Sales Price Calculation CURR 11 2 AUFSG
PAUFS Planned markup CURR 11 2 PAUFS
PENDP SP calculation: Planned sales pr. w/o price point rounding CURR 11 2 PENDP
VKPNE Sales price (net) CURR 11 2 VKPNE
VKPBR Sales price (gross) CURR 11 2 VKPBR
VWAER Sales currency CUKY 5 0 VWAER
ENDPR Final price CURR 11 2 ENDPR
KALEB Sales Pricing: Pricing level CHAR 2 0 KALEB
01 Distribution Chain
02 Plant
03 Price list
SPANE Margin (net) in sales price calculation CURR 11 2 SPANE
SPABR Margin (gross) in sales price calculation CURR 11 2 SPABR
ENDPA Current Final Price CURR 11 2 ENDPA
KALEA Pricing Level of Current Final Price CHAR 2 0 WRF_RPC_KALEA
SPANA Current margin (net) CURR 11 2 SPANA
SPABA Current margin (gross) CURR 11 2 SPABA
ROTPR Reduced-from price CURR 11 2 ROTPR
MITPR Cash price CURR 11 2 MITPR
EMPPR Recommended price CURR 11 2 EMPPR
VORPR Sales Pricing: Suggested Price CURR 11 2 W_VORPR
VKP01 Variable Sales Price 1 CURR 11 2 WRF_RPC_VKP01
VKP02 Variable Sales Price 2 CURR 11 2 WRF_RPC_VKP02
VKP03 Variable Sales Price 3 CURR 11 2 WRF_RPC_VKP03
PROZ1 SP Calculation: Variable Percentage 1 CURR 11 2 WRF_RPC_PROZ1
PROZ2 SP Calculation: Variable Percentage 2 CURR 11 2 WRF_RPC_PROZ2
MPROZ Pricing: Price Change in Percent CURR 11 2 MPROZ
LOEVM Deletion Indicator CHAR 1 0 LOEVM
EKERV Purchase Price Determination Sequence CHAR 2 0 EKERV_M
EKERA Purchase price determination type CHAR 1 0 EKERA
A PP determination with schema as in standard schema determin.
B PP determination with specified special schema
C PP determination using customer-defined function module
D Interactive entry
E PP determination from material components (sales set)
F Supplier mixed price
VKERV Sales Price Determination Sequence CHAR 2 0 EKERV_V
VKERA Sales price determination type CHAR 1 0 VKERA
A Calculate sales price from planned markup
B Use current sales price, adjust margin
C Copy sales price from list field
D Percentage price change relating to list field
E Absolute price change relating to list field
EPTYP Price Point Category CHAR 2 0 EPTYP
01 Final price
02 Retail price (for wholesalers only)
11 Markdown Planning Final Price
21 Promotion Final Price
RKTYP Price Point Groups: Ranking Type CHAR 1 0 WRF_RPC_RKTYP
A Default
B Alternative
EPRGR Price point group CHAR 6 0 EPRGR
PVGRD Reason for retail price change CHAR 4 0 PV_GRUND
ENDNE Final Price (Net) CURR 11 2 WRF_PPW_ENDNE
ENDBR Final Price (Gross) CURR 11 2 WRF_PPW_ENDBR
ENDPA_PROMO Current Promotion Sales Price CURR 11 2 WRF_PPW_ENDPA_PROMO
ENDNA Current Final Price (Net) CURR 11 2 WRF_PPW_ENDNA
ENDBA Current Final Price (Gross) CURR 11 2 WRF_PPW_ENDBA
MABSO Absolute Price Change in Relation to Current Final Price CURR 11 2 WRF_PPW_MABSO
NABSO Absolute Net Price Change in Relation to Current Final Price CURR 11 2 WRF_PPW_NABSO
INIAM Sales price calculations: key date for initial price DATS 8 0 W_INIAM
INIPR Original Price CURR 11 2 WRF_PPW_INIPR
IPROZ Percentage Price Change in Relation to Original Price CURR 11 2 WRF_PPW_IPROZ
IABSO Absolute Price Change in Relation to Original Price CURR 11 2 WRF_PPW_IABSO
EPROZ Percentage Price Change (Compared to Last Final Price) CURR 11 2 WRF_PPW_EPROZ
EABSO Absolute Price Change (Compared to Last Final Price) CURR 11 2 WRF_PPW_EABSO
PPROZ Percentage Price Change (Compared to Planned Final Price) CURR 11 2 WRF_PPW_PPROZ
PABSO Absolute Price Change (Comp. to Last Final Price) CURR 11 2 WRF_PPW_PABSO
NWLEV Flag: New Pricing Level CHAR 1 0 WRF_PPW_NWLEV
ENDPA_PROMO_CHECKED Checkbox CHAR 1 0 XFELD
No
X Yes
DEC_POS Technical currency (3 decimal places) CUKY 5 0 WAERST
RECAL Indicator: Redetermine Prices CHAR 1 0 WRF_PPW_RECAL
ROUND Rounding Category CHAR 1 0 WRF_PPW_ROUND
DECPL ABAP Dictionary: Two-Digit Numeric Field NUMC 2 0 NUM02
BONKZ Sales Pricing: Indicator - Is Final Price Net or Gross Price CHAR 1 0 W_BONKZ_KALP
NEPGR Indicator: No Price Point Group CHAR 1 0 NEPGR
PMATN Pricing Reference Material CHAR 40 0 PMATN
SATNR Material Number of the Generic Material CHAR 40 0 WSTR_SATNR
KBELN Number of pricing document CHAR 10 0 KBELN
KBELP Item Number of Pricing Document NUMC 5 0 KBELP
KBELN_COPY Number of pricing document CHAR 10 0 KBELN
KBELP_COPY Item Number of Pricing Document NUMC 5 0 KBELP
KNUMH_V Number of the sales price condition record CHAR 10 0 KNUMH_V
BPSTA Pricing: Status of Item in Pricing Document CHAR 1 0 BPSTA
A New, not saved
B Changed, not saved
C Saved
D Flagged for Deletion
E Cancelled
SUBRC Subroutines for return code NUMC 2 0 SUBRC
HERKU Origin of Pricing Document CHAR 1 0 W_HERKU
GUID_VERS RAW 16 0
TIMEST_CALC Time Stamp for Creating Costing Data CHAR 14 0 WRF_PPW_TIMEST_CALC
FILGR Local Plant Groups CHAR 18 0 WRF_PPW_FILGR
REFSITE_VK Int. Calculation: Price of Reference Store CURR 11 2 WRF_PPW_REFSITE_VK
WEIGH_AVERAGE_VK Int. Calculation: Median Weighted Sales Price of Assg. Store CURR 11 2 WRF_PPW_WEIGHTED_AVERAGE_VK
AVERAGE_VK Int. Calculation: Median Sales Price of Assigned Stores CURR 11 2 WRF_PPW_AVERAGE_VK
MIN_VK Minimum Price for Dependent Stores CURR 11 2 WRF_PPW_MIN_VK
REFERENCE_PRICE Reference Price for Calculating Budget in Promotion Process CURR 11 2 WRF_PPW_REFERENCE_PRICE
SORTKEY_PA Sort Key for Price Activation Levels CHAR 22 0 WRF_PPW_SORTKEY_PA
AKTIV Processed by Activation Report and Budgets (if Used) Updated CHAR 1 0 WRF_PPW_AKTIV
DEVI_PRICE_EXIST Flag: Price Variances Exist CHAR 1 0 WRF_PPW_DEVI_PRICE_EXIST
LOEKZ Deletion Indicator CHAR 1 0 WRF_PPW_LOEKZ
PROMO_CHANGED Flag for Subsequent Change of a Promotion CHAR 1 0 WRF_PPW_PROMO_CHANGED
Item Was Not Corrected
1 Corrected Item of Original Version (Version 00)
2 Corrected Item of New Version (Version 01)
DEAKT Price Plan Item Was Deactivated CHAR 1 0 WRF_PPW_DEAKT
BUDGET_VP_ACCU_REL Internally Released Budget CURR 13 2 WRF_PPW_BUDGET_VP_REL
REFSITE_VK_ORIG Int. Calculation: Price of Reference Store CURR 11 2 WRF_PPW_REFSITE_VK
WEIGH_AVRG_VK_OR Int. Calculation: Median Weighted Sales Price of Assg. Store CURR 11 2 WRF_PPW_WEIGHTED_AVERAGE_VK
AVERAGE_VK_ORIG Int. Calculation: Median Sales Price of Assigned Stores CURR 11 2 WRF_PPW_AVERAGE_VK
BUDGET_VP_ACCU_SOLD Budget from Sold Articles CURR 13 2 WRF_PPW_BUDGET_VP_SOLD