C_ChartOfAccounts

DDL: C_CHARTOFACCOUNTS SQL: CCHARTOFACC Type: view CONSUMPTION Package: ODATA_MAINT_CHART_OF_ACCOUNTS

chart of accounts

C_ChartOfAccounts is a Consumption CDS View that provides data about "chart of accounts" in SAP S/4HANA. It reads from 1 data source (I_ChartOfAccounts) and exposes 5 fields with key field ChartOfAccounts. Part of development package ODATA_MAINT_CHART_OF_ACCOUNTS.

Data Sources (1)

SourceAliasJoin Type
I_ChartOfAccounts I_ChartOfAccounts from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CCHARTOFACC view
EndUserText.label chart of accounts view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey ChartOfAccounts view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts ChartOfAccounts
ChartOfAcctsIsBlocked ChartOfAcctsIsBlocked
CorporateGroupChartOfAccounts CorporateGroupChartOfAccounts
LanguageName
ChartOfAccountsName
@AbapCatalog.sqlViewName: 'CCHARTOFACC'
@EndUserText.label: 'chart of accounts'
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck:  #CHECK
@ObjectModel.representativeKey: 'ChartOfAccounts'

@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MASTER


define view C_ChartOfAccounts
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language : sylangu
  as select from I_ChartOfAccounts
{
  key ChartOfAccounts,
      ChartOfAcctsIsBlocked,
      CorporateGroupChartOfAccounts,
      _Language._Text[1: Language = $parameters.P_Language].LanguageName,
      _Text[1: Language = $parameters.P_Language].ChartOfAccountsName

}