I_CAInstallmentPlanHeader

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_CAInstallmentPlanHeader.
-- 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_CAInstallmentPlanHeader AS
SELECT
  rpnum AS CAInstallmentPlan,
  rpcat AS CAInstallmentPlanCategory,
  deadt AS CAInstlmntPlanDeactivationDate,
  deman AS CAInstlmntPlanDeactivationType,
  deoff AS CADeactivationOpenAmountInTC,
  waers AS TransactionCurrency,
  deagd AS CAInstlmntPlanDactvtnRsn,
  sttdt AS CAInstallmentPlanStartDate,
  enddt AS CAInstallmentPlanEndDate,
  ninst AS CANumberOfInstallments,
  vkont AS ContractAccount,
  gpart AS BusinessPartner,
  vtref AS CAContract,
  bukrs AS CompanyCode,
  dzins AS CAInstlmntPlanIntrstCalcType,
  gzver AS CAIntrstAndChargesAreDistrd,
  faein AS CAInterestDueCategory,
  dpudt AS CAInstlmntPlanDactvtnEntryDate,
  dputm AS CAInstlmntPlanDactvtnEntryTime,
  c4eye AS CAWorkflowCheckReason,
  c4eyp AS CAWorkflowCheckProcess,
  subap AS CASubApplication,
  anzintrt AS CANumberOfAddlIntrstInstlmnts,
  sttin AS CAInterestCalculationStartDate,
  invip AS CAInstlmntPlnIsChgdByInvoicing,
  orig_rpnum AS CAPredecessorInstallmentPlan,
  gwval AS CAInstlmntPlanGoodwillValue,
  cpudt AS CAInstallmentPlanIssueDate,
  cputm AS CAInstallmentPlanIssueTime
FROM fkk_instpln_head
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CAInstallmentPlanCategory AS _CAInstallmentPlanCategory ON CAInstallmentPlanCategory = _CAInstallmentPlanCategory.CAInstallmentPlanCategory  -- association [1..1]
LEFT OUTER JOIN I_CAInstallmentPlanHeader AS _CAPredecessorInstallmentPlan ON CAPredecessorInstallmentPlan = _CAPredecessorInstallmentPlan.CAInstallmentPlan  -- association [0..1]
LEFT OUTER JOIN I_CAInstlmntPlanDactvtnRsn AS _CAInstlmntPlanDactvtnRsn ON CAInstlmntPlanDactvtnRsn = _CAInstlmntPlanDactvtnRsn.CAInstlmntPlanDactvtnRsn  -- association [0..1]
LEFT OUTER JOIN I_CAProviderContractHeader AS _CAProviderContract ON CASubApplication = 'P' AND CAContract = _CAProviderContract.CAProviderContract  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplication ON CASubApplication = _CASubApplication.CASubApplication  -- association [0..1]
LEFT OUTER JOIN I_CAWorkflowCheckReason AS _CAWorkflowCheckReason ON CAWorkflowCheckReason = _CAWorkflowCheckReason.CAWorkflowCheckReason  -- association [0..1]
LEFT OUTER JOIN I_CAWorkflowCheckProcess AS _CAWorkflowCheckProcess ON CAWorkflowCheckProcess = _CAWorkflowCheckProcess.CAWorkflowCheckProcess  -- 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 _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [1..1]
;