VWRF_BETRWH

18 Fields 2 CDS Views

Generated Table for View

VWRF_BETRWH is an SAP database table in S/4HANA. Generated Table for View. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
SHSM_VWRF_BETRWH1 view from
SHSM_VWRF_BETRWH3 view from

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY werks WERKS_D Plant
KEY bwkey BWKEY Valuation Area
KEY bukrs BUKRS Company Code
KEY date_from AD_DATE_FR From
KEY nation AD_NATION Address Version
kunnr KUNNR_WK Customer No Plant
vlfkz VLFKZ Plant Cat.
dep_store WRF_DEP_STORE Sup. DS
storetype WRF_STORETYPE Store Cat
sort2 AD_SORT1 Search Term 1
sort1 AD_SORT2 Search Term 2
post_code1 AD_PSTCD1 Postal Code
city1 AD_CITY1 City
mc_city1 AD_MC_CITY City
name2 AD_NAME2 Name 2
name1 AD_NAME1 Name
mc_name1 AD_MC_NAME Name

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VWRF_BETRWH (
    MANDT,       -- Client [MANDT]
    WERKS,       -- Plant [WERKS_D]
    BWKEY,       -- Valuation Area [BWKEY]
    BUKRS,       -- Company Code [BUKRS]
    DATE_FROM,   -- From [AD_DATE_FR]
    NATION,      -- Address Version [AD_NATION]
    KUNNR,       -- Customer No Plant [KUNNR_WK]
    VLFKZ,       -- Plant Cat. [VLFKZ]
    DEP_STORE,   -- Sup. DS [WRF_DEP_STORE]
    STORETYPE,   -- Store Cat [WRF_STORETYPE]
    SORT2,       -- Search Term 1 [AD_SORT1]
    SORT1,       -- Search Term 2 [AD_SORT2]
    POST_CODE1,  -- Postal Code [AD_PSTCD1]
    CITY1,       -- City [AD_CITY1]
    MC_CITY1,    -- City [AD_MC_CITY]
    NAME2,       -- Name 2 [AD_NAME2]
    NAME1,       -- Name [AD_NAME1]
    MC_NAME1,    -- Name [AD_MC_NAME]
    PRIMARY KEY (MANDT, WERKS, BWKEY, BUKRS, DATE_FROM, NATION)
);

Learn More