C_RO_StRpCashJournalC

DDL: C_RO_STRPCASHJOURNALC Type: view_entity CONSUMPTION
50 Fields 2 Data Sources

Romanian Cash Journal - Cube

C_RO_StRpCashJournalC is a Consumption CDS View (Cube) that provides data about "Romanian Cash Journal - Cube" in SAP S/4HANA. It reads from 2 data sources (I_GLAccountInCompanyCode, I_StRpTrialBalanceItemCube) and exposes 50 fields with key fields Ledger, CompanyCode, FiscalYear, SourceLedger, AccountingDocument.

Data Sources (2)

SourceAliasJoin Type
I_GLAccountInCompanyCode CashAccnt from
I_StRpTrialBalanceItemCube I_StRpTrialBalanceItemCube inner

Parameters (4)

NameTypeDefault
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to
P_FromFiscalPeriod fis_period_from
P_ToFiscalPeriod fis_period_to

Annotations (10)

NameValueLevelField
EndUserText.label Romanian Cash Journal - Cube view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
Analytics.internalName #LOCAL view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY Ledger BalanceItem Ledger Ledger
KEY CompanyCode BalanceItem CompanyCode Receiver Company Code
KEY FiscalYear BalanceItem FiscalYear G/L Fiscal Year
KEY SourceLedger BalanceItem SourceLedger Source Ledger
KEY AccountingDocument BalanceItem AccountingDocument Journal Entry
KEY LedgerGLLineItem BalanceItem LedgerGLLineItem Journal Entry Item
KEY StatryRptCategory BalanceItem StatryRptCategory Report ID
KEY StatryRptgEntity BalanceItem StatryRptgEntity Reporting Entity
KEY StatryRptRunID BalanceItem StatryRptRunID Report Run ID
PostingDate BalanceItem PostingDate Posting Date for GR
DocumentDate BalanceItem DocumentDate Journal Entry Date
FiscalPeriod BalanceItem FiscalPeriod Tax period
DocumentItemText BalanceItem DocumentItemText Text
AccountingDocumentType BalanceItem AccountingDocumentType Journal Entry Type
DocumentReferenceID
AccountingDocumentHeaderText
AccountingDocumentItem BalanceItem AccountingDocumentItem Posting View Item
GLAccountLongName BalanceItem GLAccountLongName Long Text
AlternativeGLAccountName
DebitCreditCode BalanceItem DebitCreditCode Single-Character Flag
ChartOfAccounts BalanceItem ChartOfAccounts Node Class
AlternativeGLAccount I_GLAccountInCompanyCode AlternativeGLAccount Group Account
CountryChartOfAccounts BalanceItem CountryChartOfAccounts Chart of Accts
GLAccount BalanceItem GLAccount General Ledger
Supplier BalanceItem Supplier Supplier
Customer BalanceItem Customer Sold-to Party
FinancialAccountType BalanceItem FinancialAccountType Fin. Account Type
CompanyCodeCurrency BalanceItem CompanyCodeCurrency Local Currency
TransactionCurrency BalanceItem TransactionCurrency Transaction Currency
GLAccountCurrency
OffsettingAccount BalanceItem OffsettingAccount Offsetting Acct
StartingBalanceAmtInCoCodeCrcy BalanceItem StartingBalanceAmtInCoCodeCrcy
StartingBalanceAmtInTransCrcy BalanceItem StartingBalanceAmtInTransCrcy
AmountInCompanyCodeCurrency BalanceItem AmountInCompanyCodeCurrency Local Crcy Amt
AmountInTransactionCurrency BalanceItem AmountInTransactionCurrency Pt Crcy Amt
EndingBalanceAmtInCoCodeCrcy BalanceItem EndingBalanceAmtInCoCodeCrcy
EndingBalanceAmtInTransCrcy BalanceItem EndingBalanceAmtInTransCrcy
TransactionCode
ReferenceDocumentType
OriginalReferenceDocument
AssignmentReference BalanceItem AssignmentReference Assignment Reference
_Supplier BalanceItem _Supplier
_Customer BalanceItem _Customer
_CompanyCode BalanceItem _CompanyCode
_GLAccountText BalanceItem _GLAccountText
_GLAccountInChartOfAccounts BalanceItem _GLAccountInChartOfAccounts
_GLAccountInCompanyCode BalanceItem _GLAccountInCompanyCode
_ChartOfAccounts BalanceItem _ChartOfAccounts
_CountryChartOfAccounts BalanceItem _CountryChartOfAccounts
_ReportedItemsLog BalanceItem _ReportedItemsLog

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_RO_StRpCashJournalC.
-- 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_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_FromFiscalPeriod : fis_period_from, P_ToFiscalPeriod : fis_period_to

