C_CashFlowQuery
Cash Flow Query
C_CashFlowQuery (Consumption)
Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.
Financial Operations
C_CashFlowQuery is a Consumption CDS View that provides data about "Cash Flow Query" in SAP S/4HANA. It reads from 1 data source (I_CashFlowCube) and exposes 55 fields with key fields OriginSystem, OriginApplication, OriginDocument, OriginTransaction, OriginTransactionQualifier. Part of development package FQM.
SAP Help Documentation
| Category | CDS Views for Cash and Liquidity Management |
|---|---|
| Data Category | Query |
This CDS view provides a definition of the query on the records in One Exposure. It retrieves the effective date records of cash flows coming from all the pre-defined source applications. When the Accounting scope is configured as Cash Position and Liquidity Analysis, this view fetches liquidity analysis flows only. This CDS view provides the data to answer the following business questions: What is the definition of the query on the records in One Exposure? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .
Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: Display These restriction types are edited in the Maintain Business Roles app. Users who want to use this CDS view must have the following authorization objects assigned: F_FDSR_BUK Configuration For configuration, you can refer to Configuration for One Exposure from Operations, including the activation of One Exposure (Source Applications), Data Load (Load Data into One Exposure from Operations Hub).
Structure
Fields Used for Filtering The main filters are as follows: CompanyCode OriginApplication CertaintyLevel TransactionDate Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment OriginSystem Original System This field is optional. If it is empty, it means that the flow comes from the current system. OriginApplication Original Application IsValid Valid Flag CompanyCode Company Code This field is mandatory. TransactionDate Transaction Date This field is mandatory. CertaintyLevel Certainty Level This field is mandatory. TransactionCurrency Transaction Currency This field is mandatory. AmountInTransactionCurrency Amount in Transaction Currency This field is mandatory. CompanyCodeCurrency Company Code Currency AmountInCompanyCodeCurrency Amount in Company Code Currency AccountingDocument Journal Entry Number This field is only valid for the flows from Accounting. AccountingDocumentItem Journal Entry Line Item This field is only valid for the flows from Accounting. FiscalYear Fiscal Year This field is only valid for the flows from Accounting. AccountingDocumentType Document Type This field is only valid for the flows from Accounting. GLAccount G/L Account FinancialAccountType Account Type It is G/L Account type. DocumentItemText Description PostingDate Posting Date This field is only valid for the flows from Accounting. ValueDate Value Date CashPlanningGroup Planning Group CashPlanningLevel Planning Level HouseBank House Bank HouseBankAccount House Bank Account BankAccountInternalID Bank Account Internal ID Customer Customer Supplier Supplier BusinessPartner Business Partner Material Material BusinessArea Business Area ProfitCenter Profit Center PartnerCompany Partner Company CostCenter Cost Center Segment Segment LiqudityItem Liquidity Item Fund Fund GrantID Grant ID FinancialInstrumentProductType Product Type of Financial Instrument This field is only valid for the flows from Treasury Management. FinancialTransactionType Financial Transaction Type This field is only valid for the flows from Treasury Management. SecurityClass Security Class This field is only valid for the flows from Treasury Management. SecurityAccount Security Account This field is only valid for the flows from Treasury Management. AssetContract Asset Contract This field is only valid for the flows from Treasury Management. Portfolio Portfolio This field is only valid for the flows from Treasury Management.
SAP API Hub
| Category | Consumption |
|---|---|
| State | C1 |
| Line of Business | Financial Operations |
| Application Component | FIN-FSCM-CLM-FQM-2CL |
| Capabilities | Analytical Query |
| Extensible (Key User) | No |
| Extensible (Developer) | No |
| Release State (Key User) | Released |
| Release State (Developer) | Not Released |
| Package | Financial Operations for SAP S/4HANA Cloud Public Edition |
| Description | <p>This CDS view provides a definition of the query on the records in One Exposure. It retrieves the effective date records of cash flows coming from all the pre-defined source applications.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li> <p>What is the definition of the query on the records in One Exposure?</p> </li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p> |
Documentation
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_CashFlowCube | I_CashFlowCube | from |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CCSHFLWQRY | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| Analytics.query | true | view | |
| Analytics.settings.maxProcessingEffort | #HIGH | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Metadata.allowExtensions | true | view | |
| VDM.viewType | #CONSUMPTION | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_QUERY | view | |
| EndUserText.label | Cash Flow Query | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view |
Fields (55)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | OriginSystem | OriginSystem | LogSys: Formula | |
| KEY | OriginApplication | OriginApplication | Origin Application | |
| KEY | OriginDocument | OriginDocument | Source Document ID | |
| KEY | OriginTransaction | OriginTransaction | Source Transaction ID | |
| KEY | OriginTransactionQualifier | OriginTransactionQualifier | Source Transaction Qualifier | |
| KEY | CashFlow | CashFlow | Line Item in Source Document | |
| KEY | ValidFrom | ValidFrom | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | |
| KEY | ValidTo | ValidTo | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | |
| CashFlowID | CashFlowID | Flow ID | ||
| IsValid | IsValid | FQM Flag Actual | ||
| CashTransactionOwner | CashTransactionOwner | Owner of a Business Transaction | ||
| CompanyCode | CompanyCode | Receiver Company Code | ||
| TransactionDate | TransactionDate | Transaction Date | ||
| CertaintyLevel | CertaintyLevel | Certainty Level | ||
| TransactionCurrency | TransactionCurrency | Transaction Currency | ||
| AmountInTransactionCurrency | AmountInTransactionCurrency | Pt Crcy Amt | ||
| CompanyCodeCurrency | CompanyCodeCurrency | Local Currency | ||
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | Local Crcy Amt | ||
| CashReleaseStatus | CashReleaseStatus | Release Status | ||
| AccountingDocument | AccountingDocument | Document Number of an Accounting Document | ||
| AccountingDocumentItem | AccountingDocumentItem | Number of Line Item Within Accounting Document | ||
| FiscalYear | FiscalYear | G/L Fiscal Year | ||
| PostingFiscalPeriod | PostingFiscalPeriod | Fiscal Period | ||
| AccountingDocumentType | AccountingDocumentType | Journal Entry Type | ||
| PaymentMethod | PaymentMethod | Payment Method | ||
| GLAccount | GLAccount | General Ledger Account | ||
| FinancialAccountType | FinancialAccountType | Fin. Account Type | ||
| DocumentItemText | DocumentItemText | Item Text | ||
| PostingDate | PostingDate | Posting Date in the Document | ||
| ValueDate | ValueDate | Value Date | ||
| NetDueDate | NetDueDate | Net Due Date | ||
| CashPlanningGroup | CashPlanningGroup | Planning Group | ||
| PlanningLevel | PlanningLevel | Planning Level | ||
| HouseBank | HouseBank | Short Key for a House Bank | ||
| HouseBankAccount | HouseBankAccount | ID for Account Details | ||
| BankAccountInternalID | BankAccountInternalID | Bank Account Technical ID | ||
| Customer | Customer | Customer Number | ||
| Supplier | Supplier | Account Number of Supplier | ||
| BusinessPartner | BusinessPartner | Business Partner Number | ||
| Material | Material | Material Number | ||
| BusinessArea | BusinessArea | Business Area | ||
| ProfitCenter | ProfitCenter | Profit Center | ||
| PartnerCompany | PartnerCompany | Company ID of Trading Partner | ||
| CostCenter | CostCenter | Cost Center | ||
| Segment | Segment | Segment for Segmental Reporting | ||
| LiquidityItem | LiquidityItem | Liquidity Item | ||
| SourceCompanyCode | SourceCompanyCode | Company Code | ||
| Fund | Fund | Sender Fund | ||
| GrantID | GrantID | Sender Grant | ||
| FinancialInstrumentProductType | FinancialInstrumentProductType | Product Type | ||
| FinancialTransactionType | FinancialTransactionType | Financial Transaction Type | ||
| SecurityClass | SecurityClass | Security Class ID Number | ||
| SecurityAccount | SecurityAccount | Securities Account | ||
| AssetContract | AssetContract | Contract Number | ||
| Portfolio | Portfolio | Portfolio |
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_CashFlowQuery.
-- 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: CCSHFLWQRY
CREATE VIEW C_CashFlowQuery AS
SELECT
OriginSystem,
OriginApplication,
OriginDocument,
OriginTransaction,
OriginTransactionQualifier,
CashFlow,
ValidFrom,
ValidTo,
CashFlowID,
IsValid,
CashTransactionOwner,
CompanyCode,
TransactionDate,
CertaintyLevel,
TransactionCurrency,
AmountInTransactionCurrency,
CompanyCodeCurrency,
AmountInCompanyCodeCurrency,
CashReleaseStatus,
AccountingDocument,
AccountingDocumentItem,
FiscalYear,
PostingFiscalPeriod,
AccountingDocumentType,
PaymentMethod,
GLAccount,
FinancialAccountType,
DocumentItemText,
PostingDate,
ValueDate,
NetDueDate,
CashPlanningGroup,
PlanningLevel,
HouseBank,
HouseBankAccount,
BankAccountInternalID,
Customer,
Supplier,
BusinessPartner,
Material,
BusinessArea,
ProfitCenter,
PartnerCompany,
CostCenter,
Segment,
LiquidityItem,
SourceCompanyCode,
Fund,
GrantID,
FinancialInstrumentProductType,
FinancialTransactionType,
SecurityClass,
SecurityAccount,
AssetContract,
Portfolio
FROM I_CashFlowCube
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA