C_RU_FinStmntCashFlowItemQ

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_FinStmntCashFlowItemQ.
-- 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_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_RU_FinStmntCashFlowItemQ 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,
  CalendarYear,
  cast(PeriodBalAmtInDspCrcy as firu_period_bal_amt) AS PeriodBalAmtInDspCrcy,
  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,
  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,
  SpecialGLCode,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  BusinessPlace
FROM C_RU_FinStmntCashFlowItemC
;