WRF1

Plant data | #masterdata | Component: Sites
Column Name Description
MANDT FK Client
LOCNR FK Customer Number
Column Name Description
Column Name Description
📏 Sales area (floor space) unit (VERFE):
VERFL Sales area (floor space)
Column Name Description
EROED Opening Date
SCHLD Closing Date
SPDAB Block from
SPDBI Block to
MOAB1 Goods receipt times: Monday morning from ...
MOBI1 Goods receiving hours: Monday morning until ...
MOAB2 Goods receiving hours: Monday afternoon from ...
MOBI2 Goods receiving hours: Monday afternoon until ...
DIAB1 Goods receiving hours: Tuesday morning from...
DIBI1 Goods receipt times: Tuesday morning until ...
DIAB2 Goods receiving hours: Tuesday afternoon from ...
DIBI2 Goods receiving hours: Tuesday afternoon until ...
MIAB1 Goods receiving hours: Wednesday morning from ...
MIBI1 Goods receiving hours: Wednesday morning until ...
MIAB2 Goods receiving hours: Wednesday afternoon from ...
MIBI2 Goods receiving hours: Wednesday afternoon until ...
DOAB1 Goods receiving hours: Thursday morning from ...
DOBI1 Goods receiving hours: Thursday morning until ...
DOAB2 Goods receiving hours: Thursday afternoon from ...
DOBI2 Goods receiving hours: Thursday afternoon until...
FRAB1 Goods receiving hours: Friday morning from ...
FRBI1 Goods receiving hours: Friday morning until ...
FRAB2 Goods receiving hours: Friday afternoon from ...
FRBI2 Goods receiving hours: Friday afternoon until ...
SAAB1 Goods receiving hours: Saturday morning from ...
SABI1 Goods receiving hours: Saturday morning from ...
SAAB2 Goods receiving hours: Saturday afternoon from ...
SABI2 Goods receiving hours: Saturday afternoon until ...
SOAB1 Goods receiving hours: Sunday morning from ...
SOBI1 Goods receiving hours: Sunday morning until ...
SOAB2 Goods receiving hours: Sunday afternoon from ...
SOBI2 Goods receiving hours: Sunday afternoon until ...
ERDAT Date on which the record was created
Column Name Description
KZLIK Listing Conditions for Assortments Show values
NLMATFB ID: Carry out subsequent listing Show values
VLFKZ Plant category Show values
LIGRD Basic listing rule for assortments Show values
Column Name Description Domain name
AUTOB Automatic purchase order CHAR001
ERNAM Name of Person Responsible for Creating the Object USNAM
VKBUR_WRK Sales office VKBUR
DESROI ROI required DEC3_2
TIMINC Time increment for investement buying algorithm DEC5
LASTCHANGEDBYUSER User Who Last Changed the Business Document USNAM
LASTCHANGEDATETIME UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
ORGPRICE Retail: Original Price for Segment Definition E2WRF1M E2WRF_ORGPRICES
PRCTR Profit Center PRCTR
RMA_PROF Retail: RMA Profile for Segment Definition E2WRF1M E2WRMA_PROF
Master Data Relations Join Conditions
Assortment list profile
  • Assortment list profile
  • Client
  • WRF1.BBPRO == TWBP.BBPRO
  • WRF1.MANDT == TWBP.MANDT
Foreign key(s)
  • WRF1.MANDT == TWRF2.MANDT
  • WRF1.BETRP == TWRF2.BETRP
Sales organization
  • WRF1.MANDT == TVKO.MANDT
  • WRF1.BWVKO == TVKO.VKORG
Distribution channels
  • Distribution channel for retail price determination
  • Client
  • WRF1.BWVTW == TVTW.VTWEG
  • WRF1.MANDT == TVTW.MANDT
Plants/branches
  • WRF1.MANDT == T001W.MANDT
  • WRF1.BWWRK == T001W.WERKS
POS outbound: condition type group
  • POS outbound: condition type group
  • Client
  • WRF1.EKOAR == TWPPK.EKOAR
  • WRF1.MANDT == TWPPK.MANDT
Area schema
  • WRF1.MANDT == TWGF.MANDT
  • WRF1.FLVAR == TWGF.FLVAR
POS Inbound Profile
  • WRF1.MANDT == TWPIS.MANDT
  • WRF1.INPRO == TWPIS.INPRO
POS Outbound Profile
  • WRF1.MANDT == TWPFI.MANDT
  • WRF1.KOPRO == TWPFI.KOPRO
Layout
  • Layout
  • Client
  • WRF1.LAYVR == TWGV.LAYVR
  • WRF1.MANDT == TWGV.MANDT
Customer Number
  • WRF1.MANDT == KNA1.MANDT
  • WRF1.LOCNR == KNA1.KUNNR
Listing procedure for store or other assortment categories
  • Listing procedure for store or other assortment categories
  • Client
  • WRF1.LSTFL == TWLV.LSTFL
  • WRF1.MANDT == TWLV.MANDT
Client WRF1.MANDT == T000.MANDT
Currency of POS Systems
  • WRF1.MANDT == TCURC.MANDT
  • WRF1.POSWS == TCURC.WAERS
Sales Organization
  • WRF1.MANDT == TVKO.MANDT
  • WRF1.RMA_VKORG == TVKO.VKORG
Distribution Channel
  • Cost allocation distribution channel
  • Client
  • WRF1.RMA_VTWEG == TVTW.VTWEG
  • WRF1.MANDT == TVTW.MANDT
Blocking Reason
  • Blocking Reason
  • Client
Space management profile
  • Space management profile
  • Client
  • WRF1.SSOPT_PRO == TWSSO.SSOPT_PRO
  • WRF1.MANDT == TWSSO.MANDT
Calendar WRF1.STFAK == TFACD.IDENT
Sales area (floor space) unit
  • WRF1.MANDT == T006.MANDT
  • WRF1.VERFE == T006.MSEHI
Sales Organization for Intercompany Billing
  • WRF1.MANDT == TVKO.MANDT
  • WRF1.VKORG == TVKO.VKORG
Distribution channel for intercompany billing
  • Distribution channel for intercompany billing
  • Client
  • WRF1.VTWEG == TVTW.VTWEG
  • WRF1.MANDT == TVTW.MANDT
Goods receiving hours ID (default value)
  • WRF1.MANDT == TVWA.MANDT
  • WRF1.WANID == TVWA.WANID
Profile for value-based inventory management
  • WRF1.MANDT == TWPR.MANDT
  • WRF1.WBPRO == TWPR.WBPRO