R_REUseEnableAddlObjAssgmtTP

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_REUseEnableAddlObjAssgmtTP.
-- 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: RREUSEACOASSTP

CREATE VIEW R_REUseEnableAddlObjAssgmtTP AS
SELECT
  InternalRealEstateNumber,
  REObjectAssignmentType,
  REStatusObjectTarget,
  cast(concat(ValidityStartDate, ValidityEndDate ) as recadateperiod preserving type ) AS ValidityStartEndDateValue,
  REStatusObjectTarget AS REStatusObjectTargetForEdit,
  cast( '' as recaident ) AS REIdentification,
  cast( '' as recaidentkey ) AS REIdentificationKey,
  REStatusObjectSource,
  cast( coalesce(ValidityStartDate, '00000000') as rebdvdmvalidfrom preserving type ) AS ValidityStartDate,
  cast( coalesce(ValidityEndDate, '99991231') as rebdvdmvalidto preserving type ) AS ValidityEndDate,
  REStatusObjectSourceIsArchived,
  REObjectTypeTarget,
  REIsLeadingObject
FROM I_REIntegObjectObjectAssgmt AS _REObjectAssgmt
LEFT OUTER JOIN I_REEntryValidity AS _REEntryValidity ON REEntryValidity = _REEntryValidity.REEntryValidity  -- association [1..1]
LEFT OUTER JOIN I_REObjectAssgmtHierAddl AS _REObjectAssgmtHierAddl ON REObjectAssignmentType = _REObjectAssgmtHierAddl.REObjectAssignmentType AND REStatusObjectTarget = _REObjectAssgmtHierAddl.REStatusObjectTarget AND REStatusObjectSource = _REObjectAssgmtHierAddl.REStatusObjectSource AND InternalRealEstateNumber = _REObjectAssgmtHierAddl.InternalRealEstateNumber AND ValidityStartEndDateValue = _REObjectAssgmtHierAddl.ValidityStartEndDateValue  -- association [1..1]
LEFT OUTER JOIN I_REObjectTypeText AS _REObjectTypeText ON _REObjectTypeText.Language = $session.system_language AND ( _REObjectTypeText.RealEstateObjectType = 'KS' OR _REObjectTypeText.RealEstateObjectType = 'OR' OR _REObjectTypeText.RealEstateObjectType = 'PR' OR _REObjectTypeText.RealEstateObjectType = 'IW' OR _REObjectTypeText.RealEstateObjectType = 'IB' OR _REObjectTypeText.RealEstateObjectType = 'IG' OR _REObjectTypeText.RealEstateObjectType = 'IM' )  -- association [1..*]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON REStatusObjectTarget = _CostCenter.ObjectInternalID AND REObjectTypeTarget = 'KS' AND ( _CostCenter.ValidityStartDate <= $session.system_date AND _CostCenter.ValidityEndDate >= $session.system_date )  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON REStatusObjectTarget = _WBSElement.WBSElementObject AND REObjectTypeTarget = 'PR'  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON REStatusObjectTarget = _InternalOrder.ControllingObject AND REObjectTypeTarget = 'OR'  -- association [0..1]
LEFT OUTER JOIN I_REObjectTypeDetails AS _REObjectTypeDetails ON REStatusObjectTarget = _REObjectTypeDetails.REStatusObject  -- association [0..1]
;