EVBS

Transparent Table Application Table
16 Fields 9 CDS Views

Verbrauchsstelle

EVBS is an SAP database table in S/4HANA. Verbrauchsstelle. It contains 16 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
CRMS4_IU_C_CONBP view inner Connection object by business partner
CRMS4_IU_C_CONPOD view inner Connection Object by Internal PoD ID
CRMS4_IU_C_CONVAR view_entity left_outer Connection Object by Various Fields
CRMS4_IU_C_PRMADDR view inner Premise by Address
I_UtilitiesPremise view from BASIC Premise
ISU_C4C_BP_PREMISE_V view_entity inner Premises linked to business partner
SHSM_I_EAUSE view inner Move-Out Doc. by Premise
SHSM_I_ECAMIOPR_PREMISE view inner CDS SH for Parked Document by Premise
SHSM_I_EDISCDOCPREMISE view inner CDS SH for Disc. Doc. with Ref. Obj. Premise

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY vstelle vstelle Premise
haus haus Connection Obj.
str_erg2 ad_strspp2 Street 3
haus_num2 ad_hsnm2 Supplement
txtlangu spras Language
lgzusatz lgzusatz Locatn Supplmnt
vbsart vbsart Premise type
eigent e_gpartner Owner
objnr j_objnr Object number
tplnummer tplnummer Functional loc.
anzpers anz_pers No. of persons
floor ad_floor Floor
roomnumber ad_roomnum Room Number
hptwhnsitz mainresi Main resid.
str_erg4 ad_lctn Street 5

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.

-- Verbrauchsstelle
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EVBS (
    MANDT,       -- Client [mandt]
    VSTELLE,     -- Premise [vstelle]
    HAUS,        -- Connection Obj. [haus]
    STR_ERG2,    -- Street 3 [ad_strspp2]
    HAUS_NUM2,   -- Supplement [ad_hsnm2]
    TXTLANGU,    -- Language [spras]
    LGZUSATZ,    -- Locatn Supplmnt [lgzusatz]
    VBSART,      -- Premise type [vbsart]
    EIGENT,      -- Owner [e_gpartner]
    OBJNR,       -- Object number [j_objnr]
    TPLNUMMER,   -- Functional loc. [tplnummer]
    ANZPERS,     -- No. of persons [anz_pers]
    FLOOR,       -- Floor [ad_floor]
    ROOMNUMBER,  -- Room Number [ad_roomnum]
    HPTWHNSITZ,  -- Main resid. [mainresi]
    STR_ERG4,    -- Street 5 [ad_lctn]
    PRIMARY KEY (MANDT, VSTELLE)
);

Learn More