R_MaterialCostEstimateTP

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

Material Cost Estimate - TP

R_MaterialCostEstimateTP is a Transactional CDS View that provides data about "Material Cost Estimate - TP" in SAP S/4HANA. It reads from 1 data source (I_ProductCostEstimate) and exposes 51 fields with key fields CostingReferenceObject, Plant, Product, CostingVariant, ValuationType.

Data Sources (1)

SourceAliasJoin Type
I_ProductCostEstimate MaterialCostEstimate from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.sapObjectNodeType.name ProductCostEstimate view
EndUserText.label Material Cost Estimate - TP view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY CostingReferenceObject I_ProductCostEstimate CostingReferenceObject Reference Obj.
KEY Plant I_ProductCostEstimate Plant Valuation Area
KEY Product I_ProductCostEstimate Product Product Sold
KEY CostingVariant I_ProductCostEstimate CostingVariant Costing Variant
KEY ValuationType I_ProductCostEstimate ValuationType Valuation Type
KEY CostingVersion I_ProductCostEstimate CostingVersion Costing Version
KEY CostingDate I_ProductCostEstimate CostingDate Costing Date
KEY CostIsEnteredManually I_ProductCostEstimate CostIsEnteredManually Additive Costs
KEY CostEstimate I_ProductCostEstimate CostEstimate Cost EstimateNo
CostingType I_ProductCostEstimate CostingType Costing Type
ValuationVariant I_ProductCostEstimate ValuationVariant Valuation Variant
ValuationArea I_ProductCostEstimate ValuationArea Valuation Area
ControllingArea I_ProductCostEstimate ControllingArea Controlling Area
CompanyCode I_ProductCostEstimate CompanyCode Receiver Company Code
CostEstimateValidityStartDate I_ProductCostEstimate CostEstimateValidityStartDate Cstg Date From
CostEstimateValidityEndDate I_ProductCostEstimate CostEstimateValidityEndDate Costing Date To
ValuationDate I_ProductCostEstimate ValuationDate Valuation Date
QuantityStructureDate I_ProductCostEstimate QuantityStructureDate Qty Struc. Date
ProductionVersion I_ProductCostEstimate ProductionVersion Version ID
BillOfMaterial I_ProductCostEstimate BillOfMaterial BOM
ProductBOMUsage I_ProductCostEstimate ProductBOMUsage Usage
AlternativeBillOfMaterial I_ProductCostEstimate AlternativeBillOfMaterial Alternative
TaskListGroup I_ProductCostEstimate TaskListGroup Group
TaskListType I_ProductCostEstimate TaskListType Task List Type
TaskListGroupCounter I_ProductCostEstimate TaskListGroupCounter Group Counter
CostingLotSize I_ProductCostEstimate CostingLotSize Cstg Lot Size
ValuationQuantityUnit I_ProductCostEstimate ValuationQuantityUnit Valuation Unit
CostEstimateCreatedByUser I_ProductCostEstimate CostEstimateCreatedByUser
CostEstimateCreationDate I_ProductCostEstimate CostEstimateCreationDate Imported On
CostEstimateStatus I_ProductCostEstimate CostEstimateStatus Costing Status
CostEstimateIsReleased I_ProductCostEstimate CostEstimateIsReleased Released
CostingSheet I_ProductCostEstimate CostingSheet Costing Sheet
CostingOverheadType I_ProductCostEstimate CostingOverheadType Overhead Type
ProductValuationStrategy I_ProductCostEstimate ProductValuationStrategy Material Vltn
ProductValnPurgInfoRecdStrgy I_ProductCostEstimate ProductValnPurgInfoRecdStrgy Substr.InfoRec.
Ledger I_ProductCostEstimate Ledger Ledger
CostingOverheadGroup I_ProductCostEstimate CostingOverheadGroup Overhead Group
CostingOverhead I_ProductCostEstimate CostingOverhead Overhead key
CostEstimateMarkedByUser I_ProductCostEstimate CostEstimateMarkedByUser Marked By
CostEstimateMarkingDate I_ProductCostEstimate CostEstimateMarkingDate Marked On
CostEstimateReleasedByUser I_ProductCostEstimate CostEstimateReleasedByUser Released By
CostEstimateReleaseDate I_ProductCostEstimate CostEstimateReleaseDate Released On
CostEstimateTransferControl I_ProductCostEstimate CostEstimateTransferControl Transfer Control
CostComponentStructure I_ProductCostEstimate CostComponentStructure Reserve
ProfitCenter I_ProductCostEstimate ProfitCenter Profit Center
CompanyCodeCurrency I_ProductCostEstimate CompanyCodeCurrency Local Currency
ControllingAreaCurrency I_ProductCostEstimate ControllingAreaCurrency Local Currency
ExchangeRateType I_ProductCostEstimate ExchangeRateType Exch. Rate Type
EstimatedCostCostingRun I_ProductCostEstimate EstimatedCostCostingRun Costing Run
EstimatedCostCostingRunDate I_ProductCostEstimate EstimatedCostCostingRunDate Cstg Run Date
ProductIsCostedWithQtyStruc I_ProductCostEstimate ProductIsCostedWithQtyStruc

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

Learn More