I_CollsPromiseToPay

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_CollsPromiseToPay.
-- 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_CollsPromiseToPay AS
SELECT
  PromiseToPayUUID,
  CompanyCode,
  Customer,
  cast ( SAPObjectType as swo_objtyp ) AS ObjectType,
  LinkedInvoiceKey,
  PromisedAmount,
  PaidAmount,
  Currency,
  DueDate,
  PromiseToPayDate,
  LastPaymentDate,
  PromiseToPayStatus,
  PromiseToPayLevel,
  PromiseToPayGivenByPersonName,
  ContactPersonEmailAddress,
  ContactPersonPhoneNumber,
  ContactPersonFaxNumber,
  ContactPersonFaxCountry,
  cast ( ContactPerson as udm_contact_key ) AS ContactPerson,
  NumberOfInstallments,
  PaidOnScheduleAmount,
  PaidOffScheduleAmount,
  NextInstallmentDueDate,
  NextInstallmentAmount,
  Prms2PToInvoiceGroupRefUUID,
  _CaseAttribute.CaseID AS CaseID,
  cast( _CaseAttribute.CaseExternalReference as coll_p2p_external_reference preserving type ) AS CaseExternalReference,
  _CaseAttribute.CaseCreatedBy AS CaseCreatedBy,
  cast( _CaseAttribute.CaseCreatedOn as coll_pr_creation_date_time preserving type ) AS CaseCreatedOn,
  _CaseAttribute.CaseLastChangedBy AS CaseLastChangedBy,
  cast( _CaseAttribute.CaseLastChangedOn as coll_pr_changed_at preserving type ) AS CaseLastChangedOn,
  _CaseAttribute.CaseClosedBy AS CaseClosedBy,
  cast( _CaseAttribute.CaseClosedTime as coll_pr_closed_at preserving type ) AS CaseClosedTime
FROM I_CollectionsPromiseToPayBasic
LEFT OUTER JOIN I_CaseAttribute AS _CaseAttribute ON PromiseToPayUUID = _CaseAttribute.CaseUniqueID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByContactCard ON casecreatedby = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangedByContactCard ON caselastchangedby = _ChangedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ClosedByContactCard ON caseclosedby = _ClosedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_CustomerContact AS _CustomerContact ON ContactPerson = _CustomerContact.CustomerContact  -- association [0..1]
LEFT OUTER JOIN I_CollectionsInvoiceMemory AS _InvoiceMemory ON LinkedInvoiceKey = _InvoiceMemory.ObjectKey  -- association [0..1]
;