C_GLAccountInchartOfAccount

DDL: C_GLACCOUNTINCHARTOFACCOUNT SQL: CGLACCINCOA Type: view CONSUMPTION

GL Accounts in Chart of Account

C_GLAccountInchartOfAccount is a Consumption CDS View that provides data about "GL Accounts in Chart of Account" in SAP S/4HANA. It reads from 1 data source (I_GLAcctWithGrpChartOfAccounts) and exposes 34 fields with key fields ChartOfAccounts, GLAccount. It has 1 association to related views.

1 data source(s) 34 fields

Data Sources (1)

SourceAliasJoin Type
I_GLAcctWithGrpChartOfAccounts _GLAccount from

Parameters (2)

NameTypeDefault
P_Language sylangu
P_ChartOfAccounts ktopl

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_GLAccountInChartOfAccounts _GroupGLAccountExternal $projection.CorporateGroupChartOfAccounts = _GroupGLAccountExternal.ChartOfAccounts and _GLAccount.CorporateGroupAccount = _GroupGLAccountExternal.GLAccount

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName CGLACCINCOA view
EndUserText.label GL Accounts in Chart of Account view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts ChartOfAccounts
KEY GLAccount GLAccount
GLAccountName
GLAccountLongName
GLAccountExternal GLAccountExternal
IsBalanceSheetAccount IsBalanceSheetAccount
CorporateGroupAccountExternal _GroupGLAccountExternal GLAccountExternal
CorporateGroupAccount CorporateGroupAccount
CorporateGroupAccountLongName
ProfitLossAccountType ProfitLossAccountType
SampleGLAccount SampleGLAccount
AccountIsMarkedForDeletion AccountIsMarkedForDeletion
AccountIsBlockedForCreation AccountIsBlockedForCreation
AccountIsBlockedForPosting AccountIsBlockedForPosting
AccountIsBlockedForPlanning AccountIsBlockedForPlanning
CorporateGroupChartOfAccounts CorporateGroupChartOfAccounts
PartnerCompany PartnerCompany
CompanyName _GlobalCompany CompanyName
FunctionalArea FunctionalArea
FunctionalAreaName
CreationDate
CreatedByUser CreatedByUser
GLAccountType GLAccountType
GLAccountTypeName
GLAccountGroup GLAccountGroup
AccountGroupName
RetainedEarningsGLAccount _RetainedEarningsGLAccount RetainedEarningsGLAccount
IsProfitLossAccount IsProfitLossAccount
GLAccountDetermination
CreatedByUserName _User UserDescription
GLAccountIsNotProdnRelevant GLAccountIsNotProdnRelevant
GLAcctCOAImplementStatus
GLAccountCOAIsDeliveredBySAP
_GroupGLAccountExternal _GroupGLAccountExternal 
@AbapCatalog.sqlViewName: 'CGLACCINCOA'
@EndUserText.label: 'GL Accounts in Chart of Account'
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED


define view C_GLAccountInchartOfAccount
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language        : sylangu,
    P_ChartOfAccounts : ktopl
  as select from    I_GLAcctWithGrpChartOfAccounts as _GLAccount
  association [0..1] to I_GLAccountInChartOfAccounts as _GroupGLAccountExternal on  $projection.CorporateGroupChartOfAccounts = _GroupGLAccountExternal.ChartOfAccounts
                                                                                and _GLAccount.CorporateGroupAccount          = _GroupGLAccountExternal.GLAccount
{
  key ChartOfAccounts,
  key GLAccount,
      _Text[1: Language = $parameters.P_Language].GLAccountName,
      _Text[1: Language = $parameters.P_Language].GLAccountLongName,
      GLAccountExternal,
      IsBalanceSheetAccount,
      _GroupGLAccountExternal.GLAccountExternal                                                                                                                           as CorporateGroupAccountExternal,
      CorporateGroupAccount,
      _CorporateGroupAccountText[1: Language = $parameters.P_Language].GLAccountLongName                                                                                  as CorporateGroupAccountLongName,
      ProfitLossAccountType,
      SampleGLAccount,
      AccountIsMarkedForDeletion,
      AccountIsBlockedForCreation,
      AccountIsBlockedForPosting,
      AccountIsBlockedForPlanning,
      CorporateGroupChartOfAccounts,
      PartnerCompany,
      _GlobalCompany.CompanyName,
      FunctionalArea,
      _FunctionalArea._Text[1: Language = $parameters.P_Language].FunctionalAreaName,
      cast ( CreationDate as abap.char(8) )                                                                                                                               as CreationDate,
      CreatedByUser,

      GLAccountType,
      _GLAccountType._GLAccountTypeText[1: Language = $parameters.P_Language].GLAccountTypeName,
      GLAccountGroup,
      _GLAccountGroup._GLAccountGroupText[1: Language = $parameters.P_Language].AccountGroupName,
      _RetainedEarningsGLAccount.RetainedEarningsGLAccount,
      IsProfitLossAccount,
      cast ( '' as abap.char(30))                                                                                                                                         as GLAccountDetermination,
      _User.UserDescription                                                                                                                                               as CreatedByUserName,
      GLAccountIsNotProdnRelevant,
      _GLAccount._GLAcctInChartOfAcctsStatus.GLAcctCOAImplementStatus, 
      _GLAccount._GLAcctInChartOfAcctsStatus.GLAccountCOAIsDeliveredBySAP,
      _GroupGLAccountExternal
}
where
  ChartOfAccounts = :P_ChartOfAccounts and
  ( GLAccountIsNotProdnRelevant <> 'X' or GLAccountIsNotProdnRelevant is null )

Learn More