C_FinStmntCashFlowItemQuery

DDL: C_FINSTMNTCASHFLOWITEMQUERY SQL: CFS_ITEM_CF_Q Type: view CONSUMPTION
55 Fields 1 Data Sources

Cash Flow Statements for ACR - Query

C_FinStmntCashFlowItemQuery is a Consumption CDS View that provides data about "Cash Flow Statements for ACR - Query" in SAP S/4HANA. It reads from 1 data source (C_RU_FinStmntCashFlowItemC) and exposes 55 fields with key fields FinancialStatementLeafItem, StatryRptgEntity, StatryRptCategory, StatryRptRunID, CashFlowStatementHierVersion.

Data Sources (1)

SourceAliasJoin Type
C_RU_FinStmntCashFlowItemC C_RU_FinStmntCashFlowItemC from

Parameters (5)

NameTypeDefault
P_StatryRptRunID srf_report_run_id
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_FinancialStatementHierarchy firu_cf_version
P_SourceLedger fins_ledger_pers

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CFS_ITEM_CF_Q view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Cash Flow Statements for ACR - Query view
VDM.viewType #CONSUMPTION view
Analytics.query true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY FinancialStatementLeafItem FinancialStatementLeafItem Node
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptRunID StatryRptRunID Report Run ID
KEY CashFlowStatementHierVersion CashFlowStatementHierVersion
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY ClearedInvoiceNumber ClearedInvoiceNumber
KEY ClearedInvoiceYear
CashFlowStmntReportingPeriod
PeriodBalAmtInDspCrcy
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
BusinessArea BusinessArea Business Area
ControllingArea ControllingArea Controlling Area
FunctionalArea FunctionalArea Sendr Fctl Area
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
CostCenter CostCenter Cost Center
ProfitCenter ProfitCenter Profit Center
Segment Segment Segment number
WBSElementExternalID WBSElementExternalID WBS Element External ID
AlternativeGLAccount AlternativeGLAccount Group Account
GLAccount GLAccount General Ledger
FundsCenter FundsCenter Funds Center
AssignmentReference AssignmentReference Assignment Reference
AssetClass AssetClass Asset Class
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
Customer Customer Sold-to Party
Supplier Supplier Supplier
Plant Plant Valuation Area
Material Material Vehicle Model
Product Product Product Sold
AccountingDocumentItem Posting View Item
AccountingDocumentType Journal Entry Type
CommitmentItem CommitmentItem Commitment item
FiscalPeriod FiscalPeriod Tax period
ParentItem
ItemType ItemType Object Type
FinancialStmntCashFlowItemMode FinancialStmntCashFlowItemMode
ItemSignIsReversed ItemSignIsReversed Change Item Sign
ItemIsHiddenInReporting ItemIsHiddenInReporting
FinancialStatementFormType FinancialStatementFormType
DocumentReferenceID DocumentReferenceID Reference
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
JrnlEntryCntrySpecificRef4 Country/Region Specific Reference 4
JrnlEntryCntrySpecificDate4 Country/Region Specific Date 4
Currency Currency Valuation Crcy
FinancialManagementArea FinancialManagementArea FM Area
ChartOfAccounts ChartOfAccounts Node Class
SourceCompanyCode SourceCompanyCode Source Company Code
CountryChartOfAccounts CountryChartOfAccounts Chart of Accts

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_FinStmntCashFlowItemQuery.
-- 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: CFS_ITEM_CF_Q
-- Parameters: P_StatryRptRunID : srf_report_run_id, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_FinancialStatementHierarchy : firu_cf_version, P_SourceLedger : fins_ledger_pers

CREATE VIEW C_FinStmntCashFlowItemQuery AS
SELECT
  FinancialStatementLeafItem,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CashFlowStatementHierVersion,
  CompanyCode,
  cast( AccountingDocument as fis_belnr) AS AccountingDocument,
  LedgerGLLineItem,
  FiscalYear,
  ClearedInvoiceNumber,
  cast(ClearedInvoiceYear as firu_cf_inv_year) AS ClearedInvoiceYear,
  cast(CashFlowStmntReportingPeriod as firu_cf_reportperiod) AS CashFlowStmntReportingPeriod,
  cast(PeriodBalAmtInDspCrcy as firu_period_bal_amt) AS PeriodBalAmtInDspCrcy,
  DocumentDate,
  PostingDate,
  BusinessArea,
  ControllingArea,
  FunctionalArea,
  ValuationArea,
  InventoryValuationType,
  CostCenter,
  ProfitCenter,
  Segment,
  WBSElementExternalID,
  AlternativeGLAccount,
  GLAccount,
  FundsCenter,
  AssignmentReference,
  AssetClass,
  MasterFixedAsset,
  FixedAsset,
  Customer,
  Supplier,
  Plant,
  Material,
  Product,
  cast(AccountingDocumentItem as fis_buzei) AS AccountingDocumentItem,
  cast(AccountingDocumentType as fis_blart) AS AccountingDocumentType,
  CommitmentItem,
  FiscalPeriod,
  cast(ParentItem as firu_cf_parent_item) AS ParentItem,
  ItemType,
  FinancialStmntCashFlowItemMode,
  ItemSignIsReversed,
  ItemIsHiddenInReporting,
  FinancialStatementFormType,
  DocumentReferenceID,
  AccountingDocumentHeaderText,
  cast( JrnlEntryCntrySpecificRef4 as firu_paymentordernumber ) AS JrnlEntryCntrySpecificRef4,
  cast( JrnlEntryCntrySpecificDate4 as firu_paymentorderdate ) AS JrnlEntryCntrySpecificDate4,
  Currency,
  FinancialManagementArea,
  ChartOfAccounts,
  SourceCompanyCode,
  CountryChartOfAccounts
FROM C_RU_FinStmntCashFlowItemC
;

Learn More