I_CAPromiseToPay

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_CAPromiseToPay.
-- 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_CAPromiseToPay AS
SELECT
  ppkey AS CAPromiseToPay,
  prgpa AS CABPThatPromisedPayment,
  gpart AS BusinessPartner,
  vkont AS ContractAccount,
  bukrs AS CompanyCode,
  pprsc AS CAPromiseToPayReason,
  pprsw AS CAPromiseToPayWthdrwlReason,
  ppcat AS CAPromiseToPayCategory,
  c4eye AS CAWorkflowCheckReason,
  c4lev AS CANumberOfChecks,
  prcur AS PaymentCurrency,
  pramt AS CAPromisedAmount,
  pramt_chr AS CAPromiseToPayChargesAmount,
  pramt_int AS CAPromiseToPayInterestAmount,
  xp2ps AS CAIsSimplePromiseToPay,
  fdgrp AS CashPlanningGroup,
  fdlev AS PlanningLevel,
  betrz_pc AS CAPaymentAmountInTransCurrency,
  rdamt AS CAAmountClearedByOtherMeans,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  ertim AS CreationTime,
  chdat AS CACheckDateForStatusDetn,
  ppsta AS CAPromiseToPayStatus,
  degff AS CAPromiseToPayFulfillmentLvl,
  ppkey_new AS CAPrmsToPayCreatedAsRplcmt,
  opbel_chr AS CAChargesDocNmbrForPrmsToPay,
  opbel_int AS CAIntrstDocNmbrForPrmsToPay,
  opbel_int_adj AS CAIntrstAdjmtDocNmbrForPrms2P,
  xindr AS CAIndividualInstlmntsAreAgreed
FROM dfkkpp
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CAPromiseToPayCategory AS _CAPromiseToPayCategory ON CAPromiseToPayCategory = _CAPromiseToPayCategory.CAPromiseToPayCategory  -- association [1..1]
LEFT OUTER JOIN I_CAPromiseToPayReason AS _CAPromiseToPayReason ON CAPromiseToPayReason = _CAPromiseToPayReason.CAPromiseToPayReason  -- association [1..1]
LEFT OUTER JOIN I_CAPromiseToPayStatus AS _CAPromiseToPayStatus ON CAPromiseToPayStatus = _CAPromiseToPayStatus.CAPromiseToPayStatus  -- association [1..1]
LEFT OUTER JOIN I_CAPromiseToPayWthdrwlReason AS _CAPromiseToPayWthdrwlReason ON CAPromiseToPayWthdrwlReason = _CAPromiseToPayWthdrwlReason.CAPromiseToPayWthdrwlReason  -- association [1..1]
LEFT OUTER JOIN I_CAWorkflowCheckReason AS _CAWorkflowCheckReason ON CAWorkflowCheckReason = _CAWorkflowCheckReason.CAWorkflowCheckReason  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccount ON ContractAccount = _ContractAccount.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON BusinessPartner = _ContractAccountPartner.BusinessPartner AND ContractAccount = _ContractAccountPartner.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _PaymentCurrency ON PaymentCurrency = _PaymentCurrency.Currency  -- association [1..1]
;