P_CAInstallmentPlanHeaderEnh

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_CAInstallmentPlanHeaderEnh.
-- 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.
-- Parameters: P_Currency : waers_kk

CREATE VIEW P_CAInstallmentPlanHeaderEnh AS
SELECT
  _InstallmentPlanHeader.CAInstallmentPlan AS CAInstallmentPlan,
  _InstallmentPlanHeader.CAInstallmentPlanCategory AS CAInstallmentPlanCategory,
  _InstallmentPlanHeader.CAInstlmntPlanDeactivationDate AS CAInstlmntPlanDeactivationDate,
  _InstallmentPlanHeader.CAInstlmntPlanDeactivationType AS CAInstlmntPlanDeactivationType,
  _InstallmentPlanHeader.CADeactivationOpenAmountInTC AS CADeactivationOpenAmountInTC,
  _InstallmentPlanHeader.TransactionCurrency AS TransactionCurrency,
  _InstallmentPlanHeader.CAInstlmntPlanDactvtnRsn AS CAInstlmntPlanDactvtnRsn,
  _InstallmentPlanHeader.CAInstallmentPlanStartDate AS CAInstallmentPlanStartDate,
  _InstallmentPlanHeader.CAInstallmentPlanEndDate AS CAInstallmentPlanEndDate,
  _InstallmentPlanHeader.CANumberOfInstallments AS CANumberOfInstallments,
  _InstallmentPlanHeader.ContractAccount AS ContractAccount,
  _InstallmentPlanHeader.BusinessPartner AS BusinessPartner,
  _InstallmentPlanHeader.CAContract AS CAContract,
  _InstallmentPlanHeader.CompanyCode AS CompanyCode,
  _InstallmentPlanHeader.CAInstlmntPlanIntrstCalcType AS CAInstlmntPlanIntrstCalcType,
  _InstallmentPlanHeader.CAIntrstAndChargesAreDistrd AS CAIntrstAndChargesAreDistrd,
  _InstallmentPlanHeader.CAInterestDueCategory AS CAInterestDueCategory,
  _InstallmentPlanHeader.CAInstlmntPlanDactvtnEntryDate AS CAInstlmntPlanDactvtnEntryDate,
  _InstallmentPlanHeader.CAInstlmntPlanDactvtnEntryTime AS CAInstlmntPlanDactvtnEntryTime,
  _InstallmentPlanHeader.CAWorkflowCheckReason AS CAWorkflowCheckReason,
  _InstallmentPlanHeader.CAWorkflowCheckProcess AS CAWorkflowCheckProcess,
  _InstallmentPlanHeader.CASubApplication AS CASubApplication,
  _InstallmentPlanHeader.CANumberOfAddlIntrstInstlmnts AS CANumberOfAddlIntrstInstlmnts,
  _InstallmentPlanHeader.CAInterestCalculationStartDate AS CAInterestCalculationStartDate,
  _InstallmentPlanHeader.CAInstlmntPlnIsChgdByInvoicing AS CAInstlmntPlnIsChgdByInvoicing,
  _InstallmentPlanHeader.CAPredecessorInstallmentPlan AS CAPredecessorInstallmentPlan,
  _InstallmentPlanHeader.CAInstlmntPlanGoodwillValue AS CAInstlmntPlanGoodwillValue,
  _InstallmentPlanHeader.CAInstallmentPlanIssueDate AS CAInstallmentPlanIssueDate,
  _InstallmentPlanHeader.CAInstallmentPlanIssueTime AS CAInstallmentPlanIssueTime,
  case when _AmountsInDC.DueAmountInDisplayCrcy = 0 then 1 else cast( ( get_numeric_value( _AmountsInDC.ClearedAmountInDisplayCurrency ) / get_numeric_value( _AmountsInDC.DueAmountInDisplayCrcy ) ) as abap.dec(23,2) ) end as CAInstlmntPlanFulfillmentRate AS dec232endasCAInstlmntPlanFulfillmentRate,
  _InstallmentPlanHeader._BusinessPartner AS _BusinessPartner,
  _InstallmentPlanHeader._CAInstallmentPlanCategory AS _CAInstallmentPlanCategory,
  _InstallmentPlanHeader._CAInstlmntPlanDactvtnRsn AS _CAInstlmntPlanDactvtnRsn,
  _InstallmentPlanHeader._CAPredecessorInstallmentPlan AS _CAPredecessorInstallmentPlan,
  _InstallmentPlanHeader._CAProviderContract AS _CAProviderContract,
  _InstallmentPlanHeader._CASubApplication AS _CASubApplication,
  _InstallmentPlanHeader._CAWorkflowCheckProcess AS _CAWorkflowCheckProcess,
  _InstallmentPlanHeader._CAWorkflowCheckReason AS _CAWorkflowCheckReason,
  _InstallmentPlanHeader._CompanyCode AS _CompanyCode,
  _InstallmentPlanHeader._ContractAccount AS _ContractAccount,
  _InstallmentPlanHeader._ContractAccountPartner AS _ContractAccountPartner,
  _InstallmentPlanHeader._TransactionCurrency AS _TransactionCurrency
FROM I_CAInstallmentPlanHeader AS _InstallmentPlanHeader
INNER JOIN I_CADocTotalSeparatedAmtsInDC ON /* join condition not captured in parsed metadata */
;