WRF6
Plant / material group
WRF6 is an SAP database table in S/4HANA. Plant / material group. It contains 17 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_SiteProductGroup | view | from | BASIC | Product Group Assignment to Site |
Fields (17)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | locnr | kunnr | Customer | |||
| KEY | matkl | matkl | Material Group | |||
| sstuf | sstuf | Assortm. Grade | ||||
| sorbr | w_sorbr | Astmt length | ||||
| abtnr | abtnr | Department | ||||
| priot | w_pflkn | Int.astmt prio. | ||||
| dispr | dispr | MRP profile | ||||
| propr | propr | Forecast Prof. | ||||
| primw | primw | Pr. incl. tax | ||||
| uprof | uprof_d | Rev.profile | ||||
| wdaus | wdaus | POS exclusion | ||||
| rqgrp | wrreqgrp | Req.group | ||||
| fbpro | fbeintprof | StorProcProfile | ||||
| pltyp_p | pltyp_p | Price list/item | ||||
| pstra | pstra | Pricing strategy | ||||
| mgint | mgint | Int class no. |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Plant / material group
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRF6 (
MANDT, -- Client [mandt]
LOCNR, -- Customer [kunnr]
MATKL, -- Material Group [matkl]
SSTUF, -- Assortm. Grade [sstuf]
SORBR, -- Astmt length [w_sorbr]
ABTNR, -- Department [abtnr]
PRIOT, -- Int.astmt prio. [w_pflkn]
DISPR, -- MRP profile [dispr]
PROPR, -- Forecast Prof. [propr]
PRIMW, -- Pr. incl. tax [primw]
UPROF, -- Rev.profile [uprof_d]
WDAUS, -- POS exclusion [wdaus]
RQGRP, -- Req.group [wrreqgrp]
FBPRO, -- StorProcProfile [fbeintprof]
PLTYP_P, -- Price list/item [pltyp_p]
PSTRA, -- Pricing strategy [pstra]
MGINT, -- Int class no. [mgint]
PRIMARY KEY (MANDT, LOCNR, MATKL)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA