What is I_ProductCostEstimateDEX in SAP S/4HANA?

I_ProductCostEstimateDEX is a basic CDS view in SAP S/4HANA. Product Cost Estimate Extraction It contains 75 fields.

Which tables does I_ProductCostEstimateDEX read from?

I_ProductCostEstimateDEX reads data from: P_KEKO.

What VDM layer is I_ProductCostEstimateDEX?

I_ProductCostEstimateDEX is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_ProductCostEstimateDEX

DDL: I_PRODUCTCOSTESTIMATEDEX SQL: IPRODCESTDEX Type: view BASIC Package: FINS_PCP_COSTEST

75 Fields 1 Data Sources 5 Associations

Product Cost Estimate Extraction

I_ProductCostEstimateDEX (Basic)

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

Product Cost Estimate · Accounting and Financial Close

I_ProductCostEstimateDEX is a Basic CDS View (Fact) that provides data about "Product Cost Estimate Extraction" in SAP S/4HANA. It reads from 1 data source (P_KEKO) and exposes 75 fields with key fields CostingReferenceObject, CostEstimate, CostingType, CostingVersion, ValuationVariant. It has 5 associations to related views. Part of development package FINS_PCP_COSTEST.

SAP Help Documentation

Category	CDS Views for Inventory Accounting
Data Category	FACT

Purpose
This CDS view provides the header information of cost estimates for materials, sales document items and other planning objects, containing the relevant dates, lot size, unit of measure and further costing-related information. 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 The user must have the authorization to access the costing variants.

SAP Business Warehouse (SAP BW) Extraction
Data extraction type Full (physical deletions are possible in source tables) Delta (change data capture)

View on SAP Help Portal →

SAP API Hub

Category	Basic
State	C1
Line of Business	Accounting and Financial Close
Application Component	CO-PC-PCP-2CL
Capabilities	Data Source for Data Extraction
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 provides the header information of cost estimates for materials, sales document items and other planning objects, containing the relevant dates, lot size, unit of measure and further costing-related information.</p> <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_KEKO	P_KEKO	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..1]	I_Currency	_GroupCurrency	`$projection.GroupCurrency = _GroupCurrency.Currency`
[1..1]	I_ValuationArea	_ValuationArea	`$projection.ValuationArea = _ValuationArea.ValuationArea`
[0..1]	I_UnitOfMeasure	_UnitOfMeasure	`$projection.ValuationQuantityUnit = _UnitOfMeasure.UnitOfMeasure`
[0..1]	I_Currency	_CompanyCodeCurrency	`$projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency`
[0..*]	I_ProductCostEstimateItemDEX	_ProductCostEstimateItem	$projection.CostingReferenceObject = _ProductCostEstimateItem.CostingReferenceObject and $projection.CostEstimate = _ProductCostEstimateItem.CostEstimate and $projection.CostingType = _ProductCostEstimateItem.CostingType and $projection.CostingDate = _ProductCostEstimateItem.CostingDate and $projection.CostingVersion = _ProductCostEstimateItem.CostingVersion and $projection.ValuationVariant = _ProductCostEstimateItem.ValuationVariant and $projection.CostIsEnteredManually = _ProductCostEstimateItem.CostIsEnteredManually

Annotations (16)

Name	Value	Level
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.sqlViewName	IPRODCESTDEX	view
AccessControl.authorizationCheck	#CHECK	view
Analytics.dataCategory	#FACT	view
Analytics.dataExtraction.enabled	true	view
Analytics.internalName	#LOCAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Product Cost Estimate Extraction	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.modelingPattern	#NONE	view
ObjectModel.sapObjectNodeType.name	ProductCostEstimate	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.viewType	#BASIC	view

Fields (75)

