SAP WRF6 Plant / material group Table

Overview

WRF6 is a standard SAP S/4HANA table that stores Plant / material group data. There are total 17 fields in the WRF6 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table WRF6 belongs to Sites (LO-RFM-MD-SIT) module and is located in the package IS-R: Store master (WFIL).

In addition, following links provide an overview of foreign key relationships, if any, that link WRF6 to other SAP tables and standard CDS views available based on WRF6 table in S/4HANA 2020.

Techincal Settings of WRF6

Below are technical details of the table WRF6

  • Buffering allowed but switched off
  • No buffering
  • Storage type is Column Store

List of WRF6 Fields

The following table gives you an overview of the fields available in WRF6

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
LOCNRCustomer NumberKUNNRKNA1CHAR10
MATKLMaterial GroupMATKLT023CHAR9
SSTUFAssortment gradeSSTUFTWSSCHAR2
SORBRAssortment lengthW_SORBRNUMC13
ABTNRDepartment numberABTNRTSABCHAR4
PRIOTAssortment PriorityW_PFLKNTWSPCHAR1
DISPRMaterial: MRP profileDISPRMDIPCHAR4
PROPRForecast profilePROPRMPRPCHAR4
PRIMWPrice including sales taxPRIMWCHAR1
UPROFRetail revalution profileUPROF_DTWUPCHAR4
WDAUSExclude material group from POS outbound processingWDAUSCHAR1
RQGRPReplenishment: requirement groupWRREQGRPTWRPPCHAR2
FBPROStore procurement profile for store order replenishmentFBEINTPROFTWPISCHAR4
PLTYP_PPrice determination: Item-based price list typePLTYP_PT189CHAR2
PSTRASales Pricing: Pricing StrategyPSTRATWPSCHAR2
MGINTInternal class number of competitor groupMGINTKLAHNUMC10

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WRF6

Table NameFieldCardinalityCheck Table
WRF6ABTNR1: CNTSAB
WRF6DISPR1: CNMDIP
WRF6FBPRO1: CNTWPIS
WRF6LOCNR1: CNKNA1
WRF6MANDT1: CNT000
WRF6MATKL1: CNT023
WRF6MGINT1: CNKLAH
WRF6PLTYP_P1: CNT189
WRF6PRIOTC: CNTWSP
WRF6PROPR1: CNMPRP
WRF6PSTRA1: CNTWPS
WRF6RQGRPC: CNTWRPP
WRF6SSTUF1: CNTWSS
WRF6UPROF:TWUP

Other References