C_CAInstallmentPlanEnhanced

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 C_CAInstallmentPlanEnhanced.
-- 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 C_CAInstallmentPlanEnhanced AS
SELECT
  cast(CAInstallmentPlan as rpbel_gfn_kk preserving type ) AS CAInstallmentPlan,
  cast(CAInstallmentPlanStatus as rpsta_kk preserving type ) AS CAInstallmentPlanStatus,
  _CAInstallmentPlanStatus._Text[1: Language=$session.system_language].CAInstallmentPlanStatusText AS CAInstallmentPlanStatusText,
  BusinessPartner,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  ContractAccount,
  _ContractAccountPartner.ContractAccountName AS ContractAccountName,
  cast(CAInstallmentPlanStartDate as stardat_gfn_kk preserving type ) AS CAInstallmentPlanStartDate,
  cast(CAInstallmentPlanEndDate as endedat_gfn_kk preserving type ) AS CAInstallmentPlanEndDate,
  CANumberOfInstallments,
  cast(_CAInstallmentPlanAmounts.CACreationOpenAmountInTC as betro_ip_gfn_kk preserving type ) AS CACreationOpenAmountInTC,
  TransactionCurrency,
  cast(CAInstallmentPlanIssueDate as fis_cpdat preserving type) AS CAInstallmentPlanIssueDate,
  cast(CAInstallmentPlanCategory as rpcat_gfn_kk preserving type ) AS CAInstallmentPlanCategory,
  _CAInstallmentPlanCategory._Text[1: Language=$session.system_language].CAInstallmentPlanCategoryName AS CAInstallmentPlanCategoryName,
  cast(CAInstlmntPlanDeactivationDate as deadt_gfn_kk preserving type ) AS CAInstlmntPlanDeactivationDate,
  cast(CAInstlmntPlanDactvtnRsn as deagd_gfn_kk preserving type ) AS CAInstlmntPlanDactvtnRsn,
  _CAInstlmntPlanDactvtnRsn._Text[1: Language=$session.system_language].CAInstlmntPlanDactvtnRsnName AS CAInstlmntPlanDactvtnRsnName,
  cast(CAInstlmntPlanDeactivationType as deman_gfn_kk preserving type ) AS CAInstlmntPlanDeactivationType,
  _CAInstlmntPlnDeactivationType._IndicatorText[1: Language=$session.system_language].IndicatorText AS CAInstlmntPlanDactvtnTypeText,
  CAContract,
  GeneralizedCAContract,
  CASubApplication,
  _CAInstallmentPlan._CAContractType.CAContractType AS CAContractType,
  _CAInstallmentPlan._CAContractType._Text.CAContractTypeText : localized AS CAContractTypeTextlocalized,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast(CAInstlmntPlanIntrstCalcType as dzins_gfn_kk preserving type ) AS CAInstlmntPlanIntrstCalcType,
  _CAInstlmntPlanIntrstCalc._Text[1: Language=$session.system_language].CAInstlmntPlnIntrstCalcTypeTxt AS CAInstlmntPlnIntrstCalcTypeTxt,
  cast(CAInterestCalculationStartDate as stdtint_gfn_kk preserving type ) AS CAInterestCalculationStartDate,
  cast(CAInterestDueCategory as faein_gfn_kk preserving type ) AS CAInterestDueCategory,
  _CAInterestDueCategory._Text[1: Language=$session.system_language].CAInterestDueCategoryText AS CAInterestDueCategoryText,
  cast(CAInstlmntPlnIsChgdByInvoicing as invip_gfn_kk preserving type ) AS CAInstlmntPlnIsChgdByInvoicing,
  CADeactivationOpenAmountInTC,
  CAInstlmntPlanDactvtnEntryDate,
  CAInstlmntPlanDactvtnEntryTime,
  CAWorkflowCheckReason,
  CAWorkflowCheckProcess,
  CANumberOfAddlIntrstInstlmnts,
  CAPredecessorInstallmentPlan,
  CAInstlmntPlanGoodwillValue,
  CAInstallmentPlanIssueTime
FROM R_CAInstallmentPlanTP
;