Key	Field	Source Table	Source Field	Description
KEY	CostingReferenceObject		CostingReferenceObject	Reference Object
KEY	CostEstimate		CostEstimate	Cost EstimateNo
KEY	CostingType		CostingType	Costing Type
KEY	CostingVersion		CostingVersion	Costing Version
KEY	ValuationVariant		ValuationVariant	Valuation Variant in Costing
KEY	CostIsEnteredManually		CostIsEnteredManually	Costs Entered Manually in Additive or Automatic Cost Est.
	Material		Product	Product Sold
	ValuationType		ValuationType	Valuation Type
	Plant		Plant	Valuation Area
	ValuationArea		ValuationArea	Valuation Area
	CompanyCode	_ValuationArea	CompanyCode	Receiver Company Code
	ControllingArea		ControllingArea	Controlling Area
	CostEstimateValidityStartDate		CostEstimateValidityStartDate	Costing Date From
	CostEstimateValidityEndDate		CostEstimateValidityEndDate	Costing Date To
	MaterialValuationDate		ValuationDate	Valuation Date of a Cost Estimate
	QuantityStructureDate		QuantityStructureDate	Quantity Structure Date for Costing
	ProductionVersion		ProductionVersion	Production Version
	BillOfMaterial		BillOfMaterial	Bill of Material
	ProductBOMUsage		ProductBOMUsage	BOM Usage
	AlternativeBillOfMaterial		AlternativeBillOfMaterial	Alternative BOM
	TaskListGroup		TaskListGroup	Key for Task List Group
	TaskListType		TaskListType	Task List Type
	TaskListGroupCounter		TaskListGroupCounter	Group Counter
	CostingItemIsProductComp		CostingItemIsProductComp	Material Component
	CostEstIsMarkedForDeletion		CostEstIsMarkedForDeletion	Deletion Indicator for Product Costing
	CostingLotSize		CostingLotSize	Lot Size for Product Costing
	ValuationQuantityUnit		ValuationQuantityUnit	Valuation Unit of Measure
	CostEstimateCreatedByUser		CostEstimateCreatedByUser	Created By
	CostEstimateCreationDate		CostEstimateCreationDate	Date on Which Cost Estimate Was Created
	CostEstimateStatus		CostEstimateStatus	Costing Status
	CostEstimateIsReleased		CostEstimateIsReleased	Release of Standard Cost Estimate
	CostEstimateReleasedByUser		CostEstimateReleasedByUser	User Who Released Cost Estimate in Material Master Record
	CostEstimateReleaseDate		CostEstimateReleaseDate	Date on Which Cost Estimate Released in Material Master
	CostEstimateMarkingDate		CostEstimateMarkingDate	Date on Which Cost Estimate Was Marked
	CostEstimateMarkingUser		CostEstimateMarkedByUser	User Who Marked Cost Estimate in Material Master
	CostEstimateMarkedByUser		CostEstimateMarkedByUser	User Who Marked Cost Estimate in Material Master
	CostingErrorMessageType		CostingErrorMessageType	Message Type
	CostEstIsMixedCosting		CostEstIsMixedCosting	Mixed Costing Indicator
	CostEstimateIsForProcmtAltv		CostEstimateIsForProcmtAltv	Cost Estimate for a Procurement Alternative
	ProcmtAltvCostEstimate		ProcmtAltvCostEstimate	Cost Estimate Number of Procurement Alternative
	ProcessCategory		ProcessCategory	Process Category
	CostgMixingRatioValue		CostgMixingRatioValue	Mixed Costing: Mixing Ratio
	ProcmtAltvValuationVariant		ProcmtAltvValuationVariant	Valuation Variant of Procurement Alternative
	SpecialProcurementType		SpecialProcurementType	Special Procurement Key for the Costing Object
	MaterialProcurementType		ProductProcurementType	Special procurement type
	SpecialProcurementPlant		SpecialProcurementPlant	Special Procurement Plant - Costing
	CostingSheet		CostingSheet	Costing Sheet for Calculating Overhead
	CostingOverheadType		CostingOverheadType	Overhead Type
	MaterialValnStrategy		ProductValuationStrategy	Valuation Strategy for Raw Materials and Purchased Parts
	MaterialValnPurgInfoRecdStrgy		ProductValnPurgInfoRecdStrgy	Substrategy for Material Valuat. with Purchasing Info Record
	CostingVariant		CostingVariant	Costing Variant
	Ledger		Ledger	Ledger in General Ledger Accounting
	CostingOverheadGroup		CostingOverheadGroup	Costing Overhead Group
	CostingOverhead		CostingOverhead	Overhead key
	PostingPeriod		PostingPeriod	Posting Period
	PostingFiscalYear		PostingFiscalYear	Posting Date YYYY
	CostingErrorLogID		CostingErrorLogID	Error Management Number
	CostEstimateTransferControl		CostEstimateTransferControl	Transfer Control
	LowLevelCode		LowLevelCode	Low-Level Code
	CostEstimateCostingLevel		CostEstimateCostingLevel	Costing Level
	CostComponentStructure		CostComponentStructure	Cost Component Structure - CGM and Sales/Administr. Costs
	AuxiliaryCostCompStructure		AuxiliaryCostCompStructure	Cost Component Structure for Auxiliary Cost Component Split
	BusinessArea		BusinessArea	Business Area
	ProfitCenter		ProfitCenter	Profit Center
	CompanyCodeCurrency		CompanyCodeCurrency	Company Code Currency
	GroupCurrency		ControllingAreaCurrency	Global Currency
	EstimatedCostCostingRun		EstimatedCostCostingRun	Name of Costing Run
	EstimatedCostCostingRunDate		EstimatedCostCostingRunDate	Costing Run Date
	ConfiguredProduct		ConfiguredProduct	Configured Material (Variant)
	IsMaterialCostedWithQtyStruc		ProductIsCostedWithQtyStruc	Material Is Costed with Quantity Structure
	_ValuationArea		_ValuationArea
	_GroupCurrency		_GroupCurrency
	_CompanyCodeCurrency		_CompanyCodeCurrency
	_UnitOfMeasure		_UnitOfMeasure
	_ProductCostEstimateItem		_ProductCostEstimateItem

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_ProductCostEstimateDEX.
-- 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: IPRODCESTDEX

