What is R_ProductCostEstimateTP in SAP S/4HANA?

R_ProductCostEstimateTP is a transactional CDS view in SAP S/4HANA. Product Cost Estimate - TP It contains 77 fields.

Which tables does R_ProductCostEstimateTP read from?

R_ProductCostEstimateTP reads data from: I_ProductCostEstimate.

What VDM layer is R_ProductCostEstimateTP?

R_ProductCostEstimateTP is classified as a Transactional view that supports create, update, and delete operations.

R_ProductCostEstimateTP

DDL: R_PRODUCTCOSTESTIMATETP Type: view_entity TRANSACTIONAL Package: RAP_FIN_PCP_PRODCOSTEST

77 Fields 1 Data Sources 12 Associations

Product Cost Estimate - TP

R_ProductCostEstimateTP is a Transactional CDS View that provides data about "Product Cost Estimate - TP" in SAP S/4HANA. It reads from 1 data source (I_ProductCostEstimate) and exposes 77 fields with key fields CostingReferenceObject, CostEstimate, CostingType, CostingDate, CostingVersion. It has 12 associations to related views. Part of development package RAP_FIN_PCP_PRODCOSTEST.

Data Sources (1)

Source	Alias	Join Type
I_ProductCostEstimate	ProductCostEstimate	from

Associations (12)

Cardinality	Target	Alias	Condition
[1..1]	I_UserContactCard	_CreatedByContactCard	`$projection.CostEstimateCreatedByUser = _CreatedByContactCard.ContactCardID`
[1..1]	I_UserContactCard	_MarkedByContactCard	`$projection.CostEstimateMarkedByUser = _MarkedByContactCard.ContactCardID`
[1..1]	I_UserContactCard	_ReleasedByContactCard	`$projection.CostEstimateReleasedByUser = _ReleasedByContactCard.ContactCardID`
[1..1]	I_EstimatedCostCostingRunStdVH	_EstimatedCostCostingRunText	`$projection.EstimatedCostCostingRun = _EstimatedCostCostingRunText.EstimatedCostCostingRun and $projection.EstimatedCostCostingRunDate = _EstimatedCostCostingRunText.EstimatedCostCostingRunDate and $projection.CostingVersion = _EstimatedCostCostingRunText.CostingVersion`
[1..*]	I_CostingVersionText	_CostingVersionText	`$projection.CostingVersion = _CostingVersionText.CostingVersion and $projection.CostingType = _CostingVersionText.CostingType and $projection.ValuationVariant = _CostingVersionText.ValuationVariant`
[1..*]	I_CostingTypeText	_CostingTypeText	`$projection.CostingType = _CostingTypeText.CostingType`
[1..*]	I_CostingVariantText	_CostingVariantText	`$projection.CostingVariant = _CostingVariantText.CostingVariant`
[1..*]	I_ProductText	_ProductText	`$projection.Product = _ProductText.Product`
[0..1]	I_ProfitCenterText	_ProfitCenterText	`$projection.ProfitCenter = _ProfitCenterText.ProfitCenter and $projection.ControllingArea = _ProfitCenterText.ControllingArea and $projection.ValuationDate <= _ProfitCenterText.ValidityEndDate and $projection.ValuationDate >= _ProfitCenterText.ValidityStartDate and _ProfitCenterText.Language = $session.system_language`
[0..*]	I_CostEstimateStatusText	_CostEstimateStatusText	`$projection.CostEstimateStatus = _CostEstimateStatusText.CostEstimateStatus`
[1..*]	I_CostingValuationVarText	_ValuationVariantText	`$projection.ValuationVariant = _ValuationVariantText.ValuationVariant`
[0..*]	R_ProductCostEstimateItemTP	_Item

Annotations (9)

Name	Value	Level
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
VDM.viewType	#TRANSACTIONAL	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.sapObjectNodeType.name	ProductCostEstimate	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	Product Cost Estimate - TP	view

Fields (77)

