P_MatVal_By_Period_Types

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 P_MatVal_By_Period_Types.
-- 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: PMTVLPERIODTYPES

CREATE VIEW P_MatVal_By_Period_Types AS
SELECT
  price.CostEstimate AS CostEstimate,
  marvld.CurrentFiscalYear AS FiscalYear,
  marvld.CurrentFiscalPeriod AS FiscalPeriod,
  mlnc.LedgerValuationCurrencyRole AS LedgerValuationCurrencyRole,
  mlnc.Ledger AS Ledger,
  price.ValuationArea AS ValuationArea,
  marvld.CurrentFiscalYearPeriod AS FiscalYearPer,
  mlnc.CurrencyRole AS CurrencyRole,
  price.CompanyCode AS CompanyCode,
  price.Material AS Material,
  price.MaterialPrice AS MaterialPrice,
  price.Currency AS Currency,
  price.MaterialPriceControl AS MaterialPriceControl,
  price.MatlPrcValdtyStrtFsclYearPerd AS MatlPrcValdtyStrtFsclYearPerd,
  price.MatlPrcValdtyEndFsclYearPeriod AS MatlPrcValdtyEndFsclYearPeriod,
  price.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  price.ValuationQuantityUnit AS BaseUnit,
  price.InventoryValuationType AS InventoryValuationType,
  price.MatlPrcValdtyStrtFsclYearPerd AS MaxFiscPerCKMLPP,
  'LF' AS period_type,
  mlnc.JrnlEntrItemCrcyRolePosition AS JrnlEntrItemCrcyRolePosition
FROM I_MaterialLedgerPrice AS price
INNER JOIN R_MatlLedgerValnCrcyRole AS mlnc ON /* join condition not captured in parsed metadata */
INNER JOIN P_MatlCtrlRecdLdgrFiscalPeriod AS marvld ON /* join condition not captured in parsed metadata */
INNER JOIN P_CCLdgrShiftedPrevYearPer AS marvld ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_MaterialLedgerPrice
;