I_REIntegrationObjectBasicData

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_REIntegrationObjectBasicData.
-- 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: IREINTOBJECTBSC

CREATE VIEW I_REIntegrationObjectBasicData AS
SELECT
  intreno AS InternalRealEstateNumber,
  extid AS RealEstateExternalID,
  objnr AS REStatusObject,
  ionr AS REIntegrationObjectNumber,
  iotype AS REIntegrationObjectType,
  iocoobjtype AS REIntegObjectCtrlgObjectType,
  xsobject AS REIntegrationObjectName,
  xlobject AS REIntegObjectLongName,
  iosgtype AS REIntegObjSpaceGroupType,
  iosgusagetype AS RESpaceGroupUsageType,
  iosgenableusetype AS RESpaceGrpEnableUseType,
  intrenoenableuse AS REInternalNumberForUseEnable,
  bukrs AS CompanyCode,
  ioparenttype AS REParentIntegObjectType,
  ioparentextid AS REParentIntegObjectExternalID,
  areaunit AS REAreaUnit,
  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,
  authgrp AS REAuthorizationGroup
FROM viipobject
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_UnitOfMeasure AS _UnitOfMeasureArea ON REAreaUnit = _UnitOfMeasureArea.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_REKeyAssgmt AS _REKeyAssgmt ON InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_REAuthorizationGroup AS _REAuthorizationGroup ON REAuthorizationGroup = _REAuthorizationGroup.REAuthorizationGroup AND _REAuthorizationGroup.RealEstateObjectType = 'J5'  -- association [0..1]
LEFT OUTER JOIN I_REIntegObjectType AS _REIntegObjectType ON REIntegrationObjectType = _REIntegObjectType.REIntegrationObjectType  -- association [1..1]
LEFT OUTER JOIN I_REIntegObjectType AS _REParentIntegObjectType ON REParentIntegObjectType = _REParentIntegObjectType.REIntegrationObjectType  -- association [1..1]
LEFT OUTER JOIN I_REIntegObjCtrlgObjType AS _REIntegObjCtrlgObjType ON REIntegObjectCtrlgObjectType = _REIntegObjCtrlgObjType.REIntegObjectCtrlgObjectType  -- association [1..1]
LEFT OUTER JOIN I_REIntegObjSpaceGroupType AS _REIntegObjSpaceGroupType ON REIntegObjSpaceGroupType = _REIntegObjSpaceGroupType.REIntegObjSpaceGroupType  -- association [1..1]
LEFT OUTER JOIN I_RESpaceGroupUsageType AS _RESpaceGroupUsageType ON RESpaceGroupUsageType = _RESpaceGroupUsageType.RESpaceGroupUsageType  -- association [1..1]
LEFT OUTER JOIN I_RESpaceGrpEnableUseType AS _RESpaceGrpEnableUseType ON RESpaceGrpEnableUseType = _RESpaceGrpEnableUseType.RESpaceGrpEnableUseType  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- 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_REIntegObjectOccupancy AS _REIntegObjectOccupancy ON InternalRealEstateNumber = _REIntegObjectOccupancy.REIntegObjectInternalNumber  -- association [1..*]
LEFT OUTER JOIN I_REIntegObjToContractAssgmt AS _REIntegObjToContractAssgmt ON REStatusObject = _REIntegObjToContractAssgmt.REStatusObjectSource  -- association [1..*]
LEFT OUTER JOIN I_REIntegrationObjectSubObj AS _REIntegrationObjSubObj ON _REIntegrationObjSubObj.InternalRealEstateNumberLvl0 = InternalRealEstateNumber OR _REIntegrationObjSubObj.InternalRealEstateNumberLvl1 = InternalRealEstateNumber OR _REIntegrationObjSubObj.InternalRealEstateNumberLvl2 = InternalRealEstateNumber OR _REIntegrationObjSubObj.InternalRealEstateNumberLvl3 = InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_REIntegrationObject AS _REParentIntegrationObject ON REParentIntegObjectExternalID = _REParentIntegrationObject.RealEstateExternalID  -- association [0..1]
LEFT OUTER JOIN I_REIntegrationObjectBasicData AS _REUseEnableIntegrationObject ON REInternalNumberForUseEnable = _REUseEnableIntegrationObject.InternalRealEstateNumber  -- association [0..1]
LEFT OUTER JOIN I_REIntegrationObjectRelation AS _REIntegrationObjectRelation ON InternalRealEstateNumber = _REIntegrationObjectRelation.InternalRealEstateNumber  -- association [0..*]
LEFT OUTER JOIN I_REIntegObjectRelationPartial AS _REIntegObjectRelationPartial ON InternalRealEstateNumber = _REIntegObjectRelationPartial.InternalRealEstateNumber  -- association [0..*]
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_REReminderObjRule AS _REReminderRule ON InternalRealEstateNumber = _REReminderRule.InternalRealEstateNumber  -- association [0..*]
LEFT OUTER JOIN I_REIntegObjectMeasurement AS _REMeasurement ON InternalRealEstateNumber = _REMeasurement.InternalRealEstateNumber  -- association [0..*]
LEFT OUTER JOIN I_REIntegObjectAcctObjAssgmt AS _REIntegObjectAcctObjAssgmt ON InternalRealEstateNumber = _REIntegObjectAcctObjAssgmt.InternalRealEstateNumber  -- association [0..*]
LEFT OUTER JOIN I_REIntegrationObjectTimeline AS _REIntegrationObjectTimeline ON InternalRealEstateNumber = _REIntegrationObjectTimeline.InternalRealEstateNumber  -- association [0..*]
LEFT OUTER JOIN E_REIntegrationObject AS _Extension ON InternalRealEstateNumber = _Extension.InternalRealEstateNumber  -- association [1..1]
;