C_SI_StRpGeneralLedgerCube

DDL: C_SI_STRPGENERALLEDGERCUBE SQL: CSISTRPGRLLGRC Type: view Package: GLO_FIN_IS_GL_SI
56 Fields 1 Data Sources 1 Associations

General Ledger Items for Slovenia - Cube

C_SI_StRpGeneralLedgerCube is a CDS View of category Cube that provides data about "General Ledger Items for Slovenia - Cube" in SAP S/4HANA. It reads from 1 data source (I_StRpTrialBalanceItemCube) and exposes 56 fields with key fields Ledger, CompanyCode, FiscalYear, SourceLedger, AccountingDocument. It has 1 association to related views. Part of development package GLO_FIN_IS_GL_SI.

Data Sources (1)

SourceAliasJoin Type
I_StRpTrialBalanceItemCube I_StRpTrialBalanceItemCube from

Parameters (4)

NameTypeDefault
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to
P_FromFiscalPeriod fis_period_from
P_ToFiscalPeriod fis_period_to

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_JournalEntry _JournalEntry $projection.CompanyCode = _JournalEntry.CompanyCode and $projection.FiscalYear = _JournalEntry.FiscalYear and $projection.AccountingDocument = _JournalEntry.AccountingDocument

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CSISTRPGRLLGRC view
AbapCatalog.compiler.compareFilter true view
Analytics.dataCategory #CUBE view
EndUserText.label General Ledger Items for Slovenia - Cube view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Analytics.internalName #LOCAL view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY Ledger TB Ledger Ledger
KEY CompanyCode TB CompanyCode Receiver Company Code
KEY FiscalYear TB FiscalYear G/L Fiscal Year
KEY SourceLedger TB SourceLedger Source Ledger
KEY AccountingDocument TB AccountingDocument Journal Entry
KEY LedgerGLLineItem TB LedgerGLLineItem Journal Entry Item
KEY StatryRptCategory TB StatryRptCategory Report ID
KEY StatryRptgEntity TB StatryRptgEntity Reporting Entity
KEY StatryRptRunID TB StatryRptRunID Report Run ID
PostingDate TB PostingDate Posting Date for GR
DocumentDate TB DocumentDate Journal Entry Date
FiscalPeriod TB FiscalPeriod Tax period
DocumentItemText TB DocumentItemText Text
AccountingDocumentType TB AccountingDocumentType Journal Entry Type
DocumentReferenceID _JournalEntry DocumentReferenceID Reference
AccountingDocumentHeaderText _JournalEntry AccountingDocumentHeaderText Doc.Header Text
TaxReportingDate _JournalEntry TaxReportingDate Tax Reporting Date
TaxCode TB TaxCode Tax Code
CostCenter JournalEntryItem CostCenter Cost Center
AccountingDocumentCreationDate _JournalEntry AccountingDocumentCreationDate Journal Entry Date
CreationTime _JournalEntry CreationTime Time of Change
OffsettingAccount JournalEntryItem OffsettingAccount Offsetting Acct
AccountingDocCreatedByUser TB AccountingDocCreatedByUser User which created overhead document
AccountingDocumentItem TB AccountingDocumentItem Posting View Item
GLAccountLongNameendasGLAccountLongName
DebitCreditCode TB DebitCreditCode Single-Character Flag
ChartOfAccounts TB ChartOfAccounts Node Class
AlternativeGLAccount GLAlterAccount AlternativeGLAccount Group Account
AltvRecnclnAccts AlterOffAcc AlternativeGLAccount Group Account
CountryChartOfAccounts TB CountryChartOfAccounts Chart of Accts
GLAccount TB GLAccount General Ledger
ReconciliationAccountType TB ReconciliationAccountType Reconcil. ID
Supplier TB Supplier Supplier
Customer TB Customer Sold-to Party
FinancialAccountType TB FinancialAccountType Fin. Account Type
SpecialGLCode TB SpecialGLCode Special G/L Ind
PostingKey TB PostingKey Posting Key
AccountingDocumentCategory TB AccountingDocumentCategory Journal Entry Category
BankAccountMessageStatusText TB AlternativeGLAccount Group Account
CompanyCodeCurrency TB CompanyCodeCurrency Local Currency
StartingBalanceAmtInCoCodeCrcy TB StartingBalanceAmtInCoCodeCrcy
AmountInCompanyCodeCurrency TB AmountInCompanyCodeCurrency Local Crcy Amt
EndingBalanceAmtInCoCodeCrcy TB EndingBalanceAmtInCoCodeCrcy
AssignmentReference TB AssignmentReference Assignment Reference
_Supplier TB _Supplier
_Customer TB _Customer
_CompanyCode TB _CompanyCode
_GLAccountText TB _GLAccountText
_GLAccountInChartOfAccounts TB _GLAccountInChartOfAccounts
_AlternativeGLAccount TB _AlternativeGLAccount
_GLAccountInCompanyCode TB _GLAccountInCompanyCode
_ChartOfAccounts TB _ChartOfAccounts
_CountryChartOfAccounts TB _CountryChartOfAccounts
_TaxCode TB _TaxCode
_ReportedItemsLog TB _ReportedItemsLog
_JournalEntry _JournalEntry

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_SI_StRpGeneralLedgerCube.
-- 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: CSISTRPGRLLGRC
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_FromFiscalPeriod : fis_period_from, P_ToFiscalPeriod : fis_period_to

