ScmPrd_Matlotsz

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 ScmPrd_Matlotsz.
-- 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: SCMPRDMATLOTSZ

CREATE VIEW ScmPrd_Matlotsz AS
SELECT
  cast(marc.scm_matlocid_guid22 as /sapapo/lszid) AS LSZID,
  '' AS INCLUDE_PROF,
  cast( '' as /sapapo/lszky ) AS LSZKY,
  cast( '' as /sapapo/lsztx ) AS LSZTX,
  case when _t439a.losvf = 'P' then 'P' else '' end as SL_LSZ_RANGE AS losvfPthenPelseendasSL_LSZ_RANGE,
  marc.bstfe AS BSTFE,
  marc.bstmi AS BSTMI,
  marc.bstma AS BSTMA,
  marc.bstrf AS BSTRF,
  case when marc.ausss is not null or marc.ausss != 0 then division(marc.ausss*100 , marc.ausss + 100 , 2) end as AUSSS AS ausss1002endasAUSSS,
  marc.rdprf AS RDPRF,
  marc.scm_lsuom AS LSUOM,
  case when _t439a.lgknd = '2' and _t439a.disls is not null then 'X' else ' ' end as LGKND AS dislsisnotnullthenXelseendasLGKND,
  _t439a.lastl AS LASTL,
  case when _t439a.untkz is not null then _t439a.untkz else '' end AS UNTKZ,
  cast(case when _t438m.shzet is not null and _t438m.shzet <> '' and marc.shzet = '' then cast(_t438m.shzet as abap.int2) * 240000 else cast(marc.shzet as abap.int2) * 240000 end as /sapapo/svtty) as SVTTY AS int2240000endassapaposvttyasSVTTY,
  marc.scm_reord_dur AS REORD_DUR,
  marc.scm_target_dur AS TARGET_DUR,
  marc.target_stock_level_meth AS TARGET_METHOD,
  case when _t439a.losvf = 'P' and _t439a.loskz = 'W' then 'W' when _t439a.losvf = 'P' and _t439a.loskz = 'T' then 'D' when _t439a.losvf = 'P' and _t439a.loskz = 'M' then 'M' when _t439a.losvf = 'P' and _t439a.loskz = 'K' then 'K' else '' end as PERVR AS loskzKthenKelseendasPERVR,
  cast( case when _t439a.losvf = 'P' then _t439a.peraz else cast('0' as abap.dec(3,0)) end as /sapapo/rrp_peraz) as PER_AMOUNT AS dec30endassapaporrp_perazasPER_AMOUNT,
  marc.scm_tstrid AS TSTRID,
  marc.use_period_factor AS REQ_COVER_FLAG,
  marc.period_factor_value AS REQ_COVER_TYPE,
  marc.period_factor_tds AS PERIOD_FACTOR_TDS,
  '' AS SNPLOTSTRAT,
  '' AS SNPLOTBEG,
  case when marc.scm_reord_dur <> 0 then '' else case when _t439a.loskz = 'F' or _t439a.losvf = 'P' then '' else 'X' end end as SL_LSZ_EXACT AS losvfPthenelseXendendasSL_LSZ_EXACT,
  case when marc.scm_reord_dur <> 0 then '' else case when _t439a.loskz = 'F' then 'X' else '' end end as SL_LSZ_FIXED AS loskzFthenXelseendendasSL_LSZ_FIXED,
  case when marc.scm_reord_dur <> 0 then '' else case when _t439a.losvf = 'P' then 'X' else '' end end as SL_LSZ_PERI AS losvfPthenXelseendendasSL_LSZ_PERI,
  case when marc.scm_reord_dur <> 0 then 'X' else case when _t439a.losvf = 'P' then ' ' else '' end end as SL_LSZ_REORD AS losvfPthenelseendendasSL_LSZ_REORD,
  cast( '' as /sapapo/catgrp ) AS CATGRP
FROM ScmPrd_Matlotsz_Union AS marc
LEFT OUTER JOIN t438m ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t439a ON /* join condition not captured in parsed metadata */
;