C_CAInstallmentPlan

DDL: C_CAINSTALLMENTPLAN SQL: CCAINSTLMNTPLN Type: view CONSUMPTION
46 Fields 1 Data Sources

Analyse der Ratenpläne

C_CAInstallmentPlan is a Consumption CDS View that provides data about "Analyse der Ratenpläne" in SAP S/4HANA. It reads from 1 data source (P_CAInstallmentPlan2) and exposes 46 fields with key fields CAInstallmentPlan, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber.

Data Sources (1)

SourceAliasJoin Type
P_CAInstallmentPlan2 P_CAInstallmentPlan2 from

Parameters (4)

NameTypeDefault
P_Currency waers_kk
P_CAInternalAppCode tileid_kk
P_Date sydatum
P_Language sylangu

Annotations (9)

NameValueLevelField
EndUserText.label Analyse der Ratenpläne view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName CCAINSTLMNTPLN view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY CAInstallmentPlan _InstPlan CAInstallmentPlan
KEY CARepetitionItemNumber CARepetitionItemNumber Repetition Item
KEY CABPItemNumber CABPItemNumber Item
KEY CASubItemNumber CASubItemNumber Subitem
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName BusinessPartnerName Extracted Customer Name
FirstName FirstName First Name
LastName LastName Last Name
PostalCode PostalCode Postal Code
ContractAccount ContractAccount Contract Acct
ContractAccountCategory ContractAccountCategory Cont. Acct Cat.
ContractAccountCategoryName ContractAccountCategoryName
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
Segment Segment Segment number
CAInstallmentPlanCategory CAInstallmentPlanCategory
CAInstallmentPlanCategoryName CAInstallmentPlanCategoryName
CAInstlmntPlanGoodwillValue CAInstlmntPlanGoodwillValue
CANumberOfInstallments CANumberOfInstallments
CAInstallmentPlanStatus CAInstallmentPlanStatus
CAWorkflowCheckProcess CAWorkflowCheckProcess Process
CAInstlmntPlanDactvtnRsn CAInstlmntPlanDactvtnRsn
CAInstlmntPlanDactvtnRsnName CAInstlmntPlanDactvtnRsnName
CAInstallmentPlanStartDate CAInstallmentPlanStartDate
CAInstallmentPlanEndDate CAInstallmentPlanEndDate
CAInstlmntPlanDeactivationDate CAInstlmntPlanDeactivationDate
CAInstallmentPlanTerm CAInstallmentPlanTerm
CAInstallmentPlanIssueDate CAInstallmentPlanIssueDate
CANetDueDate CANetDueDate Net Due Date
CAClearingStatus CAClearingStatus Clearing Status
CAClearingDate CAClearingDate Clearing
CAInstallmentDaysInArrears CAInstallmentDaysInArrears
AmountInDisplayCurrency AmountInDisplayCurrency
DisplayCurrency
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
TransactionCurrency TransactionCurrency Transaction Currency
CAInstlmntPlanGoodwillAmount
CAInstlmntPlanFulfillmentRate CAInstlmntPlanFulfillmentRate
CAAuthorizationGroup CAAuthorizationGroup AuthorizGroup
CAProviderContractAuthznGroup CAProviderContractAuthznGroup
WorklistItemCreationDate WorklistItemCreationDate
CAClrfctnStatus CAClrfctnStatus
CAClrfctnStatusName CAClrfctnStatusName
_CAPartner _CAPartner

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_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: CCAINSTLMNTPLN
-- Parameters: P_Currency : waers_kk, P_CAInternalAppCode : tileid_kk, P_Date : sydatum, P_Language : sylangu

CREATE VIEW C_CAInstallmentPlan AS
SELECT
  _InstPlan.CAInstallmentPlan AS CAInstallmentPlan,
  CARepetitionItemNumber,
  CABPItemNumber,
  CASubItemNumber,
  BusinessPartner,
  BusinessPartnerName,
  FirstName,
  LastName,
  PostalCode,
  ContractAccount,
  ContractAccountCategory,
  ContractAccountCategoryName,
  CAContract,
  CASubApplication,
  CompanyCode,
  BusinessArea,
  Segment,
  CAInstallmentPlanCategory,
  CAInstallmentPlanCategoryName,
  CAInstlmntPlanGoodwillValue,
  CANumberOfInstallments,
  CAInstallmentPlanStatus,
  CAWorkflowCheckProcess,
  CAInstlmntPlanDactvtnRsn,
  CAInstlmntPlanDactvtnRsnName,
  CAInstallmentPlanStartDate,
  CAInstallmentPlanEndDate,
  CAInstlmntPlanDeactivationDate,
  CAInstallmentPlanTerm,
  CAInstallmentPlanIssueDate,
  CANetDueDate,
  CAClearingStatus,
  CAClearingDate,
  CAInstallmentDaysInArrears,
  AmountInDisplayCurrency,
  $parameters.P_Currency AS DisplayCurrency,
  CAAmountInTransactionCurrency,
  TransactionCurrency,
  cast(AmountInDisplayCurrency * CAInstlmntPlanGoodwillValue as farp_amount_display_crcy) AS CAInstlmntPlanGoodwillAmount,
  CAInstlmntPlanFulfillmentRate,
  CAAuthorizationGroup,
  CAProviderContractAuthznGroup,
  WorklistItemCreationDate,
  CAClrfctnStatus,
  CAClrfctnStatusName
FROM P_CAInstallmentPlan2
;

Learn More