I_GLAccountGroupText

DDL: I_GLACCOUNTGROUPTEXT SQL: IGLACCTGRPTXT Type: view BASIC Package: FINS_GL_ACCOUNT_GROUP_VDM

G/L Account Group - Text

I_GLAccountGroupText is a Basic CDS View that provides data about "G/L Account Group - Text" in SAP S/4HANA. It reads from 1 data source (t077z) and exposes 6 fields with key fields ChartOfAccounts, GLAccountGroup, Language. It has 2 associations to related views. Part of development package FINS_GL_ACCOUNT_GROUP_VDM.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
t077z t077z from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IGLACCTGRPTXT view
EndUserText.label G/L Account Group - Text view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT 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

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts ktopl
KEY GLAccountGroup ktoks
KEY Language spras
AccountGroupName txt30
_Language _Language
_ChartOfAccounts _ChartOfAccounts 
@AbapCatalog.sqlViewName: 'IGLACCTGRPTXT'
@EndUserText.label: 'G/L Account Group - Text'
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #TEXT
@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,#LANGUAGE_DEPENDENT_TEXT]
define view I_GLAccountGroupText
  as select from t077z
  association [0..1] to I_Language        as _Language        on $projection.Language = _Language.Language
  association [0..1] to I_ChartOfAccounts as _ChartOfAccounts on $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
{
      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
  key ktopl as ChartOfAccounts,
  key ktoks as GLAccountGroup,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language
  key spras as Language,
      @Semantics.text: true
      txt30 as AccountGroupName,
      _Language,
      _ChartOfAccounts
}

Learn More