fsh_ddl_tpo_1

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 fsh_ddl_tpo_1.
-- 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_FSH_TPO_1

CREATE VIEW fsh_ddl_tpo_1 AS
SELECT
  ekpo.matnr AS matnr,
  ekpo.werks AS werks,
  ekpo.berid AS berid,
  ekpo.sgt_scat AS sgt_scat,
  ekpo.umrez AS umrez,
  ekpo.umren AS umren,
  ekpo.eglkz AS eglkz,
  ekpo.pstyp AS pstyp,
  ekpo.retpo AS retpo,
  ekpo.lgort AS lgort,
  ekpo.ebeln AS delnr,
  cast(rpad(ekpo.ebelp,6,' ') as pph_delps preserving type) AS delps,
  case when ekpo.sobkz = '' then '' else knttp end AS knttp,
  case when ekpo.sobkz = '' then '' else kzvbr end AS kzvbr,
  ekpo.sobkz AS sobkz,
  case when ekpo.sobkz = '' then '' else kzbws end AS kzbws,
  ekpo.statu AS statu,
  ekpo.wepos AS wepos,
  ekpo.statu AS mdbs_statu,
  ekpo.wepos AS mdbs_wepos,
  ekpo.emlif AS mdbs_emlif,
  ekpo.lblkz AS mdbs_lblkz,
  eket.fixkz AS fixkz,
  ekpo.meins AS mdbs_bstme,
  eket.menge AS mng01,
  eket.menge AS auftm,
  eket.menge AS etmen,
  eket.glmng AS glmng,
  eket.eindt AS dat01,
  eket.bedat AS bedat,
  eket.etenr AS delet,
  eket.nodisp AS mdbs_no_disp,
  coalesce(ekko.reswk,'') AS wrk02,
  coalesce(ekko.lifnr,'') AS lifnr,
  case when ekpo.retpo = '' then 'BE' else 'RP' end as delkz AS retpothenBEelseRPendasdelkz,
  fls_rsto,
  ameng AS mdbs_ameng,
  fixmg AS mdbs_fixmg
FROM ekpo
INNER JOIN eket ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ekko ON /* join condition not captured in parsed metadata */
;