nsdm_e_msku

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

CREATE VIEW nsdm_e_msku AS
SELECT
  t.mandt AS mandt,
  t.matnr AS matnr,
  t.werks AS werks,
  t.charg AS charg,
  t.sobkz AS sobkz,
  t.kunnr AS kunnr,
  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.kuspr AS kuspr,
  case when m.kulab is null then 0 else m.kulab end AS kulab,
  case when m.kuins is null then 0 else m.kuins end AS kuins,
  case when m.kuvla is null then 0 else m.kuvla end AS kuvla,
  case when m.kuvin is null then 0 else m.kuvin end AS kuvin,
  t.kuill AS kuill,
  t.kuilq AS kuilq,
  t.kuvll AS kuvll,
  t.kuvlq AS kuvlq,
  t.kufll AS kufll,
  t.kuflq AS kuflq,
  t.kudll AS kudll,
  case when m.kuein is null then 0 else m.kuein end AS kuein,
  case when m.kuvei is null then 0 else m.kuvei end AS kuvei,
  t.ersda AS ersda,
  t.kujin AS kujin,
  case when m.kurue is null then ' ' else m.kurue end AS kurue,
  case when m.kuuml is null then 0 else m.kuuml end AS kuuml,
  t.sgt_scat AS sgt_scat,
  ' ' AS fsh_season,
  ' ' AS fsh_theme,
  case when m./cwm/kulab is null then 0 else m./cwm/kulab end AS /cwm/kulab,
  case when m./cwm/kuins is null then 0 else m./cwm/kuins end AS /cwm/kuins,
  case when m./cwm/kuein is null then 0 else m./cwm/kuein end AS /cwm/kuein,
  case when m./cwm/kuuml is null then 0 else m./cwm/kuuml end AS /cwm/kuuml,
  case when m./cwm/kuvla is null then 0 else m./cwm/kuvla end AS /cwm/kuvla,
  case when m./cwm/kuvin is null then 0 else m./cwm/kuvin end AS /cwm/kuvin,
  case when m./cwm/kuvei is null then 0 else m./cwm/kuvei end AS /cwm/kuvei
FROM msku AS t
;