I_ProductValuationWD

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_ProductValuationWD.
-- 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: IPRDVALUATIONWD

CREATE VIEW I_ProductValuationWD AS
SELECT
  Valuation.Product AS Product,
  Valuation.ValuationArea AS ValuationArea,
  Valuation.ValuationType AS ValuationType,
  Valuation.ProdCostEstNumber AS ProdCostEstNumber,
  Valuation.ValuationArea AS ValuationAreaForEdit,
  Valuation.ValuationType AS ValuationTypeForEdit,
  Valuation.ValuationClass AS ValuationClass,
  Valuation.PriceDeterminationControl AS PriceDeterminationControl,
  Valuation.StandardPrice AS StandardPrice,
  Valuation.PriceUnitQty AS PriceUnitQty,
  Valuation.InventoryValuationProcedure AS InventoryValuationProcedure,
  Valuation.IsMarkedForDeletion AS IsMarkedForDeletion,
  Valuation.MovingAveragePrice AS MovingAveragePrice,
  Valuation.ValuationCategory AS ValuationCategory,
  Valuation.ProductUsageType AS ProductUsageType,
  Valuation.ProductOriginType AS ProductOriginType,
  Valuation.IsProducedInhouse AS IsProducedInhouse,
  Valuation.ValuationClassSalesOrderStock AS ValuationClassSalesOrderStock,
  Valuation.ProjectStockValuationClass AS ProjectStockValuationClass,
  Valuation.PriceLastChangeDate AS PriceLastChangeDate,
  Valuation.Currency AS Currency,
  cast(case when Valuation.ValuationType <> '' then 'X' else ' ' end as abap.char( 1 ) ) AS IsSplitValuation,
  Valuation.ValuationMargin AS ValuationMargin,
  Valuation.BaseUnit AS BaseUnit
FROM I_ProductValuationBasic AS Valuation
LEFT OUTER JOIN E_Productvaluation AS _ActiveExtension ON Product = _ActiveExtension.Product AND ValuationArea = _ActiveExtension.ValuationArea AND ValuationType = _ActiveExtension.ValuationType  -- association [0..1]
LEFT OUTER JOIN E_Productvaluation AS _DraftExtension ON Product = _DraftExtension.Product AND ValuationArea = _DraftExtension.ValuationArea AND ValuationType = _DraftExtension.ValuationType  -- association [0..1]
LEFT OUTER JOIN I_ProductWD AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Productmlaccountwd AS _MLAccount ON Product = _MLAccount.Product AND ValuationArea = _MLAccount.ValuationArea AND ValuationType = _MLAccount.ValuationType  -- association [0..*]
LEFT OUTER JOIN I_ProductMLPricesTP AS _MLPrices ON Product = _MLPrices.Product AND ValuationArea = _MLPrices.ValuationArea AND ValuationType = _MLPrices.ValuationType  -- association [0..*]
LEFT OUTER JOIN I_ProductValuationAcctTP AS _ValuationAccount ON Product = _ValuationAccount.Product AND ValuationArea = _ValuationAccount.ValuationArea AND ValuationType = _ValuationAccount.ValuationType  -- association [0..1]
LEFT OUTER JOIN I_ProductValuationCostingTP AS _ValuationCosting ON Product = _ValuationCosting.Product AND ValuationArea = _ValuationCosting.ValuationArea AND ValuationType = _ValuationCosting.ValuationType  -- association [0..1]
;