I_REProperty

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_REProperty.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IREPROPERTY

CREATE VIEW I_REProperty AS
SELECT
  intreno AS InternalRealEstateNumber,
  bukrs AS CompanyCode,
  cast(swenr as rebdvdmbeno preserving type) AS REBusinessEntity,
  cast(sgrnr as rebdvdmprno preserving type) AS RealEstateProperty,
  objnr AS REStatusObject,
  cast(imkey as recaimkeyfi preserving type) AS REInternalFinNumber,
  creationtype AS RECreationType,
  rerf AS CreatedByUser,
  derf AS CreationDate,
  terf AS CreationTime,
  reher AS RESourceOfCreation,
  rbear AS LastChangedByUser,
  dbear AS LastChangeDate,
  tbear AS LastChangeTime,
  rbher AS RESourceOfChange,
  Responsible,
  userexclusive AS REUserExclusive,
  authgrp AS REAuthorizationGroup,
  cast( validfrom as rebdvdmvalidfrom ) AS ValidityStartDate,
  cast( validto as rebdvdmvalidto ) AS ValidityEndDate,
  xgrtxt AS REPropertyName,
  waers AS Currency,
  leins AS RELengthUnit,
  rgrnart AS REPropertyUsageTypePerLandUse,
  bdmqmb1 AS REPropertyMarketPrice,
  bdmqmb2 AS REPropertyPurchasePrice,
  bdnrwert AS REPropertyReferencePrice,
  bdnwert AS REPropertyPrice,
  dbdnwert AS REPropertyValDeterminationDate,
  rbeplan AS REDevelopmentPlanDescription,
  dbeplan AS REDevelopmentPlanDate,
  xnutzgru AS REPropertyUsageDescription,
  nzgrz AS REGrntdSiteOccupancyIndexValue,
  nzgfz AS REGrntdFloorAreaRatioValue,
  nzbmz AS REGrntdConstructionDimnValue,
  ntgrz AS REActlSiteOccupancyIndexValue,
  ntgfz AS REActlFloorAreaRatioValue,
  ntbmz AS REActlConstructionDimnValue,
  rnbplan AS REPropertyUsageTypePerDevPlan,
  sgrart AS REPropertyType,
  sgrqal AS RELocationQuality,
  sgrfrm AS REGroundType,
  sgrgzs AS REPropertyStatus,
  dwirtub AS REEconomicTransferDate,
  xgemark AS RELocalSubDistrict,
  nflurnr AS REPropertyTractNumberText,
  xflurst AS REParcelOfLandText,
  brflurst AS REFractionalParcelOfLandText,
  jerbbau AS REHeritableBuildingRight,
  gemeinde AS REMunicipalityKey,
  zulbauh AS REPermittedBuildingHeightQty,
  dverkauf AS RESaleDate,
  dvrkplan AS REPlannedSaleDate,
  sunutza AS REMainUsageType,
  usgfunction AS REFunctionOfObject,
  _REKeyAssgmt.RealEstateObjectType AS RealEstateObjectType,
  _REKeyAssgmt.REIdentificationKey AS REIdentificationKey
FROM vibdpr AS _REProperty
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON LastChangedByUser = _ChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ResponsibleUser ON Responsible = _ResponsibleUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureLength ON RELengthUnit = _UnitOfMeasureLength.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_RECreationType AS _RECreationType ON RECreationType = _RECreationType.RECreationType  -- association [0..1]
LEFT OUTER JOIN I_REKeyAssgmt AS _REKeyAssgmt ON InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_REObjectType AS _REObjectType ON RealEstateObjectType = _REObjectType.RealEstateObjectType  -- association [1..1]
LEFT OUTER JOIN I_REAuthorizationGroup AS _REAuthorizationGroup ON REAuthorizationGroup = _REAuthorizationGroup.REAuthorizationGroup AND RealEstateObjectType = _REAuthorizationGroup.RealEstateObjectType  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObject ON REStatusObject = _StatusObject.StatusObject  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatus AS _StatusObjectStatus ON REStatusObject = _StatusObjectStatus.StatusObject  -- association [1..*]
LEFT OUTER JOIN I_REObjectAddress AS _REObjectAddress ON InternalRealEstateNumber = _REObjectAddress.InternalRealEstateNumber  -- association [0..1]
LEFT OUTER JOIN I_REBusinessEntity AS _REBusinessEntity ON CompanyCode = _REBusinessEntity.CompanyCode AND REBusinessEntity = _REBusinessEntity.REBusinessEntity  -- association [1..1]
LEFT OUTER JOIN I_REPropertyType AS _REPropertyType ON REPropertyType = _REPropertyType.REPropertyType  -- association [0..1]
LEFT OUTER JOIN I_RELocationQuality AS _RELocationQuality ON RELocationQuality = _RELocationQuality.RELocationQuality  -- association [0..1]
LEFT OUTER JOIN I_REGroundType AS _REGroundType ON REGroundType = _REGroundType.REGroundType  -- association [0..1]
LEFT OUTER JOIN I_REPropertyStatus AS _REPropertyStatus ON REPropertyStatus = _REPropertyStatus.REPropertyStatus  -- association [0..1]
LEFT OUTER JOIN I_RELocalSubDistrict AS _RELocalSubDistrict ON RELocalSubDistrict = _RELocalSubDistrict.RELocalSubDistrict  -- association [0..1]
LEFT OUTER JOIN I_REMunicipality AS _REMunicipality ON REMunicipalityKey = _REMunicipality.REMunicipalityKey  -- association [0..1]
LEFT OUTER JOIN I_REPartnerAssgmt AS _REPartnerAssgmt ON InternalRealEstateNumber = _REPartnerAssgmt.InternalRealEstateNumber  -- association [0..*]
LEFT OUTER JOIN I_REObjectAssgmt AS _REObjectAssgmt ON REStatusObject = _REObjectAssgmt.REStatusObjectSource  -- association [0..*]
LEFT OUTER JOIN I_REOrganizationalAssgmtTerm AS _REOrganizationalAssgmtTerm ON InternalRealEstateNumber = _REOrganizationalAssgmtTerm.InternalRealEstateNumber  -- association [1..*]
LEFT OUTER JOIN I_REReminderObjRule AS _REReminderRule ON InternalRealEstateNumber = _REReminderRule.InternalRealEstateNumber  -- association [0..*]
LEFT OUTER JOIN I_REMeasurement AS _REMeasurement ON InternalRealEstateNumber = _REMeasurement.InternalRealEstateNumber  -- association [0..*]
;