I_REBuilding

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_REBuilding.
-- 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: IREBUILDING

CREATE VIEW I_REBuilding AS
SELECT
  intreno AS InternalRealEstateNumber,
  bukrs AS CompanyCode,
  cast(swenr as rebdvdmbeno preserving type) AS REBusinessEntity,
  cast(sgenr as rebdvdmbuno preserving type) AS RealEstateBuilding,
  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,
  xgetxt AS REBuildingName,
  waers AS Currency,
  reins AS RECubicUnit,
  rgebart AS REBuildingType,
  jerbbau AS REHeritableBuildingRight,
  rgebzust AS REBuildingStatus,
  ybaujahr AS REConstructionDate,
  ymodern AS REModernizationDate,
  yaufbau AS REReconstructionDate,
  dbaubegi AS REConstructionStartDate,
  bbauwx AS REEstimatedConstructionCost,
  bbauwaktx AS RECurrentBuildingPrice,
  bdmcbmra AS REPerCubicMeterCost,
  dbaugene AS REBuildingPermitDate,
  xbaugene AS BuildingPermitNote,
  dbezugsf AS REReadyForOccupancyDate,
  dfertig AS RECompletionDate,
  dschluss AS REFinalInspectionDate,
  jdenkmal AS IsProtectedHistoricalSite,
  dbauvor AS REPlanningInquiryDate,
  dvorbes AS REPriorNoticeDate,
  dantbau AS REBuildingPermitApplDate,
  beinheitwx AS REAssessedBuildingPrice,
  neinheitw AS REDtmndAssessedValueYear,
  bverswrtx AS REInsurableFireDamageAmount,
  rverswrt AS REInsuranceValueType,
  dwirtub AS REEconomicTransferDate,
  dverkauf AS RESaleDate,
  dvrkplan AS REPlannedSaleDate,
  dnutzend AS REPlannedEndOfUsageDate,
  dfrdvon AS REPublicFundingStartDate,
  dfrdbis AS REPublicFundingEndDate,
  banzge AS NumberOfFloors,
  sunutza AS REMainUsageType,
  sstckbis AS HighestFloor,
  sliftbis AS ElevatorToFloor,
  augesch AS NumberOfBasements,
  rlraloc AS REListOfRentsLocationClass,
  usesrlra AS REListOfRentsIsUsed,
  gemeinde AS REMunicipalityKey,
  hascop AS RECurOccupancyPrincipleIsUsed,
  usgfunction AS REFunctionOfObject,
  _RELocationClass.REListOfRents AS REListOfRents,
  _REKeyAssgmt.RealEstateObjectType AS RealEstateObjectType,
  _REKeyAssgmt.REIdentificationKey AS REIdentificationKey
FROM vibdbu AS _REBuilding
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 _UnitOfMeasureCubic ON RECubicUnit = _UnitOfMeasureCubic.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_REObjectClassification AS _REObjectClassification ON REBuildingType = _REObjectClassification.REObjectClassification  -- 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_REMunicipality AS _REMunicipality ON REMunicipalityKey = _REMunicipality.REMunicipalityKey  -- association [0..1]
LEFT OUTER JOIN I_REObjectState AS _REObjectState ON REBuildingStatus = _REObjectState.REObjectState  -- association [0..1]
LEFT OUTER JOIN I_REInsuranceValueType AS _REInsuranceValueType ON REInsuranceValueType = _REInsuranceValueType.REInsuranceValueType  -- association [0..1]
LEFT OUTER JOIN I_REListOfRents AS _REListOfRents ON REListOfRents = _REListOfRents.REListOfRents  -- 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..*]
;