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.
-- SQL view name: ICAINSTPLNHEADER

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 CAInstlmntPlanDactvtnEntryDay,
  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 _CAInstlmntPlanCat ON CAInstallmentPlanCategory = _CAInstlmntPlanCat.CAInstallmentPlanCategory  -- association [1..1]
LEFT OUTER JOIN I_CAInstallmentPlanHeader AS _CAPrdcssrInstlmntPln ON CAPredecessorInstallmentPlan = _CAPrdcssrInstlmntPln.CAInstallmentPlan  -- association [0..1]
LEFT OUTER JOIN I_CAInstlmntPlanDactvtnRsn AS _CAInstlmntPlanDactvtnRsn ON CAInstlmntPlanDactvtnRsn = _CAInstlmntPlanDactvtnRsn.CAInstlmntPlanDactvtnRsn  -- association [0..1]
LEFT OUTER JOIN I_CAProviderContractHeader AS _ProviderContract ON CASubApplication = 'P' AND CAContract = _ProviderContract.CAProviderContract  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _SubApplication ON CASubApplication = _SubApplication.CASubApplication  -- association [0..1]
LEFT OUTER JOIN I_CAWorkflowCheckReason AS _WorkflowCheckReason ON CAWorkflowCheckReason = _WorkflowCheckReason.CAWorkflowCheckReason  -- association [0..1]
LEFT OUTER JOIN I_CAWorkflowCheckProcess AS _WorkflowCheckProcess ON CAWorkflowCheckProcess = _WorkflowCheckProcess.CAWorkflowCheckProcess  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _CAHeader ON ContractAccount = _CAHeader.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner AND ContractAccount = _CAPartner.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON CompanyCode = _CompCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [1..1]
;