WRF1

Transparent Table Application Table
72 Fields 7 CDS Views

Plant data

WRF1 is an SAP database table in S/4HANA. Plant data. It contains 72 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
CIC_RetailSiteData view_entity from Proj. view on Retail Site data
I_AsstmtMdlUsrToAsstmtMdl_2 view inner BASIC Assortment User Assignment to Assortment Module
I_SiteBlocking view from BASIC Site Blocking
I_SiteMasterAdministrativeData view from BASIC Site Administrative Fields
I_SiteOpeningHours view from BASIC Site Opening Hours
I_SitePointOfSale view from BASIC Site Point of Sale
I_SiteValnAndInvtryManagement view from BASIC Site Valuation and inventory mgmt

Fields (72)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY locnr KUNNR Customer
eroed EROED Opening Date
schld SCHLD Closing Date
spdab SPDAB Block from
spdbi SPDBI Block to
autob AUTOB Autom. PO
kopro POSKOPRO POS Outbnd Prf.
layvr LAYVAR Layout
flvar FLVAR Area schema
stfak STKAL Calendar
wanid WANID Goods rec.hours
moab1 WAMOAB1 Monday
mobi1 WAMOBI1 Monday
moab2 WAMOAB2 Monday
mobi2 WAMOBI2 Monday
diab1 WADIAB1 Tuesday
dibi1 WADIBI1 Tuesday
diab2 WADIAB2 Tuesday
dibi2 WADIBI2 Tuesday
miab1 WAMIAB1 Wednesday
mibi1 WAMIBI1 Wednesday
miab2 WAMIAB2 Wednesday
mibi2 WAMIBI2 Wednesday
doab1 WADOAB1 Thursday
dobi1 WADOBI1 Thursday
doab2 WADOAB2 Thursday
dobi2 WADOBI2 Thursday
frab1 WAFRAB1 Friday
frbi1 WAFRBI1 Friday
frab2 WAFRAB2 Friday
frbi2 WAFRBI2 Friday
saab1 WASAAB1 Saturday
sabi1 WASABI1 Saturday
saab2 WASAAB2 Saturday
sabi2 WASABI2 Saturday
soab1 WASOAB1 Sunday
sobi1 WASOBI1 Sunday
soab2 WASOAB2 Sunday
sobi2 WASOBI2 Sunday
verfl VERFL_WWS Sales area
verfe VERFE_WWS Sales area unit
spgr1 SPGR1 Blocking Reason
inpro POSINTPROF Inbound Profile
ekoar POSEKOAR Cond. type grp
kzlik KZLIK ListCondAstmt
betrp BETRP Plant profile
erdat ERDAT Created On
ernam ERNAM Created By
nlmatfb NLMATFB ID subseq.list.
bwwrk BWWRK Plant RPD
bwvko BWVKO SOrg retail pr.
bwvtw BWVTW DChl Retail pr.
bbpro BBPRO AL profile
vkbur_wrk VKBUR_WRK Sales office
vlfkz VLFKZ Plant Cat.
lstfl LSTFL LP for Stores
ligrd WLIGRD BasicRuleListng
vkorg VKOIV Sales Org. ICB
vtweg VTWIV Distrib.Channel
desroi DESROI ROI required
timinc TIMINC Time increment
posws POSWS POS Currency
ssopt_pro SSOPT_PRO Space mgmt prof
wbpro WBPRO Profile vIM
lastchangedbyuser LAST_CHANGED_BY_USER Last Changed By
lastchangedatetime TIMESTAMPL Time Stamp
orgprice E2WRF_ORGPRICES Retail: Original Price for Segment Definition E2WRF1M
prctr PRCTR Profit Center
rma_prof E2WRMA_PROF Retail: RMA Profile for Segment Definition E2WRF1M
rma_vkorg WCAT_VKORG CAL Sales Org.
rma_vtweg WCAT_VTWEG CAL Distr.Channel

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 data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRF1 (
    MANDT,               -- Client [MANDT]
    LOCNR,               -- Customer [KUNNR]
    EROED,               -- Opening Date [EROED]
    SCHLD,               -- Closing Date [SCHLD]
    SPDAB,               -- Block from [SPDAB]
    SPDBI,               -- Block to [SPDBI]
    AUTOB,               -- Autom. PO [AUTOB]
    KOPRO,               -- POS Outbnd Prf. [POSKOPRO]
    LAYVR,               -- Layout [LAYVAR]
    FLVAR,               -- Area schema [FLVAR]
    STFAK,               -- Calendar [STKAL]
    WANID,               -- Goods rec.hours [WANID]
    MOAB1,               -- Monday [WAMOAB1]
    MOBI1,               -- Monday [WAMOBI1]
    MOAB2,               -- Monday [WAMOAB2]
    MOBI2,               -- Monday [WAMOBI2]
    DIAB1,               -- Tuesday [WADIAB1]
    DIBI1,               -- Tuesday [WADIBI1]
    DIAB2,               -- Tuesday [WADIAB2]
    DIBI2,               -- Tuesday [WADIBI2]
    MIAB1,               -- Wednesday [WAMIAB1]
    MIBI1,               -- Wednesday [WAMIBI1]
    MIAB2,               -- Wednesday [WAMIAB2]
    MIBI2,               -- Wednesday [WAMIBI2]
    DOAB1,               -- Thursday [WADOAB1]
    DOBI1,               -- Thursday [WADOBI1]
    DOAB2,               -- Thursday [WADOAB2]
    DOBI2,               -- Thursday [WADOBI2]
    FRAB1,               -- Friday [WAFRAB1]
    FRBI1,               -- Friday [WAFRBI1]
    FRAB2,               -- Friday [WAFRAB2]
    FRBI2,               -- Friday [WAFRBI2]
    SAAB1,               -- Saturday [WASAAB1]
    SABI1,               -- Saturday [WASABI1]
    SAAB2,               -- Saturday [WASAAB2]
    SABI2,               -- Saturday [WASABI2]
    SOAB1,               -- Sunday [WASOAB1]
    SOBI1,               -- Sunday [WASOBI1]
    SOAB2,               -- Sunday [WASOAB2]
    SOBI2,               -- Sunday [WASOBI2]
    VERFL,               -- Sales area [VERFL_WWS]
    VERFE,               -- Sales area unit [VERFE_WWS]
    SPGR1,               -- Blocking Reason [SPGR1]
    INPRO,               -- Inbound Profile [POSINTPROF]
    EKOAR,               -- Cond. type grp [POSEKOAR]
    KZLIK,               -- ListCondAstmt [KZLIK]
    BETRP,               -- Plant profile [BETRP]
    ERDAT,               -- Created On [ERDAT]
    ERNAM,               -- Created By [ERNAM]
    NLMATFB,             -- ID subseq.list. [NLMATFB]
    BWWRK,               -- Plant RPD [BWWRK]
    BWVKO,               -- SOrg retail pr. [BWVKO]
    BWVTW,               -- DChl Retail pr. [BWVTW]
    BBPRO,               -- AL profile [BBPRO]
    VKBUR_WRK,           -- Sales office [VKBUR_WRK]
    VLFKZ,               -- Plant Cat. [VLFKZ]
    LSTFL,               -- LP for Stores [LSTFL]
    LIGRD,               -- BasicRuleListng [WLIGRD]
    VKORG,               -- Sales Org. ICB [VKOIV]
    VTWEG,               -- Distrib.Channel [VTWIV]
    DESROI,              -- ROI required [DESROI]
    TIMINC,              -- Time increment [TIMINC]
    POSWS,               -- POS Currency [POSWS]
    SSOPT_PRO,           -- Space mgmt prof [SSOPT_PRO]
    WBPRO,               -- Profile vIM [WBPRO]
    LASTCHANGEDBYUSER,   -- Last Changed By [LAST_CHANGED_BY_USER]
    LASTCHANGEDATETIME,  -- Time Stamp [TIMESTAMPL]
    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]
    RMA_VKORG,           -- CAL Sales Org. [WCAT_VKORG]
    RMA_VTWEG,           -- CAL Distr.Channel [WCAT_VTWEG]
    PRIMARY KEY (MANDT, LOCNR)
);

Learn More