I_ProductValuationCosting

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_ProductValuationCosting.
-- 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: IPRODVALCOST

CREATE VIEW I_ProductValuationCosting AS
SELECT
  ProdCosting.Product AS Product,
  ProdCosting.ValuationArea AS ValuationArea,
  ProdCosting.ValuationType AS ValuationType,
  ProdCosting.IsMaterialCostedWithQtyStruc AS IsMaterialCostedWithQtyStruc,
  ProdCosting.IsMaterialRelatedOrigin AS IsMaterialRelatedOrigin,
  ProdCosting.CostOriginGroup AS CostOriginGroup,
  ProdCosting.CostingOverheadGroup AS CostingOverheadGroup,
  ProdCosting.PlannedPrice1InCoCodeCrcy AS PlannedPrice1InCoCodeCrcy,
  ProdCosting.PlannedPrice2InCoCodeCrcy AS PlannedPrice2InCoCodeCrcy,
  ProdCosting.PlannedPrice3InCoCodeCrcy AS PlannedPrice3InCoCodeCrcy,
  ProdCosting.FuturePlndPrice1ValdtyDate AS FuturePlndPrice1ValdtyDate,
  ProdCosting.FuturePlndPrice2ValdtyDate AS FuturePlndPrice2ValdtyDate,
  ProdCosting.FuturePlndPrice3ValdtyDate AS FuturePlndPrice3ValdtyDate,
  ProdCosting.PlannedPrice AS PlannedPrice,
  t001.waers AS Currency,
  t001.bukrs AS CompanyCode
FROM P_ProductValuationBasic AS ProdCosting
INNER JOIN t001k ON /* join condition not captured in parsed metadata */
INNER JOIN t001 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN E_Productvaluation AS _ProdValuationExt ON Product = _ProdValuationExt.Product AND ValuationArea = _ProdValuationExt.ValuationArea AND ValuationType = _ProdValuationExt.ValuationType  -- association [0..1]
LEFT OUTER JOIN I_CostOriginGroupText AS _CostOriginGroupText ON CostOriginGroup = _CostOriginGroupText.CostOriginGroup  -- association [0..*]
;