Key	Field	Source Table	Source Field	Description
KEY	CostingReferenceObject	I_ProductCostEstimate	CostingReferenceObject
KEY	CostEstimate	I_ProductCostEstimate	CostEstimate	Cost EstimateNo
KEY	CostingType	I_ProductCostEstimate	CostingType
KEY	CostingDate	I_ProductCostEstimate	CostingDate
KEY	CostingVersion	I_ProductCostEstimate	CostingVersion
KEY	ValuationVariant	I_ProductCostEstimate	ValuationVariant
KEY	CostIsEnteredManually	I_ProductCostEstimate	CostIsEnteredManually
	Product	I_ProductCostEstimate	Product	Product Sold
	Plant	I_ProductCostEstimate	Plant	Valuation Area
	ValuationArea	I_ProductCostEstimate	ValuationArea	Valuation Area
	ValuationType	I_ProductCostEstimate	ValuationType	Valuation Type
	ControllingArea	I_ProductCostEstimate	ControllingArea	Controlling Area
	CompanyCode	I_ProductCostEstimate	CompanyCode	Receiver Company Code
	CostEstimateValidityStartDate	I_ProductCostEstimate	CostEstimateValidityStartDate
	CostEstimateValidityEndDate	I_ProductCostEstimate	CostEstimateValidityEndDate
	ValuationDate	I_ProductCostEstimate	ValuationDate	Valuation Date
	QuantityStructureDate	I_ProductCostEstimate	QuantityStructureDate
	ProductionVersion	I_ProductCostEstimate	ProductionVersion	Version ID
	BillOfMaterial	I_ProductCostEstimate	BillOfMaterial	BOM
	ProductBOMUsage	I_ProductCostEstimate	ProductBOMUsage
	AlternativeBillOfMaterial	I_ProductCostEstimate	AlternativeBillOfMaterial
	TaskListGroup	I_ProductCostEstimate	TaskListGroup	Group
	TaskListType	I_ProductCostEstimate	TaskListType	Task List Type
	TaskListGroupCounter	I_ProductCostEstimate	TaskListGroupCounter	Group Counter
	CostingLotSize	I_ProductCostEstimate	CostingLotSize
	ValuationQuantityUnit	I_ProductCostEstimate	ValuationQuantityUnit
	CostEstimateCreatedByUser	I_ProductCostEstimate	CostEstimateCreatedByUser
	CostEstimateCreationDate	I_ProductCostEstimate	CostEstimateCreationDate
	CostEstimateStatus	I_ProductCostEstimate	CostEstimateStatus
	CostEstimateIsReleased	I_ProductCostEstimate	CostEstimateIsReleased
	CostingSheet	I_ProductCostEstimate	CostingSheet	Costing Sheet
	CostingOverheadType	I_ProductCostEstimate	CostingOverheadType
	ProductValuationStrategy	I_ProductCostEstimate	ProductValuationStrategy
	ProductValnPurgInfoRecdStrgy	I_ProductCostEstimate	ProductValnPurgInfoRecdStrgy
	CostingVariant	I_ProductCostEstimate	CostingVariant
	Ledger	I_ProductCostEstimate	Ledger	Ledger
	CostingOverheadGroup	I_ProductCostEstimate	CostingOverheadGroup
	CostingOverhead	I_ProductCostEstimate	CostingOverhead
	CostEstimateMarkingUser	I_ProductCostEstimate	CostEstimateMarkedByUser
	CostEstimateMarkedByUser	I_ProductCostEstimate	CostEstimateMarkedByUser
	CostEstimateMarkingDate	I_ProductCostEstimate	CostEstimateMarkingDate
	CostEstimateReleaseUser	I_ProductCostEstimate	CostEstimateReleasedByUser
	CostEstimateReleasedByUser	I_ProductCostEstimate	CostEstimateReleasedByUser
	CostEstimateReleaseDate	I_ProductCostEstimate	CostEstimateReleaseDate
	CostEstimateTransferControl	I_ProductCostEstimate	CostEstimateTransferControl
	CostComponentStructure	I_ProductCostEstimate	CostComponentStructure
	ProfitCenter	I_ProductCostEstimate	ProfitCenter	Profit Center
	CompanyCodeCurrency	I_ProductCostEstimate	CompanyCodeCurrency	Local Currency
	ControllingAreaCurrency	I_ProductCostEstimate	ControllingAreaCurrency
	ExchangeRateType	I_ProductCostEstimate	ExchangeRateType	Exch. Rate Type
	ComponentBreakdown	I_ProductCostEstimate	ComponentBreakdown
	EstimatedCostCostingRun	I_ProductCostEstimate	EstimatedCostCostingRun
	EstimatedCostCostingRunDate	I_ProductCostEstimate	EstimatedCostCostingRunDate
	TotalCostInCompanyCodeCurrency	TotalCostPerView	TotalCostInCompanyCodeCurrency
	FixedCostInCompanyCodeCurrency	TotalCostPerView	FixedCostInCompanyCodeCurrency
	TotalCostInCtrlgAreaCurrency	TotalCostPerView	TotalCostInCtrlgAreaCurrency
	FixedCostInCtrlgAreaCurrency	TotalCostPerView	FixedCostInCtrlgAreaCurrency
	CO2eqEmissionUnit	CO2eQty	CO2eqEmissionUnit
	CO2eqEmissionQuantity	CO2eQty	CO2eqEmissionQuantity
	_Item		_Item
	_CreatedByContactCard		_CreatedByContactCard
	_MarkedByContactCard		_MarkedByContactCard
	_ReleasedByContactCard		_ReleasedByContactCard
	_ProductText		_ProductText
	_PlantText	I_ProductCostEstimate	_PlantText
	_CostingVersionText		_CostingVersionText
	_CostingVersionText_2	I_ProductCostEstimate	_CostingVersionText_2
	_CostingVariantText		_CostingVariantText
	_ValuationVariantText		_ValuationVariantText
	_CostingTypeText		_CostingTypeText
	_CompanyCodeText	I_ProductCostEstimate	_CompanyCodeText
	_ProfitCenterText		_ProfitCenterText
	_ProfitCenterText_2	I_ProductCostEstimate	_ProfitCenterText_2
	_EstimatedCostCostingRunText		_EstimatedCostCostingRunText
	_CostEstimateStatusText		_CostEstimateStatusText
	_CostingOverheadGroupText	I_ProductCostEstimate	_CostingOverheadGroupText
	_ControllingAreaText	I_ProductCostEstimate	_ControllingAreaText

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 R_ProductCostEstimateTP.
-- 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.

