I_CollectionsContactDraft

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_CollectionsContactDraft.
-- 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 I_CollectionsContactDraft AS
SELECT
  DraftUUID,
  RelationshipNumber,
  BusinessPartnerCompany,
  BusinessPartnerPerson,
  CollectionSegment,
  FirstName,
  LastName,
  PhoneNumber,
  MobileNumber,
  FaxNumber,
  EmailAddress,
  ContactPersonFunction,
  ContactPersonDepartment,
  cast ( hasactiveentity as boolean preserving type ) AS HasActiveEntity,
  draftentitycreationdatetime AS DraftCreationDateTime,
  draftentitylastchangedatetime AS DraftLastChangedDateTime,
  DraftAdministrativeDataUUID
FROM collcontdra
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartnerCompany ON BusinessPartnerCompany = _BusinessPartnerCompany.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartnerPerson ON BusinessPartnerPerson = _BusinessPartnerPerson.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BPContactToFuncAndDept AS _BPContactToFuncAndDept ON BusinessPartnerCompany = _BPContactToFuncAndDept.BusinessPartnerCompany AND BusinessPartnerPerson = _BPContactToFuncAndDept.BusinessPartnerPerson AND _BPContactToFuncAndDept.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_BpContactToAddress AS _BpContactToAddress ON BusinessPartnerCompany = _BpContactToAddress.BusinessPartnerCompany AND BusinessPartnerPerson = _BpContactToAddress.BusinessPartnerPerson AND _BpContactToAddress.ValidityEndDate >= $session.system_date AND _BpContactToAddress.IsDefaultAddress = 'X'  -- association [0..1]
LEFT OUTER JOIN I_CollectionSegment AS _CollectionSegment ON CollectionSegment = _CollectionSegment.CollectionSegment  -- association [0..1]
LEFT OUTER JOIN I_ContactPersonFunction AS _ContactPersonFunction ON ContactPersonFunction = _ContactPersonFunction.ContactPersonFunction  -- association [0..1]
LEFT OUTER JOIN I_ContactPersondepartment AS _ContactPersondepartment ON ContactPersonDepartment = _ContactPersondepartment.ContactPersonDepartment  -- association [0..1]
LEFT OUTER JOIN I_BPRelationship AS _BPRelationship ON RelationshipNumber = _BPRelationship.RelationshipNumber AND BusinessPartnerCompany = _BPRelationship.BusinessPartnerCompany AND BusinessPartnerPerson = _BPRelationship.BusinessPartnerPerson  -- association [0..*]
LEFT OUTER JOIN I_DraftAdministrativeData AS _DraftAdministrativeData ON DraftAdministrativeDataUUID = _DraftAdministrativeData.DraftUUID AND _DraftAdministrativeData.DraftEntityType = 'R_COLLECTIONCONTACTTP'  -- association [0..1]
;