I_MaterialValuationsByPeriods

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_MaterialValuationsByPeriods.
-- 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: IMATVALMGMPNV

CREATE VIEW I_MaterialValuationsByPeriods AS
SELECT
  pnv.CostEstimate AS CostEstimate,
  pnv.FiscalYear AS FiscalYear,
  pnv.FiscalPeriod AS FiscalPeriod,
  pnv.LedgerValuationCurrencyRole AS LedgerValuationCurrencyRole,
  md.ValuationArea AS ValuationArea,
  lvcr.LegalCurrencyRole AS LegalCurrencyRole,
  lvcr.Ledger AS Ledger,
  lvcr.AccountingValuationView AS AccountingValuationView,
  lvcr.AccountingValuationSubview AS AccountingValuationSubview,
  lvcr.LedgerValnCrcyRoleIsUsedInLogs AS LedgerValnCrcyRoleIsUsedInLogs,
  lvcr.LegalCurrencyRoleName AS LegalCurrencyRoleName,
  lvcr.LedgerName AS LedgerName,
  lvcr.AccountingValuationViewName AS AccountingValuationViewName,
  lvcr.AccountingValuationSubviewName AS AccountingValuationSubviewName,
  lvcr.AcctgValnVwSubviewCombinedName AS AcctgValnVwSubviewCombinedName,
  lvcr.CurrencyRole AS CurrencyRole,
  _CompanyCode.ControllingArea AS ControllingArea,
  cast (lvcr.AccountingValuationView as valutyp) AS ControllingValuationType,
  pnv.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  pnv.MovingAveragePrice AS MovingAveragePrice,
  pnv.InvtryValnSpecialStockType AS InvtryValnSpecialStockType,
  pnv.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  pnv.MaterialPriceControl AS MaterialPriceControl,
  pnv.StandardPrice AS StandardPrice,
  pnv.PriceDeterminationControl AS PriceDeterminationControl,
  pnv.FuturePrice AS FuturePrice,
  pnv.FuturePriceValidityStartDate AS FuturePriceValidityStartDate,
  pnv.FuturePlannedPrice AS FuturePlannedPrice,
  pnv.TotalValuatedStockAmount AS TotalValuatedStockAmount,
  pnv.TotalVltdStockQuantity AS TotalVltdStockQuantity,
  md.Currency AS Currency,
  md.BaseUnit AS BaseUnit,
  md.ValuationQuantityUnit AS ValuationQuantityUnit,
  md.CompanyCode AS CompanyCode,
  md.Material AS Material,
  _MaterialText.MaterialName AS MaterialName,
  md.InventoryValuationType AS InventoryValuationType,
  md.InventoryValuationCategory AS InventoryValuationCategory,
  cast (md.ValuationArea as werks_d) AS Plant,
  _Plant.PlantName AS PlantName,
  cast ( pnv.period_type as ck_per_art ) AS PostgFsclPerdCurDateRelation,
  _CompanyCode._ControllingArea AS _ControllingArea
FROM P_Matval_Manage_Pnv AS pnv
INNER JOIN P_Matval_Manage_Md2 AS md ON /* join condition not captured in parsed metadata */
INNER JOIN R_MatlLedgerValnCrcyRole AS lvcr ON /* join condition not captured in parsed metadata */
INNER JOIN I_MatlCtrlRecdLdgrFiscalPeriod AS mcrfp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON ValuationArea = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
;