I_GLAccountGroup

DDL: I_GLACCOUNTGROUP SQL: IGLACCTGRP Type: view BASIC

General Ledger Account Group

I_GLAccountGroup is a Basic CDS View (Dimension) that provides data about "General Ledger Account Group" in SAP S/4HANA. It reads from 1 data source (t077s) and exposes 5 fields with key fields ChartOfAccounts, GLAccountGroup. It has 3 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
t077s t077s from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_GLAccountGroupText _GLAccountGroupText $projection.ChartOfAccounts = _GLAccountGroupText.ChartOfAccounts and $projection.GLAccountGroup = _GLAccountGroupText.GLAccountGroup
[1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
[0..*] I_ChartOfAccountsText _ChartOfAccountsText $projection.ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IGLACCTGRP view
EndUserText.label General Ledger Account Group view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey GLAccountGroup view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 1 view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts ktopl
KEY GLAccountGroup ktoks
_ChartOfAccountsText _ChartOfAccountsText
_GLAccountGroupText _GLAccountGroupText
_ChartOfAccounts _ChartOfAccounts 
@AbapCatalog.sqlViewName: 'IGLACCTGRP'
@EndUserText.label: 'General Ledger Account Group'
@Analytics: {
  dataCategory: #DIMENSION
  //dataExtraction.enabled: true

}
@Metadata.allowExtensions:true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'GLAccountGroup'
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #GENERIC
@AbapCatalog.buffering.numberOfKeyFields: 1
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass:  #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities:[#CDS_MODELING_DATA_SOURCE]
@Search.searchable: true
define view I_GLAccountGroup
  as select from t077s
  association [0..*] to I_GLAccountGroupText  as _GLAccountGroupText  on  $projection.ChartOfAccounts = _GLAccountGroupText.ChartOfAccounts
                                                                      and $projection.GLAccountGroup  = _GLAccountGroupText.GLAccountGroup

  association [1]    to I_ChartOfAccounts     as _ChartOfAccounts     on  $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
  association [0..*] to I_ChartOfAccountsText as _ChartOfAccountsText on  $projection.ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts
{

      //--[ GENERATED:012:29JlHNUf7jY4ip0dSlCN8W

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_ChartOfAccountsStdVH',
                     element: 'ChartOfAccounts' }
        }]
      // ]--GENERATED

      @ObjectModel.text.association: '_ChartOfAccountsText'
      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
      @Search.defaultSearchElement: true
  key ktopl as ChartOfAccounts,
      @ObjectModel.text.association: '_GLAccountGroupText'
      @Search.defaultSearchElement: true
  key ktoks as GLAccountGroup,
      _ChartOfAccountsText,
      _GLAccountGroupText,
      _ChartOfAccounts

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T077S"
],
"ASSOCIATED":
[
"I_CHARTOFACCOUNTS",
"I_CHARTOFACCOUNTSTEXT",
"I_GLACCOUNTGROUPTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More