CREATE VIEW R_ProductCostEstimateTP AS
SELECT
  ProductCostEstimate.CostingReferenceObject AS CostingReferenceObject,
  ProductCostEstimate.CostEstimate AS CostEstimate,
  ProductCostEstimate.CostingType AS CostingType,
  ProductCostEstimate.CostingDate AS CostingDate,
  ProductCostEstimate.CostingVersion AS CostingVersion,
  ProductCostEstimate.ValuationVariant AS ValuationVariant,
  ProductCostEstimate.CostIsEnteredManually AS CostIsEnteredManually,
  ProductCostEstimate.Product AS Product,
  ProductCostEstimate.Plant AS Plant,
  ProductCostEstimate.ValuationArea AS ValuationArea,
  ProductCostEstimate.ValuationType AS ValuationType,
  ProductCostEstimate.ControllingArea AS ControllingArea,
  ProductCostEstimate.CompanyCode AS CompanyCode,
  ProductCostEstimate.CostEstimateValidityStartDate AS CostEstimateValidityStartDate,
  ProductCostEstimate.CostEstimateValidityEndDate AS CostEstimateValidityEndDate,
  ProductCostEstimate.ValuationDate AS ValuationDate,
  ProductCostEstimate.QuantityStructureDate AS QuantityStructureDate,
  ProductCostEstimate.ProductionVersion AS ProductionVersion,
  ProductCostEstimate.BillOfMaterial AS BillOfMaterial,
  ProductCostEstimate.ProductBOMUsage AS ProductBOMUsage,
  ProductCostEstimate.AlternativeBillOfMaterial AS AlternativeBillOfMaterial,
  ProductCostEstimate.TaskListGroup AS TaskListGroup,
  ProductCostEstimate.TaskListType AS TaskListType,
  ProductCostEstimate.TaskListGroupCounter AS TaskListGroupCounter,
  ProductCostEstimate.CostingLotSize AS CostingLotSize,
  ProductCostEstimate.ValuationQuantityUnit AS ValuationQuantityUnit,
  ProductCostEstimate.CostEstimateCreatedByUser AS CostEstimateCreatedByUser,
  ProductCostEstimate.CostEstimateCreationDate AS CostEstimateCreationDate,
  ProductCostEstimate.CostEstimateStatus AS CostEstimateStatus,
  ProductCostEstimate.CostEstimateIsReleased AS CostEstimateIsReleased,
  ProductCostEstimate.CostingSheet AS CostingSheet,
  ProductCostEstimate.CostingOverheadType AS CostingOverheadType,
  ProductCostEstimate.ProductValuationStrategy AS ProductValuationStrategy,
  ProductCostEstimate.ProductValnPurgInfoRecdStrgy AS ProductValnPurgInfoRecdStrgy,
  ProductCostEstimate.CostingVariant AS CostingVariant,
  ProductCostEstimate.Ledger AS Ledger,
  ProductCostEstimate.CostingOverheadGroup AS CostingOverheadGroup,
  ProductCostEstimate.CostingOverhead AS CostingOverhead,
  ProductCostEstimate.CostEstimateMarkedByUser AS CostEstimateMarkingUser,
  ProductCostEstimate.CostEstimateMarkedByUser AS CostEstimateMarkedByUser,
  ProductCostEstimate.CostEstimateMarkingDate AS CostEstimateMarkingDate,
  ProductCostEstimate.CostEstimateReleasedByUser AS CostEstimateReleaseUser,
  ProductCostEstimate.CostEstimateReleasedByUser AS CostEstimateReleasedByUser,
  ProductCostEstimate.CostEstimateReleaseDate AS CostEstimateReleaseDate,
  ProductCostEstimate.CostEstimateTransferControl AS CostEstimateTransferControl,
  ProductCostEstimate.CostComponentStructure AS CostComponentStructure,
  ProductCostEstimate.ProfitCenter AS ProfitCenter,
  ProductCostEstimate.CompanyCodeCurrency AS CompanyCodeCurrency,
  ProductCostEstimate.ControllingAreaCurrency AS ControllingAreaCurrency,
  ProductCostEstimate.ExchangeRateType AS ExchangeRateType,
  ProductCostEstimate.ComponentBreakdown AS ComponentBreakdown,
  ProductCostEstimate.EstimatedCostCostingRun AS EstimatedCostCostingRun,
  ProductCostEstimate.EstimatedCostCostingRunDate AS EstimatedCostCostingRunDate,
  TotalCostPerView.TotalCostInCompanyCodeCurrency AS TotalCostInCompanyCodeCurrency,
  TotalCostPerView.FixedCostInCompanyCodeCurrency AS FixedCostInCompanyCodeCurrency,
  TotalCostPerView.TotalCostInCtrlgAreaCurrency AS TotalCostInCtrlgAreaCurrency,
  TotalCostPerView.FixedCostInCtrlgAreaCurrency AS FixedCostInCtrlgAreaCurrency,
  CO2eQty.CO2eqEmissionUnit AS CO2eqEmissionUnit,
  CO2eQty.CO2eqEmissionQuantity AS CO2eqEmissionQuantity,
  ProductCostEstimate._PlantText AS _PlantText,
  ProductCostEstimate._CostingVersionText_2 AS _CostingVersionText_2,
  ProductCostEstimate._CompanyCodeText AS _CompanyCodeText,
  ProductCostEstimate._ProfitCenterText_2 AS _ProfitCenterText_2,
  ProductCostEstimate._CostingOverheadGroupText AS _CostingOverheadGroupText,
  ProductCostEstimate._ControllingAreaText AS _ControllingAreaText
