P_DMVCECCostElement

DDL: P_DMVCECCOSTELEMENT Type: view_entity BASIC

P_DMVCECCostElement is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_CostElementOnChartOfAccounts, I_CostElementOnControllingArea) and exposes 7 fields with key fields ControllingArea, CostElement. It has 1 association to related views.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_CostElementOnChartOfAccounts I_CostElementOnChartOfAccounts inner
I_CostElementOnControllingArea I_CostElementOnControllingArea from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CostElementText _Text $projection.ChartOfAccounts = _Text.ChartOfAccounts and $projection.CostElement = _Text.CostElement

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey CostElement view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.private true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea I_CostElementOnControllingArea ControllingArea
KEY CostElement I_CostElementOnControllingArea CostElement
ValidityStartDate I_CostElementOnControllingArea ValidityStartDate
ValidityEndDate I_CostElementOnControllingArea ValidityEndDate
CostElementCategory I_CostElementOnControllingArea CostElementCategory
ChartOfAccounts I_CostElementOnChartOfAccounts ChartOfAccounts
_Text _Text 
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'CostElement'
@Metadata.ignorePropagatedAnnotations: true

@VDM.viewType: #BASIC
@VDM.private: true
define view entity P_DMVCECCostElement
  as select from I_CostElementOnControllingArea

    inner join   I_CostElementOnChartOfAccounts on  I_CostElementOnControllingArea.ChartOfAccounts = I_CostElementOnChartOfAccounts.ChartOfAccounts
                                                and I_CostElementOnControllingArea.CostElement     = I_CostElementOnChartOfAccounts.CostElement

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

{
  key I_CostElementOnControllingArea.ControllingArea,
  key I_CostElementOnControllingArea.CostElement,
      @Semantics.businessDate.from: true
      I_CostElementOnControllingArea.ValidityStartDate,
      @Semantics.businessDate.to: true
      I_CostElementOnControllingArea.ValidityEndDate,

      I_CostElementOnControllingArea.CostElementCategory,
      I_CostElementOnChartOfAccounts.ChartOfAccounts,

      _Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COSTELEMENTONCHARTOFACCOUNTS",
"I_COSTELEMENTONCONTROLLINGAREA"
],
"ASSOCIATED":
[
"I_COSTELEMENTTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More