Which tables does I_CostElementOnControllingArea use?

I_CostElementOnControllingArea reads from 1 data source(s): cskb.

How many fields does I_CostElementOnControllingArea have?

I_CostElementOnControllingArea has 14 fields. Key fields: ControllingArea, CostElement, ValidityEndDate.

I_CostElementOnControllingArea

DDL: I_COSTELEMENTONCONTROLLINGAREA SQL: ICECA Type: view BASIC Package: FINS_FIS_FICO

Cost element depend on controlling area

I_CostElementOnControllingArea is a Basic CDS View that provides data about "Cost element depend on controlling area" in SAP S/4HANA. It reads from 1 data source (cskb) and exposes 14 fields with key fields ControllingArea, CostElement, ValidityEndDate. It has 5 associations to related views. Part of development package FINS_FIS_FICO.

Data Sources (1)

Source	Alias	Join Type
cskb	cskb	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..1]	I_ControllingArea	_ControllingAreaText	`$projection.ControllingArea = _ControllingAreaText.ControllingArea`
[0..1]	I_ControllingArea	_ControllingArea	`$projection.ControllingArea = _ControllingArea.ControllingArea`
[0..1]	I_UnitOfMeasure	_UnitOfMeasure	`$projection.UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure`
[0..1]	I_CostElementOnChartOfAccounts	_CostElementOnChartOfAccounts	`$projection.ChartOfAccounts = _CostElementOnChartOfAccounts.ChartOfAccounts and $projection.CostElement = _CostElementOnChartOfAccounts.CostElement`
[0..1]	I_CostElementCategory	_CostElementCategory	`$projection.CostElementCategory = _CostElementCategory.CostElementCategory`

Annotations (12)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#BASIC	view
AbapCatalog.sqlViewName	ICECA	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Cost element depend on controlling area	view
ObjectModel.entityChangeStateId	LastChangeDateTime	view
ObjectModel.representativeKey	CostElement	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (14)

Key	Field	Source Table	Source Field
KEY	ControllingArea	cskb	kokrs
KEY	CostElement	cskb	kstar
KEY	ValidityEndDate	cskb	datbi
	ValidityStartDate	cskb	datab
	CostElementCategory	cskb	katyp
	ConsumptionQtyIsRecorded	cskb	mgefl
	UnitOfMeasure	cskb	msehi
	ChartOfAccounts	tka01	ktopl
	LastChangeDateTime	cskb	last_changed_ts
	_ControllingArea		_ControllingArea
	_CostElementOnChartOfAccounts		_CostElementOnChartOfAccounts
	_CostElementCategory		_CostElementCategory
	_UnitOfMeasure		_UnitOfMeasure
	_ControllingAreaText		_ControllingAreaText

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'ICECA'
@AbapCatalog.compiler.compareFilter: true
//@AccessControl.authorizationCheck: #NOT_REQUIRED

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Cost element depend on controlling area'
@ObjectModel.entityChangeStateId: 'LastChangeDateTime'
@ObjectModel.representativeKey: 'CostElement'
@ObjectModel.usageType: {
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #MIXED
}
//--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

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


define view I_CostElementOnControllingArea
  as select from           cskb
    left outer to one join tka01 on cskb.kokrs = tka01.kokrs
  
  //--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

  association [0..1] to I_ControllingArea      as _ControllingAreaText on   $projection.ControllingArea = _ControllingAreaText.ControllingArea
  // ]--GENERATED

  association [0..1] to I_ControllingArea              as _ControllingArea              on  $projection.ControllingArea = _ControllingArea.ControllingArea
  association [0..1] to I_UnitOfMeasure                as _UnitOfMeasure                on  $projection.UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure
  association [0..1] to I_CostElementOnChartOfAccounts as _CostElementOnChartOfAccounts on  $projection.ChartOfAccounts = _CostElementOnChartOfAccounts.ChartOfAccounts
                                                                                        and $projection.CostElement     = _CostElementOnChartOfAccounts.CostElement
  association [0..1] to I_CostElementCategory          as _CostElementCategory          on  $projection.CostElementCategory = _CostElementCategory.CostElementCategory
{
      //--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_ControllingAreaStdVH',
                     element: 'ControllingArea' }
        }]
      @ObjectModel.text.association: '_ControllingAreaText'
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_ControllingArea'
  key cskb.kokrs           as ControllingArea,
  key cskb.kstar           as CostElement,
      @Semantics.businessDate.to: true
  key cskb.datbi           as ValidityEndDate,
      @Semantics.businessDate.from: true
      cskb.datab           as ValidityStartDate,
      @ObjectModel.foreignKey.association: '_CostElementCategory'
      cskb.katyp           as CostElementCategory,
      cskb.mgefl           as ConsumptionQtyIsRecorded,
      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      cskb.msehi           as UnitOfMeasure,
      tka01.ktopl          as ChartOfAccounts,
      cskb.last_changed_ts as LastChangeDateTime,
      _ControllingArea,
      _CostElementOnChartOfAccounts,
      _CostElementCategory,
      _UnitOfMeasure,
      //--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

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


}

Depth:

I_CostElementOnControllingArea view

cskb