VIBDRO

Transparent Table Application Table
81 Fields 1 CDS Views

Rental Object

VIBDRO is an SAP database table in S/4HANA. Rental Object. It contains 81 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RERentalObject view from BASIC Real Estate Rental Object

Fields (81)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY intreno RECAINTRENO RE Key
bukrs BUKRS Company Code
swenr REBDBENO Business Entity
smenr REBDRONO Rental Object
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
rotype REBDROTYPE RO Type
snunr REBDUSAGETYPE Usage Type
xmetxt REBDXRO Rental Obj Name
sgrnr REBDPRNO Land
sgenr REBDBUNO Building
saltnr SALTNR RU no. old
canbecommon REBDCANBECOMMON Common Usage
firstposting RECDCFSTARTFROM Cash Flow From
dbezu DBEZU Initial usage
dwtverm DWTVERM Date: Subs.rntal
dresab DRESA Date: Res.from
dresbis DRESB Date: Res.upto
sgebt SGEBT Build.part
rlrafixfitcate REAJRLRAFIXFITCATE Fix/Fitt.Categ.
rlraloc REAJRLRALOC Location Class
pzuabsp REBDSUREPERCENT Incr/Reduc.(%)
sposinmsp REBDRLRABASEIND Base Value
pposinmsp REBDRLRAPERCENT Percentage
perhoe PERHOE Increase (%)
rprozgrd RPROZGRD Variance reason
rlgesch RLGESCH Loc.on Floor
xstandnr VVXSTANDNR Park space.no
jeigwohn VVJEIGWOHN Sep.Ownership
sstockw VVSSTOCKW Floor
sstckbis VVSSTCKBIS To Floor
drestaur VVDRESTAUR Mod.date
cfarchivedto RECDCFARCHIVEDTO CF Archived To
cflockedto RECDCFLOCKEDTO CF Fixed Until
cfpostingfrom RECDCFPOSTINGFROM 1st Posting Frm
hascop RESCHASCOP Curr.Occ.Prin.
rlra REAJRLRA Repr.rent list
usesrlra REAJUSESRLRA RLR Used
buildyear VVYBAUJAHR ConstYr
currency WAERS Currency
commonowned REBDCOMMONOWNED Common Property
oolock REOROOLOCK Locked as Offer
neighborh1 REBDNEIGHBORHOOD Neighborhood
neighborh2 REBDNEIGHBORHOOD Neighborhood
neighborh3 REBDNEIGHBORHOOD Neighborhood
edid REXCCHEDID EDID
egid REXCCHEGID EGID
floor REXCCHROFLOOR Floor
floorloc REXCCHROFLOORLOC Location on Floor
ewid REXCCHEWID EWID
kitchen REXCCHROKITCHEN Cooking
adminno REXCCHROADMINNO Admin.Dwelling No.
doorno REXCCHRODOORNO Door Number
objcond REXCCHROCOND Dwelling Stat.
yeardeconstr REXCCHBUDECONYEAR Demolition Year
numrooms REXCCHRONUMROOMS No. of Rooms
livingarea REXCCHROAREA Floor Area (M2)
usagetype REXCCHROUSAGETYPE UsageType
gemeindech RELMLRDISTRICT Land Reg. Dist.
protcv REXCNLPROTCV Protected City View
llpmon REXCNLLLPMON Conservation by LL
carehome REXCNLCAREHOME Care Home
statmon REXCNLSTATMON State Monument
vpt REXCPTVPT_NOSIGN Prop Tax. Value
vptcurrency 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.