CREATE VIEW I_ProductCostEstimateDEX AS
SELECT
  CostingReferenceObject,
  CostEstimate,
  CostingType,
  CostingVersion,
  ValuationVariant,
  CostIsEnteredManually,
  Product AS Material,
  ValuationType,
  Plant,
  ValuationArea,
  _ValuationArea.CompanyCode AS CompanyCode,
  ControllingArea,
  CostEstimateValidityStartDate,
  CostEstimateValidityEndDate,
  ValuationDate AS MaterialValuationDate,
  QuantityStructureDate,
  ProductionVersion,
  BillOfMaterial,
  ProductBOMUsage,
  AlternativeBillOfMaterial,
  TaskListGroup,
  TaskListType,
  TaskListGroupCounter,
  CostingItemIsProductComp,
  CostEstIsMarkedForDeletion,
  CostingLotSize,
  ValuationQuantityUnit,
  CostEstimateCreatedByUser,
  CostEstimateCreationDate,
  CostEstimateStatus,
  CostEstimateIsReleased,
  CostEstimateReleasedByUser,
  CostEstimateReleaseDate,
  CostEstimateMarkingDate,
  CostEstimateMarkedByUser AS CostEstimateMarkingUser,
  CostEstimateMarkedByUser,
  CostingErrorMessageType,
  CostEstIsMixedCosting,
  CostEstimateIsForProcmtAltv,
  ProcmtAltvCostEstimate,
  ProcessCategory,
  CostgMixingRatioValue,
  ProcmtAltvValuationVariant,
  SpecialProcurementType,
  ProductProcurementType AS MaterialProcurementType,
  SpecialProcurementPlant,
  CostingSheet,
  CostingOverheadType,
  ProductValuationStrategy AS MaterialValnStrategy,
  ProductValnPurgInfoRecdStrgy AS MaterialValnPurgInfoRecdStrgy,
  CostingVariant,
  Ledger,
  CostingOverheadGroup,
  CostingOverhead,
  PostingPeriod,
  PostingFiscalYear,
  CostingErrorLogID,
  CostEstimateTransferControl,
  LowLevelCode,
  CostEstimateCostingLevel,
  CostComponentStructure,
  AuxiliaryCostCompStructure,
  BusinessArea,
  ProfitCenter,
  CompanyCodeCurrency,
  ControllingAreaCurrency AS GroupCurrency,
  EstimatedCostCostingRun,
  EstimatedCostCostingRunDate,
  ConfiguredProduct,
  ProductIsCostedWithQtyStruc AS IsMaterialCostedWithQtyStruc
FROM P_KEKO
LEFT OUTER JOIN I_Currency AS _GroupCurrency ON GroupCurrency = _GroupCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ValuationArea AS _ValuationArea ON ValuationArea = _ValuationArea.ValuationArea  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON ValuationQuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ProductCostEstimateItemDEX AS _ProductCostEstimateItem ON CostingReferenceObject = _ProductCostEstimateItem.CostingReferenceObject AND CostEstimate = _ProductCostEstimateItem.CostEstimate AND CostingType = _ProductCostEstimateItem.CostingType AND CostingDate = _ProductCostEstimateItem.CostingDate AND CostingVersion = _ProductCostEstimateItem.CostingVersion AND ValuationVariant = _ProductCostEstimateItem.ValuationVariant AND CostIsEnteredManually = _ProductCostEstimateItem.CostIsEnteredManually  -- association [0..*]
;

Depth:

I_ProductCostEstimateDEX view

P_KEKO view_entity