C_RU_FinStmntCashFlowItemC

DDL: C_RU_FINSTMNTCASHFLOWITEMC SQL: CRUFS_ITEM_CF_C Type: view CONSUMPTION
89 Fields 1 Data Sources

Financial Statement Cash Flow Cube

C_RU_FinStmntCashFlowItemC is a Consumption CDS View (Cube) that provides data about "Financial Statement Cash Flow Cube" in SAP S/4HANA. It reads from 1 data source (I_RU_FinStmntCashFlowLogItem) and exposes 89 fields with key fields FinancialStatementLeafItem, StatryRptgEntity, StatryRptCategory, StatryRptRunID, CashFlowStatementHierVersion.

Data Sources (1)

SourceAliasJoin Type
I_RU_FinStmntCashFlowLogItem I_RU_FinStmntCashFlowLogItem 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 (14)

NameValueLevelField
AbapCatalog.sqlViewName CRUFS_ITEM_CF_C view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Financial Statement Cash Flow Cube view
AccessControl.personalData.blocking #BLOCK_DATA_INCLUDED view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
Analytics.dataExtraction.enabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (89)

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 AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY ClearedInvoiceNumber ClearedInvoiceNumber
KEY ClearedInvoiceYear ClearedInvoiceYear
KEY CashFlowStmntReportingPeriod CashFlowStmntReportingPeriod
CalendarYear
Currency Currency Valuation Crcy
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
WBSElement WBSElement WBS Internal ID
WBSElementInternalID WBSElementInternalID WBS Internal ID
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 AccountingDocumentItem Posting View Item
AccountingDocumentType AccountingDocumentType Journal Entry Type
CountryChartOfAccounts CountryChartOfAccounts Chart of Accts
ChartOfAccounts ChartOfAccounts Node Class
FinancialManagementArea FinancialManagementArea FM Area
SourceCompanyCode SourceCompanyCode Receiver Company Code
SourceLedger SourceLedger Source Ledger
FiscalPeriod FiscalPeriod Tax period
Item _Item Item Task ID
ParentItem _Item ParentItem
ItemType _Item ItemType Object Type
FinancialStmntCashFlowItemMode _Item FinancialStmntCashFlowItemMode
ItemSignIsReversed _Item ItemSignIsReversed Change Item Sign
ItemIsHiddenInReporting _Item ItemIsHiddenInReporting
FinancialStatementFormType
CommitmentItem
DocumentReferenceID DocumentReferenceID Reference
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
JrnlEntryCntrySpecificRef4 JrnlEntryCntrySpecificRef4 Country/Region Specific Reference 4
JrnlEntryCntrySpecificDate4 JrnlEntryCntrySpecificDate4 Country/Region Specific Date 4
_AccountingDocumentType _AccountingDocumentType
_AlternativeGLAccount _AlternativeGLAccount
_BusinessArea _BusinessArea
_ChartOfAccounts _ChartOfAccounts
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_CostCenter _CostCenter
_CountryChartOfAccounts _CountryChartOfAccounts
_Customer _Customer
_FinancialManagementArea _FinancialManagementArea
_FunctionalArea _FunctionalArea
_FundsCenter _FundsCenter
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_GLAccountLineItem _GLAccountLineItem
_InventoryValuationType _InventoryValuationType
_Item _Item
_Version _Version
_MasterFixedAsset _MasterFixedAsset
_Material _Material
_Plant _Plant
_ProfitCenter _ProfitCenter
_PurReqValuationArea _PurReqValuationArea
_Segment _Segment
_Supplier _Supplier
_WBSElement _WBSElement
SpecialGLCode _OperationalAcctgDocItem SpecialGLCode Special G/L Ind
Reference1IDByBusinessPartner _OperationalAcctgDocItem Reference1IDByBusinessPartner Reference Key 1
Reference2IDByBusinessPartner _OperationalAcctgDocItem Reference2IDByBusinessPartner Reference Key 2
Reference3IDByBusinessPartner _OperationalAcctgDocItem Reference3IDByBusinessPartner Reference Key 3
BusinessPlace _OperationalAcctgDocItem BusinessPlace Business place

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_RU_FinStmntCashFlowItemC.
-- 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: CRUFS_ITEM_CF_C
-- 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_RU_FinStmntCashFlowItemC AS
SELECT
  FinancialStatementLeafItem,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CashFlowStatementHierVersion,
  CompanyCode,
  AccountingDocument,
  LedgerGLLineItem,
  FiscalYear,
  ClearedInvoiceNumber,
  ClearedInvoiceYear,
  CashFlowStmntReportingPeriod,
  cast(substring(PostingDate, 1, 4) as calendaryear) AS CalendarYear,
  Currency,
  DocumentDate,
  PostingDate,
  BusinessArea,
  ControllingArea,
  FunctionalArea,
  ValuationArea,
  InventoryValuationType,
  CostCenter,
  ProfitCenter,
  Segment,
  WBSElement,
  WBSElementInternalID,
  WBSElementExternalID,
  AlternativeGLAccount,
  GLAccount,
  FundsCenter,
  AssignmentReference,
  AssetClass,
  MasterFixedAsset,
  FixedAsset,
  Customer,
  Supplier,
  Plant,
  Material,
  Product,
  AccountingDocumentItem,
  AccountingDocumentType,
  CountryChartOfAccounts,
  ChartOfAccounts,
  FinancialManagementArea,
  SourceCompanyCode,
  SourceLedger,
  FiscalPeriod,
  _Item.Item AS Item,
  _Item.ParentItem AS ParentItem,
  _Item.ItemType AS ItemType,
  _Item.FinancialStmntCashFlowItemMode AS FinancialStmntCashFlowItemMode,
  _Item.ItemSignIsReversed AS ItemSignIsReversed,
  _Item.ItemIsHiddenInReporting AS ItemIsHiddenInReporting,
  cast ('4' as firu_finstat_formtype) AS FinancialStatementFormType,
  cast(_OperationalAcctgDocItem.CommitmentItem as fm_fipex) AS CommitmentItem,
  DocumentReferenceID,
  AccountingDocumentHeaderText,
  JrnlEntryCntrySpecificRef4,
  JrnlEntryCntrySpecificDate4,
  _OperationalAcctgDocItem.SpecialGLCode AS SpecialGLCode,
  _OperationalAcctgDocItem.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  _OperationalAcctgDocItem.Reference2IDByBusinessPartner AS Reference2IDByBusinessPartner,
  _OperationalAcctgDocItem.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  _OperationalAcctgDocItem.BusinessPlace AS BusinessPlace
FROM I_RU_FinStmntCashFlowLogItem
;

Learn More