I_SuplrContactCard

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 I_SuplrContactCard.
-- 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: ISUPLRCC

CREATE VIEW I_SuplrContactCard AS
SELECT
  _Supplier.lifnr AS ContactCardID,
  'Supplier' AS ContactCardRole,
  'Supplier' AS ContactCardType,
  _Supplier.name1 AS FullName,
  _Supplier.adrnr AS AddressID,
  cast(_DefaultPhoneNumber.telnr_long as contactcardphonenumber) AS PhoneNumber,
  cast(_DefaultMobilePhoneNumber.telnr_long as contactcardmobilephonenumber) AS MobilePhoneNumber,
  cast(_DefaultEmailAddress.smtp_addr as contactcardemailaddress) AS EmailAddress,
  'Supplier' AS ContactCardNavLinkSemanticObj,
  concat('Supplier=', _Supplier.lifnr) AS ContactCardNavLinkQueryPart,
  _Supplier.ktokk AS SupplierAccountGroup,
  _Supplier.begru AS AuthorizationGroup,
  _Supplier.cvp_xblck AS IsBusinessPurposeCompleted,
  _Supplier.ort01 AS CityName,
  _Supplier.pstlz AS PostalCode,
  _Supplier.stras AS StreetName,
  _Supplier.land1 AS Country,
  _Supplier.data_ctrlr1 AS DataController1,
  _Supplier.data_ctrlr2 AS DataController2,
  _Supplier.data_ctrlr3 AS DataController3,
  _Supplier.data_ctrlr4 AS DataController4,
  _Supplier.data_ctrlr5 AS DataController5,
  _Supplier.data_ctrlr6 AS DataController6,
  _Supplier.data_ctrlr7 AS DataController7,
  _Supplier.data_ctrlr8 AS DataController8,
  _Supplier.data_ctrlr9 AS DataController9,
  _Supplier.data_ctrlr10 AS DataController10,
  _Supplier.xdcset AS DataControllerSet
FROM lfa1 AS _Supplier
LEFT OUTER JOIN adr2 AS _DefaultPhoneNumber ON _DefaultPhoneNumber.addrnumber = AddressID AND _DefaultPhoneNumber.persnumber = ' ' AND _DefaultPhoneNumber.r3_user = '1'  -- association [0..1]
LEFT OUTER JOIN adr2 AS _DefaultMobilePhoneNumber ON _DefaultMobilePhoneNumber.addrnumber = AddressID AND _DefaultMobilePhoneNumber.persnumber = ' ' AND _DefaultMobilePhoneNumber.r3_user = '3'  -- association [0..1]
LEFT OUTER JOIN adr6 AS _DefaultEmailAddress ON _DefaultEmailAddress.addrnumber = AddressID AND _DefaultEmailAddress.persnumber = ' ' AND _DefaultEmailAddress.flgdefault = 'X'  -- association [0..1]
;