NSDM_DDL_CHK_MAT_MASTER

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_DDL_CHK_MAT_MASTER.
-- 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_CHK_MD_MM

CREATE VIEW NSDM_DDL_CHK_MAT_MASTER AS
SELECT
  matbf,
  m.werks AS werks,
  lgort_sid,
  charg_sid,
  lifnr_sid,
  mat_kdauf,
  mat_kdpos,
  mat_pspnr,
  kunnr_sid,
  m.sobkz AS sobkz,
  max( m.gjper ) AS gjper,
  '' AS icon,
  'MARC' as master_table AS lgortmatbf,
  'MARD' as master_table AS chargmatbf,
  'MCHB' as master_table AS sobkzmatbf,
  'MSLB' as master_table AS pspnrmatbf,
  'MCH1' AS master_table
FROM matdoc_extract AS m
LEFT OUTER JOIN v_marc_md AS s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_mard_md AS s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_mchb_md AS s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_mska_md AS s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_msku_md AS s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_mkol_md AS s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_mslb_md AS s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_mspr_md AS s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN msrd_md AS s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN msfd_md AS s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mcha AS s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mch1 AS s ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): matdoc_extract
;