I_MaterialValuationHist

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_MaterialValuationHist.
-- 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: IMMVALNHIST

CREATE VIEW I_MaterialValuationHist AS
SELECT
  MatValHist.matnr AS Material,
  MatValHist.bwkey AS ValuationArea,
  bwtar AS ValuationType,
  MatValHist.lfgja AS FiscalYearCurrentPeriod,
  MatValHist.lfmon AS FiscalMonthCurrentPeriod,
  lbkum AS TotalValStockQuantity,
  salk3 AS StockValueInCCCrcy,
  vprsv AS MaterialPriceControl,
  verpr AS MovingAveragePrice,
  stprs AS StandardPrice,
  peinh AS MaterialPriceUnitQty,
  bklas AS ValuationClass,
  salkv AS ValBsdOnMvgAvgPrcInCCCrcy,
  vksal AS TotStkValAtSlsPrcInCoCodeCrcy,
  CompanyCode.Currency AS Currency,
  CompanyCode.CompanyCode AS CompanyCode,
  cast ( concat( MatValHist.lfgja , concat( MatValHist.lfmon , '01' ) ) as erdat )as CreationDate AS lfmon01aserdatasCreationDate
FROM Mbv_Mbewh AS MatValHist
INNER JOIN I_ValuationArea AS ValuationArea ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
;