nsdm_e_mkol

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 nsdm_e_mkol.
-- 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: NSDM_V_MKOL

CREATE VIEW nsdm_e_mkol AS
SELECT
  t.mandt AS mandt,
  t.matnr AS matnr,
  t.werks AS werks,
  t.lgort AS lgort,
  t.charg AS charg,
  t.sobkz AS sobkz,
  t.lifnr AS lifnr,
  t.lvorm AS lvorm,
  t.ersda AS ersda,
  t.ernam AS ernam,
  t.aenam AS aenam,
  t.laeda AS laeda,
  case when m.gjper is null then '0000' else cast(substring(m.gjper, 1, 4) as abap.numc(4)) end AS lfgja,
  case when m.gjper is null then '00' else cast(substring(m.gjper, 6, 2) as abap.numc(2)) end AS lfmon,
  t.spers AS spers,
  case when m.slabs is null then 0 else m.slabs end AS slabs,
  case when m.sinsm is null then 0 else m.sinsm end AS sinsm,
  case when m.seinm is null then 0 else m.seinm end AS seinm,
  case when m.sspem is null then 0 else m.sspem end AS sspem,
  case when m.svmla is null then 0 else m.svmla end AS svmla,
  case when m.svmin is null then 0 else m.svmin end AS svmin,
  case when m.svmei is null then 0 else m.svmei end AS svmei,
  case when m.svmsp is null then 0 else m.svmsp end AS svmsp,
  t.kzisl AS kzisl,
  t.kzisq AS kzisq,
  t.kzise AS kzise,
  t.kziss AS kziss,
  t.kzvsl AS kzvsl,
  t.kzvsq AS kzvsq,
  t.kzvse AS kzvse,
  t.kzvss AS kzvss,
  t.mmeng AS mmeng,
  t.ameng AS ameng,
  t.kodll AS kodll,
  t.kojin AS kojin,
  case when m.korue is null then ' ' else m.korue end AS korue,
  t.sgt_scat AS sgt_scat,
  case when m./cwm/slabs is null then 0 else m./cwm/slabs end AS /cwm/slabs,
  case when m./cwm/sinsm is null then 0 else m./cwm/sinsm end AS /cwm/sinsm,
  case when m./cwm/seinm is null then 0 else m./cwm/seinm end AS /cwm/seinm,
  case when m./cwm/sspem is null then 0 else m./cwm/sspem end AS /cwm/sspem,
  case when m./cwm/svmla is null then 0 else m./cwm/svmla end AS /cwm/svmla,
  case when m./cwm/svmin is null then 0 else m./cwm/svmin end AS /cwm/svmin,
  case when m./cwm/svmei is null then 0 else m./cwm/svmei end AS /cwm/svmei,
  case when m./cwm/svmsp is null then 0 else m./cwm/svmsp end AS /cwm/svmsp
FROM mkol AS t
;