SAP WRF1 Plant data Table
Overview
WRF1 is a standard SAP S/4HANA table that stores Plant data data. There are total 70 fields in the WRF1 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRF1 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 WRF1 to other SAP tables and standard CDS views available based on WRF1 table in S/4HANA 2020.
Techincal Settings of WRF1
Below are technical details of the table WRF1
- Buffering allowed but switched off
- No buffering
- Storage type is Column Store
List of WRF1 Fields
The following table gives you an overview of the fields available in WRF1
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| LOCNR | Customer Number | KUNNR | KNA1 | CHAR | 10 |
| EROED | Opening Date | EROED | DATS | 8 | |
| SCHLD | Closing Date | SCHLD | DATS | 8 | |
| SPDAB | Block from | SPDAB | DATS | 8 | |
| SPDBI | Block to | SPDBI | DATS | 8 | |
| AUTOB | Automatic purchase order | AUTOB | CHAR | 1 | |
| KOPRO | POS Outbound Profile | POSKOPRO | TWPFI | CHAR | 4 |
| LAYVR | Layout | LAYVAR | TWGV | CHAR | 10 |
| FLVAR | Area schema | FLVAR | TWGF | CHAR | 4 |
| STFAK | Calendar | STKAL | TFACD | CHAR | 2 |
| WANID | Goods receiving hours ID (default value) | WANID | TVWA | CHAR | 3 |
| MOAB1 | Goods receipt times: Monday morning from ... | WAMOAB1 | TIMS | 6 | |
| MOBI1 | Goods receiving hours: Monday morning until ... | WAMOBI1 | TIMS | 6 | |
| MOAB2 | Goods receiving hours: Monday afternoon from ... | WAMOAB2 | TIMS | 6 | |
| MOBI2 | Goods receiving hours: Monday afternoon until ... | WAMOBI2 | TIMS | 6 | |
| DIAB1 | Goods receiving hours: Tuesday morning from... | WADIAB1 | TIMS | 6 | |
| DIBI1 | Goods receipt times: Tuesday morning until ... | WADIBI1 | TIMS | 6 | |
| DIAB2 | Goods receiving hours: Tuesday afternoon from ... | WADIAB2 | TIMS | 6 | |
| DIBI2 | Goods receiving hours: Tuesday afternoon until ... | WADIBI2 | TIMS | 6 | |
| MIAB1 | Goods receiving hours: Wednesday morning from ... | WAMIAB1 | TIMS | 6 | |
| MIBI1 | Goods receiving hours: Wednesday morning until ... | WAMIBI1 | TIMS | 6 | |
| MIAB2 | Goods receiving hours: Wednesday afternoon from ... | WAMIAB2 | TIMS | 6 | |
| MIBI2 | Goods receiving hours: Wednesday afternoon until ... | WAMIBI2 | TIMS | 6 | |
| DOAB1 | Goods receiving hours: Thursday morning from ... | WADOAB1 | TIMS | 6 | |
| DOBI1 | Goods receiving hours: Thursday morning until ... | WADOBI1 | TIMS | 6 | |
| DOAB2 | Goods receiving hours: Thursday afternoon from ... | WADOAB2 | TIMS | 6 | |
| DOBI2 | Goods receiving hours: Thursday afternoon until... | WADOBI2 | TIMS | 6 | |
| FRAB1 | Goods receiving hours: Friday morning from ... | WAFRAB1 | TIMS | 6 | |
| FRBI1 | Goods receiving hours: Friday morning until ... | WAFRBI1 | TIMS | 6 | |
| FRAB2 | Goods receiving hours: Friday afternoon from ... | WAFRAB2 | TIMS | 6 | |
| FRBI2 | Goods receiving hours: Friday afternoon until ... | WAFRBI2 | TIMS | 6 | |
| SAAB1 | Goods receiving hours: Saturday morning from ... | WASAAB1 | TIMS | 6 | |
| SABI1 | Goods receiving hours: Saturday morning from ... | WASABI1 | TIMS | 6 | |
| SAAB2 | Goods receiving hours: Saturday afternoon from ... | WASAAB2 | TIMS | 6 | |
| SABI2 | Goods receiving hours: Saturday afternoon until ... | WASABI2 | TIMS | 6 | |
| SOAB1 | Goods receiving hours: Sunday morning from ... | WASOAB1 | TIMS | 6 | |
| SOBI1 | Goods receiving hours: Sunday morning until ... | WASOBI1 | TIMS | 6 | |
| SOAB2 | Goods receiving hours: Sunday afternoon from ... | WASOAB2 | TIMS | 6 | |
| SOBI2 | Goods receiving hours: Sunday afternoon until ... | WASOBI2 | TIMS | 6 | |
| VERFL | Sales area (floor space) | VERFL_WWS | QUAN | 6 | |
| VERFE | Sales area (floor space) unit | VERFE_WWS | T006 | UNIT | 3 |
| SPGR1 | Blocking Reason | SPGR1 | TWRF11 | CHAR | 2 |
| INPRO | POS Inbound Profile | POSINTPROF | TWPIS | CHAR | 4 |
| EKOAR | POS outbound: condition type group | POSEKOAR | TWPPK | CHAR | 4 |
| KZLIK | Listing Conditions for Assortments | KZLIK | CHAR | 1 | |
| BETRP | Plant profile | BETRP | TWRF2 | CHAR | 4 |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| NLMATFB | ID: Carry out subsequent listing | NLMATFB | CHAR | 1 | |
| BWWRK | Plant for retail price determination | BWWRK | T001W | CHAR | 4 |
| BWVKO | Sales organization for retail price determination | BWVKO | TVKO | CHAR | 4 |
| BWVTW | Distribution channel for retail price determination | BWVTW | TVTW | CHAR | 2 |
| BBPRO | Assortment list profile | BBPRO | TWBP | CHAR | 4 |
| VKBUR_WRK | Sales office | VKBUR_WRK | CHAR | 4 | |
| VLFKZ | Plant category | VLFKZ | CHAR | 1 | |
| LSTFL | Listing procedure for store or other assortment categories | LSTFL | TWLV | CHAR | 2 |
| LIGRD | Basic listing rule for assortments | WLIGRD | CHAR | 1 | |
| VKORG | Sales Organization for Intercompany Billing | VKOIV | TVKO | CHAR | 4 |
| VTWEG | Distribution channel for intercompany billing | VTWIV | TVTW | CHAR | 2 |
| DESROI | ROI required | DESROI | DEC | 5 | |
| TIMINC | Time increment for investement buying algorithm | TIMINC | DEC | 5 | |
| POSWS | Currency of POS Systems | POSWS | TCURC | CUKY | 5 |
| SSOPT_PRO | Space management profile | SSOPT_PRO | TWSSO | CHAR | 4 |
| WBPRO | Profile for value-based inventory management | WBPRO | TWPR | CHAR | 4 |
| ORGPRICE | Retail: Original Price for Segment Definition E2WRF1M | E2WRF_ORGPRICES | CHAR | 1 | |
| PRCTR | Profit Center | PRCTR | CHAR | 10 | |
| RMA_PROF | Retail: RMA Profile for Segment Definition E2WRF1M | E2WRMA_PROF | CHAR | 4 | |
| RMA_VKORG | Cost allocation sales organization | WCAT_VKORG | TVKO | CHAR | 4 |
| RMA_VTWEG | Cost allocation distribution channel | WCAT_VTWEG | TVTW | CHAR | 2 |
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 WRF1
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WRF1 | BBPRO | : | TWBP |
| WRF1 | BETRP | : | TWRF2 |
| WRF1 | BWVKO | 1: CN | TVKO |
| WRF1 | BWVTW | 1: CN | TVTW |
| WRF1 | BWWRK | 1: CN | T001W |
| WRF1 | EKOAR | 1: CN | TWPPK |
| WRF1 | FLVAR | C: CN | TWGF |
| WRF1 | INPRO | 1: CN | TWPIS |
| WRF1 | KOPRO | 1: CN | TWPFI |
| WRF1 | LAYVR | 1: CN | TWGV |
| WRF1 | LOCNR | 1: CN | KNA1 |
| WRF1 | LSTFL | : | TWLV |
| WRF1 | MANDT | 1: CN | T000 |
| WRF1 | POSWS | 1: CN | TCURC |
| WRF1 | RMA_VKORG | 1: CN | TVKO |
| WRF1 | RMA_VTWEG | 1: CN | TVTW |
| WRF1 | SPGR1 | 1: CN | TWRF11 |
| WRF1 | SSOPT_PRO | 1: CN | TWSSO |
| WRF1 | STFAK | 1: CN | TFACD |
| WRF1 | VERFE | 1: CN | T006 |
| WRF1 | VKORG | 1: CN | TVKO |
| WRF1 | VTWEG | C: CN | TVTW |
| WRF1 | WANID | C: CN | TVWA |
| WRF1 | WBPRO | 1: CN | TWPR |