I_REIntegObjToContractAssgmt

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_REIntegObjToContractAssgmt.
-- 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: IREINTCONT

CREATE VIEW I_REIntegObjToContractAssgmt AS
SELECT
  REStatusObjectTarget AS REStatusObjectSource,
  REObjectAssignmentType,
  _REContract.CompanyCode AS CompanyCode,
  _REContract.RealEstateContract AS RealEstateContract,
  cast(concat(ValidityStartDate, ValidityEndDate ) as recadateperiod) AS ValidityStartEndDateValue,
  _REObjectTypeDetails.InternalRealEstateNumber AS InternalRealEstateNumber,
  case when _REObjectAssgmt.ValidityStartDate > _REContract.ContractStartDate then cast( coalesce(ValidityStartDate, '00000000') as rebdvdmvalidfrom ) when _REObjectTypeDetails._REIntegrationObject.ValidityStartDate > _REContract.ContractStartDate then _REObjectTypeDetails._REIntegrationObject.ValidityStartDate else _REContract.ContractStartDate end as ValidityStartDate AS ContractStartDateendasValidityStartDate,
  REStatusObjectSource AS REStatusObjectTarget,
  case when _REObjectAssgmt.ValidityEndDate < _REContract.ContractEndDate then cast( coalesce(ValidityEndDate, '99991231') as rebdvdmvalidto ) when _REObjectTypeDetails._REIntegrationObject.ValidityEndDate < _REContract.ContractEndDate then _REObjectTypeDetails._REIntegrationObject.ValidityEndDate else _REContract.ContractEndDate end as ValidityEndDate AS ContractEndDateendasValidityEndDate,
  REOnlyInfoAssgmt,
  REStatusObjectSourceIsArchived,
  REGenerationType,
  REIsMainAsset,
  REAssignmentHasMultiple,
  REObjectPossessionStartDate,
  REObjectPossessionEndDate,
  _REContract._CompanyCode AS _CompanyCode
FROM I_REObjectAssgmt AS _REObjectAssgmt
LEFT OUTER JOIN I_REContract AS _REContract ON REStatusObjectTarget = _REContract.REStatusObject  -- association [1..1]
;