R_CAInstallmentPlanTP

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 R_CAInstallmentPlanTP.
-- 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 R_CAInstallmentPlanTP AS
SELECT
  CAInstallmentPlan,
  CAInstallmentPlanCategory,
  CAInstlmntPlanDeactivationDate,
  CAInstlmntPlanDeactivationType,
  CADeactivationOpenAmountInTC,
  TransactionCurrency,
  CAInstlmntPlanDactvtnRsn,
  CAInstallmentPlanStartDate,
  CAInstallmentPlanEndDate,
  CANumberOfInstallments,
  ContractAccount,
  BusinessPartner,
  CAContract,
  CompanyCode,
  CAInstlmntPlanIntrstCalcType,
  CAIntrstAndChargesAreDistrd,
  CAInterestDueCategory,
  CAInstlmntPlanDactvtnEntryDate,
  CAInstlmntPlanDactvtnEntryTime,
  CAWorkflowCheckReason,
  CAWorkflowCheckProcess,
  CASubApplication,
  CANumberOfAddlIntrstInstlmnts,
  CAInterestCalculationStartDate,
  CAInstlmntPlnIsChgdByInvoicing,
  CAPredecessorInstallmentPlan,
  CAInstlmntPlanGoodwillValue,
  CAInstallmentPlanIssueDate,
  CAInstallmentPlanIssueTime
FROM I_CAInstallmentPlanHeader
LEFT OUTER JOIN I_CAContractType AS _CAContractType ON CASubApplication = _CAContractType.CASubApplication  -- association [1]
LEFT OUTER JOIN I_CAInstallmentPlanAmounts AS _CAInstallmentPlanAmounts ON CAInstallmentPlan = _CAInstallmentPlanAmounts.CAInstallmentPlan  -- association [1]
LEFT OUTER JOIN I_CAInstallmentPlanStatus AS _CAInstallmentPlanStatus ON CAInstallmentPlanStatus = _CAInstallmentPlanStatus.CAInstallmentPlanStatus  -- association [1]
LEFT OUTER JOIN I_CAInstlmntPlanIntrstCalc AS _CAInstlmntPlanIntrstCalc ON CAInstlmntPlanIntrstCalcType = _CAInstlmntPlanIntrstCalc.CAInstlmntPlanIntrstCalcType  -- association [1]
LEFT OUTER JOIN I_CAInterestDueCategory AS _CAInterestDueCategory ON CAInterestDueCategory = _CAInterestDueCategory.CAInterestDueCategory  -- association [1]
LEFT OUTER JOIN I_Indicator AS _CAInstlmntPlnDeactivationType ON CAInstlmntPlanDeactivationType = _CAInstlmntPlnDeactivationType.IndicatorValue  -- association [1]
;