P_MDChgProcSuplrValnWthBusPart

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 P_MDChgProcSuplrValnWthBusPart.
-- 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: PMDCSUPLVALNBPNO

CREATE VIEW P_MDChgProcSuplrValnWthBusPart AS
SELECT
  but000.partner AS source_id,
  ausp.atzhl AS atzhl,
  ausp.mafid AS mafid,
  ausp.klart AS klart,
  ausp.adzhl AS adzhl,
  ausp.source_atinn AS source_atinn,
  ausp.atwrt AS atwrt,
  ausp.atflv AS atflv,
  ausp.atawe AS atawe,
  ausp.atflb AS atflb,
  ausp.ataw1 AS ataw1,
  ausp.atcod AS atcod,
  ausp.attlv AS attlv,
  ausp.attlb AS attlb,
  ausp.atprz AS atprz,
  ausp.atinc AS atinc,
  ausp.ataut AS ataut,
  ausp.aennr AS aennr,
  ausp.datuv AS datuv,
  ausp.lkenz AS lkenz,
  ausp.atimb AS atimb,
  ausp.atzis AS atzis,
  ausp.atsrt AS atsrt,
  ausp.atvglart AS atvglart,
  ausp.datub AS datub,
  cabn.atnam AS atnam,
  ausp.atinn AS atinn
FROM but000
INNER JOIN cvi_vend_link AS vend_link ON /* join condition not captured in parsed metadata */
INNER JOIN lfa1 ON /* join condition not captured in parsed metadata */
INNER JOIN P_MDChgProcSuplrValn AS ausp ON /* join condition not captured in parsed metadata */
INNER JOIN cabn ON /* join condition not captured in parsed metadata */
INNER JOIN mdg_mlt_assgmnt AS mlt_assmnt ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): but000
;