Pph_Ddl_Perflog_Header

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 Pph_Ddl_Perflog_Header.
-- 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: V_PPH_PF_HD_KF1

CREATE VIEW Pph_Ddl_Perflog_Header AS
SELECT
  header.uuid AS uuid,
  cast(header.start_time as pph_mrp_start_ts) AS mrpstart_ts,
  cast(header.end_time as pph_mrp_end_ts) AS mrpend_ts,
  header.uname AS uname,
  header.regen AS regen,
  header.comps AS comps,
  header.plall AS plall,
  header.trans AS trans,
  header.plmod AS plmod,
  cast(case coalesce(header.scope,' ') when ' ' then 'A' else header.scope end as pph_mrp_scope) AS scope,
  cast(case coalesce(header.trmpl,' ') when ' ' then '1' else header.trmpl end as trmpl) AS trmpl,
  header.wo_auth AS wo_auth,
  header.not_locked AS not_locked,
  header.error_string AS error_string,
  header.jobname AS jobname,
  header.stepcount AS stepcount
FROM pphmrplog AS header
;