CREATE VIEW C_RO_StRpCashJournalC AS
SELECT
  BalanceItem.Ledger AS Ledger,
  BalanceItem.CompanyCode AS CompanyCode,
  BalanceItem.FiscalYear AS FiscalYear,
  BalanceItem.SourceLedger AS SourceLedger,
  BalanceItem.AccountingDocument AS AccountingDocument,
  BalanceItem.LedgerGLLineItem AS LedgerGLLineItem,
  BalanceItem.StatryRptCategory AS StatryRptCategory,
  BalanceItem.StatryRptgEntity AS StatryRptgEntity,
  BalanceItem.StatryRptRunID AS StatryRptRunID,
  BalanceItem.PostingDate AS PostingDate,
  BalanceItem.DocumentDate AS DocumentDate,
  BalanceItem.FiscalPeriod AS FiscalPeriod,
  BalanceItem.DocumentItemText AS DocumentItemText,
  BalanceItem.AccountingDocumentType AS AccountingDocumentType,
  BalanceItem._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  BalanceItem._JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  BalanceItem.AccountingDocumentItem AS AccountingDocumentItem,
  BalanceItem.GLAccountLongName AS GLAccountLongName,
  BalanceItem._AlternativeGLAccount._Text[1: Language = $session.system_language ].GLAccountLongName AS AlternativeGLAccountName,
  BalanceItem.DebitCreditCode AS DebitCreditCode,
  BalanceItem.ChartOfAccounts AS ChartOfAccounts,
  CashAccnt.AlternativeGLAccount AS AlternativeGLAccount,
  BalanceItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  BalanceItem.GLAccount AS GLAccount,
  BalanceItem.Supplier AS Supplier,
  BalanceItem.Customer AS Customer,
  BalanceItem.FinancialAccountType AS FinancialAccountType,
  BalanceItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  BalanceItem.TransactionCurrency AS TransactionCurrency,
  BalanceItem._GLAccountInCompanyCode.GLAccountCurrency AS GLAccountCurrency,
  BalanceItem.OffsettingAccount AS OffsettingAccount,
  BalanceItem.StartingBalanceAmtInCoCodeCrcy AS StartingBalanceAmtInCoCodeCrcy,
  BalanceItem.StartingBalanceAmtInTransCrcy AS StartingBalanceAmtInTransCrcy,
  BalanceItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  BalanceItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  BalanceItem.EndingBalanceAmtInCoCodeCrcy AS EndingBalanceAmtInCoCodeCrcy,
  BalanceItem.EndingBalanceAmtInTransCrcy AS EndingBalanceAmtInTransCrcy,
  BalanceItem._JournalEntry.TransactionCode AS TransactionCode,
  BalanceItem._JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  BalanceItem._JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
  BalanceItem.AssignmentReference AS AssignmentReference,
  BalanceItem._Supplier AS _Supplier,
  BalanceItem._Customer AS _Customer,
  BalanceItem._CompanyCode AS _CompanyCode,
  BalanceItem._GLAccountText AS _GLAccountText,
  BalanceItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  BalanceItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  BalanceItem._ChartOfAccounts AS _ChartOfAccounts,
  BalanceItem._CountryChartOfAccounts AS _CountryChartOfAccounts,
  BalanceItem._ReportedItemsLog AS _ReportedItemsLog
FROM I_GLAccountInCompanyCode AS CashAccnt
INNER JOIN I_StRpTrialBalanceItemCube ON /* join condition not captured in parsed metadata */
;

Learn More