P_GR_StRpTrialBalanceGLAcct

DDL: P_GR_STRPTRIALBALANCEGLACCT Type: view_entity COMPOSITE Package: GLO_FIN_IS_TB_GR

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. Part of development package GLO_FIN_IS_TB_GR.

3 data source(s) 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
CompanyCode I_GLAccountInCompanyCode CompanyCode
GLAccount I_GLAccountInChartOfAccounts GLAccount
AlternativeGLAccount I_GLAccountInCompanyCode AlternativeGLAccount
AuthorizationGroup I_GLAccountInCompanyCode AuthorizationGroup
Currency I_CompanyCode Currency
CountryChartOfAccounts I_CompanyCode CountryChartOfAccounts 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
@EndUserText.label: 'Greece All G/L Account'
@Consumption.dbHints: [ 'NO_CYCLIC_JOIN']
define view entity P_GR_StRpTrialBalanceGLAcct
  as select from I_GLAccountInCompanyCode
    inner join   I_GLAccountInChartOfAccounts on I_GLAccountInChartOfAccounts.GLAccount = I_GLAccountInCompanyCode.GLAccount
    inner join   I_CompanyCode                on I_CompanyCode.CompanyCode = I_GLAccountInCompanyCode.CompanyCode
{
  I_GLAccountInChartOfAccounts.ChartOfAccounts,
  I_GLAccountInCompanyCode.CompanyCode,
  I_GLAccountInChartOfAccounts.GLAccount,
  I_GLAccountInCompanyCode.AlternativeGLAccount,
  I_GLAccountInCompanyCode.AuthorizationGroup,
  I_CompanyCode.Currency,
  I_CompanyCode.CountryChartOfAccounts
}

Learn More