1. Home
  2. Resources
  3. SAP Tables
  4. WRF_PPW_PPDPA_STY - PA Level Representation of a PPD

SAP Table WRF_PPW_PPDPA_STY

PA Level Representation of a PPD

WRF_PPW_PPDPA_STY (PA Level Representation of a PPD) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link WRF_PPW_PPDPA_STY to other SAP tables.

Source: WRF_PPW_PPDPA_STY (PA Level Representation of a PPD)

WRF_PPW_PPDPA_STY table fields

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