I_CostOriginGroup

DDL: I_COSTORIGINGROUP SQL: IFICOSTORIGROUP Type: view BASIC

Cost Origin Group

I_CostOriginGroup (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cost Origin Group · Accounting and Financial Close

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.

SAP Help Documentation

CategoryCDS Views for Inventory Accounting
Data CategoryDimension
Purpose
This CDS view provides information about settings for cost origin groups in Product Cost Planning. This CDS view provides the data to answer the following business questions: Which cost origin groups are available in the system? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view don't need any special authorization.

Structure
Important Fields Important fields in this view include the following: Field Name Description ControllingArea Controlling area CostOriginType Origin type CostOriginGroup Origin group as subdivision of cost element

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentCO-PC-PCP
CapabilitiesAnalytical Dimension, Data Source for Data Extraction, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

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 Controlling Area
KEY CostOriginType koaty Origin type
KEY CostOriginGroup hrkft Origin Group as Subdivision of Cost Element
_Text _Text
_ControllingArea _ControllingArea
_CostOriginType _CostOriginType

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CostOriginGroup.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IFICOSTORIGROUP

CREATE VIEW I_CostOriginGroup AS
SELECT
  cast( kokrs as fis_kokrs preserving type ) AS ControllingArea,
  koaty AS CostOriginType,
  hrkft AS CostOriginGroup
FROM tkkh1
LEFT OUTER JOIN I_CostOriginGroupText AS _Text ON ControllingArea = _Text.ControllingArea AND CostOriginGroup = _Text.CostOriginGroup AND CostOriginType = _Text.CostOriginType  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostOriginType AS _CostOriginType ON CostOriginType = _CostOriginType.CostOriginType  -- association [0..1]
;