C_GR_StRpTrialBalGLAcctCube

DDL: C_GR_STRPTRIALBALGLACCTCUBE Type: view_entity CONSUMPTION Package: GLO_FIN_IS_TB_GR
56 Fields 1 Data Sources 6 Associations

Greece Trial Balance all GL Acct - Cube

C_GR_StRpTrialBalGLAcctCube is a Consumption CDS View (Cube) that provides data about "Greece Trial Balance all GL Acct - Cube" in SAP S/4HANA. It reads from 1 data source (P_GR_StRpTrialBalanceHier) and exposes 56 fields with key fields ChartOfAccounts, CompanyCode, GLAccount, Ledger, SourceLedger. It has 6 associations to related views. Part of development package GLO_FIN_IS_TB_GR.

Data Sources (1)

SourceAliasJoin Type
P_GR_StRpTrialBalanceHier P_GR_StRpTrialBalanceHier from

Parameters (8)

NameTypeDefault
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to
P_FromFiscalPeriod fis_period_from
P_ToFiscalPeriod fis_period_to
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_Ledger fins_ledger

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and $projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount
[0..1] I_GLAccountInChartOfAccounts _AlternativeGLAccount $projection.CountryChartOfAccounts = _AlternativeGLAccount.ChartOfAccounts and $projection.AlternativeGLAccount = _AlternativeGLAccount.GLAccount
[0..1] I_ChartOfAccounts _CountryChartOfAccounts $projection.CountryChartOfAccounts = _CountryChartOfAccounts.ChartOfAccounts
[0..1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
Analytics.internalName #LOCAL view
Analytics.dataCategory #CUBE view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Greece Trial Balance all GL Acct - Cube view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts AllGLAccounts ChartOfAccounts Node Class
KEY CompanyCode AllGLAccounts CompanyCode Receiver Company Code
KEY GLAccount AllGLAccounts GLAccount General Ledger
KEY Ledger StRpTrialBalanceItemCube Ledger Ledger
KEY SourceLedger StRpTrialBalanceItemCube SourceLedger Source Ledger
KEY AccountingDocument StRpTrialBalanceItemCube AccountingDocument Journal Entry
KEY FiscalYear StRpTrialBalanceItemCube FiscalYear G/L Fiscal Year
KEY LedgerGLLineItem StRpTrialBalanceItemCube LedgerGLLineItem Journal Entry Item
KEY StatryRptgEntity StRpTrialBalanceItemCube StatryRptgEntity Reporting Entity
KEY StatryRptCategory StRpTrialBalanceItemCube StatryRptCategory Report ID
KEY StatryRptRunID StRpTrialBalanceItemCube StatryRptRunID Report Run ID
CountryChartOfAccounts AllGLAccounts CountryChartOfAccounts Chart of Accts
AlternativeGLAccount AllGLAccounts AlternativeGLAccount Group Account
FiscalPeriod StRpTrialBalanceItemCube FiscalPeriod Tax period
PostingDate StRpTrialBalanceItemCube PostingDate Posting Date for GR
DocumentDate StRpTrialBalanceItemCube DocumentDate Journal Entry Date
Supplier StRpTrialBalanceItemCube Supplier Supplier
GLAccountLongName StRpTrialBalanceItemCube GLAccountLongName Long Text
Customer StRpTrialBalanceItemCube Customer Sold-to Party
BusinessArea StRpTrialBalanceItemCube BusinessArea Business Area
FunctionalArea StRpTrialBalanceItemCube FunctionalArea Sendr Fctl Area
FinancialAccountType StRpTrialBalanceItemCube FinancialAccountType Fin. Account Type
SpecialGLCode StRpTrialBalanceItemCube SpecialGLCode Special G/L Ind
AccountingDocumentType StRpTrialBalanceItemCube AccountingDocumentType Journal Entry Type
PostingKey StRpTrialBalanceItemCube PostingKey Posting Key
AccountingDocumentCategory StRpTrialBalanceItemCube AccountingDocumentCategory Journal Entry Category
AccountingDocCreatedByUser StRpTrialBalanceItemCube AccountingDocCreatedByUser User which created overhead document
DebitCreditCode StRpTrialBalanceItemCube DebitCreditCode Single-Character Flag
AssignmentReference StRpTrialBalanceItemCube AssignmentReference Assignment Reference
DocumentItemText StRpTrialBalanceItemCube DocumentItemText Text
AuthorizationGroup AllGLAccounts AuthorizationGroup AuthorizGroup
CompanyCodeCurrency StRpTrialBalanceItemCube CompanyCodeCurrency Local Currency
CarryFwdBalAmtInCCCrcy StRpTrialBalanceItemCube CarryFwdBalAmtInCCCrcy
DebitCarryFwdBalAmtInCCCrcy StRpTrialBalanceItemCube DebitCarryFwdBalAmtInCCCrcy
CreditCarryFwdBalAmtInCCCrcy StRpTrialBalanceItemCube CreditCarryFwdBalAmtInCCCrcy
PrevPeriodYTDAmtInCCCrcy StRpTrialBalanceItemCube PrevPeriodYTDAmtInCCCrcy
DebitPrevPeriodYTDAmtInCCCrcy StRpTrialBalanceItemCube DebitPrevPeriodYTDAmtInCCCrcy
CreditPrevPeriodYTDAmtInCCCrcy StRpTrialBalanceItemCube CreditPrevPeriodYTDAmtInCCCrcy
StartingBalanceAmtInCoCodeCrcy StRpTrialBalanceItemCube StartingBalanceAmtInCoCodeCrcy
DebitStartingBalAmtInCCCrcy StRpTrialBalanceItemCube DebitStartingBalAmtInCCCrcy
CreditStartingBalAmtInCCCrcy StRpTrialBalanceItemCube CreditStartingBalAmtInCCCrcy
AmountInCompanyCodeCurrency StRpTrialBalanceItemCube AmountInCompanyCodeCurrency Local Crcy Amt
DebitAmountInCoCodeCrcy StRpTrialBalanceItemCube DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy StRpTrialBalanceItemCube CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
EndingBalanceAmtInCoCodeCrcy StRpTrialBalanceItemCube EndingBalanceAmtInCoCodeCrcy
DebitEndingBalAmtInCCCrcy StRpTrialBalanceItemCube DebitEndingBalAmtInCCCrcy
CreditEndingBalAmtInCCCrcy StRpTrialBalanceItemCube CreditEndingBalAmtInCCCrcy
YTDAmtInLoclCrcy StRpTrialBalanceItemCube YTDAmtInLoclCrcy
YTDDebitAmtInCoCodeCrcy StRpTrialBalanceItemCube YTDDebitAmtInCoCodeCrcy
YTDCrdtAmtInCoCodeCrcy StRpTrialBalanceItemCube YTDCrdtAmtInCoCodeCrcy
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_AlternativeGLAccount _AlternativeGLAccount
_CountryChartOfAccounts _CountryChartOfAccounts
_ChartOfAccounts _ChartOfAccounts
_Supplier _Supplier
_Customer _Customer

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_GR_StRpTrialBalGLAcctCube.
-- 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, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_Ledger : fins_ledger

CREATE VIEW C_GR_StRpTrialBalGLAcctCube AS
SELECT
  AllGLAccounts.ChartOfAccounts AS ChartOfAccounts,
  AllGLAccounts.CompanyCode AS CompanyCode,
  AllGLAccounts.GLAccount AS GLAccount,
  StRpTrialBalanceItemCube.Ledger AS Ledger,
  StRpTrialBalanceItemCube.SourceLedger AS SourceLedger,
  StRpTrialBalanceItemCube.AccountingDocument AS AccountingDocument,
  StRpTrialBalanceItemCube.FiscalYear AS FiscalYear,
  StRpTrialBalanceItemCube.LedgerGLLineItem AS LedgerGLLineItem,
  StRpTrialBalanceItemCube.StatryRptgEntity AS StatryRptgEntity,
  StRpTrialBalanceItemCube.StatryRptCategory AS StatryRptCategory,
  StRpTrialBalanceItemCube.StatryRptRunID AS StatryRptRunID,
  AllGLAccounts.CountryChartOfAccounts AS CountryChartOfAccounts,
  AllGLAccounts.AlternativeGLAccount AS AlternativeGLAccount,
  StRpTrialBalanceItemCube.FiscalPeriod AS FiscalPeriod,
  StRpTrialBalanceItemCube.PostingDate AS PostingDate,
  StRpTrialBalanceItemCube.DocumentDate AS DocumentDate,
  StRpTrialBalanceItemCube.Supplier AS Supplier,
  StRpTrialBalanceItemCube.GLAccountLongName AS GLAccountLongName,
  StRpTrialBalanceItemCube.Customer AS Customer,
  StRpTrialBalanceItemCube.BusinessArea AS BusinessArea,
  StRpTrialBalanceItemCube.FunctionalArea AS FunctionalArea,
  StRpTrialBalanceItemCube.FinancialAccountType AS FinancialAccountType,
  StRpTrialBalanceItemCube.SpecialGLCode AS SpecialGLCode,
  StRpTrialBalanceItemCube.AccountingDocumentType AS AccountingDocumentType,
  StRpTrialBalanceItemCube.PostingKey AS PostingKey,
  StRpTrialBalanceItemCube.AccountingDocumentCategory AS AccountingDocumentCategory,
  StRpTrialBalanceItemCube.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  StRpTrialBalanceItemCube.DebitCreditCode AS DebitCreditCode,
  StRpTrialBalanceItemCube.AssignmentReference AS AssignmentReference,
  StRpTrialBalanceItemCube.DocumentItemText AS DocumentItemText,
  AllGLAccounts.AuthorizationGroup AS AuthorizationGroup,
  StRpTrialBalanceItemCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  StRpTrialBalanceItemCube.CarryFwdBalAmtInCCCrcy AS CarryFwdBalAmtInCCCrcy,
  StRpTrialBalanceItemCube.DebitCarryFwdBalAmtInCCCrcy AS DebitCarryFwdBalAmtInCCCrcy,
  StRpTrialBalanceItemCube.CreditCarryFwdBalAmtInCCCrcy AS CreditCarryFwdBalAmtInCCCrcy,
  StRpTrialBalanceItemCube.PrevPeriodYTDAmtInCCCrcy AS PrevPeriodYTDAmtInCCCrcy,
  StRpTrialBalanceItemCube.DebitPrevPeriodYTDAmtInCCCrcy AS DebitPrevPeriodYTDAmtInCCCrcy,
  StRpTrialBalanceItemCube.CreditPrevPeriodYTDAmtInCCCrcy AS CreditPrevPeriodYTDAmtInCCCrcy,
  StRpTrialBalanceItemCube.StartingBalanceAmtInCoCodeCrcy AS StartingBalanceAmtInCoCodeCrcy,
  StRpTrialBalanceItemCube.DebitStartingBalAmtInCCCrcy AS DebitStartingBalAmtInCCCrcy,
  StRpTrialBalanceItemCube.CreditStartingBalAmtInCCCrcy AS CreditStartingBalAmtInCCCrcy,
  StRpTrialBalanceItemCube.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  StRpTrialBalanceItemCube.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  StRpTrialBalanceItemCube.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  StRpTrialBalanceItemCube.EndingBalanceAmtInCoCodeCrcy AS EndingBalanceAmtInCoCodeCrcy,
  StRpTrialBalanceItemCube.DebitEndingBalAmtInCCCrcy AS DebitEndingBalAmtInCCCrcy,
  StRpTrialBalanceItemCube.CreditEndingBalAmtInCCCrcy AS CreditEndingBalAmtInCCCrcy,
  StRpTrialBalanceItemCube.YTDAmtInLoclCrcy AS YTDAmtInLoclCrcy,
  StRpTrialBalanceItemCube.YTDDebitAmtInCoCodeCrcy AS YTDDebitAmtInCoCodeCrcy,
  StRpTrialBalanceItemCube.YTDCrdtAmtInCoCodeCrcy AS YTDCrdtAmtInCoCodeCrcy
FROM P_GR_StRpTrialBalanceHier
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _AlternativeGLAccount ON CountryChartOfAccounts = _AlternativeGLAccount.ChartOfAccounts AND AlternativeGLAccount = _AlternativeGLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _CountryChartOfAccounts ON CountryChartOfAccounts = _CountryChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
;

Learn More