C_ProdCostEstManageTP

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 C_ProdCostEstManageTP.
-- 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 C_ProdCostEstManageTP AS
SELECT
  CostingReferenceObject,
  CostEstimate,
  CostingType,
  CostingDate,
  CostingVersion,
  ValuationVariant,
  CostIsEnteredManually,
  _CostingTypeText.CostingTypeName : localized AS CostingTypeNamelocalized,
  _ValuationVariantText.ValuationVariantName : localized AS ValuationVariantNamelocalized,
  _CostingVersionText_2.CostingVersionName : localized AS CostingVersionNamelocalized,
  cast(Product as matnr preserving type ) AS Product,
  Plant,
  _PlantText.PlantName AS PlantName,
  ValuationArea,
  ValuationType,
  CompanyCode,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeName,
  ProfitCenter,
  _ProfitCenterText_2.ProfitCenterName AS ProfitCenterName,
  CostEstimateValidityStartDate,
  CostEstimateValidityEndDate,
  ValuationDate,
  QuantityStructureDate,
  CostingLotSize,
  ValuationQuantityUnit,
  CostEstimateCreationDate,
  CostEstimateCreatedByUser,
  _CreatedByContactCard.FullName AS CostEstimateCreatedByUserName,
  CostEstimateStatus,
  _CostEstimateStatusText.CostEstimateStatusText : localized AS CostEstimateStatusTextlocalized,
  CostEstimateStatusCriticality,
  CostEstimateIsReleased,
  CostingVariant,
  _CostingVariantText.CostingVariantName : localized AS CostingVariantNamelocalized,
  CostEstimateMarkingDate,
  CostEstimateMarkedByUser,
  _MarkedByContactCard.FullName AS CostEstimateMarkedByUserName,
  CostEstimateReleaseDate,
  CostEstimateReleasedByUser,
  _ReleasedByContactCard.FullName AS CostEstimateReleasedByUserName,
  EstimatedCostCostingRun,
  _EstimatedCostCostingRunText.EstimatedCostCostingRunDesc AS EstimatedCostCostingRunDesc,
  EstimatedCostCostingRunDate,
  TotalCostInCompanyCodeCurrency,
  FixedCostInCompanyCodeCurrency,
  CompanyCodeCurrency,
  TotalCostInCtrlgAreaCurrency,
  FixedCostInCtrlgAreaCurrency,
  ControllingAreaCurrency,
  CO2eqEmissionUnit,
  CO2eqEmissionQuantity
FROM R_ProductCostEstimateTP
;