SHSM_FAP_SUPPLIER

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_FAP_SUPPLIER.
-- 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: SHSMFAPSUP

CREATE VIEW SHSM_FAP_SUPPLIER AS
SELECT
  lifnr,
  sortl,
  land1,
  pstlz,
  mcod3,
  mcod1,
  ktokk,
  ort01,
  name1,
  stcd1,
  stcd2,
  stcd3,
  stcd4,
  stcd5,
  stceg,
  begru,
  xdcset AS DataControllerSet,
  data_ctrlr1 AS DataController1,
  data_ctrlr2 AS DataController2,
  data_ctrlr3 AS DataController3,
  data_ctrlr4 AS DataController4,
  data_ctrlr5 AS DataController5,
  data_ctrlr6 AS DataController6,
  data_ctrlr7 AS DataController7,
  data_ctrlr8 AS DataController8,
  data_ctrlr9 AS DataController9,
  data_ctrlr10 AS DataController10
FROM lfa1
;