R_REIntegrationObjectTP

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 R_REIntegrationObjectTP.
-- 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: RREINTEGOBJTP

CREATE VIEW R_REIntegrationObjectTP AS
SELECT
  InternalRealEstateNumber,
  RealEstateExternalID,
  REStatusObject,
  REIntegrationObjectNumber,
  REIntegrationObjectNumber AS REIntegrationObjNumberForEdit,
  REIntegrationObjectType,
  REIntegObjectCtrlgObjectType,
  REIntegrationObjectName,
  REIntegObjectLongName,
  ValidityStartDate,
  ValidityEndDate,
  REIntegObjSpaceGroupType,
  RESpaceGroupUsageType,
  RESpaceGrpEnableUseType,
  REInternalNumberForUseEnable,
  _REUseEnableIntegrationObject.REIntegrationObjectNumber AS REUseEnableObjectNumber,
  REParentIntegObjectType,
  REParentIntegObjectExternalID,
  _REParentIntegrationObject.REIntegrationObjectNumber AS REParentIntegObjectNumber,
  REAreaUnit,
  CreatedByUser,
  CreationDate,
  CreationTime,
  RESourceOfCreation,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  RESourceOfChange,
  Responsible,
  REAuthorizationGroup,
  CompanyCode,
  cast(coalesce(_REUseEnableIntegrationObject.CompanyCode, CompanyCode ) as bukrs preserving type ) AS CompanyCodeEnableUse,
  _REIntegObjSpaceGroupType.RESpaceGroupDirection AS RESpaceGroupDirection,
  _StatusObject.StatusProfile AS StatusProfile,
  cast('J5' as recaobjtype preserving type ) AS RealEstateObjectType
FROM I_REIntegrationObject AS _REIntegrationObject
LEFT OUTER JOIN E_REIntegrationObject AS _Extension ON InternalRealEstateNumber = _Extension.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeEnableUse ON CompanyCodeEnableUse = _CompanyCodeEnableUse.CompanyCode  -- association [0..1]
LEFT OUTER JOIN R_REIntegObjectAddressTP AS _REIntegObjectAddressTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REIntegObjectObjRelationTP AS _REIntegObjectObjRelationTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REIntegObjectObjAssgmtTP AS _REIntegObjectObjAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REUseEnableAddlObjAssgmtTP AS _REUseEnableAddlObjAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REUseEnableLdngObjAssgmtTP AS _REUseEnableLdngObjAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REUseEnableFxdAstObjAssgmtTP AS _REUseEnableFxdAstObjAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REUseEnableConditionTP AS _REUseEnableConditionTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REIntegObjContractAssgmtTP AS _REIntegObjContractAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REOccpcyMngLdngObjAssgmtTP AS _REOccpcyMngLdngObjAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REIntegObjectPartAssgmtTP AS _REIntegObjectPartAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REIntegObjectMeasurementTP AS _REIntegObjectMeasurementTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REIntegObjectReminderRuleTP AS _REIntegObjectReminderRuleTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REIntegObjectReminderDateTP AS _REIntegObjectReminderDateTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REIntegObjectTimelineTP AS _REIntegObjectTimelineTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REIntegObjectStatusObjectTP AS _REIntegObjectStatusObjectTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REOccpcyMngCostObjAssgmtTP AS _REOccpcyMngCostObjAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
;