P_Matval_Manage_Cost

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 P_Matval_Manage_Cost.
-- 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: PMATVALMGMCOST

CREATE VIEW P_Matval_Manage_Cost AS
SELECT
  pr.kalnr AS CostEstimate,
  k.CostingVersion AS CostingVersion,
  k.ValuationVariant AS ValuationVariant,
  pr.curtp AS LedgerValuationCurrencyRole,
  m.bwkey AS ValuationArea,
  tk.bukrs AS CompanyCode,
  f.valuation AS AccountingValuationView,
  f.valusubtyp AS AccountingValuationSubview,
  k.CostEstimateStatus AS CostingStatus,
  k.CostingVariant AS CostingVariant,
  k.CostingType AS CostingType,
  f.valuation AS ControllingValuationType,
  k.CostEstimateMarkingDate AS CostEstimateMarkingDate,
  k.CostEstimateMarkingUser AS CostEstimateMarkingUser,
  k.CostEstimateReleaseDate AS CostEstimateReleaseDate,
  k.CostEstimateReleaseUser AS CostEstimateReleaseUser,
  ml.Currency AS Currency,
  m.matnr AS Material,
  cast(pr.peinh as ck_peinh_1) AS MaterialPriceUnitQty,
  ma.meins AS BaseUnit,
  ma./cwm/xcwmat AS cwmxcwmat,
  k.CostEstimateValidityStartDate as CostEstimateValidityStartDate AS CostEstimateasCostEstimate,
  price.MaterialPrice AS PlannedPrice,
  price.FixedPortionOfMaterialPrice AS FixedPortionOfPlannedPrice,
  k.CostEstimateValidityStartDate AS CostEstimateValidityStartDate
FROM ckmlpr AS pr
INNER JOIN v_mbew_md AS m ON /* join condition not captured in parsed metadata */
INNER JOIN t001k AS tk ON /* join condition not captured in parsed metadata */
INNER JOIN I_MatlLedgerValnCrcyRoleName AS ml ON /* join condition not captured in parsed metadata */
INNER JOIN P_LedgerValuationCrcyRole AS lvcr ON /* join condition not captured in parsed metadata */
INNER JOIN fvmkld AS f ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProductCostEstimate AS k ON /* join condition not captured in parsed metadata */
INNER JOIN mara AS ma ON /* join condition not captured in parsed metadata */
INNER JOIN R_MatlPriceDataMigrationStatus AS tf ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_MaterialLedgerPrice
;