EVBS

Transparent Table Application Table
32 Fields 10 CDS Views

Premise

EVBS is an SAP database table in S/4HANA. Premise. It contains 32 fields. 10 CDS views read from this table.

CDS Views using this table (10)

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_CONVAR_DEVPOD view_entity left_outer Con. Object by Various Fields (Dev, PoD)
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 (32)

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.
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
begru BEGRU AuthorizGroup
loevm LOEVM Delete
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
dummy_utilspremise_incl_eew_ps CFD_DUMMY Dummy
zz_kontrinst ZHIK_KONTRINST
zz_kkempf ZHIK_KKEMPF
zz_verwaltung ZHIK_VERWALTUNG
zz_dienstleister ZHIK_DIENST
zz_stwe ZHIK_STWE
zz_vstelle ZHIK_HAUPTVS
zz_eigentnvs ZHIK_EIGENNVS
zz_zklemme ZZ_ZKLEMME
zz_antenne ZZ_ANTENNE

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.

-- Premise
-- 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]
    ERDAT,                           -- Created On [ERDAT]
    ERNAM,                           -- Created By [ERNAM]
    AEDAT,                           -- Changed On [AEDAT]
    AENAM,                           -- Changed By [AENAM]
    BEGRU,                           -- AuthorizGroup [BEGRU]
    LOEVM,                           -- Delete [LOEVM]
    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]
    DUMMY_UTILSPREMISE_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    ZZ_KONTRINST,                    -- ZHIK_KONTRINST
    ZZ_KKEMPF,                       -- ZHIK_KKEMPF
    ZZ_VERWALTUNG,                   -- ZHIK_VERWALTUNG
    ZZ_DIENSTLEISTER,                -- ZHIK_DIENST
    ZZ_STWE,                         -- ZHIK_STWE
    ZZ_VSTELLE,                      -- ZHIK_HAUPTVS
    ZZ_EIGENTNVS,                    -- ZHIK_EIGENNVS
    ZZ_ZKLEMME,                      -- ZZ_ZKLEMME
    ZZ_ANTENNE,                      -- ZZ_ANTENNE
    PRIMARY KEY (MANDT, VSTELLE)
);

Learn More