C_PE_CashFlowIndirectCube

DDL: C_PE_CASHFLOWINDIRECTCUBE Type: view_entity CONSUMPTION Package: GLO_FIN_IS_PE
52 Fields 2 Data Sources

Peru Cash Flow Indirect Method - Cube

C_PE_CashFlowIndirectCube is a Consumption CDS View (Cube) that provides data about "Peru Cash Flow Indirect Method - Cube" in SAP S/4HANA. It reads from 2 data sources (P_PE_CashFlowIndirectMethod, I_StRpJournalEntryLog) and exposes 52 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. Part of development package GLO_FIN_IS_PE.

Data Sources (2)

SourceAliasJoin Type
P_PE_CashFlowIndirectMethod P_PE_CashFlowIndirectMethod from
I_StRpJournalEntryLog StRpJournalEntryLog inner

Parameters (2)

NameTypeDefault
P_ReportingCurrency glo_reporting_currency
P_GLAccountHierarchy fins_sem_tag_hryid

Annotations (12)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #CUBE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
Analytics.internalName #LOCAL view
EndUserText.label Peru Cash Flow Indirect Method - Cube view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY Ledger CashFlow Ledger Ledger
KEY SourceLedger CashFlow SourceLedger Source Ledger
KEY CompanyCode CashFlow CompanyCode Receiver Company Code
KEY FiscalYear CashFlow FiscalYear G/L Fiscal Year
KEY AccountingDocument CashFlow AccountingDocument Journal Entry
KEY LedgerGLLineItem CashFlow LedgerGLLineItem Journal Entry Item
KEY GLAccountHierarchy CashFlow GLAccountHierarchy
KEY SemanticTag CashFlow SemanticTag Semantic Tag
KEY ValidityStartDate CashFlow ValidityStartDate Validity Start Date
KEY ValidityEndDate CashFlow ValidityEndDate ValidTo
KEY StatryRptCategory I_StRpJournalEntryLog StatryRptCategory Report ID
KEY StatryRptgEntity I_StRpJournalEntryLog StatryRptgEntity Reporting Entity
KEY StatryRptRunID I_StRpJournalEntryLog StatryRptRunID Report Run ID
ChartOfAccounts CashFlow ChartOfAccounts Node Class
GLAccount CashFlow GLAccount General Ledger
AlternativeGLAccount CashFlow AlternativeGLAccount Group Account
CountryChartOfAccounts CashFlow CountryChartOfAccounts Chart of Accts
AccountingDocumentCategory CashFlow AccountingDocumentCategory Journal Entry Category
FiscalQuarter CashFlow FiscalQuarter
LedgerFiscalYear CashFlow LedgerFiscalYear
FiscalPeriod CashFlow FiscalPeriod Tax period
ReportingCurrency CashFlow ReportingCurrency Currency
AmountInReportingCurrency CashFlow AmountInReportingCurrency
LongTermInvmtAmtInCCCrcy CashFlow LongTermInvmtAmtInCCCrcy
AcctsRblAmtInCCCrcy CashFlow AcctsRblAmtInCCCrcy
AcctsOthRblAmtInCCCrcy CashFlow AcctsOthRblAmtInCCCrcy
AcctsPyblAmtInCCCrcy CashFlow AcctsPyblAmtInCCCrcy
AcctsOthPyblAmtInCCCrcy CashFlow AcctsOthPyblAmtInCCCrcy
ProvisionAmtInCCCrcy CashFlow ProvisionAmtInCCCrcy
NotesReceivableAmtInCCCrcy CashFlow NotesReceivableAmtInCCCrcy
TangibleAstDeprAmtInCCCrcy CashFlow TangibleAstDeprAmtInCCCrcy
IntngblAssetAmtznAmtInCCCrcy CashFlow IntngblAssetAmtznAmtInCCCrcy
TangibleAstAmtInCCCrcy CashFlow TangibleAstAmtInCCCrcy
IntangibleAstAmtInCCCrcy CashFlow IntangibleAstAmtInCCCrcy
FixedAssetRtrmtAmtInCCCrcy CashFlow FixedAssetRtrmtAmtInCCCrcy
InventoryAmtInCCCrcy CashFlow InventoryAmtInCCCrcy
CommonStockAmtInCCCrcy CashFlow CommonStockAmtInCCCrcy
CashAndCashEqvlntAmtInCCCrcy CashFlow CashAndCashEqvlntAmtInCCCrcy
PnLResultAmtInCCCrcy CashFlow PnLResultAmtInCCCrcy
GLAcctNetIncomeAmtInCCCrcy CashFlow GLAcctNetIncomeAmtInCCCrcy
_Ledger CashFlow _Ledger
_SourceLedger CashFlow _SourceLedger
_JournalEntry CashFlow _JournalEntry
_CompanyCode CashFlow _CompanyCode
_FiscalYear CashFlow _FiscalYear
_GLAccountInChartOfAccounts CashFlow _GLAccountInChartOfAccounts
_ChartOfAccounts CashFlow _ChartOfAccounts
_AccountingDocumentCategory CashFlow _AccountingDocumentCategory
_AlternativeGLAccount CashFlow _AlternativeGLAccount
_CountryChartOfAccounts CashFlow _CountryChartOfAccounts
_SemanticTag CashFlow _SemanticTag
_Hierarchy CashFlow _Hierarchy

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_PE_CashFlowIndirectCube.
-- 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.
-- Parameters: P_ReportingCurrency : glo_reporting_currency, P_GLAccountHierarchy : fins_sem_tag_hryid

