What is I_ActualCostingActivityResult in SAP S/4HANA?

I_ActualCostingActivityResult is a composite CDS view in SAP S/4HANA. Actual Costing Run Result Activity Data It contains 33 fields.

Which tables does I_ActualCostingActivityResult read from?

I_ActualCostingActivityResult reads data from: P_ActualCostingActyRsltWithTxt.

What VDM layer is I_ActualCostingActivityResult?

I_ActualCostingActivityResult is classified as a Composite view that combines data from multiple basic views.

I_ActualCostingActivityResult

DDL: I_ACTUALCOSTINGACTIVITYRESULT Type: view_entity COMPOSITE Package: FCML4H_DISPLAY

33 Fields 1 Data Sources 4 Associations

Actual Costing Run Result Activity Data

I_ActualCostingActivityResult (Composite)

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

MaterialValuation · Accounting and Financial Close

I_ActualCostingActivityResult is a Composite CDS View (Fact) that provides data about "Actual Costing Run Result Activity Data" in SAP S/4HANA. It reads from 1 data source (P_ActualCostingActyRsltWithTxt) and exposes 33 fields with key fields CostEstimate, CurrencyRole, Ledger, MaterialLedgerCategory, ProcessCategory. It has 4 associations to related views. Part of development package FCML4H_DISPLAY.

SAP Help Documentation

Category	CDS Views for Inventory Accounting

Purpose
This CDS view displays actual costing run results for the activities within a selected costing run, year, and period. The activities are grouped on CostEstimate/ CurrencyRole/ Ledger/ MaterialLedgerCategory/ ProcessCategory/ ProductionProcess level. This CDS view displays data in the app Activity Consumption Analysis (CKM3A). This CDS view provides the data to answer the following business questions: What were the transaction amounts and valuation quantities grouped on MaterialLedgerCategory/Process CategoryProcurementAlternative/ProductionProcess level within the selected costing run, year, and period? Note When using this CDS view, please note that: It only returns activities with at least a Selection Completed status. Signs are reversed in columns (TotalVltdStockQuantity, InventoryAmtInDspCrcy, InvtryTransacAmtInDisplayCrcy, PriceDiffAmtInDisplayCrcy, ExchRateDiffAmtInDspCurrency) of Consumption records (MaterialLedgerCategory = VN). 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 must have a role with the following restriction types set to read access: BUKRS_GLRLDNR_GLRRCTY_GLRVERS (Company Code/Ledger/Record Type/Version) BWKEY (Valuation Area) KOSTL (Cost Center) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included. Users who want to use this CDS view must have the following authorization objects assigned: The CDS View is included in the business catalog SAP_A4C_BC_DEV_TST_FIN_IA0_PC.

Structure
Parameters The parameters of the CDS view are as follows: P_CostingRunType P_FiscalPeriod P_FiscalYear This parameter are used to define the actual costing run. Example The main filters are as follows: P_CostingRunType = 10100L09 (corresponds to the Costing Run field in the Edit Actual Costing Runs app) Important Fields Important fields in this view include the following: Field Attribute Field Name Description Key CostEstimate Cost Estimate Number Key CurrencyRole Currency/Valuation Key Ledger Ledger Key MaterialLedgerCategory Material Ledger Category Key ProcessCategory Process Category Key MatlLdgrDocIsCostingRelevant Material Ledger Document Is Costing Relevant Key ProductionProcess Production Process Key Material Material Key SalesOrder SD Document Key SalesOrderItem Item (SD) Key WBSElementExternalID WBS Element Key OrderID Order ID Key GLAccount General Ledger Account Attribute FiscalPeriod Fiscal Period Attribute FiscalYear Fiscal Year Attribute ValuationArea Valuation Area Attribute CostCenter Cost Center Attribute ActivityType Activity Type Attribute CompanyCode Company Code Attribute ControllingArea Controlling Area Attribute ControllingValuationType Valuation View Text MaterialLedgerCategoryText Material Ledger Category Text Text ProcessCategoryName Process Category Text Value TotalVltdStockQuantity Quantity Unit ValuationQuantityUnit Quantity Unit Value InventoryAmtInDspCrcy Actual Value Value InvtryTransacAmtInDisplayCrcy Preliminary Value Value PriceDiffAmtInDisplayCrcy Price Difference Value ExchRateDiffAmtInDspCurrency Exch.Rate Diff. Unit Currency Currency

View on SAP Help Portal →

SAP API Hub

Category	Composite
State	C1
Line of Business	Accounting and Financial Close
Application Component	CO-PC-ACT-2CL
Capabilities	Data Source for Data Extraction,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Accounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view displays actual costing run results for the activities within a selected costing run, year, and period. The activities are grouped on CostEstimate/ CurrencyRole/ Ledger/ MaterialLedgerCategory/ ProcessCategory/ ProductionProcess level. </p> <p>This CDS view displays data in the app Activity Consumption Analysis (CKM3A).</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What were the transaction amounts and valuation quantities grouped on MaterialLedgerCategory/Process CategoryProcurementAlternative/ProductionProcess level within the selected costing run, year, and period?</p></li> </ul> <p>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.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
P_ActualCostingActyRsltWithTxt	P_ActualCostingActyRsltWithTxt	from

