SHSM_V_BUT020_I

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 SHSM_V_BUT020_I.
-- 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: SHSMVBUT020I

CREATE VIEW SHSM_V_BUT020_I AS
SELECT
  but000.mc_name1 AS mc_name1,
  but000.mc_name2 AS mc_name2,
  adrc.mc_city1 AS mc_city1,
  adrc.mc_street AS mc_street,
  but000.partner AS partner,
  but000.augrp AS augrp,
  but100.rltyp AS rltyp,
  but0bk.iban AS iban,
  but000.xpcpt AS xpcpt,
  but000.xdcset AS xdcset,
  but000.data_ctrlr1 AS data_ctrlr1,
  but000.data_ctrlr2 AS data_ctrlr2,
  but000.data_ctrlr3 AS data_ctrlr3,
  but000.data_ctrlr4 AS data_ctrlr4,
  but000.data_ctrlr5 AS data_ctrlr5,
  but000.data_ctrlr6 AS data_ctrlr6,
  but000.data_ctrlr7 AS data_ctrlr7,
  but000.data_ctrlr8 AS data_ctrlr8,
  but000.data_ctrlr9 AS data_ctrlr9,
  but000.data_ctrlr10 AS data_ctrlr10
FROM but020
;