PPH_E_PLAF_UL

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_E_PLAF_UL.
-- 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_PLAF_UL

CREATE VIEW PPH_E_PLAF_UL AS
SELECT
  plaf.matnr AS matnr,
  plaf.pwwrk AS werks,
  '05' AS sort2,
  'U3' AS delkz,
  '' AS vrfkz,
  avmng - gsmng AS mng01,
  0 AS mng02,
  cast('00000000' as abap.dats) AS dat03,
  0 AS webaz,
  '' AS fix01,
  '' AS fix02,
  plaf.paart AS baart,
  '' AS beskz,
  '' AS sobes,
  '' AS umskz,
  '' AS wrk01,
  plaf.plwrk AS wrk02,
  plaf.reslo AS lgort,
  plaf.plnum AS delnr,
  plaf.sernr AS sernr,
  cast('00000000' as abap.dats) AS paltr,
  plaf.techs AS techs,
  '' AS verid,
  '' AS stlan,
  '' AS stalt,
  '00' AS ststa,
  case when sobkz = '' then '' else knttp end AS knttp,
  '' AS verto,
  '' AS qunum,
  '000' AS qupos,
  '' AS lifnr,
  '' AS ekorg,
  '' AS ebeln,
  '00000' AS ebelp,
  '' AS frthw,
  '000000000000' AS bedid,
  '' AS trmer,
  '000000000000' AS ratid,
  '' AS rater,
  '000000000000' AS groid,
  '' AS groer,
  '0000000000' AS arsnr,
  '0000' AS arsps,
  '' AS prnkz,
  '' AS kapfx,
  cast('000000' as abap.tims) AS pstti,
  cast('000000' as abap.tims) AS pedti,
  '' AS monkz,
  plaf.vrpla AS vrpla,
  case when vrpla = '' then '' else pbdnr end AS pbdnr,
  case when sobkz = '' then '' else kzbws end AS kzbws,
  0 AS wamng,
  '00000000000000000' AS edgno,
  '' AS ematn,
  '' AS prsch,
  '' AS lvsch,
  '' AS dbskz,
  0 AS pstmp,
  '' AS staex,
  plaf.lgort AS reslo,
  plaf.plifz AS plifz,
  plaf.sgt_scat AS sgt_scat,
  plaf.emlif AS plaf_emlif,
  plaf.lblkz AS plaf_lblkz,
  plaf.konnr AS plaf_konnr,
  plaf.ktpnr AS plaf_ktpnr,
  knttp AS knttp_db,
  kzvbr AS kzvbr_db,
  kzbws AS kzbws_db
FROM plaf
;