I_REBusinessEntity

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_REBusinessEntity.
-- 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: IREBUSENTITY

CREATE VIEW I_REBusinessEntity AS
SELECT
  intreno AS InternalRealEstateNumber,
  bukrs AS CompanyCode,
  cast(swenr as rebdvdmbeno preserving type) AS REBusinessEntity,
  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,
  xwetext AS REBusinessEntityName,
  waers AS Currency,
  feins AS REAreaUnit,
  reins AS RECubicUnit,
  vvlen AS RELengthUnit,
  sinstbez AS REMaintenanceDistrict,
  sstdort AS RERegionalLocation,
  sverkehr AS RETransportConnectionBusEntity,
  slagewe AS RELocationNumberBusEntity,
  sobjlage AS REDistrictLocation,
  smietr AS RETenancyLaw,
  rlra AS REListOfRents,
  vorbk AS REPrdfndOperatingCostSettlmt,
  vorhk AS REPrdfndHeatingCostSettlmt,
  xnotpl AS REAutomCrtnOfFuncnlLocIsOff,
  neighborh1 AS RENeighborhood01Text,
  neighborh2 AS RENeighborhood02Text,
  neighborh3 AS RENeighborhood03Text,
  usgfunction AS REFunctionOfObject,
  _REKeyAssgmt.RealEstateObjectType AS RealEstateObjectType,
  _REKeyAssgmt.REIdentificationKey AS REIdentificationKey
FROM vibdbe AS _REBusinessEntity
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 _UnitOfMeasureArea ON REAreaUnit = _UnitOfMeasureArea.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureCubic ON RECubicUnit = _UnitOfMeasureCubic.UnitOfMeasure  -- 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_RETenancyLaw AS _RETenancyLaw ON RETenancyLaw = _RETenancyLaw.RETenancyLaw  -- 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_REMaintenanceDistrict AS _REMaintenanceDistrict ON REMaintenanceDistrict = _REMaintenanceDistrict.REMaintenanceDistrict  -- association [0..1]
LEFT OUTER JOIN I_RERegionalLocation AS _RERegionalLocation ON RERegionalLocation = _RERegionalLocation.RERegionalLocation  -- association [0..1]
LEFT OUTER JOIN I_RETransportConnection AS _RETransportConnection ON RETransportConnectionBusEntity = _RETransportConnection.RETransportConnectionBusEntity  -- association [0..1]
LEFT OUTER JOIN I_RELocationNumberBusEntity AS _RELocationNumberBusEntity ON RELocationNumberBusEntity = _RELocationNumberBusEntity.RELocationNumberBusEntity  -- association [0..1]
LEFT OUTER JOIN I_REDistrictLocation AS _REDistrictLocation ON REDistrictLocation = _REDistrictLocation.REDistrictLocation  -- association [0..1]
LEFT OUTER JOIN I_REListOfRents AS _REListOfRents ON REListOfRents = _REListOfRents.REListOfRents  -- association [0..1]
LEFT OUTER JOIN I_RESettlementVariant AS _RESettlementVariant01 ON REPrdfndOperatingCostSettlmt = _RESettlementVariant01.RESettlementVariant  -- association [0..1]
LEFT OUTER JOIN I_RESettlementVariant AS _RESettlementVariant02 ON REPrdfndHeatingCostSettlmt = _RESettlementVariant02.RESettlementVariant  -- 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..*]
;