WRF_PPW_PPDFCDEVIANTPRICES_STY SAP (Field Catalog to Maintain Org. Levels with Own Prices) Structure details

Dictionary Type: Structure
Description: Field Catalog to Maintain Org. Levels with Own Prices




ABAP Code to SELECT data from WRF_PPW_PPDFCDEVIANTPRICES_STY
Related tables to WRF_PPW_PPDFCDEVIANTPRICES_STY
Access table WRF_PPW_PPDFCDEVIANTPRICES_STY




Structure field list including key, data, relationships and ABAP select examples

WRF_PPW_PPDFCDEVIANTPRICES_STY is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Field Catalog to Maintain Org. Levels with Own Prices" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_WRF_PPW_PPDFCDEVIANTPRICES_STY TYPE WRF_PPW_PPDFCDEVIANTPRICES_STY.

The WRF_PPW_PPDFCDEVIANTPRICES_STY table consists of various fields, each holding specific information or linking keys about Field Catalog to Maintain Org. Levels with Own Prices data available in SAP. These include FLAG_SORT_RED (General Flag), FLAG_SORT_YELLOW (General Flag), FLAG_SORT_GREEN (General Flag), FLAG_SORT_INACTIVE (General Flag).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP WRF_PPW_PPDFCDEVIANTPRICES_STY structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
ICON_PRICE_RISEIcon in text fields (substitute display, alias) ICON_DCHAR4Assigned to domainICON
FLAG_SORT_REDGeneral Flag FLAGCHAR1FLAG
FLAG_SORT_YELLOWGeneral Flag FLAGCHAR1FLAG
FLAG_SORT_GREENGeneral Flag FLAGCHAR1FLAG
FLAG_SORT_INACTIVEGeneral Flag FLAGCHAR1FLAG
ENDPR_NEWFinal Price of the Superordinate Organization Level WRF_PPW_ENDPR_FUTURECURR11(2) WERTV6
BEQUEST_LEVELSuperordinate Organization Level WRF_PPW_BEQUEST_LEVELCHAR10CHAR10
MANDTClient MANDTCLNT3Assigned to domainMANDT
GUIDUnique, Generated Key WRF_PPW_GUIDRAW16
PARENTParent WRF_PPW_PARENTRAW16
REFERENCE GUID of PA Entry to Which This Item Refers0
DEVI_PRICEPrice Variance WRF_PPW_DEVI_PRICECHAR1XFELD
SISTERRelated Markdown Proposals Exist WRF_PPW_SISTERCHAR1XFELD
NO_OF_STORESNumber of Plants Affected by a Price Change WRF_PPW_NO_OF_STORESDEC6
SAISOSeason WRF_PPW_SAISOCHAR6PERIOD
SAISJSeason Year WRF_PPW_SAISJCHAR4GJAHRCJAHR
FASHGRDFashion Grade WRF_PPW_FASHGRDCHAR4
SAITYRollout WRF_PPW_SAITYCHAR2
ATTYPMaterial Category WRF_PPW_ATTYPCHAR2ATTYP
NODE01Hierarchy Node 1 WRF_HIER_NODE1CHAR18WRF_CM_CDT
NODE02Hierarchy Node 2 WRF_HIER_NODE2CHAR18WRF_CM_CDT
NODE03Hierarchy Node 3 WRF_HIER_NODE3CHAR18WRF_CM_CDT
NODE04Hierarchy Node 4 WRF_HIER_NODE4CHAR18WRF_CM_CDT
NODE05Hierarchy Node 5 WRF_HIER_NODE5CHAR18WRF_CM_CDT
NODE06Hierarchy Node 6 WRF_HIER_NODE6CHAR18WRF_CM_CDT
NODE07Hierarchy Node 7 WRF_HIER_NODE7CHAR18WRF_CM_CDT
NODE08Hierarchy Node 8 WRF_HIER_NODE8CHAR18WRF_CM_CDT
NODE09Hierarchy Node 9 WRF_HIER_NODE9CHAR18WRF_CM_CDT
NODE10Hierarchy Node 10 WRF_HIER_NODE10CHAR18WRF_CM_CDT
NODE01_TShort Text 1 WRF_MATGRP_TEXT1CHAR40TEXT40WRF_NODE_STRUC
NODE02_TName of a Node in an Article Hierarchy WRF_MATGRP_TEXT02CHAR40TEXT40WRF_NODE_STRCT
NODE03_TDescription 3 WRF_MATGRP_TEXT3CHAR40TEXT40WRF_NODE_STRCT
NODE04_TName 4 WRF_MATGRP_TEXT4CHAR40TEXT40WRF_NODE_STRUC
NODE05_TName 5 WRF_MATGRP_TEXT5CHAR40TEXT40WRF_NODE_STRUC
NODE06_TName 6 WRF_MATGRP_TEXT6CHAR40TEXT40WRF_NODE_STRUC
NODE07_TName 7 WRF_MATGRP_TEXT7CHAR40TEXT40WRF_NODE_STRUC
NODE08_TName 8 WRF_MATGRP_TEXT8CHAR40TEXT40WRF_NODE_STRUC
NODE09_TName 9 WRF_MATGRP_TEXT9CHAR40TEXT40WRF_NODE_STRUC
NODE10_TName 10 WRF_MATGRP_TEXT10CHAR40TEXT40WRF_NODE_STRUC
MTARTMaterial Type MTARTCHAR4Assigned to domainMTARTMTA
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
DEP_ARTDependent Material Exists for Pricing Reference Material WRF_PPW_DEP_ARTCHAR1XFELD
DEAKTPrice Plan Item Was Deactivated WRF_PPW_DEAKTCHAR1XFELD
NO_OF_DEP_ARTNumber of Materials Dependent on Pricing Reference Material WRF_PPW_NO_OF_DEP_ARTNUMC3NUMC3
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
WGBEZMaterial Group Description WGBEZCHAR20TEXT20
BUDGET_NRBudget Number WRF_PPW_BUDGET_NRNUMC16
PROCESS_IDBudget ID WRF_BUDG_PROC_IDNUMC2WRF_BUDG_PROC_ID
BUDGET_VPPlanned Budget for an Item in Price Planning WRF_PPW_BUDGET_VPCURR13(2) WRF_PPW_BUDGET
DATE_FROMValidity Start Date of Budget Period WRF_PPW_DATE_FROMDATS8DATUM
DATE_TOValidity End Date of Budget Period WRF_PPW_DATE_TODATS8DATUM
WAERS_BGBudget Currency WRF_PPW_BGWAERCUKY5TCURCWAERS
BUDGET_VP_RELInternally Released Budget WRF_PPW_BUDGET_VP_RELCURR13(2) WRF_PPW_BUDGET
BUDGET_VP_SOLDBudget from Sold Articles WRF_PPW_BUDGET_VP_SOLDCURR13(2) WRF_PPW_BUDGET
STOCKCurrent Stock WRF_PPW_STOCKQUAN17(3) WRF_PPW_STOCK
STOCK_IAIncluded Stock Quantity WRF_PPW_STOCK_IAQUAN17(3)
STOCK_NIANon-Included Stock Quantity WRF_PPW_STOCK_NIAQUAN17(3)
STOCKUNITBase Unit of Measure WRF_PPW_STOCKUNITUNIT3Assigned to domainCUNITMEINS
PLND_SALES_QTYPlanned Quantity WRF_PPW_PLAN_MENGEQUAN13(3) MENGE
STOCK_DIFFStock Difference for Postprocessed Promotion PA Items WRF_PPW_STOCK_DIFFERENCEQUAN17(3) WRF_PPW_STOCK
ABV_SOLLTarget Sales Ratio WRF_PPW_TARGSLSRTIODEC5(2) WRF_PPW_PROCENT
ABV_ISTActual Sales Ratio WRF_PPW_ACTSLSRTIODEC5(2) WRF_PPW_PROCENT
MDPRCPrice Reduction as Percentage of Initial Price WRF_PPW_MDPRCDEC5(2) WRF_PPW_PROCENT
SELLPERValidity Period of Material According to Markdown Profile WRF_PPW_SELLPERNUMC4
MAXPERValidity Period of Markdown Profile WRF_PPW_MAXPERNUMC4
MDPROFMarkdown Profile WRF_PPW_MDPROFCHAR10WRF_SSMPROF
GUID_AVWorklist GUID WRF_PPW_GUID_AVRAW16
RUN_NORun Number WRF_PPW_RUN_NORAW16
GUID_CALCUnique, Generated Key WRF_PPW_GUIDRAW16
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
VRKMESales Unit W_VRKME_VKPUNIT3Assigned to domainCUNITMEINS
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
PLTYPPrice list type PLTYPCHAR2Assigned to domainPLTYPVPL
BGINTInternal Class Number CLINTNUMC10Assigned to domainCLINT
VKKABSales conditions valid from VKKABDATS8DATUM
VKKBISales conditions valid to VKKBIDATS8DATUM
VKKAMKey date for sales price conditions VKKAMDATS8DATUM
VRKPESales price unit VRKPEDEC5DEC5
VLGWKSales Pricing: Reference Plant VLGWKCHAR4Assigned to domainWERKSWRK
EKORGPurchasing Organization EKORGCHAR4Assigned to domainEKORGEKO
HWAERLocal Currency HWAERCUKY5Assigned to domainWAERS
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
INFNRNumber of Purchasing Info Record INFNRCHAR10Assigned to domainALPHAINFNRINFMEIN_C
KURSTExchange Rate Type KURSTCHAR4Assigned to domainKURSTKUT
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
EKPGRPurchase Price Calculation: (Basic Purchase Price) EKPGRCURR11(2) WERTV6
KWAERSales Pricing: Pricing Currency KAWAERCUKY5Assigned to domainWAERS
EKPNNSales Pricing: Purchase Price (Net/Net) EKPNNCURR11(2) WERTV6
AUFSGActual Markup in Sales Price Calculation AUFSGCURR11(2) WERTV6
PAUFSPlanned markup PAUFSCURR11(2) WERTV6
PENDPSP calculation: Planned sales pr. w/o price point rounding PENDPCURR11(2) WERTV6
VKPNESales price (net) VKPNECURR11(2) WERTV6
VKPBRSales price (gross) VKPBRCURR11(2) WERTV6
VWAERSales currency VWAERCUKY5Assigned to domainWAERS
ENDPRFinal price ENDPRCURR11(2) WERTV6
KALEBSales Pricing: Pricing level KALEBCHAR2KALEB
SPANEMargin (net) in sales price calculation SPANECURR11(2) WERTV6
SPABRMargin (gross) in sales price calculation SPABRCURR11(2) WERTV6
ENDPACurrent Final Price ENDPACURR11(2) WERTV6
KALEAPricing Level of Current Final Price WRF_RPC_KALEACHAR2KALEB
SPANACurrent margin (net) SPANACURR11(2) WERTV6
SPABACurrent margin (gross) SPABACURR11(2) WERTV6
ROTPRReduced-from price ROTPRCURR11(2) WERTV6
MITPRCash price MITPRCURR11(2) WERTV6
EMPPRRecommended price EMPPRCURR11(2) WERTV6
VORPRSales Pricing: Suggested Price W_VORPRCURR11(2) WERTV6
VKP01Variable Sales Price 1 WRF_RPC_VKP01CURR11(2) WERTV6
VKP02Variable Sales Price 2 WRF_RPC_VKP02CURR11(2) WERTV6
VKP03Variable Sales Price 3 WRF_RPC_VKP03CURR11(2) WERTV6
PROZ1SP Calculation: Variable Percentage 1 WRF_RPC_PROZ1CURR11(2) WERTV6
PROZ2SP Calculation: Variable Percentage 2 WRF_RPC_PROZ2CURR11(2) WERTV6
MPROZPricing: Price Change in Percent MPROZCURR11(2) WERTV6
LOEVMDeletion Indicator LOEVMCHAR1XFELD
EKERVPurchase price determination sequence EKERV_MCHAR2Assigned to domainEKERVEVM
EKERAPurchase price determination type EKERACHAR1EKERA
VKERVSales price determination sequence EKERV_VCHAR2Assigned to domainEKERVEVV
VKERASales price determination type VKERACHAR1VKERA
EPTYPPrice Point Category EPTYPCHAR2EPTYP
RKTYPPrice Point Groups: Ranking Type WRF_RPC_RKTYPCHAR1WRF_RPC_RKTYP
EPRGRPrice point group EPRGRCHAR6TWPKEPRGREPG
PVGRDReason for retail price change PV_GRUNDCHAR4TWBNALPHAPV_GRUNDPVGRD
ENDNEFinal Price (Net) WRF_PPW_ENDNECURR11(2) WERTV6
ENDBRFinal Price (Gross) WRF_PPW_ENDBRCURR11(2) WERTV6
ENDPA_PROMOCurrent Promotion Sales Price WRF_PPW_ENDPA_PROMOCURR11(2) WERTV6
ENDNACurrent Final Price (Net) WRF_PPW_ENDNACURR11(2) WERTV6
ENDBACurrent Final Price (Gross) WRF_PPW_ENDBACURR11(2) WERTV6
MABSOAbsolute Price Change in Relation to Current Final Price WRF_PPW_MABSOCURR11(2) WERTV6
NABSOAbsolute Net Price Change in Relation to Current Final Price WRF_PPW_NABSOCURR11(2) WERTV6
INIAMSales price calculations: key date for initial price W_INIAMDATS8DATUM
INIPROriginal Price WRF_PPW_INIPRCURR11(2) WERTV6
IPROZPercentage Price Change in Relation to Original Price WRF_PPW_IPROZCURR11(2) WERTV6
IABSOAbsolute Price Change in Relation to Original Price WRF_PPW_IABSOCURR11(2) WERTV6
EPROZPercentage Price Change (Compared to Last Final Price) WRF_PPW_EPROZCURR11(2) WERTV6
EABSOAbsolute Price Change (Compared to Last Final Price) WRF_PPW_EABSOCURR11(2) WERTV6
PPROZPercentage Price Change (Compared to Planned Final Price) WRF_PPW_PPROZCURR11(2) WERTV6
PABSOAbsolute Price Change (Comp. to Last Final Price) WRF_PPW_PABSOCURR11(2) WERTV6
NWLEVFlag: New Pricing Level WRF_PPW_NWLEVCHAR1XFELD
ENDPA_PROMO_CHECKEDCheckbox XFELDCHAR1XFELD
DEC_POSTechnical currency (3 decimal places) WAERSTCUKY5Assigned to domainWAERS
RECALIndicator: Redetermine Prices WRF_PPW_RECALCHAR1FLAG
ROUNDRounding Category WRF_PPW_ROUNDCHAR1FLAG
DECPLABAB Dictionary: Two-Digit Numeric Field NUM02NUMC2NUM02
BONKZSales Pricing: Indicator - Is Final Price Net or Gross Price W_BONKZ_KALPCHAR1XFELD
NEPGRIndicator: No Price Point Group NEPGRCHAR1XFELD
PMATNPricing Reference Material PMATNCHAR18Assigned to domainMATN1MATNRMAT
SATNRMaterial Number of the Generic Material WSTR_SATNRCHAR18Assigned to domainMATN1MATNRWMPPGEN
KBELNNumber of pricing document KBELNCHAR10Assigned to domainALPHAKBELN
KBELPItem Number of Pricing Document KBELPNUMC5Assigned to domainKBELP
KBELN_COPYNumber of pricing document KBELNCHAR10Assigned to domainALPHAKBELN
KBELP_COPYItem Number of Pricing Document KBELPNUMC5Assigned to domainKBELP
KNUMH_VNumber of the sales price condition record KNUMH_VCHAR10KNUMB
BPSTAPricing: Status of Item in Pricing Document BPSTACHAR1BPSTA
SUBRCSubroutines for return code SUBRCNUMC2EK08R_RC
HERKUOrigin of Pricing Document W_HERKUCHAR1W_ARCH
ICON_BUDGETBudget Status WRF_PPW_ICON_BUDGETCHAR4Assigned to domainICON
ICON_DEP_ARTDisplay 'Dependent Material Exists' as Icon WRF_PPW_ICON_DEP_ARTCHAR4Assigned to domainICON
ICON_DEVI_PRICEOrganization Levels with Own Prices Exist WRF_PPW_ICON_DEVI_PRICECHAR4Assigned to domainICON
ICON_SISTERDisplay 'Related Markdown Proposals Exist' as Icon WRF_PPW_ICON_SISTERCHAR4Assigned to domainICON
LOEKZAsset class marked for deletion LOEKZCHAR1XFELD
DEVI_PRICE_EXISTFlag: Price Variances Exist WRF_PPW_DEVI_PRICE_EXISTCHAR1CHAR1
FILGRLocal Plant Groups WRF_PPW_FILGRCHAR18
TEXT_WERKSName for Plant WRF_PPW_TEXT_WERKSCHAR20TEXT20
TEXT_PLTYPName for Price List WRF_PPW_TEXT_PLTYPCHAR20TEXT20
TEXT_VKORGName for Sales Organization WRF_PPW_TEXT_VKORGCHAR20TEXT20
TEXT_VTWEGName for Distribution Channel WRF_PPW_TEXT_VTWEGCHAR20TEXT20
AKTIVProcessed by Activation Report and Budgets (if Used) Updated WRF_PPW_AKTIVCHAR1XFELD
PROMO_CHANGEDFlag for Subsequent Change of a Promotion WRF_PPW_PROMO_CHANGEDCHAR1WRF_PPW_PROMO_CHANGED
PROCESS_TEXTName of a Process ID WRF_PPW_PROCESS_TEXTCHAR80CHAR80
BUDG_TEXTName of a Budget in Price Planning WRF_PPW_BUDG_TEXTCHAR80CHAR80
PLND_QTY_COMPLTotal Planned Quantity WRF_PPW_PLND_QTY_COMPLETEQUAN13(3) MENGE
REFERENCE_PRICEReference Price for Calculating Budget in Promotion Process WRF_PPW_REFERENCE_PRICECURR11(2) WERTV6
MIN_VKMinimum Price for Dependent Stores WRF_PPW_MIN_VKCURR11(2)
WRF_PPW_PLND_SALES_QTYPlanned Quantity WRF_PPW_PLND_SALES_QTYQUAN13
CT 0
CELLTAB 0

Key field Non-key field



How do I retrieve data from SAP structure WRF_PPW_PPDFCDEVIANTPRICES_STY using ABAP code?

As WRF_PPW_PPDFCDEVIANTPRICES_STY is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on WRF_PPW_PPDFCDEVIANTPRICES_STY as there is no data to select.

How to access SAP table WRF_PPW_PPDFCDEVIANTPRICES_STY

Within an ECC or HANA version of SAP you can also view further information about WRF_PPW_PPDFCDEVIANTPRICES_STY and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!