I_CostOriginGroup

DDL: I_COSTORIGINGROUP SQL: IFICOSTORIGROUP Type: view BASIC Package: FINS_PCP_CUST_VDM

Cost Origin Group

I_CostOriginGroup is a Basic CDS View (Dimension) that provides data about "Cost Origin Group" in SAP S/4HANA. It reads from 1 data source (tkkh1) and exposes 6 fields with key fields ControllingArea, CostOriginType, CostOriginGroup. It has 3 associations to related views. Part of development package FINS_PCP_CUST_VDM.

Data Sources (1)

SourceAliasJoin Type
tkkh1 tkkh1 from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_CostOriginGroupText _Text $projection.ControllingArea = _Text.ControllingArea and $projection.CostOriginGroup = _Text.CostOriginGroup and $projection.CostOriginType = _Text.CostOriginType
[0..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea
[0..1] I_CostOriginType _CostOriginType $projection.CostOriginType = _CostOriginType.CostOriginType

Annotations (16)

NameValueLevelField
EndUserText.label Cost Origin Group view
AbapCatalog.sqlViewName IFICOSTORIGROUP view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey CostOriginGroup view
ObjectModel.sapObjectNodeType.name CostOriginGroup view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
Search.searchable true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea
KEY CostOriginType koaty
KEY CostOriginGroup hrkft
_Text _Text
_ControllingArea _ControllingArea
_CostOriginType _CostOriginType
@EndUserText.label: 'Cost Origin Group'
@AbapCatalog.sqlViewName: 'IFICOSTORIGROUP'
@VDM.viewType: #BASIC
@Analytics: { 
  dataCategory: #DIMENSION, 
  dataExtraction.enabled: true 
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
  representativeKey: 'CostOriginGroup',
  sapObjectNodeType.name: 'CostOriginGroup',
  supportedCapabilities: [ 
    #EXTRACTION_DATA_SOURCE, 
    #ANALYTICAL_DIMENSION, 
    #CDS_MODELING_ASSOCIATION_TARGET, 
    #SQL_DATA_SOURCE, 
    #CDS_MODELING_DATA_SOURCE 
  ],
  modelingPattern: #ANALYTICAL_DIMENSION,
  usageType: {
    dataClass: #CUSTOMIZING,
    serviceQuality: #A,
    sizeCategory: #S 
  }
}

@Search.searchable: true

@Metadata: { 
  allowExtensions: true,
  ignorePropagatedAnnotations: true 
}

define view I_CostOriginGroup
  as select from tkkh1

  association [0..*] to I_CostOriginGroupText as _Text            on  $projection.ControllingArea = _Text.ControllingArea
                                                                  and $projection.CostOriginGroup = _Text.CostOriginGroup
                                                                  and $projection.CostOriginType  = _Text.CostOriginType

  association [0..1] to I_ControllingArea     as _ControllingArea on  $projection.ControllingArea = _ControllingArea.ControllingArea

  association [0..1] to I_CostOriginType      as _CostOriginType  on  $projection.CostOriginType = _CostOriginType.CostOriginType


{
      @Search.defaultSearchElement: true
      @ObjectModel.foreignKey.association: '_ControllingArea'
  key cast( kokrs as fis_kokrs preserving type ) as ControllingArea,
      @Search.defaultSearchElement: true
      @ObjectModel.foreignKey.association: '_CostOriginType'
  key koaty                                      as CostOriginType,
      @Search.defaultSearchElement: true
      @ObjectModel.text.association: '_Text'
  key hrkft                                      as CostOriginGroup,

      _Text,
      _ControllingArea,
      _CostOriginType
};