VIBDPR

Transparent Table Application Table
65 Fields 1 CDS Views

Land

VIBDPR is an SAP database table in S/4HANA. Land. It contains 65 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_REProperty view from BASIC Real Estate Property

Fields (65)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY intreno RECAINTRENO RE Key
bukrs BUKRS Company Code
swenr REBDBENO Business Entity
sgrnr REBDPRNO Land
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
xgrtxt REBDXPR Name of Land
rgrnart RGRNART Usage land map
bdmqmb1 BDMQMB1 Market value
bdmqmb2 BDMQMB2 Purchase price
bdnrwert BDNRWERT Land ref.value
bdnwert BDNWERT Land value
dbdnwert DBDNWERT Land value date
rbeplan RBEPLAN Develop.plan
dbeplan DBEPLAN Plan dated
xnutzgru XNUTZGRU Curr. usage
nzgrz NZGRZ PrmSite Occ.Ind
nzgfz NZGFZ Perm.FAR
nzbmz NZBMZ PrCnstDimensNo.
ntgrz NTGRZ ActSiteOccIndex
ntgfz NTGFZ Act.FAR
ntbmz NTBMZ ActConstDimNo.
rnbplan RNBPLAN UsagDevelPlan
sgrart VVSGRART Property type
sgrqal VVSGRQAL Loc.quality
sgrfrm VVSGRFRM Ground type
sgrgzs VVSGRGZS Overall cond.
dwirtub VVDWIRTUB TrnsfrUsag/chrg
dverkauf VVDVERKAUF Sale
sunutza VVSUNART Main usage type
junutza REBDJUNUTZAOBS Obsolete
dvrkplan VVDVRKPLAN Planned sale
xgemark VVGEMARK Loc Subdistrict
nflurnr NFLURNR Tract of Land
xflurst XFLURST Parcel of Land
brflurst VVBRFLURST Fract. Parcel
jerbbau JERBBAU Her.build.right
gemeinde VVGEMEINDE Municipality key
zulbauh VVZULBAUH Allowed Ht
leins VVLEINS Unit of length
waers WAERS Currency
usgfunction REBDUSGFUNCTION Function
planno RELMRPRGNO RPR No.
locationch REXCCHPRLOCATION Location Descr.
estatedescr REXCCHPRDESCRIPTION Location Descr.
gemeindech RELMLRDISTRICT Land Reg. Dist.
secco SECCO Section Code
bupla BUPLA Business place
vpt REXCPTVPT_NOSIGN Prop Tax. Value
currency WAERS Currency

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.

-- Land
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VIBDPR (
    MANDT,          -- Client [MANDT]
    INTRENO,        -- RE Key [RECAINTRENO]
    BUKRS,          -- Company Code [BUKRS]
    SWENR,          -- Business Entity [REBDBENO]
    SGRNR,          -- Land [REBDPRNO]
    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]
    XGRTXT,         -- Name of Land [REBDXPR]
    RGRNART,        -- Usage land map [RGRNART]
    BDMQMB1,        -- Market value [BDMQMB1]
    BDMQMB2,        -- Purchase price [BDMQMB2]
    BDNRWERT,       -- Land ref.value [BDNRWERT]
    BDNWERT,        -- Land value [BDNWERT]
    DBDNWERT,       -- Land value date [DBDNWERT]
    RBEPLAN,        -- Develop.plan [RBEPLAN]
    DBEPLAN,        -- Plan dated [DBEPLAN]
    XNUTZGRU,       -- Curr. usage [XNUTZGRU]
    NZGRZ,          -- PrmSite Occ.Ind [NZGRZ]
    NZGFZ,          -- Perm.FAR [NZGFZ]
    NZBMZ,          -- PrCnstDimensNo. [NZBMZ]
    NTGRZ,          -- ActSiteOccIndex [NTGRZ]
    NTGFZ,          -- Act.FAR [NTGFZ]
    NTBMZ,          -- ActConstDimNo. [NTBMZ]
    RNBPLAN,        -- UsagDevelPlan [RNBPLAN]
    SGRART,         -- Property type [VVSGRART]
    SGRQAL,         -- Loc.quality [VVSGRQAL]
    SGRFRM,         -- Ground type [VVSGRFRM]
    SGRGZS,         -- Overall cond. [VVSGRGZS]
    DWIRTUB,        -- TrnsfrUsag/chrg [VVDWIRTUB]
    DVERKAUF,       -- Sale [VVDVERKAUF]
    SUNUTZA,        -- Main usage type [VVSUNART]
    JUNUTZA,        -- Obsolete [REBDJUNUTZAOBS]
    DVRKPLAN,       -- Planned sale [VVDVRKPLAN]
    XGEMARK,        -- Loc Subdistrict [VVGEMARK]
    NFLURNR,        -- Tract of Land [NFLURNR]
    XFLURST,        -- Parcel of Land [XFLURST]
    BRFLURST,       -- Fract. Parcel [VVBRFLURST]
    JERBBAU,        -- Her.build.right [JERBBAU]
    GEMEINDE,       -- Municipality key [VVGEMEINDE]
    ZULBAUH,        -- Allowed Ht [VVZULBAUH]
    LEINS,          -- Unit of length [VVLEINS]
    WAERS,          -- Currency [WAERS]
    USGFUNCTION,    -- Function [REBDUSGFUNCTION]
    PLANNO,         -- RPR No. [RELMRPRGNO]
    LOCATIONCH,     -- Location Descr. [REXCCHPRLOCATION]
    ESTATEDESCR,    -- Location Descr. [REXCCHPRDESCRIPTION]
    GEMEINDECH,     -- Land Reg. Dist. [RELMLRDISTRICT]
    SECCO,          -- Section Code [SECCO]
    BUPLA,          -- Business place [BUPLA]
    VPT,            -- Prop Tax. Value [REXCPTVPT_NOSIGN]
    CURRENCY,       -- Currency [WAERS]
    PRIMARY KEY (MANDT, INTRENO)
);

Learn More