C_CAPaymentListCashFlow

DDL: C_CAPAYMENTLISTCASHFLOW SQL: CCAPAYLISTCASH Type: view CONSUMPTION
11 Fields 1 Data Sources

Cash Flow

C_CAPaymentListCashFlow is a Consumption CDS View that provides data about "Cash Flow" in SAP S/4HANA. It reads from 1 data source (P_CAPaymentListGLAccount) and exposes 11 fields with key fields CAMassRunDate, CAMassRunID, CAGLItemNumber, TransactionCurrency, GLAccount.

Data Sources (1)

SourceAliasJoin Type
P_CAPaymentListGLAccount P_CAPaymentListGLAccount from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCAPAYLISTCASH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Cash Flow view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
UI.headerInfo.typeName Cash Flow view
UI.headerInfo.typeNamePlural Cash Flows view
UI.presentationVariant.sortOrder.by TransactionCurrency view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CAMassRunDate CAMassRunDate Date ID
KEY CAMassRunID CAMassRunID Run ID
KEY CAGLItemNumber CAGLItemNumber Item
KEY TransactionCurrency TransactionCurrency Currency
KEY GLAccount GLAccount G/L Account
KEY PaidItemDueDate PaidItemDueDate Execution Date
KEY ValueDate ValueDate Value Date
KEY CAPaymentCompanyCode CAPaymentCompanyCode Company Code
CAPaymentCompanyCodeName CAPaymentCompanyCodeName Company Name
GLAccountName GLAccountName Short Text
AmountInTransactionCurrency Balance

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_CAPaymentListCashFlow.
-- 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: CCAPAYLISTCASH

CREATE VIEW C_CAPaymentListCashFlow AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  CAGLItemNumber,
  TransactionCurrency,
  GLAccount,
  PaidItemDueDate,
  ValueDate,
  CAPaymentCompanyCode,
  CAPaymentCompanyCodeName,
  GLAccountName,
  sum(GLAccountAmount) AS AmountInTransactionCurrency
FROM P_CAPaymentListGLAccount
;

Learn More