I_ProductValuation

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_ProductValuation.
-- 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: IPRDVALUATION

CREATE VIEW I_ProductValuation AS
SELECT
  Valuation.matnr AS Product,
  Valuation.bwkey AS ValuationArea,
  Valuation.bwtar AS ValuationType,
  Valuation.bklas AS ValuationClass,
  Valuation.mlast AS PriceDeterminationControl,
  marv.lfmon AS FiscalMonthCurrentPeriod,
  marv.lfgja AS FiscalYearCurrentPeriod,
  Valuation.stprs AS StandardPrice,
  Valuation.peinh AS PriceUnitQty,
  cast(Valuation.vprsv as inventoryvaluationprocedure preserving type ) AS InventoryValuationProcedure,
  Valuation.zkprs AS FutureEvaluatedAmountValue,
  Valuation.zkdat AS FuturePriceValidityStartDate,
  Valuation.stprv AS PrevInvtryPriceInCoCodeCrcy,
  Valuation.verpr AS MovingAveragePrice,
  Valuation.bwtty AS ValuationCategory,
  cast (Valuation.mtuse as productusagetype preserving type ) AS ProductUsageType,
  cast (Valuation.mtorg as productorigintype preserving type ) AS ProductOriginType,
  Valuation.ownpr AS IsProducedInhouse,
  Valuation.kaln1 AS ProdCostEstNumber,
  Valuation.lvorm AS IsMarkedForDeletion,
  Valuation.bwspa AS ValuationMargin,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  t001k.bukrs AS CompanyCode,
  Valuation.eklas AS ValuationClassSalesOrderStock,
  Valuation.qklas AS ProjectStockValuationClass,
  Valuation.zplp1 AS PlannedPrice1InCoCodeCrcy,
  Valuation.zplp2 AS PlannedPrice2InCoCodeCrcy,
  Valuation.zplp3 AS PlannedPrice3InCoCodeCrcy,
  Valuation.zpld1 AS FuturePlndPrice1ValdtyDate,
  Valuation.zpld2 AS FuturePlndPrice2ValdtyDate,
  Valuation.zpld3 AS FuturePlndPrice3ValdtyDate,
  Valuation.bwpei AS TaxBasedPricesPriceUnitQty,
  Valuation.laepr AS PriceLastChangeDate,
  Valuation.zplpr AS PlannedPrice,
  t001.waers AS Currency,
  Valuation.mlmaa AS MLIsActiveAtProductLevel,
  _Product.BaseUnit AS BaseUnit
FROM mbew AS Valuation
INNER JOIN t001k ON /* join condition not captured in parsed metadata */
INNER JOIN marv 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 I_Prodvaluationclass AS _ValuationClass ON ValuationClass = _ValuationClass.ValuationClass  -- association [0..1]
LEFT OUTER JOIN I_Prodvaluationclasstxt AS _ValuationClassText ON ValuationClass = _ValuationClassText.ValuationClass  -- association [0..*]
LEFT OUTER JOIN I_Prodvaluationclass AS _ValnClassSalesOrderStock ON ValuationClassSalesOrderStock = _ValnClassSalesOrderStock.ValuationClass  -- association [0..1]
LEFT OUTER JOIN I_Prodvaluationclasstxt AS _ValnClassSalesOrderStockText ON ValuationClassSalesOrderStock = _ValnClassSalesOrderStockText.ValuationClass  -- association [0..*]
LEFT OUTER JOIN I_Prodvaluationclass AS _ValnClassProjectStock ON ProjectStockValuationClass = _ValnClassProjectStock.ValuationClass  -- association [0..1]
LEFT OUTER JOIN I_Prodvaluationclasstxt AS _ValnClassProjectStockText ON ProjectStockValuationClass = _ValnClassProjectStockText.ValuationClass  -- association [0..*]
LEFT OUTER JOIN I_ProdValnPriceControl AS _InventoryValnProcedure ON InventoryValuationProcedure = _InventoryValnProcedure.InventoryValuationProcedure  -- association [0..1]
LEFT OUTER JOIN I_ProdValnPriceControlText AS _InventoryValnProcedureText ON InventoryValuationProcedure = _InventoryValnProcedureText.InventoryValuationProcedure  -- association [0..*]
LEFT OUTER JOIN I_PriceDeterminationControl AS _PriceDeterminationControl ON PriceDeterminationControl = _PriceDeterminationControl.PriceDeterminationControl  -- association [0..1]
LEFT OUTER JOIN I_PriceDeterminationControlTxt AS _PriceDeterminationControlText ON PriceDeterminationControl = _PriceDeterminationControlText.PriceDeterminationControl  -- association [0..*]
LEFT OUTER JOIN I_BR_MaterialUsage AS _BR_MaterialUsage ON ProductUsageType = _BR_MaterialUsage.BR_MaterialUsage  -- association [0..1]
LEFT OUTER JOIN I_BR_MaterialUsageText AS _BR_MaterialUsageText ON ProductUsageType = _BR_MaterialUsageText.BR_MaterialUsage  -- association [0..*]
LEFT OUTER JOIN I_BR_MaterialOrigin AS _BR_MaterialOrigin ON ProductOriginType = _BR_MaterialOrigin.BR_MaterialOrigin  -- association [0..1]
LEFT OUTER JOIN I_BR_MaterialOriginText AS _BR_MaterialOriginText ON ProductOriginType = _BR_MaterialOriginText.BR_MaterialOrigin  -- association [0..*]
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_InventoryValuationType AS _InventoryValuationType ON ValuationType = _InventoryValuationType.InventoryValuationType  -- association [0..1]
;