P_CollsPromiseToPayDraft

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 P_CollsPromiseToPayDraft.
-- 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 P_CollsPromiseToPayDraft AS
SELECT
  PromiseToPayUUID,
  _PromiseToPayDraft.DraftUUID AS DraftUUID,
  case when _PromiseToPayDraft.DraftUUID is null then CompanyCode else _PromiseToPayDraft.CompanyCode end as CompanyCode AS CompanyCodeendasCompanyCode,
  case when _PromiseToPayDraft.DraftUUID is null then Customer else _PromiseToPayDraft.Customer end as Customer AS CustomerendasCustomer,
  case when _PromiseToPayDraft.DraftUUID is null then ObjectType else _PromiseToPayDraft.ObjectType end as ObjectType AS ObjectTypeendasObjectType,
  case when _PromiseToPayDraft.DraftUUID is null then LinkedInvoiceKey else _PromiseToPayDraft.LinkedInvoiceKey end as LinkedInvoiceKey AS LinkedInvoiceKeyendasLinkedInvoiceKey,
  case when _PromiseToPayDraft.DraftUUID is null then PromisedAmount else _PromiseToPayDraft.PromisedAmount end as PromisedAmount AS PromisedAmountendasPromisedAmount,
  case when _PromiseToPayDraft.DraftUUID is null then PaidAmount else _PromiseToPayDraft.PaidAmount end as PaidAmount AS PaidAmountendasPaidAmount,
  case when _PromiseToPayDraft.DraftUUID is null then Currency else _PromiseToPayDraft.Currency end as Currency AS CurrencyendasCurrency,
  case when _PromiseToPayDraft.DraftUUID is null then DueDate else _PromiseToPayDraft.DueDate end as DueDate AS DueDateendasDueDate,
  case when _PromiseToPayDraft.DraftUUID is null then PromiseToPayDate else _PromiseToPayDraft.PromiseToPayDate end as PromiseToPayDate AS PromiseToPayDateendasPromiseToPayDate,
  case when _PromiseToPayDraft.DraftUUID is null then LastPaymentDate else _PromiseToPayDraft.LastPaymentDate end as LastPaymentDate AS LastPaymentDateendasLastPaymentDate,
  case when _PromiseToPayDraft.DraftUUID is null then PromiseToPayLevel else _PromiseToPayDraft.PromiseToPayLevel end as PromiseToPayLevel AS PromiseToPayLevelendasPromiseToPayLevel,
  case when _PromiseToPayDraft.DraftUUID is null then ContactPerson else _PromiseToPayDraft.ContactPerson end as ContactPerson AS ContactPersonendasContactPerson,
  case when _PromiseToPayDraft.DraftUUID is null then CaseID else _PromiseToPayDraft.CaseID end as CaseID AS CaseIDendasCaseID,
  case when _PromiseToPayDraft.DraftUUID is null then CaseCreatedBy else _PromiseToPayDraft.CaseCreatedBy end as CaseCreatedBy AS CaseCreatedByendasCaseCreatedBy,
  case when _PromiseToPayDraft.DraftUUID is null then CaseCreatedOn else _PromiseToPayDraft.CaseCreatedOn end as CaseCreatedOn AS CaseCreatedOnendasCaseCreatedOn,
  case when _PromiseToPayDraft.DraftUUID is null then CaseLastChangedBy else _PromiseToPayDraft.CaseLastChangedBy end as CaseLastChangedBy AS CaseLastChangedByendasCaseLastChangedBy,
  case when _PromiseToPayDraft.DraftUUID is null then CaseLastChangedOn else _PromiseToPayDraft.CaseLastChangedOn end as CaseLastChangedOn AS CaseLastChangedOnendasCaseLastChangedOn,
  case when _PromiseToPayDraft.DraftUUID is null then CaseClosedBy else _PromiseToPayDraft.CaseClosedBy end as CaseClosedBy AS CaseClosedByendasCaseClosedBy,
  case when _PromiseToPayDraft.DraftUUID is null then CaseClosedTime else _PromiseToPayDraft.CaseClosedTime end as CaseClosedTime AS CaseClosedTimeendasCaseClosedTime,
  cast ( 'X' as boolean ) AS HasActiveEntity,
  _PromiseToPayDraft.DraftAdministrativeDataUUID AS DraftAdministrativeDataUUID,
  _CaseAttribute.CaseType AS CaseType,
  case when _PromiseToPayDraft.DraftUUID is null then IsCleared else _PromiseToPayDraft.IsCleared end as IsCleared AS IsClearedendasIsCleared,
  CompanyCode,
  Customer,
  ObjectType,
  LinkedInvoiceKey,
  PromisedAmount,
  PaidAmount,
  Currency,
  DueDate,
  PromiseToPayDate,
  LastPaymentDate,
  PromiseToPayStatus,
  PromiseToPayLevel,
  PromiseToPayGivenByPersonName,
  ContactPersonEmailAddress,
  ContactPersonPhoneNumber,
  ContactPersonFaxNumber,
  ContactPersonFaxCountry,
  ContactPerson,
  NumberOfInstallments,
  PaidOnScheduleAmount,
  PaidOffScheduleAmount,
  NextInstallmentDueDate,
  NextInstallmentAmount,
  Prms2PToInvoiceGroupRefUUID,
  CaseID,
  CaseExternalReference,
  CaseCreatedBy,
  CaseCreatedOn,
  CaseLastChangedBy,
  CaseLastChangedOn,
  CaseClosedBy,
  CaseClosedTime,
  '' AS IsActiveEntity,
  DraftCreationDateTime,
  DraftLastChangedDateTime,
  IsCleared
FROM I_CollsPromiseToPay
LEFT OUTER JOIN I_CaseAttribute AS _CaseAttribute ON PromiseToPayUUID = _CaseAttribute.CaseUniqueID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON ContactPersonFaxCountry = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_CollsPromiseToPayStatus AS _CollsPromiseToPayStatus ON PromiseToPayStatus = _CollsPromiseToPayStatus.PromiseToPayStatus  -- 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_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CollsPromiseToPayDraft AS _PromiseToPayDraft ON PromiseToPayUUID = _PromiseToPayDraft.PromiseToPayUUID  -- association [0..1]
LEFT OUTER JOIN I_DraftAdministrativeData AS _DraftAdministrativeData ON draftadministrativedatauuid = _DraftAdministrativeData.DraftUUID AND _DraftAdministrativeData.DraftEntityType = 'R_COLLSPROMISETOPAYTP'  -- association [0..1]
-- UNION ALL with additional select branch(es): I_CollsPromiseToPayDraft
;