C_CashFlowQuery

DDL: C_CASHFLOWQUERY SQL: CCSHFLWQRY Type: view CONSUMPTION Package: FQM

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

CategoryCDS Views for Cash and Liquidity Management
Data CategoryQuery
Purpose
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.

View on SAP Help Portal →

SAP API Hub

CategoryConsumption
StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-CLM-FQM-2CL
CapabilitiesAnalytical Query
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageFinancial 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

Data Sources (1)

SourceAliasJoin Type
I_CashFlowCube I_CashFlowCube from

Annotations (14)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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
;