I_ProductValuationBasic

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_ProductValuationBasic.
-- 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: IPRDVALBASIC

CREATE VIEW I_ProductValuationBasic AS
SELECT
  Valuation.Product AS Product,
  Valuation.ValuationArea AS ValuationArea,
  Valuation.ValuationType AS ValuationType,
  Valuation.ValuationClass AS ValuationClass,
  Valuation.PriceDeterminationControl AS PriceDeterminationControl,
  marv.lfmon AS FiscalMonthCurrentPeriod,
  marv.lfgja AS FiscalYearCurrentPeriod,
  Valuation.StandardPrice AS StandardPrice,
  Valuation.PriceUnitQty AS PriceUnitQty,
  Valuation.InventoryValuationProcedure AS InventoryValuationProcedure,
  Valuation.FuturePriceValidityStartDate AS FuturePriceValidityStartDate,
  Valuation.PrevInvtryPriceInCoCodeCrcy AS PrevInvtryPriceInCoCodeCrcy,
  Valuation.MovingAveragePrice AS MovingAveragePrice,
  Valuation.ValuationCategory AS ValuationCategory,
  Valuation.ProductUsageType AS ProductUsageType,
  Valuation.ProductOriginType AS ProductOriginType,
  Valuation.IsProducedInhouse AS IsProducedInhouse,
  Valuation.ProdCostEstNumber AS ProdCostEstNumber,
  Valuation.IsMarkedForDeletion AS IsMarkedForDeletion,
  Valuation.ValuationMargin AS ValuationMargin,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  t001k.bukrs AS CompanyCode,
  Valuation.ValuationClassSalesOrderStock AS ValuationClassSalesOrderStock,
  Valuation.ProjectStockValuationClass AS ProjectStockValuationClass,
  Valuation.TaxBasedPricesPriceUnitQty AS TaxBasedPricesPriceUnitQty,
  Valuation.PriceLastChangeDate AS PriceLastChangeDate,
  Valuation.FuturePrice AS FuturePrice,
  Valuation.MaintenanceStatus AS MaintenanceStatus,
  t001.waers AS Currency,
  _Product.BaseUnit AS BaseUnit,
  Valuation.MLIsActiveAtProductLevel AS MLIsActiveAtProductLevel
FROM P_ProductValuationBasic 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_Prodvaluationclass AS _ValnClassSalesOrderStock ON ValuationClassSalesOrderStock = _ValnClassSalesOrderStock.ValuationClass  -- association [0..1]
LEFT OUTER JOIN I_Prodvaluationclass AS _ValnClassProjectStock ON ProjectStockValuationClass = _ValnClassProjectStock.ValuationClass  -- association [0..1]
LEFT OUTER JOIN I_ProdValnPriceControl AS _InventoryValnProcedure ON InventoryValuationProcedure = _InventoryValnProcedure.InventoryValuationProcedure  -- association [0..1]
LEFT OUTER JOIN I_PriceDeterminationControl AS _PriceDeterminationControl ON PriceDeterminationControl = _PriceDeterminationControl.PriceDeterminationControl  -- association [0..1]
LEFT OUTER JOIN I_BR_MaterialUsage AS _BR_MaterialUsage ON ProductUsageType = _BR_MaterialUsage.BR_MaterialUsage  -- association [0..1]
LEFT OUTER JOIN I_BR_MaterialOrigin AS _BR_MaterialOrigin ON ProductOriginType = _BR_MaterialOrigin.BR_MaterialOrigin  -- association [0..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_InventoryValuationType AS _InventoryValuationType ON ValuationType = _InventoryValuationType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnitOfMeasure ON baseunit = _BaseUnitOfMeasure.UnitOfMeasure  -- association [1..1]
;