R_BPCollsSgmtCurrentSubstitute

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_BPCollsSgmtCurrentSubstitute.
-- 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.

CREATE VIEW R_BPCollsSgmtCurrentSubstitute AS
SELECT
  BusinessPartner,
  CollectionSegment,
  BPCollSgmtAssignmentValidTo,
  BPCollSgmtAssignmentValidFrom,
  CollectionGroup,
  CollectionSpecialist,
  CollectionBPMainContactPerson
FROM I_BPCollectionsSegmentAssgmt
LEFT OUTER JOIN I_CollsSpecialistSubstitute AS _CollsSpecialistSubstitute ON CollectionGroup = _CollsSpecialistSubstitute.CollectionGroup AND CollectionSpecialist = _CollsSpecialistSubstitute.CollectionSpecialist AND _CollsSpecialistSubstitute.CollSpecialistAbsenceFrom <= $session.system_date AND _CollsSpecialistSubstitute.CollSpecialistAbsenceTo >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_BPCollectionsSgmtTmpAssgmt AS _BPCollectionsSgmtTmpAssgmt ON BusinessPartner = _BPCollectionsSgmtTmpAssgmt.BusinessPartner AND CollectionSegment = _BPCollectionsSgmtTmpAssgmt.CollectionSegment AND BPCollSgmtAssignmentValidTo = _BPCollectionsSgmtTmpAssgmt.BPCollSgmtAssignmentValidTo AND _BPCollectionsSgmtTmpAssgmt.TmpBPCollSgmtAssgmtValidFrom <= $session.system_date AND _BPCollectionsSgmtTmpAssgmt.TmpBPCollSgmtAssgmtValidTo >= $session.system_date  -- association [0..1]
;