CREATE VIEW C_PE_CashFlowIndirectCube AS
SELECT
  CashFlow.Ledger AS Ledger,
  CashFlow.SourceLedger AS SourceLedger,
  CashFlow.CompanyCode AS CompanyCode,
  CashFlow.FiscalYear AS FiscalYear,
  CashFlow.AccountingDocument AS AccountingDocument,
  CashFlow.LedgerGLLineItem AS LedgerGLLineItem,
  CashFlow.GLAccountHierarchy AS GLAccountHierarchy,
  CashFlow.SemanticTag AS SemanticTag,
  CashFlow.ValidityStartDate AS ValidityStartDate,
  CashFlow.ValidityEndDate AS ValidityEndDate,
  StRpJournalEntryLog.StatryRptCategory AS StatryRptCategory,
  StRpJournalEntryLog.StatryRptgEntity AS StatryRptgEntity,
  StRpJournalEntryLog.StatryRptRunID AS StatryRptRunID,
  CashFlow.ChartOfAccounts AS ChartOfAccounts,
  CashFlow.GLAccount AS GLAccount,
  CashFlow.AlternativeGLAccount AS AlternativeGLAccount,
  CashFlow.CountryChartOfAccounts AS CountryChartOfAccounts,
  CashFlow.AccountingDocumentCategory AS AccountingDocumentCategory,
  CashFlow.FiscalQuarter AS FiscalQuarter,
  CashFlow.LedgerFiscalYear AS LedgerFiscalYear,
  CashFlow.FiscalPeriod AS FiscalPeriod,
  CashFlow.ReportingCurrency AS ReportingCurrency,
  CashFlow.AmountInReportingCurrency AS AmountInReportingCurrency,
  CashFlow.LongTermInvmtAmtInCCCrcy AS LongTermInvmtAmtInCCCrcy,
  CashFlow.AcctsRblAmtInCCCrcy AS AcctsRblAmtInCCCrcy,
  CashFlow.AcctsOthRblAmtInCCCrcy AS AcctsOthRblAmtInCCCrcy,
  CashFlow.AcctsPyblAmtInCCCrcy AS AcctsPyblAmtInCCCrcy,
  CashFlow.AcctsOthPyblAmtInCCCrcy AS AcctsOthPyblAmtInCCCrcy,
  CashFlow.ProvisionAmtInCCCrcy AS ProvisionAmtInCCCrcy,
  CashFlow.NotesReceivableAmtInCCCrcy AS NotesReceivableAmtInCCCrcy,
  CashFlow.TangibleAstDeprAmtInCCCrcy AS TangibleAstDeprAmtInCCCrcy,
  CashFlow.IntngblAssetAmtznAmtInCCCrcy AS IntngblAssetAmtznAmtInCCCrcy,
  CashFlow.TangibleAstAmtInCCCrcy AS TangibleAstAmtInCCCrcy,
  CashFlow.IntangibleAstAmtInCCCrcy AS IntangibleAstAmtInCCCrcy,
  CashFlow.FixedAssetRtrmtAmtInCCCrcy AS FixedAssetRtrmtAmtInCCCrcy,
  CashFlow.InventoryAmtInCCCrcy AS InventoryAmtInCCCrcy,
  CashFlow.CommonStockAmtInCCCrcy AS CommonStockAmtInCCCrcy,
  CashFlow.CashAndCashEqvlntAmtInCCCrcy AS CashAndCashEqvlntAmtInCCCrcy,
  CashFlow.PnLResultAmtInCCCrcy AS PnLResultAmtInCCCrcy,
  CashFlow.GLAcctNetIncomeAmtInCCCrcy AS GLAcctNetIncomeAmtInCCCrcy,
  CashFlow._Ledger AS _Ledger,
  CashFlow._SourceLedger AS _SourceLedger,
  CashFlow._JournalEntry AS _JournalEntry,
  CashFlow._CompanyCode AS _CompanyCode,
  CashFlow._FiscalYear AS _FiscalYear,
  CashFlow._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  CashFlow._ChartOfAccounts AS _ChartOfAccounts,
  CashFlow._AccountingDocumentCategory AS _AccountingDocumentCategory,
  CashFlow._AlternativeGLAccount AS _AlternativeGLAccount,
  CashFlow._CountryChartOfAccounts AS _CountryChartOfAccounts,
  CashFlow._SemanticTag AS _SemanticTag,
  CashFlow._Hierarchy AS _Hierarchy
FROM P_PE_CashFlowIndirectMethod
INNER JOIN I_StRpJournalEntryLog AS StRpJournalEntryLog ON /* join condition not captured in parsed metadata */
;

Learn More