SAP table WPFGR (Family Pricing: Defintion of Family Groups)

SAP table WPFGR has 3 primary key fields being MANDT,FAMNR,GRP01.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
FAMNR Identification Number for Price Family CHAR 10 0 WPFAM WPF_FAMNR
GRP01 Number of a Family Group in a Price Family CHAR 10 0 WPF_GROUP
RMATN Price Family: Reference Material of Family Group CHAR 40 0 MARA WPF_RMATN
VRKME Sales Unit UNIT 3 0 T006 W_VRKME_VKP
MODKZ Price Family: Indicator for Permitted Price Change CHAR 1 0 WPF_MODKZ
No price change allowed
1 Price change only allowed at family group level
2 Price change allowed for family group and materials
GPRKZ Price Group Rounding Allowed for Family Grp of Price Family CHAR 1 0 WPF_GPRKZ
PRELS Price Family: Indicator for Price Relationship CHAR 1 0 WPF_PRELS
1 Percentage Price Relationship
2 Absolute Price Interval
KBETR Amount for the Price Relationship for a Family Group CURR 11 2 KBETR_PRELS
KONWA Condition Unit (Currency or Percentage) CUKY 5 0 TCURC KONWA
OLDFL Different Dist.-Chain-Specific Price Relationship (X = Yes) CHAR 1 0 WPF_OLDFL

WPFGR foreign key relationships

Table Field Check Table Check Field
0 WPFGR FAMNR WPFAM Family Pricing: Definition of Families MANDT
0 WPFGR FAMNR WPFAM Family Pricing: Definition of Families FAMNR
1 WPFGR KONWA TCURC Currency Codes MANDT
1 WPFGR KONWA TCURC Currency Codes WAERS
0 WPFGR MANDT T000 Clients MANDT
1 WPFGR RMATN MARA General Material Data MATNR
0 WPFGR VRKME T006 Units of Measurement MANDT
0 WPFGR VRKME T006 Units of Measurement MSEHI