I_RERentalObject

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_RERentalObject.
-- 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: IRERENTOBJECT

CREATE VIEW I_RERentalObject AS
SELECT
  intreno AS InternalRealEstateNumber,
  bukrs AS CompanyCode,
  cast(swenr as rebdvdmbeno preserving type) AS REBusinessEntity,
  cast(smenr as rebdvdmrono preserving type) AS RERentalObject,
  cast(sgenr as rebdvdmbuno preserving type) AS RealEstateBuilding,
  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,
  xmetxt AS RERentalObjectName,
  rotype AS RentalObjectType,
  snunr AS RERentalObjectUsageType,
  buildyear AS REConstructionDate,
  Currency,
  firstposting AS REFirstPostingFromDate,
  cfarchivedto AS RECashFlowArchivedToDate,
  cflockedto AS RECashFlowLockedToDate,
  cfpostingfrom AS RECashFlowPostingFromDate,
  sstockw AS FloorLevel,
  saltnr AS RERentalUnitNumberText,
  canbecommon AS RECommonUsageIsAllowed,
  dbezu AS REInitialUsageDate,
  dwtverm AS RESubsequentRentalDate,
  dresab AS REReservedFromDate,
  dresbis AS REReservedToDate,
  sgebt AS REBuildingSection,
  rlrafixfitcate AS REFixturesAndFittingsCat,
  rlraloc AS REListOfRentsLocationClass,
  pzuabsp AS REListOfRentsChangeValue,
  sposinmsp AS REListOfRentsBaseRentCalc,
  pposinmsp AS REListOfRentsSpreadStrtgValue,
  perhoe AS REPercentageRateIncreaseValue,
  rprozgrd AS REVarianceReasonForPercentage,
  rlgesch AS RELocationOnFloor,
  xstandnr AS REParkingLotNumberText,
  jeigwohn AS RERentalUnitHasDiffntOwnership,
  sstckbis AS RERentalUnitTopFloor,
  drestaur AS REModernizationDate,
  hascop AS RECurOccupancyPrincipleIsUsed,
  rlra AS REListOfRents,
  usesrlra AS REListOfRentsIsUsed,
  commonowned AS RERentalObjectIsCommonProperty,
  oolock AS REIsNotConsideredForSearch,
  neighborh1 AS RENeighborhood01Text,
  neighborh2 AS RENeighborhood02Text,
  neighborh3 AS RENeighborhood03Text,
  _REKeyAssgmt.RealEstateObjectType AS RealEstateObjectType,
  _REKeyAssgmt.REIdentificationKey AS REIdentificationKey
FROM vibdro AS _RERentalObject
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_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_RERentalObjectType AS _RERentalObjectType ON RentalObjectType = _RERentalObjectType.RentalObjectType  -- association [1..1]
LEFT OUTER JOIN I_RERentalObjectUsageType AS _RERentalObjectUsageType ON RERentalObjectUsageType = _RERentalObjectUsageType.RERentalObjectUsageType  -- association [1..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_REBuilding AS _REBuilding ON CompanyCode = _REBuilding.CompanyCode AND REBusinessEntity = _REBuilding.REBusinessEntity AND RealEstateBuilding = _REBuilding.RealEstateBuilding  -- association [0..1]
LEFT OUTER JOIN I_REProperty AS _REProperty ON CompanyCode = _REProperty.CompanyCode AND REBusinessEntity = _REProperty.REBusinessEntity AND RealEstateProperty = _REProperty.RealEstateProperty  -- association [0..1]
LEFT OUTER JOIN I_REBuildingSection AS _REBuildingSection ON REBuildingSection = _REBuildingSection.REBuildingSection  -- association [0..1]
LEFT OUTER JOIN I_REFixturesAndFttgsCat AS _REFixturesAndFttgsCat ON REFixturesAndFittingsCat = _REFixturesAndFttgsCat.REFixturesAndFittingsCat AND REListOfRents = _REFixturesAndFttgsCat.REListOfRents  -- association [0..1]
LEFT OUTER JOIN I_RELocationClass AS _RELocationClass ON REListOfRentsLocationClass = _RELocationClass.REListOfRentsLocationClass AND REListOfRents = _RELocationClass.REListOfRents  -- association [0..1]
LEFT OUTER JOIN I_REVarcRsnForPercentage AS _REVarcRsnForPercentage ON REVarianceReasonForPercentage = _REVarcRsnForPercentage.REVarianceReasonForPercentage  -- association [0..1]
LEFT OUTER JOIN I_RELocationOnFloor AS _RELocationOnFloor ON RELocationOnFloor = _RELocationOnFloor.RELocationOnFloor  -- association [0..1]
LEFT OUTER JOIN I_REFloor AS _REFloor ON RERentalUnitTopFloor = _REFloor.REFloor  -- association [0..1]
LEFT OUTER JOIN I_REListOfRents AS _REListOfRents ON REListOfRents = _REListOfRents.REListOfRents  -- association [0..1]
LEFT OUTER JOIN I_REListOfRentsBaseRentCalc AS _REListOfRentsBaseRentCalc ON REListOfRentsBaseRentCalc = _REListOfRentsBaseRentCalc.REListOfRentsBaseRentCalc  -- 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_RECondition AS _RECondition ON InternalRealEstateNumber = _RECondition.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..*]
;