P_CAInstallmentPlan2

DDL: P_CAINSTALLMENTPLAN2 SQL: PCAINSTLMNTPLN2 Type: view CONSUMPTION
40 Fields 1 Data Sources

Analyse der Ratenpläne

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

Data Sources (1)

SourceAliasJoin Type
P_CAInstallmentPlan P_CAInstallmentPlan from

Parameters (4)

NameTypeDefault
P_Currency waers_kk
P_CAInternalAppCode tileid_kk
P_Date sydatum
P_Language sylangu

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCAINSTLMNTPLN2 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Analyse der Ratenpläne view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY CAInstallmentPlan 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
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
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
TransactionCurrency TransactionCurrency Transaction Currency
CAInstlmntPlanFulfillmentRate CAInstlmntPlanFulfillmentRate
CAAuthorizationGroup CAAuthorizationGroup AuthorizGroup
CAProviderContractAuthznGroup CAProviderContractAuthznGroup AuthorizGroup
CAClrfctnStatus CAClrfctnStatus
CAClrfctnStatusName CAClrfctnStatusName

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

CREATE VIEW P_CAInstallmentPlan2 AS
SELECT
  CAInstallmentPlan,
  CARepetitionItemNumber,
  CABPItemNumber,
  CASubItemNumber,
  BusinessPartner,
  BusinessPartnerName,
  FirstName,
  LastName,
  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,
  CAAmountInTransactionCurrency,
  TransactionCurrency,
  CAInstlmntPlanFulfillmentRate,
  CAAuthorizationGroup,
  CAProviderContractAuthznGroup,
  CAClrfctnStatus,
  CAClrfctnStatusName
FROM P_CAInstallmentPlan
;

Learn More