FROM I_ProductCostEstimate AS ProductCostEstimate
LEFT OUTER JOIN I_UserContactCard AS _CreatedByContactCard ON CostEstimateCreatedByUser = _CreatedByContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _MarkedByContactCard ON CostEstimateMarkedByUser = _MarkedByContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _ReleasedByContactCard ON CostEstimateReleasedByUser = _ReleasedByContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_EstimatedCostCostingRunStdVH AS _EstimatedCostCostingRunText ON EstimatedCostCostingRun = _EstimatedCostCostingRunText.EstimatedCostCostingRun AND EstimatedCostCostingRunDate = _EstimatedCostCostingRunText.EstimatedCostCostingRunDate AND CostingVersion = _EstimatedCostCostingRunText.CostingVersion  -- association [1..1]
LEFT OUTER JOIN I_CostingVersionText AS _CostingVersionText ON CostingVersion = _CostingVersionText.CostingVersion AND CostingType = _CostingVersionText.CostingType AND ValuationVariant = _CostingVersionText.ValuationVariant  -- association [1..*]
LEFT OUTER JOIN I_CostingTypeText AS _CostingTypeText ON CostingType = _CostingTypeText.CostingType  -- association [1..*]
LEFT OUTER JOIN I_CostingVariantText AS _CostingVariantText ON CostingVariant = _CostingVariantText.CostingVariant  -- association [1..*]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product  -- association [1..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ProfitCenter = _ProfitCenterText.ProfitCenter AND ControllingArea = _ProfitCenterText.ControllingArea AND ValuationDate <= _ProfitCenterText.ValidityEndDate AND ValuationDate >= _ProfitCenterText.ValidityStartDate AND _ProfitCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostEstimateStatusText AS _CostEstimateStatusText ON CostEstimateStatus = _CostEstimateStatusText.CostEstimateStatus  -- association [0..*]
LEFT OUTER JOIN I_CostingValuationVarText AS _ValuationVariantText ON ValuationVariant = _ValuationVariantText.ValuationVariant  -- association [1..*]
LEFT OUTER JOIN R_ProductCostEstimateItemTP AS _Item ON /* condition not available in parsed metadata */  -- association [0..*]
;

Depth:

R_ProductCostEstimateTP view_entity

I_ProductCostEstimate view

C_ProdCostEstManageTP view_entity
I_ProductCostEstimateTP view_entity