-- Rental Object
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VIBDRO (
    MANDT,           -- Client [MANDT]
    INTRENO,         -- RE Key [RECAINTRENO]
    BUKRS,           -- Company Code [BUKRS]
    SWENR,           -- Business Entity [REBDBENO]
    SMENR,           -- Rental Object [REBDRONO]
    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]
    ROTYPE,          -- RO Type [REBDROTYPE]
    SNUNR,           -- Usage Type [REBDUSAGETYPE]
    XMETXT,          -- Rental Obj Name [REBDXRO]
    SGRNR,           -- Land [REBDPRNO]
    SGENR,           -- Building [REBDBUNO]
    SALTNR,          -- RU no. old [SALTNR]
    CANBECOMMON,     -- Common Usage [REBDCANBECOMMON]
    FIRSTPOSTING,    -- Cash Flow From [RECDCFSTARTFROM]
    DBEZU,           -- Initial usage [DBEZU]
    DWTVERM,         -- Date: Subs.rntal [DWTVERM]
    DRESAB,          -- Date: Res.from [DRESA]
    DRESBIS,         -- Date: Res.upto [DRESB]
    SGEBT,           -- Build.part [SGEBT]
    RLRAFIXFITCATE,  -- Fix/Fitt.Categ. [REAJRLRAFIXFITCATE]
    RLRALOC,         -- Location Class [REAJRLRALOC]
    PZUABSP,         -- Incr/Reduc.(%) [REBDSUREPERCENT]
    SPOSINMSP,       -- Base Value [REBDRLRABASEIND]
    PPOSINMSP,       -- Percentage [REBDRLRAPERCENT]
    PERHOE,          -- Increase (%) [PERHOE]
    RPROZGRD,        -- Variance reason [RPROZGRD]
    RLGESCH,         -- Loc.on Floor [RLGESCH]
    XSTANDNR,        -- Park space.no [VVXSTANDNR]
    JEIGWOHN,        -- Sep.Ownership [VVJEIGWOHN]
    SSTOCKW,         -- Floor [VVSSTOCKW]
    SSTCKBIS,        -- To Floor [VVSSTCKBIS]
    DRESTAUR,        -- Mod.date [VVDRESTAUR]
    CFARCHIVEDTO,    -- CF Archived To [RECDCFARCHIVEDTO]
    CFLOCKEDTO,      -- CF Fixed Until [RECDCFLOCKEDTO]
    CFPOSTINGFROM,   -- 1st Posting Frm [RECDCFPOSTINGFROM]
    HASCOP,          -- Curr.Occ.Prin. [RESCHASCOP]
    RLRA,            -- Repr.rent list [REAJRLRA]
    USESRLRA,        -- RLR Used [REAJUSESRLRA]
    BUILDYEAR,       -- ConstYr [VVYBAUJAHR]
    CURRENCY,        -- Currency [WAERS]
    COMMONOWNED,     -- Common Property [REBDCOMMONOWNED]
    OOLOCK,          -- Locked as Offer [REOROOLOCK]
    NEIGHBORH1,      -- Neighborhood [REBDNEIGHBORHOOD]
    NEIGHBORH2,      -- Neighborhood [REBDNEIGHBORHOOD]
    NEIGHBORH3,      -- Neighborhood [REBDNEIGHBORHOOD]
    EDID,            -- EDID [REXCCHEDID]
    EGID,            -- EGID [REXCCHEGID]
    FLOOR,           -- Floor [REXCCHROFLOOR]
    FLOORLOC,        -- Location on Floor [REXCCHROFLOORLOC]
    EWID,            -- EWID [REXCCHEWID]
    KITCHEN,         -- Cooking [REXCCHROKITCHEN]
    ADMINNO,         -- Admin.Dwelling No. [REXCCHROADMINNO]
    DOORNO,          -- Door Number [REXCCHRODOORNO]
    OBJCOND,         -- Dwelling Stat. [REXCCHROCOND]
    YEARDECONSTR,    -- Demolition Year [REXCCHBUDECONYEAR]
    NUMROOMS,        -- No. of Rooms [REXCCHRONUMROOMS]
    LIVINGAREA,      -- Floor Area (M2) [REXCCHROAREA]
    USAGETYPE,       -- UsageType [REXCCHROUSAGETYPE]
    GEMEINDECH,      -- Land Reg. Dist. [RELMLRDISTRICT]
    PROTCV,          -- Protected City View [REXCNLPROTCV]
    LLPMON,          -- Conservation by LL [REXCNLLLPMON]
    CAREHOME,        -- Care Home [REXCNLCAREHOME]
    STATMON,         -- State Monument [REXCNLSTATMON]
    VPT,             -- Prop Tax. Value [REXCPTVPT_NOSIGN]
    VPTCURRENCY,     -- Currency [WAERS]
    CONDK,           -- Conserv. Level [REXCPTRACONS]
    PRIMARY KEY (MANDT, INTRENO)
);

Learn More