Parameters (3)

Name	Type	Default
P_CostingRunType	ckml_run_type
P_FiscalPeriod	fins_fiscalperiod
P_FiscalYear	fis_gjahr_no_conv

Associations (4)

Cardinality	Target	Alias	Condition
[1..1]	I_Product	_Product	`$projection.Material = _Product.Product`
[1..1]	I_Ledger	_Ledger	`$projection.Ledger = _Ledger.Ledger`
[1..1]	I_Currency	_Currency	`$projection.Currency = _Currency.Currency`
[1..1]	I_UnitOfMeasure	_QuantityUnit	`$projection.ValuationQuantityUnit = _QuantityUnit.UnitOfMeasure`

Annotations (14)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
ObjectModel.sapObjectNodeType.name	MaterialValuation	view
Analytics.dataExtraction.enabled	true	view
Analytics.dataCategory	#FACT	view
Analytics.technicalName	IACTActivityResult	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	Actual Costing Run Result Activity Data	view

Fields (33)

Key	Field	Source Field	Description
KEY	CostEstimate	CostEstimate	Cost Estimate Number for Cost Est. w/o Qty Structure
KEY	CurrencyRole	CurrencyRole	External Currency Type and Valuation View
KEY	Ledger	Ledger	Ledger in General Ledger Accounting
KEY	MaterialLedgerCategory	MaterialLedgerCategory	Material Ledger Category
KEY	ProcessCategory	ProcessCategory	Process Category
KEY	MatlLdgrDocIsCostingRelevant	MatlLdgrDocIsCostingRelevant	Costing Document
KEY	ProductionProcess	ProductionProcess	Production Process
KEY	Material	Material	Material Number
KEY	SalesOrder	SalesOrder	SD Document
KEY	SalesOrderItem	SalesOrderItem	Sales Order Item
KEY	WBSElementExternalID	WBSElementExternalID	Work Breakdown Structure Element (WBS Element) Edited
KEY	OrderID	OrderID	Order Number
KEY	GLAccount	GLAccount	General Ledger
	FiscalPeriod		Fiscal Period
	FiscalYear		Fiscal Year
	ValuationArea	ValuationArea	Valuation Area
	CostCenter	CostCenter	Cost Center
	ActivityType	ActivityType	Activity Type
	TotalVltdStockQuantity	TotalVltdStockQuantity	Transaction Quantity in Valuation Quantity Unit of Mesure
	ValuationQuantityUnit	ValuationQuantityUnit	Quantity Unit for Valuation
	InventoryAmtInDspCrcy	InventoryAmtInDspCrcy	Actual Value
	InvtryTransacAmtInDisplayCrcy	InvtryTransacAmtInDisplayCrcy	Preliminary Value
	PriceDiffAmtInDisplayCrcy	PriceDiffAmtInDisplayCrcy	Price Difference
	Currency	Currency	Valuation Crcy
	MaterialLedgerCategoryText	MaterialLedgerCategoryText	Material Ledger Category Text
	ProcessCategoryName	ProcessCategoryName	Process Category Text
	CompanyCode	CompanyCode	Receiver Company Code
	ControllingArea	ControllingArea	Controlling Area
	ControllingValuationType	ControllingValuationType	Valuation View (for Transfer Prices)
	_Product	_Product
	_Ledger	_Ledger
	_Currency	_Currency
	_QuantityUnit	_QuantityUnit

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_ActualCostingActivityResult.
-- 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.
-- Parameters: P_CostingRunType : ckml_run_type, P_FiscalPeriod : fins_fiscalperiod, P_FiscalYear : fis_gjahr_no_conv

CREATE VIEW I_ActualCostingActivityResult AS
SELECT
  CostEstimate,
  CurrencyRole,
  Ledger,
  MaterialLedgerCategory,
  ProcessCategory,
  MatlLdgrDocIsCostingRelevant,
  ProductionProcess,
  Material,
  SalesOrder,
  SalesOrderItem,
  WBSElementExternalID,
  OrderID,
  GLAccount,
  $parameters.P_FiscalPeriod AS FiscalPeriod,
  $parameters.P_FiscalYear AS FiscalYear,
  ValuationArea,
  CostCenter,
  ActivityType,
  TotalVltdStockQuantity,
  ValuationQuantityUnit,
  InventoryAmtInDspCrcy,
  InvtryTransacAmtInDisplayCrcy,
  PriceDiffAmtInDisplayCrcy,
  Currency,
  MaterialLedgerCategoryText,
  ProcessCategoryName,
  CompanyCode,
  ControllingArea,
  ControllingValuationType
FROM P_ActualCostingActyRsltWithTxt
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnit ON ValuationQuantityUnit = _QuantityUnit.UnitOfMeasure  -- association [1..1]
;

Depth:

I_ActualCostingActivityResult view_entity

P_ActualCostingActyRsltWithTxt view_entity