CREATE VIEW C_SI_StRpGeneralLedgerCube AS
SELECT
  TB.Ledger AS Ledger,
  TB.CompanyCode AS CompanyCode,
  TB.FiscalYear AS FiscalYear,
  TB.SourceLedger AS SourceLedger,
  TB.AccountingDocument AS AccountingDocument,
  TB.LedgerGLLineItem AS LedgerGLLineItem,
  TB.StatryRptCategory AS StatryRptCategory,
  TB.StatryRptgEntity AS StatryRptgEntity,
  TB.StatryRptRunID AS StatryRptRunID,
  TB.PostingDate AS PostingDate,
  TB.DocumentDate AS DocumentDate,
  TB.FiscalPeriod AS FiscalPeriod,
  TB.DocumentItemText AS DocumentItemText,
  TB.AccountingDocumentType AS AccountingDocumentType,
  _JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  _JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  _JournalEntry.TaxReportingDate AS TaxReportingDate,
  TB.TaxCode AS TaxCode,
  JournalEntryItem.CostCenter AS CostCenter,
  _JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  _JournalEntry.CreationTime AS CreationTime,
  JournalEntryItem.OffsettingAccount AS OffsettingAccount,
  TB.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  TB.AccountingDocumentItem AS AccountingDocumentItem,
  case when JournalEntryItem._GLAccountInChartOfAccounts._Text[1: Language = '5' ].GLAccountLongName = '' or JournalEntryItem._GLAccountInChartOfAccounts._Text[1: Language = '5' ].GLAccountLongName is null then JournalEntryItem._GLAccountInChartOfAccounts._Text[1: Language = $session.system_language ].GLAccountLongName else JournalEntryItem._GLAccountInChartOfAccounts._Text[1: Language = '5' ].GLAccountLongName end as GLAccountLongName AS GLAccountLongNameendasGLAccountLongName,
  TB.DebitCreditCode AS DebitCreditCode,
  TB.ChartOfAccounts AS ChartOfAccounts,
  GLAlterAccount.AlternativeGLAccount AS AlternativeGLAccount,
  AlterOffAcc.AlternativeGLAccount AS AltvRecnclnAccts,
  TB.CountryChartOfAccounts AS CountryChartOfAccounts,
  TB.GLAccount AS GLAccount,
  TB.ReconciliationAccountType AS ReconciliationAccountType,
  TB.Supplier AS Supplier,
  TB.Customer AS Customer,
  TB.FinancialAccountType AS FinancialAccountType,
  TB.SpecialGLCode AS SpecialGLCode,
  TB.PostingKey AS PostingKey,
  TB.AccountingDocumentCategory AS AccountingDocumentCategory,
  TB.AlternativeGLAccount AS BankAccountMessageStatusText,
  TB.CompanyCodeCurrency AS CompanyCodeCurrency,
  TB.StartingBalanceAmtInCoCodeCrcy AS StartingBalanceAmtInCoCodeCrcy,
  TB.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  TB.EndingBalanceAmtInCoCodeCrcy AS EndingBalanceAmtInCoCodeCrcy,
  TB.AssignmentReference AS AssignmentReference,
  TB._Supplier AS _Supplier,
  TB._Customer AS _Customer,
  TB._CompanyCode AS _CompanyCode,
  TB._GLAccountText AS _GLAccountText,
  TB._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  TB._AlternativeGLAccount AS _AlternativeGLAccount,
  TB._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  TB._ChartOfAccounts AS _ChartOfAccounts,
  TB._CountryChartOfAccounts AS _CountryChartOfAccounts,
  TB._TaxCode AS _TaxCode,
  TB._ReportedItemsLog AS _ReportedItemsLog
FROM I_StRpTrialBalanceItemCube
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [0..1]
;

Learn More