FSH_DDL_TPO

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

CREATE VIEW FSH_DDL_TPO AS
SELECT
  m.matnr AS matnr,
  m.werks AS werks,
  m.berid AS berid,
  mdbs_bstme AS meins,
  dat01 AS dat00,
  m.lgort AS lgort,
  m.charg AS charg,
  delnr,
  m.knttp AS knttp,
  m.kzvbr AS kzvbr,
  e.vbeln AS kdauf,
  lifnr,
  bedat,
  m.kzbws AS kzbws,
  sgt_scat,
  vbap.sgt_rcat AS sgt_rcat,
  mdbs_statu,
  mdbs_no_disp,
  mdbs_wepos,
  vbap.fsh_season AS fsh_season,
  vbap.fsh_theme as fsh_theme AS matnrasmatnr,
  '+' AS plumi,
  cast(rpad(eban.bnfpo,6,' ') as pph_delps preserving type) AS delps,
  cast('' as abap.numc( 4 )) AS DELET,
  fixkz,
  eban.sobkz AS sobkz,
  coalesce(ebkn.vbelp,'000000') AS kdpos,
  coalesce(ebkn.ps_psp_pnr,'00000000') AS pspel,
  cast (0 as abap.dec(13,3)) AS ETMEN,
  cast (0 as abap.dec(13,3)) AS GLMNG,
  cast (0 as abap.dec(13,3)) AS auftm,
  cast (0 as abap.dec(13,3)) AS MDMNG,
  cast (0 as abap.dec(13,3)) AS TPMNG,
  cast ('' as abap.unit( 3 )) AS MDBS_BSTME,
  '' AS MDBS_EMLIF,
  '' AS MDBS_LBLKZ,
  cast (0 as abap.dec(13,3)) AS MDBS_MENGE_DB,
  cast (0 as abap.dec(13,3)) AS MDBS_WEMNG_DB,
  cast (0 as abap.dec(13,3)) AS MDBS_WAMNG_DB,
  cast (0 as abap.dec(13,3)) AS MDBS_DABMG_DB,
  cast (0 as abap.dec(13,3)) AS MDBS_AMENG,
  '' AS MDBS_FIXMG,
  cast (0 as abap.dec(13,3)) AS MDBS_AMNG01,
  vbap.fsh_theme AS fsh_theme
FROM fsh_ddl_tpo_4 AS m
INNER JOIN pph_e_Ekkn AS e ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbap ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN pph_e_Ebkn AS ebkn ON /* join condition not captured in parsed metadata */
;