SAP Table WRF1

Plant data

WRF1 (Plant data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link WRF1 to other SAP tables.

Source: WRF1 (Plant data)

WRF1 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LOCNR Customer Number KUNNR KNA1 CHAR 10 0
EROED Opening date EROED DATS 8 0
SCHLD Closing date SCHLD DATS 8 0
SPDAB Block from SPDAB DATS 8 0
SPDBI Block to SPDBI DATS 8 0
AUTOB Automatic purchase order AUTOB CHAR 1 0
KOPRO POS outbound profile POSKOPRO TWPFI CHAR 4 0
LAYVR Layout LAYVAR TWGV CHAR 10 0
FLVAR Area schema FLVAR TWGF CHAR 4 0
STFAK Calendar STKAL TFACD CHAR 2 0
WANID Goods receiving hours ID (default value) WANID TVWA CHAR 3 0
MOAB1 Goods receipt times: Monday morning from ... WAMOAB1 TIMS 6 0
MOBI1 Goods receiving hours: Monday morning until ... WAMOBI1 TIMS 6 0
MOAB2 Goods receiving hours: Monday afternoon from ... WAMOAB2 TIMS 6 0
MOBI2 Goods receiving hours: Monday afternoon until ... WAMOBI2 TIMS 6 0
DIAB1 Goods receiving hours: Tuesday morning from... WADIAB1 TIMS 6 0
DIBI1 Goods receipt times: Tuesday morning until ... WADIBI1 TIMS 6 0
DIAB2 Goods receiving hours: Tuesday afternoon from ... WADIAB2 TIMS 6 0
DIBI2 Goods receiving hours: Tuesday afternoon until ... WADIBI2 TIMS 6 0
MIAB1 Goods receiving hours: Wednesday morning from ... WAMIAB1 TIMS 6 0
MIBI1 Goods receiving hours: Wednesday morning until ... WAMIBI1 TIMS 6 0
MIAB2 Goods receiving hours: Wednesday afternoon from ... WAMIAB2 TIMS 6 0
MIBI2 Goods receiving hours: Wednesday afternoon until ... WAMIBI2 TIMS 6 0
DOAB1 Goods receiving hours: Thursday morning from ... WADOAB1 TIMS 6 0
DOBI1 Goods receiving hours: Thursday morning until ... WADOBI1 TIMS 6 0
DOAB2 Goods receiving hours: Thursday afternoon from ... WADOAB2 TIMS 6 0
DOBI2 Goods receiving hours: Thursday afternoon until... WADOBI2 TIMS 6 0
FRAB1 Goods receiving hours: Friday morning from ... WAFRAB1 TIMS 6 0
FRBI1 Goods receiving hours: Friday morning until ... WAFRBI1 TIMS 6 0
FRAB2 Goods receiving hours: Friday afternoon from ... WAFRAB2 TIMS 6 0
FRBI2 Goods receiving hours: Friday afternoon until ... WAFRBI2 TIMS 6 0
SAAB1 Goods receiving hours: Saturday morning from ... WASAAB1 TIMS 6 0
SABI1 Goods receiving hours: Saturday morning from ... WASABI1 TIMS 6 0
SAAB2 Goods receiving hours: Saturday afternoon from ... WASAAB2 TIMS 6 0
SABI2 Goods receiving hours: Saturday afternoon until ... WASABI2 TIMS 6 0
SOAB1 Goods receiving hours: Sunday morning from ... WASOAB1 TIMS 6 0
SOBI1 Goods receiving hours: Sunday morning until ... WASOBI1 TIMS 6 0
SOAB2 Goods receiving hours: Sunday afternoon from ... WASOAB2 TIMS 6 0
SOBI2 Goods receiving hours: Sunday afternoon until ... WASOBI2 TIMS 6 0
VERFL Sales area (floor space) VERFL_WWS QUAN 6 0
VERFE Sales area (floor space) unit VERFE_WWS T006 UNIT 3 0
SPGR1 Blocking reason SPGR1 TWRF11 CHAR 2 0
INPRO POS inbound profile POSINTPROF TWPIS CHAR 4 0
EKOAR POS outbound: condition type group POSEKOAR TWPPK CHAR 4 0
KZLIK Listing conditions should be created per assortment KZLIK CHAR 1 0
X Yes
NULL No
BETRP Plant profile BETRP TWRF2 CHAR 4 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
NLMATFB ID: Carry out subsequent listing NLMATFB CHAR 1 0
1 No subsequent listing; error is being processed
2 Subs. listing
3 Manual decision
BWWRK Plant for retail price determination BWWRK T001W CHAR 4 0
BWVKO Sales organization for retail price determination BWVKO TVKO CHAR 4 0
BWVTW Distribution channel for retail price determination BWVTW TVTW CHAR 2 0
BBPRO Assortment list profile BBPRO TWBP CHAR 4 0
VKBUR_WRK Sales office VKBUR_WRK CHAR 4 0
VLFKZ Plant category VLFKZ CHAR 1 0
A Store
B Distribution Center
LSTFL Listing procedure for store or other assortment categories LSTFL TWLV CHAR 2 0
LIGRD Basic listing rule for assortments WLIGRD CHAR 1 0
NULL Can order everything, regardless of assortment assigned
1 Can only order the assortment assigned
2 Check takes place via user exit
VKORG Sales organization for intercompany billing VKOIV TVKO CHAR 4 0
VTWEG Distribution channel for intercompany billing VTWIV TVTW CHAR 2 0
DESROI ROI required DESROI DEC 5 2
TIMINC Time increment for investement buying algorithm TIMINC DEC 5 0
POSWS Currency of POS systems POSWS TCURC CUKY 5 0
SSOPT_PRO Space management profile SSOPT_PRO TWSSO CHAR 4 0
WBPRO Profile for value-based inventory management WBPRO TWPR CHAR 4 0
ORGPRICE Retail: Original Price for Segment Definition E2WRF1M E2WRF_ORGPRICES CHAR 1 0
PRCTR Profit Center PRCTR CHAR 10 0
RMA_PROF Retail: RMA Profile for Segment Definition E2WRF1M E2WRMA_PROF CHAR 4 0
RMA_VKORG Cost allocation sales organization WCAT_VKORG TVKO CHAR 4 0
RMA_VTWEG Cost allocation distribution channel WCAT_VTWEG TVTW CHAR 2 0

WRF1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
WRF1 BBPRO WRF1 MANDT TWBP Assortment list profile MANDT
WRF1 BBPRO WRF1 BBPRO TWBP Assortment list profile BBPRO
WRF1 BETRP WRF1 BETRP TWRF2 Plant Profiles BETRP
WRF1 BETRP WRF1 MANDT TWRF2 Plant Profiles MANDT
WRF1 BWVKO WRF1 MANDT TVKO Organizational Unit: Sales Organizations MANDT
WRF1 BWVKO WRF1 BWVKO TVKO Organizational Unit: Sales Organizations VKORG
WRF1 BWVTW WRF1 BWVTW TVTW Organizational Unit: Distribution Channels VTWEG
WRF1 BWVTW WRF1 MANDT TVTW Organizational Unit: Distribution Channels MANDT
WRF1 BWWRK WRF1 MANDT T001W Plants/Branches MANDT
WRF1 BWWRK WRF1 BWWRK T001W Plants/Branches WERKS
WRF1 EKOAR WRF1 MANDT TWPPK POS outbound: condition type group MANDT
WRF1 EKOAR WRF1 EKOAR TWPPK POS outbound: condition type group EKOAR
WRF1 FLVAR WRF1 FLVAR TWGF Area schema FLVAR
WRF1 FLVAR WRF1 MANDT TWGF Area schema MANDT
WRF1 INPRO WRF1 MANDT TWPIS POS interface: profile for internal interfaces MANDT
WRF1 INPRO WRF1 INPRO TWPIS POS interface: profile for internal interfaces INPRO
WRF1 KOPRO WRF1 MANDT TWPFI POS outbound profile MANDT
WRF1 KOPRO WRF1 KOPRO TWPFI POS outbound profile KOPRO
WRF1 LAYVR WRF1 MANDT TWGV Layout MANDT
WRF1 LAYVR WRF1 LAYVR TWGV Layout LAYVR
WRF1 LOCNR WRF1 LOCNR KNA1 General Data in Customer Master KUNNR
WRF1 LOCNR WRF1 MANDT KNA1 General Data in Customer Master MANDT
WRF1 LSTFL WRF1 MANDT TWLV Listing procedure, assortments MANDT
WRF1 LSTFL WRF1 LSTFL TWLV Listing procedure, assortments LSTFL
WRF1 MANDT WRF1 MANDT T000 Clients MANDT
WRF1 POSWS WRF1 MANDT TCURC Currency Codes MANDT
WRF1 POSWS WRF1 POSWS TCURC Currency Codes WAERS
WRF1 RMA_VKORG WRF1 MANDT TVKO Organizational Unit: Sales Organizations MANDT
WRF1 RMA_VKORG WRF1 RMA_VKORG TVKO Organizational Unit: Sales Organizations VKORG
WRF1 RMA_VTWEG WRF1 MANDT TVTW Organizational Unit: Distribution Channels MANDT
WRF1 RMA_VTWEG WRF1 RMA_VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
WRF1 SPGR1 WRF1 SPGR1 TWRF11 Plant blocking reasons SPGR1
WRF1 SPGR1 WRF1 MANDT TWRF11 Plant blocking reasons MANDT
WRF1 SSOPT_PRO WRF1 MANDT TWSSO Space management profile MANDT
WRF1 SSOPT_PRO WRF1 SSOPT_PRO TWSSO Space management profile SSOPT_PRO
WRF1 STFAK WRF1 STFAK TFACD Factory calendar definition IDENT
WRF1 VERFE WRF1 MANDT T006 Units of Measurement MANDT
WRF1 VERFE WRF1 VERFE T006 Units of Measurement MSEHI
WRF1 VKORG WRF1 MANDT TVKO Organizational Unit: Sales Organizations MANDT
WRF1 VKORG WRF1 VKORG TVKO Organizational Unit: Sales Organizations VKORG
WRF1 VTWEG WRF1 VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
WRF1 VTWEG WRF1 MANDT TVTW Organizational Unit: Distribution Channels MANDT
WRF1 WANID WRF1 MANDT TVWA Customers: Goods receiving hours (default values) MANDT
WRF1 WANID WRF1 WANID TVWA Customers: Goods receiving hours (default values) WANID
WRF1 WBPRO WRF1 MANDT TWPR Profile for Value-Based Inventory Management MANDT
WRF1 WBPRO WRF1 WBPRO TWPR Profile for Value-Based Inventory Management WBPRO