VIBDBU

Transparent Table Application Table
97 Fields 1 CDS Views

Building

VIBDBU is an SAP database table in S/4HANA. Building. It contains 97 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_REBuilding view from BASIC Real Estate Building

Fields (97)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY intreno RECAINTRENO RE Key
bukrs BUKRS Company Code
swenr REBDBENO Business Entity
sgenr REBDBUNO Building
objnr RECAOBJNR Object Number
imkey RECAIMKEY Real Estate Key
creationtype RECACREATIONTYPE How Created
rerf RERF Entered By
derf DERF First Enterd On
terf TERF Time
reher REHER Source.In.Entry
rbear RBEAR Last Changed By
dbear DBEAR Last Edited On
tbear TBEAR Last Edited At
rbher RBHER Editing Source
responsible RECARESPONSIBLE Person Respons.
userexclusive RECAUSEREXCLUSIVE Change Auth.
authgrp RECAAUTHGRP Authoriz. Group
validfrom REBDOBJVALIDFROM Obj. Valid From
validto REBDOBJVALIDTO Object Valid To
xgetxt REBDXBU Building Name
rgebart RGEBART Building type
jerbbau JERBBAU Her.build.right
rgebzust RGEBZUST Building cond.
ybaujahr VVYBAUJAHR ConstYr
ymodern VVYMODERN Modernization
yaufbau VVYAUFBAU Reconstruct.
dbaubegi DBAUBEGI Beg. const
bbauw13 BBAUWXOLD BldValOld
bbauwx BBAUWX Building Value
bbauwakt BBAUWAKTXOLD CurrBldValOld
bbauwaktx BBAUWAKTX Curr.Build.Val.
bdmcbmra BDMCBMRA Amnt/vol.unit
dbaugene DBAUGENE Building permit
xbaugene XBAUGENE BuildPermNote
dbezugsf DBEZUGSF Ready for occ.
dfertig DFERTIG Completion
dschluss DSCHLUSS Final Inspect.
jdenkmal JDENKMAL Prot.Hist.Sites
dbauvor DBAUVOR Plan. inquiry
dvorbes DVORBES Prior notice
dantbau DANTBAU Build.perm.app.
beinheitw BEINHEITWXOLD AssessedValOld
beinheitwx BEINHEITWX Assessed Value
neinheitw NEINHEITW Yr assessedVal
bverswrt BVERSWRTXOLD Insur. Val. Old
bverswrtx BVERSWRTX Insurable Val.
rverswrt RVERSWRT TypeInsuranVal
dwirtub VVDWIRTUB TrnsfrUsag/chrg
dverkauf VVDVERKAUF Sale
dvrkplan VVDVRKPLAN Planned sale
dnutzend VVDNUTZEND End of usage
dfrdvon VVDFRDVON PublicFund.frm
dfrdbis VVDFRDBIS Publ.funding to
banzge VVBANZGE No. of floors
sunutza VVSUNART Main usage type
junutza REBDJUNUTZAOBS Obsolete
sstckbis VVSTCKBIS Top Floor
sliftbis VVLIFTBIS Elev. to floor
augesch AUGESCH Basements
janlhie REBDJANLHIEOBS Obsolete
rlraloc REAJRLRALOC Location Class
usesrlra REAJUSESRLRA RLR Used
gemeinde VVGEMEINDE Municipality key
reins REINS Volume unit
waers WAERS Currency
hascop RESCHASCOP Curr.Occ.Prin.
usgfunction REBDUSGFUNCTION Function
objcond REXCCHBUCOND Building Stat.
objcat REXCCHBUCATEGORY Build. Categ. Code
yeardeconstr REXCCHBUDECONYEAR Demolition Year
areavalue REXCCHBUAREA Floor Area (M2)
heatingtype REXCCHBUHEATINGTYPE Heating Type
energyheat REXCCHBUENERGYSOURCEH En.Carrier (Heating)
energywater REXCCHBUENERGYSOURCEW En.Carrier (Water)
hotwatersupply REXCCHBUHOTWATER Hot W. Supply
powerconsum REXCCHBUPOWERCONSUMPTION Power Cons(kWh)
glazing REXCCHBUGLAZING Glazing Type
adminno REXCCHBUADMINNO Admin BU No.
adminxgetxt REXCCHBUADMINXBU Building Name
gemeindech RELMLRDISTRICT Land Reg. Dist.
banzgech VVBANZGE No. of floors
sstckbisch VVSTCKBIS Top Floor
sliftbisch VVLIFTBIS Elev. to floor
augeschch AUGESCH Basements
secco SECCO Section Code
bupla BUPLA Business place
repkoch REXCJPREPKOCH Kind of Change
bdconstr REXCJPBDCONSTR Construction Status
bdfireprev REXCJPBDFIREPREV Fire Fighting Method
bdothow REXCJPBDOTHOW Other Owner Number
bdownship REXCJPBDOWNSHIP Building Owner Stat
kochdate REXCJPKOCHDATE Date of Change in KC
vpt REXCPTVPT_NOSIGN Prop Tax. Value
currency WAERS Currency
condk REXCPTRACONS Conserv. Level

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.

