SAP Table WRF_PPW_PPDPRICEINFO_STY

Representation of Prices with Their Validity Per. of a PPD

WRF_PPW_PPDPRICEINFO_STY (Representation of Prices with Their Validity Per. 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_PPDPRICEINFO_STY to other SAP tables.

WRF_PPW_PPDPRICEINFO_STY table fields

Field Data element Checktable Datatype Length Decimals
GUID_CALC Unique, Generated Key WRF_PPW_GUID RAW 16 0
PARENT_CALC Parent WRF_PPW_PARENT RAW 16 0
REFERENCE_CALC Unique, Generated Key WRF_PPW_GUID 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
FILGR Local Plant Groups WRF_PPW_FILGR CHAR 18 0
TIMEST_CALC Time Stamp for Creating Costing Data WRF_PPW_TIMEST_CALC CHAR 14 0
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 Weighted Sales Price of Assg. Store WRF_PPW_WEIGHTED_AVERAGE_VK 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
LOEKZ Deletion Indicator WRF_PPW_LOEKZ CHAR 1 0
X Yes
NULL No