I_CostOriginGroup

DDL: I_COSTORIGINGROUP SQL: IFICOSTORIGROUP Type: view BASIC

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.

1 data source(s) 6 fields

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 #CHECK 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 #M 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: #CHECK //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: #M
                           }
              } 

@Search.searchable: true

@Metadata.allowExtensions: true
@Metadata.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
}; 
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"TKKH1"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA",
"I_COSTORIGINGROUPTEXT",
"I_COSTORIGINTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More