P_Matval_Manage_Pnv_Pre

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_Manage_Pnv_Pre.
-- 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: PMATVALMGMPRE

CREATE VIEW P_Matval_Manage_Pnv_Pre AS
SELECT
  CostEstimate,
  cast(case mx.period_type when 'LF' then mv.lfgja when 'VM' then mv.vmgja when 'VJ' then mv.vjgja else '' end as fin_fiscyear) as FiscalYear AS vjgjaelseendasfin_fiscyearasFiscalYear,
  cast(case mx.period_type when 'LF' then concat('0',mv.lfmon) when 'VM' then concat('0',mv.vmmon) when 'VJ' then concat('0',mv.vjmon) else '' end as fin_fiscper) as FiscalPeriod AS vjmonelseendasfin_fiscperasFiscalPeriod,
  mlnc.curtp AS LedgerValuationCurrencyRole,
  mlnc.rldnr AS Ledger,
  mx.ValuationArea AS ValuationArea,
  MaxFiscPerCKMLPP,
  mx.period_type AS period_type,
  mlnc.rcolumn AS matnrkeyCostEstimate,
  marvld.CurrentFiscalYear AS FiscalYear,
  marvld.CurrentFiscalPeriod AS FiscalPeriod,
  mlnc.rcolumn AS rcolumn
FROM P_Matval_Manage_Max AS mx
INNER JOIN R_MatlPriceDataMigrationStatus AS tf ON /* join condition not captured in parsed metadata */
INNER JOIN t001k AS tk ON /* join condition not captured in parsed metadata */
INNER JOIN marv AS mv ON /* join condition not captured in parsed metadata */
INNER JOIN P_MaterialLedger_Name_Curtp 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 ckmlhd AS hd ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_MaterialLedgerPrice
;