I_ProductCostEstimateTP

DDL: I_PRODUCTCOSTESTIMATETP Type: view_entity TRANSACTIONAL
51 Fields 1 Data Sources

Product Cost Estimate - TP

I_ProductCostEstimateTP is a Transactional CDS View that provides data about "Product Cost Estimate - TP" in SAP S/4HANA. It reads from 1 data source (R_ProductCostEstimateTP) and exposes 51 fields with key fields CostingReferenceObject, CostEstimate, CostingType, CostingDate, CostingVersion.

Data Sources (1)

SourceAliasJoin Type
R_ProductCostEstimateTP R_ProductCostEstimateTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name ProductCostEstimate view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Product Cost Estimate - TP view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY CostingReferenceObject CostingReferenceObject
KEY CostEstimate CostEstimate Cost EstimateNo
KEY CostingType CostingType
KEY CostingDate CostingDate
KEY CostingVersion CostingVersion
KEY ValuationVariant ValuationVariant
KEY CostIsEnteredManually CostIsEnteredManually
Product Product Product Sold
Plant Plant Valuation Area
ValuationArea ValuationArea Valuation Area
ValuationType ValuationType Valuation Type
ControllingArea ControllingArea Controlling Area
CompanyCode CompanyCode Receiver Company Code
CostEstimateValidityStartDate CostEstimateValidityStartDate
CostEstimateValidityEndDate CostEstimateValidityEndDate
ValuationDate ValuationDate Valuation Date
QuantityStructureDate QuantityStructureDate
ProductionVersion ProductionVersion Version ID
BillOfMaterial BillOfMaterial BOM
ProductBOMUsage ProductBOMUsage
AlternativeBillOfMaterial AlternativeBillOfMaterial
TaskListGroup TaskListGroup Group
TaskListType TaskListType Task List Type
TaskListGroupCounter TaskListGroupCounter Group Counter
CostingLotSize CostingLotSize
ValuationQuantityUnit ValuationQuantityUnit
CostEstimateCreatedByUser CostEstimateCreatedByUser
CostEstimateCreationDate CostEstimateCreationDate
CostEstimateStatus CostEstimateStatus
CostEstimateIsReleased CostEstimateIsReleased
CostingSheet CostingSheet Costing Sheet
CostingOverheadType CostingOverheadType
ProductValuationStrategy ProductValuationStrategy
ProductValnPurgInfoRecdStrgy ProductValnPurgInfoRecdStrgy
CostingVariant CostingVariant
CostingOverheadGroup CostingOverheadGroup
CostingOverhead CostingOverhead
CostEstimateMarkingDate CostEstimateMarkingDate
CostEstimateMarkedByUser CostEstimateMarkedByUser
CostEstimateMarkingUser CostEstimateMarkingUser
CostEstimateReleaseDate CostEstimateReleaseDate
CostEstimateReleasedByUser CostEstimateReleasedByUser
CostEstimateReleaseUser CostEstimateReleaseUser
CostEstimateTransferControl CostEstimateTransferControl
CostComponentStructure CostComponentStructure
ProfitCenter ProfitCenter Profit Center
CompanyCodeCurrency CompanyCodeCurrency Local Currency
ControllingAreaCurrency ControllingAreaCurrency
ExchangeRateType ExchangeRateType Exch. Rate Type
EstimatedCostCostingRun EstimatedCostCostingRun
EstimatedCostCostingRunDate EstimatedCostCostingRunDate

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_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 I_ProductCostEstimateTP AS
SELECT
  CostingReferenceObject,
  CostEstimate,
  CostingType,
  CostingDate,
  CostingVersion,
  ValuationVariant,
  CostIsEnteredManually,
  Product,
  Plant,
  ValuationArea,
  ValuationType,
  ControllingArea,
  CompanyCode,
  CostEstimateValidityStartDate,
  CostEstimateValidityEndDate,
  ValuationDate,
  QuantityStructureDate,
  ProductionVersion,
  BillOfMaterial,
  ProductBOMUsage,
  AlternativeBillOfMaterial,
  TaskListGroup,
  TaskListType,
  TaskListGroupCounter,
  CostingLotSize,
  ValuationQuantityUnit,
  CostEstimateCreatedByUser,
  CostEstimateCreationDate,
  CostEstimateStatus,
  CostEstimateIsReleased,
  CostingSheet,
  CostingOverheadType,
  ProductValuationStrategy,
  ProductValnPurgInfoRecdStrgy,
  CostingVariant,
  CostingOverheadGroup,
  CostingOverhead,
  CostEstimateMarkingDate,
  CostEstimateMarkedByUser,
  CostEstimateMarkingUser,
  CostEstimateReleaseDate,
  CostEstimateReleasedByUser,
  CostEstimateReleaseUser,
  CostEstimateTransferControl,
  CostComponentStructure,
  ProfitCenter,
  CompanyCodeCurrency,
  ControllingAreaCurrency,
  ExchangeRateType,
  EstimatedCostCostingRun,
  EstimatedCostCostingRunDate
FROM R_ProductCostEstimateTP
;

Learn More