C_CashFlowIndirectIFRS

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_CashFlowIndirectIFRS.
-- 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: CFICSHFLINDIFRS
-- Parameters: P_FromFiscalPeriod : fins_fagl_fiscper_from, P_ToFiscalPeriod : fins_fagl_fiscper_to

CREATE VIEW C_CashFlowIndirectIFRS AS
SELECT
  GLAccountHierarchy,
  CompanyCode,
  LedgerFiscalYear,
  Ledger,
  AssetAccountingKeyFigure,
  FiscalPeriod,
  FiscalQuarter,
  DebitCreditCode,
  AssetTransactionType,
  FinancialTransactionType,
  AccountingDocumentType,
  SemanticTag,
  GLAccount,
  FunctionalArea,
  CostCenter,
  ProfitCenter,
  AccountingDocument,
  PostingDate,
  Segment,
  BusinessArea,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS CashFlowAmount,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS OperatingCashFlowAmount,
  PnLResultAmtInCCCrcy AS GLAcctNetIncomeAmtInCCCrcy,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS IncomeAdjustmentAmount,
  TangibleAstDeprAmtInCCCrcy * (-1) AS OpgTngblAssetDeprAmtInCCCrcy,
  IntngblAssetAmtznAmtInCCCrcy * (-1) AS OpgIntngblAstAmtznAmtInCCCrcy,
  FixedAssetRtrmtAmtInCCCrcy * (-1) AS OpgFxdAstRtrmtAmtInCCCrcy,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS AssetLiabilityAmount,
  ProvisionAmtInCCCrcy * (-1) AS ProvisionAmtInCCCrcy,
  InventoryAmtInCCCrcy * (-1) AS InventoryAmtInCCCrcy,
  AcctsRblAmtInCCCrcy * (-1) AS AcctsRblAmtInCCCrcy,
  AcctsOthRblAmtInCCCrcy * (-1) AS AcctsOthRblAmtInCCCrcy,
  AcctsPyblAmtInCCCrcy,
  AcctsOthPyblAmtInCCCrcy,
  OperatingActyCashAmtInCCCrcy,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS InvestingCashFlowAmount,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS FixedAssetAmount,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS TangibleAssetAmount,
  TangibleAstAmtInCCCrcy* (-1) AS TangibleAstAmtInCCCrcy,
  TangibleAstDeprAmtInCCCrcy,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS IntangibleAssetAmount,
  IntangibleAstAmtInCCCrcy * (-1) AS IntangibleAstAmtInCCCrcy,
  IntngblAssetAmtznAmtInCCCrcy,
  FixedAssetRtrmtAmtInCCCrcy AS InvstgFxdAstRtrmtAmtInCCCrcy,
  LongTermInvmtAmtInCCCrcy * (-1) AS LongTermInvmtAmtInCCCrcy,
  InvestingActyCashAmtInCCCrcy,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS FinancingCashFlowAmount,
  CommonStockAmtInCCCrcy,
  NotesReceivableAmtInCCCrcy,
  FinancingActyCashAmtInCCCrcy,
  NetCashAmtInCCCrcy,
  CashAndCashEqvlntAmtInCCCrcy,
  0 AS CashValidationBalAmtInCCCrcy,
  ChartOfAccounts,
  FiscalYearVariant,
  FiscalYear,
  ControllingArea
FROM I_GLAccountLineItemSemTag
;