I_REProperty

Real Estate Property | view: IREPROPERTY | ATTR | Extraction: Full or Incremental | Component: Basic Data
Tables used: VICAINTRENOVIBDPR
Column Name Description
InternalRealEstateNumber Internal Key of Real Estate Object
Column Name Description
💲 Currency Key (Currency):
REPropertyMarketPrice Market value
REPropertyPurchasePrice Purchase price
REPropertyReferencePrice Land reference value for determining current market value
REPropertyPrice Land value for determining current market value
Column Name Description
📏 Unit of length (RELengthUnit):
REPermittedBuildingHeightQty Permitted building height
Column Name Description
CreationDate First Entered On
CreationTime Time of Creation
LastChangeDate Last Edited On
LastChangeTime Last Edited At
ValidityStartDate Validity Start Date
ValidityEndDate Validity End Date
REPropertyValDeterminationDate Date of land value
REDevelopmentPlanDate Date of development plan
REEconomicTransferDate Transfer usage / charges
RESaleDate Sale date
REPlannedSaleDate Planned sale
Column Name Description
RECreationType How the Object Was Created Show values
Column Name Description Domain name
REBusinessEntity RE Business Entity REBDVDMBENO
RealEstateProperty Real Estate Property REBDVDMPRNO
REInternalFinNumber Internal Key of Real Estate Object (FI) IMKEYNOCONV
CreatedByUser Entered By SYCHAR12
RESourceOfCreation Source of Initial Entry CHAR10
LastChangedByUser Employee ID SYCHAR12
RESourceOfChange Editing Source CHAR10
REAuthorizationGroup Authorization Group RECAAUTHGRP
REPropertyName Name of Land RECAXLDESCRIPTION
REDevelopmentPlanDescription Development plan XMBEZ
REPropertyUsageDescription Current usage of property XMBEZ
REGrntdSiteOccupancyIndexValue Permitted Usage: Site Occupancy Index DEC1_2
REGrntdFloorAreaRatioValue Permitted Usage: Floor Area Ratio DEC2_2
REGrntdConstructionDimnValue Permitted Usage: Construction Dimension Number DEC3_2
REActlSiteOccupancyIndexValue Actual Usage: Site Occupancy Index DEC1_2
REActlFloorAreaRatioValue Actual Usage: Floor Area Ratio DEC2_2
REActlConstructionDimnValue Actual Usage: Construction Dimension Number DEC3_2
REPropertyTractNumberText Number of Tract of Land in Land Register NFLURNR
REParcelOfLandText Parcel of Land TEXT10
REFractionalParcelOfLandText Fractional Parcel of Land VVBRFLURST
REIdentificationKey ID Part Key, for example "1000/123" CHAR45
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_REPROPERTY.COMPANYCODE == T001.BUKRS
  • I_REPROPERTY.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • I_REPROPERTY.CURRENCY == TCURC.WAERS
  • I_REPROPERTY.MANDT == TCURC.MANDT
Function of Object
  • ?
  • Function of Object
  • Client
Ground Type
  • Client
  • Property ground type
  • I_REPROPERTY.MANDT == TIV58.MANDT
  • I_REPROPERTY.REGROUNDTYPE == TIV58.SGRFRM
Heritable building right indicator
  • Heritable building right indicator
  • Client
  • I_REPROPERTY.REHERITABLEBUILDINGRIGHT == TDO9.SOBJERBBAU
  • I_REPROPERTY.MANDT == TDO9.MANDT
Unit of length
  • Unit of length
  • Client
  • I_REPROPERTY.RELENGTHUNIT == T006.MSEHI
  • I_REPROPERTY.MANDT == T006.MANDT
Local Subdistrict
  • Local Subdistrict
  • Client
  • I_REPROPERTY.RELOCALSUBDISTRICT == TIVG2.GEMARK
  • I_REPROPERTY.MANDT == TIVG2.MANDT
Property Quality
  • Client
  • Property: Quality of location
  • I_REPROPERTY.MANDT == TIV57.MANDT
  • I_REPROPERTY.RELOCATIONQUALITY == TIV57.SGRQAL
Main Usage Type
  • Main usage type
  • Client
  • I_REPROPERTY.REMAINUSAGETYPE == TIV36.SUNART
  • I_REPROPERTY.MANDT == TIV36.MANDT
Municipality key
  • Municipality key
  • Client
  • I_REPROPERTY.REMUNICIPALITYKEY == TIVG1.GEMEINDE
  • I_REPROPERTY.MANDT == TIVG1.MANDT
Overall Condition
  • Overall condition of property
  • Client
  • I_REPROPERTY.REPROPERTYSTATUS == TIV59.SGRGZS
  • I_REPROPERTY.MANDT == TIV59.MANDT
Property Type
  • Property type
  • Client
  • I_REPROPERTY.REPROPERTYTYPE == TIV56.SGRART
  • I_REPROPERTY.MANDT == TIV56.MANDT
Usage type according to development plan
  • Usage type according to development plan
  • Client
  • I_REPROPERTY.REPROPERTYUSAGETYPEPERDEVPLAN == TIVB3.RNBPLAN
  • I_REPROPERTY.MANDT == TIVB3.MANDT
Usage Type of Property According to Land Use Map
  • Usage Type of Property According to Land Use Map
  • Client
  • I_REPROPERTY.REPROPERTYUSAGETYPEPERLANDUSE == TIVC4.RGRNART
  • I_REPROPERTY.MANDT == TIVC4.MANDT
Person Responsible
  • Person Responsible
  • Client
  • I_REPROPERTY.RESPONSIBLE == USR02.BNAME
  • I_REPROPERTY.MANDT == USR02.MANDT
User with Exclusive Change Authorization
  • User with Exclusive Change Authorization
  • Client
  • I_REPROPERTY.REUSEREXCLUSIVE == USR02.BNAME
  • I_REPROPERTY.MANDT == USR02.MANDT