P_CAInstallmentPlan

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_CAInstallmentPlan.
-- 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: PCAINSTLMNTPLN
-- Parameters: P_Currency : waers_kk, P_CAInternalAppCode : tileid_kk, P_Date : sydatum, P_Language : sylangu

CREATE VIEW P_CAInstallmentPlan AS
SELECT
  _CAInstallmentPlan.CAInstallmentPlan AS CAInstallmentPlan,
  _DocBPItem.CARepetitionItemNumber AS CARepetitionItemNumber,
  _DocBPItem.CABPItemNumber AS CABPItemNumber,
  _DocBPItem.CASubItemNumber AS CASubItemNumber,
  _CAInstallmentPlan.BusinessPartner AS BusinessPartner,
  _CAPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _CAPartner._BusinessPartner.FirstName AS FirstName,
  _CAPartner._BusinessPartner.LastName AS LastName,
  _CAPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  _CAInstallmentPlan.ContractAccount AS ContractAccount,
  _CAHeader.ContractAccountCategory AS ContractAccountCategory,
  _CAHeader._Category._Text[1:Language = :P_Language].ContractAccountCategoryName AS ContractAccountCategoryName,
  _CAInstallmentPlan.CAContract AS CAContract,
  _CAInstallmentPlan.CASubApplication AS CASubApplication,
  _CAInstallmentPlan.CompanyCode AS CompanyCode,
  _DocBPItem.BusinessArea AS BusinessArea,
  _DocBPItem.Segment AS Segment,
  _CAInstallmentPlan.CAInstallmentPlanCategory AS CAInstallmentPlanCategory,
  _CAInstlmntPlanCat._Text[1:Language = :P_Language].CAInstallmentPlanCategoryName AS CAInstallmentPlanCategoryName,
  _CAInstallmentPlan.CAInstlmntPlanGoodwillValue AS CAInstlmntPlanGoodwillValue,
  _CAInstallmentPlan.CANumberOfInstallments AS CANumberOfInstallments,
  _CAInstallmentPlan.CAWorkflowCheckProcess AS CAWorkflowCheckProcess,
  _CAInstallmentPlan.CAInstlmntPlanDactvtnRsn AS CAInstlmntPlanDactvtnRsn,
  _CAInstlmntPlanDactvtnRsn._Text[1:Language = :P_Language].CAInstlmntPlanDactvtnRsnName AS CAInstlmntPlanDactvtnRsnName,
  _CAInstallmentPlan.CAInstallmentPlanStartDate AS CAInstallmentPlanStartDate,
  _CAInstallmentPlan.CAInstallmentPlanEndDate AS CAInstallmentPlanEndDate,
  _CAInstallmentPlan.CAInstlmntPlanDeactivationDate AS CAInstlmntPlanDeactivationDate,
  dats_days_between(_CAInstallmentPlan.CAInstallmentPlanStartDate,_CAInstallmentPlan.CAInstallmentPlanEndDate) + 1 AS CAInstallmentPlanTerm,
  _CAInstallmentPlan.CAInstallmentPlanIssueDate AS CAInstallmentPlanIssueDate,
  _DocBPItem.CANetDueDate AS CANetDueDate,
  _DocBPItem.CAClearingStatus AS CAClearingStatus,
  _DocBPItem.CAClearingDate AS CAClearingDate,
  case when _DocBPItem.CAClearingDate = '00000000' then cast( concat(:P_Date, '') as abap.dats) else _DocBPItem.CAClearingDate end as ExchangeRateDate AS CAClearingDateendasExchangeRateDate,
  _DocBPItem.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  _DocBPItem.TransactionCurrency AS TransactionCurrency,
  _CAInstallmentPlan.CAInstlmntPlanFulfillmentRate AS CAInstlmntPlanFulfillmentRate,
  _ContractAccount.CAAuthorizationGroup AS CAAuthorizationGroup,
  _ProviderContract.CAAuthorizationGroup AS CAProviderContractAuthznGroup,
  _LastWorkItem( P_CAInternalAppCode : $parameters.P_CAInternalAppCode, P_Language : $parameters.P_Language ).WorklistItemCreationDate AS WorklistItemCreationDate,
  _LastWorkItem( P_CAInternalAppCode : $parameters.P_CAInternalAppCode, P_Language : $parameters.P_Language ).CAClrfctnStatus AS CAClrfctnStatus,
  _LastWorkItem( P_CAInternalAppCode : $parameters.P_CAInternalAppCode, P_Language : $parameters.P_Language ).CAClrfctnStatusName AS CAClrfctnStatusName
FROM P_CAInstallmentPlanHeaderEnh
INNER JOIN P_CAInstallmentPlnBPItmLogical AS _DocBPItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CALastWorklistItem AS _LastWorkItem ON BusinessPartner = _LastWorkItem.BusinessPartner  -- association [1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccount ON BusinessPartner = _ContractAccount.BusinessPartner AND ContractAccount = _ContractAccount.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_CAContractPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner  -- association [1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1]
;