SAP table WRF1 (Plant data)

SAP table WRF1 has 2 primary key fields being MANDT,LOCNR.

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
LOCNR Customer Number CHAR 10 0 KNA1 KUNNR
EROED Opening Date DATS 8 0 EROED
SCHLD Closing Date DATS 8 0 SCHLD
SPDAB Block from DATS 8 0 SPDAB
SPDBI Block to DATS 8 0 SPDBI
AUTOB Automatic purchase order CHAR 1 0 AUTOB
KOPRO POS Outbound Profile CHAR 4 0 TWPFI POSKOPRO
LAYVR Layout CHAR 10 0 TWGV LAYVAR
FLVAR Area schema CHAR 4 0 TWGF FLVAR
STFAK Calendar CHAR 2 0 TFACD STKAL
WANID Goods receiving hours ID (default value) CHAR 3 0 TVWA WANID
MOAB1 Goods receipt times: Monday morning from ... TIMS 6 0 WAMOAB1
MOBI1 Goods receiving hours: Monday morning until ... TIMS 6 0 WAMOBI1
MOAB2 Goods receiving hours: Monday afternoon from ... TIMS 6 0 WAMOAB2
MOBI2 Goods receiving hours: Monday afternoon until ... TIMS 6 0 WAMOBI2
DIAB1 Goods receiving hours: Tuesday morning from... TIMS 6 0 WADIAB1
DIBI1 Goods receipt times: Tuesday morning until ... TIMS 6 0 WADIBI1
DIAB2 Goods receiving hours: Tuesday afternoon from ... TIMS 6 0 WADIAB2
DIBI2 Goods receiving hours: Tuesday afternoon until ... TIMS 6 0 WADIBI2
MIAB1 Goods receiving hours: Wednesday morning from ... TIMS 6 0 WAMIAB1
MIBI1 Goods receiving hours: Wednesday morning until ... TIMS 6 0 WAMIBI1
MIAB2 Goods receiving hours: Wednesday afternoon from ... TIMS 6 0 WAMIAB2
MIBI2 Goods receiving hours: Wednesday afternoon until ... TIMS 6 0 WAMIBI2
DOAB1 Goods receiving hours: Thursday morning from ... TIMS 6 0 WADOAB1
DOBI1 Goods receiving hours: Thursday morning until ... TIMS 6 0 WADOBI1
DOAB2 Goods receiving hours: Thursday afternoon from ... TIMS 6 0 WADOAB2
DOBI2 Goods receiving hours: Thursday afternoon until... TIMS 6 0 WADOBI2
FRAB1 Goods receiving hours: Friday morning from ... TIMS 6 0 WAFRAB1
FRBI1 Goods receiving hours: Friday morning until ... TIMS 6 0 WAFRBI1
FRAB2 Goods receiving hours: Friday afternoon from ... TIMS 6 0 WAFRAB2
FRBI2 Goods receiving hours: Friday afternoon until ... TIMS 6 0 WAFRBI2
SAAB1 Goods receiving hours: Saturday morning from ... TIMS 6 0 WASAAB1
SABI1 Goods receiving hours: Saturday morning from ... TIMS 6 0 WASABI1
SAAB2 Goods receiving hours: Saturday afternoon from ... TIMS 6 0 WASAAB2
SABI2 Goods receiving hours: Saturday afternoon until ... TIMS 6 0 WASABI2
SOAB1 Goods receiving hours: Sunday morning from ... TIMS 6 0 WASOAB1
SOBI1 Goods receiving hours: Sunday morning until ... TIMS 6 0 WASOBI1
SOAB2 Goods receiving hours: Sunday afternoon from ... TIMS 6 0 WASOAB2
SOBI2 Goods receiving hours: Sunday afternoon until ... TIMS 6 0 WASOBI2
VERFL Sales area (floor space) QUAN 6 0 VERFL_WWS
VERFE Sales area (floor space) unit UNIT 3 0 T006 VERFE_WWS
SPGR1 Blocking Reason CHAR 2 0 TWRF11 SPGR1
INPRO POS Inbound Profile CHAR 4 0 TWPIS POSINTPROF
EKOAR POS outbound: condition type group CHAR 4 0 TWPPK POSEKOAR
KZLIK Listing Conditions for Assortments CHAR 1 0 KZLIK
BETRP Plant profile CHAR 4 0 TWRF2 BETRP
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
NLMATFB ID: Carry out subsequent listing CHAR 1 0 NLMATFB
1 No subsequent listing; error is being processed
2 Subs. listing
3 Manual decision
BWWRK Plant for retail price determination CHAR 4 0 T001W BWWRK
BWVKO Sales organization for retail price determination CHAR 4 0 TVKO BWVKO
BWVTW Distribution channel for retail price determination CHAR 2 0 TVTW BWVTW
BBPRO Assortment list profile CHAR 4 0 TWBP BBPRO
VKBUR_WRK Sales office CHAR 4 0 VKBUR_WRK
VLFKZ Plant category CHAR 1 0 VLFKZ
A Store
B Distribution Center
LSTFL Listing procedure for store or other assortment categories CHAR 2 0 TWLV LSTFL
LIGRD Basic listing rule for assortments CHAR 1 0 WLIGRD
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 CHAR 4 0 TVKO VKOIV
VTWEG Distribution channel for intercompany billing CHAR 2 0 TVTW VTWIV
DESROI ROI required DEC 5 2 DESROI
TIMINC Time increment for investement buying algorithm DEC 5 0 TIMINC
POSWS Currency of POS Systems CUKY 5 0 TCURC POSWS
SSOPT_PRO Space management profile CHAR 4 0 TWSSO SSOPT_PRO
WBPRO Profile for value-based inventory management CHAR 4 0 TWPR WBPRO
LASTCHANGEDBYUSER User Who Last Changed the Business Document CHAR 12 0 LAST_CHANGED_BY_USER
LASTCHANGEDATETIME UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) DEC 21 7 TIMESTAMPL
ORGPRICE Retail: Original Price for Segment Definition E2WRF1M CHAR 1 0 E2WRF_ORGPRICES
PRCTR Profit Center CHAR 10 0 PRCTR
RMA_PROF Retail: RMA Profile for Segment Definition E2WRF1M CHAR 4 0 E2WRMA_PROF
RMA_VKORG Cost allocation sales organization CHAR 4 0 TVKO WCAT_VKORG
RMA_VTWEG Cost allocation distribution channel CHAR 2 0 TVTW WCAT_VTWEG

WRF1 foreign key relationships

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