-- Building
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VIBDBU (
    MANDT,           -- Client [MANDT]
    INTRENO,         -- RE Key [RECAINTRENO]
    BUKRS,           -- Company Code [BUKRS]
    SWENR,           -- Business Entity [REBDBENO]
    SGENR,           -- Building [REBDBUNO]
    OBJNR,           -- Object Number [RECAOBJNR]
    IMKEY,           -- Real Estate Key [RECAIMKEY]
    CREATIONTYPE,    -- How Created [RECACREATIONTYPE]
    RERF,            -- Entered By [RERF]
    DERF,            -- First Enterd On [DERF]
    TERF,            -- Time [TERF]
    REHER,           -- Source.In.Entry [REHER]
    RBEAR,           -- Last Changed By [RBEAR]
    DBEAR,           -- Last Edited On [DBEAR]
    TBEAR,           -- Last Edited At [TBEAR]
    RBHER,           -- Editing Source [RBHER]
    RESPONSIBLE,     -- Person Respons. [RECARESPONSIBLE]
    USEREXCLUSIVE,   -- Change Auth. [RECAUSEREXCLUSIVE]
    AUTHGRP,         -- Authoriz. Group [RECAAUTHGRP]
    VALIDFROM,       -- Obj. Valid From [REBDOBJVALIDFROM]
    VALIDTO,         -- Object Valid To [REBDOBJVALIDTO]
    XGETXT,          -- Building Name [REBDXBU]
    RGEBART,         -- Building type [RGEBART]
    JERBBAU,         -- Her.build.right [JERBBAU]
    RGEBZUST,        -- Building cond. [RGEBZUST]
    YBAUJAHR,        -- ConstYr [VVYBAUJAHR]
    YMODERN,         -- Modernization [VVYMODERN]
    YAUFBAU,         -- Reconstruct. [VVYAUFBAU]
    DBAUBEGI,        -- Beg. const [DBAUBEGI]
    BBAUW13,         -- BldValOld [BBAUWXOLD]
    BBAUWX,          -- Building Value [BBAUWX]
    BBAUWAKT,        -- CurrBldValOld [BBAUWAKTXOLD]
    BBAUWAKTX,       -- Curr.Build.Val. [BBAUWAKTX]
    BDMCBMRA,        -- Amnt/vol.unit [BDMCBMRA]
    DBAUGENE,        -- Building permit [DBAUGENE]
    XBAUGENE,        -- BuildPermNote [XBAUGENE]
    DBEZUGSF,        -- Ready for occ. [DBEZUGSF]
    DFERTIG,         -- Completion [DFERTIG]
    DSCHLUSS,        -- Final Inspect. [DSCHLUSS]
    JDENKMAL,        -- Prot.Hist.Sites [JDENKMAL]
    DBAUVOR,         -- Plan. inquiry [DBAUVOR]
    DVORBES,         -- Prior notice [DVORBES]
    DANTBAU,         -- Build.perm.app. [DANTBAU]
    BEINHEITW,       -- AssessedValOld [BEINHEITWXOLD]
    BEINHEITWX,      -- Assessed Value [BEINHEITWX]
    NEINHEITW,       -- Yr assessedVal [NEINHEITW]
    BVERSWRT,        -- Insur. Val. Old [BVERSWRTXOLD]
    BVERSWRTX,       -- Insurable Val. [BVERSWRTX]
    RVERSWRT,        -- TypeInsuranVal [RVERSWRT]
    DWIRTUB,         -- TrnsfrUsag/chrg [VVDWIRTUB]
    DVERKAUF,        -- Sale [VVDVERKAUF]
    DVRKPLAN,        -- Planned sale [VVDVRKPLAN]
    DNUTZEND,        -- End of usage [VVDNUTZEND]
    DFRDVON,         -- PublicFund.frm [VVDFRDVON]
    DFRDBIS,         -- Publ.funding to [VVDFRDBIS]
    BANZGE,          -- No. of floors [VVBANZGE]
    SUNUTZA,         -- Main usage type [VVSUNART]
    JUNUTZA,         -- Obsolete [REBDJUNUTZAOBS]
    SSTCKBIS,        -- Top Floor [VVSTCKBIS]
    SLIFTBIS,        -- Elev. to floor [VVLIFTBIS]
    AUGESCH,         -- Basements [AUGESCH]
    JANLHIE,         -- Obsolete [REBDJANLHIEOBS]
    RLRALOC,         -- Location Class [REAJRLRALOC]
    USESRLRA,        -- RLR Used [REAJUSESRLRA]
    GEMEINDE,        -- Municipality key [VVGEMEINDE]
    REINS,           -- Volume unit [REINS]
    WAERS,           -- Currency [WAERS]
    HASCOP,          -- Curr.Occ.Prin. [RESCHASCOP]
    USGFUNCTION,     -- Function [REBDUSGFUNCTION]
    OBJCOND,         -- Building Stat. [REXCCHBUCOND]
    OBJCAT,          -- Build. Categ. Code [REXCCHBUCATEGORY]
    YEARDECONSTR,    -- Demolition Year [REXCCHBUDECONYEAR]
    AREAVALUE,       -- Floor Area (M2) [REXCCHBUAREA]
    HEATINGTYPE,     -- Heating Type [REXCCHBUHEATINGTYPE]
    ENERGYHEAT,      -- En.Carrier (Heating) [REXCCHBUENERGYSOURCEH]
    ENERGYWATER,     -- En.Carrier (Water) [REXCCHBUENERGYSOURCEW]
    HOTWATERSUPPLY,  -- Hot W. Supply [REXCCHBUHOTWATER]
    POWERCONSUM,     -- Power Cons(kWh) [REXCCHBUPOWERCONSUMPTION]
    GLAZING,         -- Glazing Type [REXCCHBUGLAZING]
    ADMINNO,         -- Admin BU No. [REXCCHBUADMINNO]
    ADMINXGETXT,     -- Building Name [REXCCHBUADMINXBU]
    GEMEINDECH,      -- Land Reg. Dist. [RELMLRDISTRICT]
    BANZGECH,        -- No. of floors [VVBANZGE]
    SSTCKBISCH,      -- Top Floor [VVSTCKBIS]
    SLIFTBISCH,      -- Elev. to floor [VVLIFTBIS]
    AUGESCHCH,       -- Basements [AUGESCH]
    SECCO,           -- Section Code [SECCO]
    BUPLA,           -- Business place [BUPLA]
    REPKOCH,         -- Kind of Change [REXCJPREPKOCH]
    BDCONSTR,        -- Construction Status [REXCJPBDCONSTR]
    BDFIREPREV,      -- Fire Fighting Method [REXCJPBDFIREPREV]
    BDOTHOW,         -- Other Owner Number [REXCJPBDOTHOW]
    BDOWNSHIP,       -- Building Owner Stat [REXCJPBDOWNSHIP]
    KOCHDATE,        -- Date of Change in KC [REXCJPKOCHDATE]
    VPT,             -- Prop Tax. Value [REXCPTVPT_NOSIGN]
    CURRENCY,        -- Currency [WAERS]
    CONDK,           -- Conserv. Level [REXCPTRACONS]
    PRIMARY KEY (MANDT, INTRENO)
);

Learn More