I_CostElementOnChartOfAccounts

DDL: I_COSTELEMENTONCHARTOFACCOUNTS SQL: ICECHTACCTS Type: view BASIC

Cost Element depend on Chart of Accounts

I_CostElementOnChartOfAccounts is a Basic CDS View that provides data about "Cost Element depend on Chart of Accounts" in SAP S/4HANA. It reads from 1 data source (cska) and exposes 10 fields with key fields ChartOfAccounts, CostElement. It has 5 associations to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
cska cska from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
[0..1] I_FunctionalArea _FunctionalArea $projection.FunctionalArea = _FunctionalArea.FunctionalArea
[0..*] I_CostElementText _Text $projection.ChartOfAccounts = _Text.ChartOfAccounts and $projection.CostElement = _Text.CostElement
[0..*] I_CostElementOnControllingArea _CostElementOnControllingArea $projection.ChartOfAccounts = _CostElementOnControllingArea.ChartOfAccounts and $projection.CostElement = _CostElementOnControllingArea.CostElement
[0..1] I_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and $projection.CostElement = _GLAccountInChartOfAccounts.GLAccount

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName ICECHTACCTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Cost Element depend on Chart of Accounts view
ObjectModel.representativeKey CostElement view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts ktopl
KEY CostElement kstar
CreationDate ersda
CreatedByUser usnam
FunctionalArea func_area
_ChartOfAccounts _ChartOfAccounts
_FunctionalArea _FunctionalArea
_CostElementOnControllingArea _CostElementOnControllingArea
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_Text _Text 
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'ICECHTACCTS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Cost Element depend on Chart of Accounts'
@ObjectModel.representativeKey: 'CostElement'
@ObjectModel.usageType: {
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #MASTER
}
define view I_CostElementOnChartOfAccounts
  as select from cska

  association [0..1] to I_ChartOfAccounts              as _ChartOfAccounts              on  $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts

  association [0..1] to I_FunctionalArea               as _FunctionalArea               on  $projection.FunctionalArea = _FunctionalArea.FunctionalArea

  association [0..*] to I_CostElementText              as _Text                         on  $projection.ChartOfAccounts = _Text.ChartOfAccounts
                                                                                        and $projection.CostElement     = _Text.CostElement

  association [0..*] to I_CostElementOnControllingArea as _CostElementOnControllingArea on  $projection.ChartOfAccounts = _CostElementOnControllingArea.ChartOfAccounts
                                                                                        and $projection.CostElement     = _CostElementOnControllingArea.CostElement

  association [0..1] to I_GLAccountInChartOfAccounts   as _GLAccountInChartOfAccounts   on  $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts
                                                                                        and $projection.CostElement     = _GLAccountInChartOfAccounts.GLAccount

{
      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
  key ktopl     as ChartOfAccounts,
      @ObjectModel.text.association: '_Text'
  key kstar     as CostElement,

      @Semantics.systemDate.createdAt: true
      ersda     as CreationDate,
      @Semantics.user.createdBy: true
      usnam     as CreatedByUser,

      @ObjectModel.foreignKey.association: '_FunctionalArea'
      func_area as FunctionalArea,

      _ChartOfAccounts,
      _FunctionalArea,
      _CostElementOnControllingArea,
      _GLAccountInChartOfAccounts,
      _Text
}             
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"CSKA"
],
"ASSOCIATED":
[
"I_CHARTOFACCOUNTS",
"I_COSTELEMENTONCONTROLLINGAREA",
"I_COSTELEMENTTEXT",
"I_FUNCTIONALAREA",
"I_GLACCOUNTINCHARTOFACCOUNTS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More