ICM_PARTNER_PERSON

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 ICM_PARTNER_PERSON.
-- 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: ICM_PARTNER_PERS

CREATE VIEW ICM_PARTNER_PERSON AS
SELECT
  b00.partner AS partner,
  ac.addrnumber AS addrnumber,
  ac.nation AS nation,
  a2.consnumber AS consnumber,
  a6.consnumber AS consnumber_1,
  b00.type AS type,
  b00.persnumber AS persnumber,
  b00.augrp AS augrp,
  b00.name_first AS name_first,
  b00.name_last AS name_last,
  ac.city1 AS city1,
  ac.post_code1 AS post_code1,
  ac.post_code2 AS post_code2,
  ac.po_box AS po_box,
  ac.street AS street,
  ac.house_num1 AS house_num1,
  ac.country AS country,
  ac.region AS region,
  a2.telnr_long AS telnr_long,
  a6.smtp_addr AS smtp_addr,
  ad.comp_pers AS comp_pers
FROM but000 AS b00
INNER JOIN adcp AS ad ON /* join condition not captured in parsed metadata */
INNER JOIN adrc AS ac ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adr2 AS a2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adr6 AS a6 ON /* join condition not captured in parsed metadata */
;