I_ChartOfAccounts

DDL: I_CHARTOFACCOUNTS SQL: IFICHOFACC Type: view BASIC

Chart Of Accounts

I_ChartOfAccounts is a Basic CDS View (Dimension) that provides data about "Chart Of Accounts" in SAP S/4HANA. It reads from 1 data source (t004) and exposes 8 fields with key field ChartOfAccounts. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
t004 t004 from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_ChartOfAccountsText _CorpGroupChartOfAccountsText $projection.CorporateGroupChartOfAccounts = _CorpGroupChartOfAccountsText.ChartOfAccounts
[0..*] I_ChartOfAccountsText _Text $projection.ChartOfAccounts = _Text.ChartOfAccounts
[0..1] I_Language _Language $projection.MaintenanceLanguage = _Language.Language
[0..1] I_ChartOfAccounts _CorpGroupChartOfAccounts $projection.CorporateGroupChartOfAccounts = _CorpGroupChartOfAccounts.ChartOfAccounts

Annotations (19)

NameValueLevelField
EndUserText.label Chart Of Accounts view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Metadata.allowExtensions true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFICHOFACC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey ChartOfAccounts view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 1 view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts
CorporateGroupChartOfAccounts kktpl
ChartOfAcctsIsBlocked xsper
MaintenanceLanguage dspra
_Language _Language
_Text _Text
_CorpGroupChartOfAccounts _CorpGroupChartOfAccounts
_CorpGroupChartOfAccountsText _CorpGroupChartOfAccountsText
@EndUserText.label: 'Chart Of Accounts'
@Analytics:{
    dataCategory: #DIMENSION,
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture: {
        automatic: true
        }
    }
}
@Metadata.allowExtensions:true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IFICHOFACC'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'ChartOfAccounts'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  dataClass: #CUSTOMIZING,
  serviceQuality: #A,
  sizeCategory: #S
}
@AbapCatalog.buffering:{
  status: #ACTIVE,
  type: #GENERIC,
  numberOfKeyFields: 1
}
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
//--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

@AccessControl.privilegedAssociations: ['_CorpGroupChartOfAccountsText']
// ]--GENERATED

@ObjectModel.supportedCapabilities:[#CDS_MODELING_DATA_SOURCE,#EXTRACTION_DATA_SOURCE]
define view I_ChartOfAccounts as select from t004


  //--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

  association [0..*] to I_ChartOfAccountsText      as _CorpGroupChartOfAccountsText on   $projection.CorporateGroupChartOfAccounts = _CorpGroupChartOfAccountsText.ChartOfAccounts
  // ]--GENERATED

  association [0..*] to I_ChartOfAccountsText as _Text       on $projection.ChartOfAccounts = _Text.ChartOfAccounts
association [0..1] to I_Language            as _Language   on  $projection.MaintenanceLanguage = _Language.Language
association [0..1] to I_ChartOfAccounts     as _CorpGroupChartOfAccounts
  on $projection.CorporateGroupChartOfAccounts = _CorpGroupChartOfAccounts.ChartOfAccounts
{
  @ObjectModel.text.association: '_Text'
  key cast( ktopl as fis_ktopl preserving type) as ChartOfAccounts,
      //--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

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

  @ObjectModel.foreignKey.association: '_CorpGroupChartOfAccounts'
  kktpl as CorporateGroupChartOfAccounts,
  xsper as ChartOfAcctsIsBlocked,

  @ObjectModel.foreignKey.association: '_Language'  
  dspra as MaintenanceLanguage,

  _Language,
  _Text,
  _CorpGroupChartOfAccounts,
      //--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

      @Consumption.hidden: true
      _CorpGroupChartOfAccountsText
      // ]--GENERATED


};            
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T004"
],
"ASSOCIATED":
[
"I_CHARTOFACCOUNTSTEXT",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/