NSDM_E_MSRD

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

CREATE VIEW NSDM_E_MSRD 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.pspnr AS pspnr,
  m.rdspr AS rdspr,
  case when t.rdlab is null then 0 else t.rdlab end AS rdlab,
  case when t.rdins is null then 0 else t.rdins end AS rdins,
  case when t.rdvla is null then 0 else t.rdvla end AS rdvla,
  case when t.rdvin is null then 0 else t.rdvin end AS rdvin,
  m.rdill AS rdill,
  m.rdilq AS rdilq,
  m.rdvll AS rdvll,
  m.rdvlq AS rdvlq,
  m.rdfll AS rdfll,
  m.rdflq AS rdflq,
  m.rddll AS rddll,
  case when t.rdein is null then 0 else t.rdein end AS rdein,
  case when t.rdvei is null then 0 else t.rdvei end AS rdvei,
  m.ersda AS ersda,
  m.rdjin AS rdjin,
  'X' AS rdrue
FROM msrd_md AS m
;