P_GR_StRpTrialBalanceGLAcct

DDL: P_GR_STRPTRIALBALANCEGLACCT Type: view_entity COMPOSITE

Greece All G/L Account

P_GR_StRpTrialBalanceGLAcct is a Composite CDS View that provides data about "Greece All G/L Account" in SAP S/4HANA. It reads from 3 data sources (I_CompanyCode, I_GLAccountInChartOfAccounts, I_GLAccountInCompanyCode) and exposes 7 fields.

Data Sources (3)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode inner
I_GLAccountInChartOfAccounts I_GLAccountInChartOfAccounts inner
I_GLAccountInCompanyCode I_GLAccountInCompanyCode from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Greece All G/L Account view

Fields (7)

KeyFieldSource TableSource FieldDescription
ChartOfAccounts I_GLAccountInChartOfAccounts ChartOfAccounts Node Class
CompanyCode I_GLAccountInCompanyCode CompanyCode Receiver Company Code
GLAccount I_GLAccountInChartOfAccounts GLAccount General Ledger
AlternativeGLAccount I_GLAccountInCompanyCode AlternativeGLAccount Group Account
AuthorizationGroup I_GLAccountInCompanyCode AuthorizationGroup AuthorizGroup
Currency I_CompanyCode Currency Valuation Crcy
CountryChartOfAccounts I_CompanyCode CountryChartOfAccounts Chart of Accts

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 P_GR_StRpTrialBalanceGLAcct.
-- 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.

CREATE VIEW P_GR_StRpTrialBalanceGLAcct AS
SELECT
  I_GLAccountInChartOfAccounts.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountInCompanyCode.CompanyCode AS CompanyCode,
  I_GLAccountInChartOfAccounts.GLAccount AS GLAccount,
  I_GLAccountInCompanyCode.AlternativeGLAccount AS AlternativeGLAccount,
  I_GLAccountInCompanyCode.AuthorizationGroup AS AuthorizationGroup,
  I_CompanyCode.Currency AS Currency,
  I_CompanyCode.CountryChartOfAccounts AS CountryChartOfAccounts
FROM I_GLAccountInCompanyCode
INNER JOIN I_GLAccountInChartOfAccounts ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
;