NSDM_E_MSFD

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

CREATE VIEW NSDM_E_MSFD AS
SELECT
  m.mandt AS mandt,
  m.matnr AS matnr,
  m.werks AS werks,
  m.charg AS charg,
  m.sobkz AS sobkz,
  m.lifnr AS lifnr,
  m.vbeln AS vbeln,
  m.posnr AS posnr,
  m.fdspr AS fdspr,
  case when t.fdlab is null then 0 else t.fdlab end AS fdlab,
  case when t.fdins is null then 0 else t.fdins end AS fdins,
  case when t.fdvla is null then 0 else t.fdvla end AS fdvla,
  case when t.fdvin is null then 0 else t.fdvin end AS fdvin,
  m.fdill AS fdill,
  m.fdilq AS fdilq,
  m.fdvll AS fdvll,
  m.fdvlq AS fdvlq,
  m.fdfll AS fdfll,
  m.fdflq AS fdflq,
  m.fddll AS fddll,
  case when t.fdein is null then 0 else t.fdein end AS fdein,
  case when t.fdvei is null then 0 else t.fdvei end AS fdvei,
  m.ersda AS ersda,
  m.fdjin AS fdjin,
  'X' AS fdrue
FROM msfd_md AS m
;