I_UserContactCard

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_UserContactCard.
-- 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: IUSERCTC

CREATE VIEW I_UserContactCard AS
SELECT
  _User.bname AS ContactCardID,
  _User.persnumber AS Person,
  _User.bpperson AS BusinessPartnerUUID,
  _Person.name_first AS FirstName,
  _Person.name_last AS LastName,
  cast(coalesce( _Person.name_text , _User.techdesc ) as ad_namtext preserving type ) AS FullName,
  cast( _User.techdesc as vdm_userdescription preserving type ) AS UserDescription,
  _User.addrnumber AS AddressID,
  cast(_DefaultPhoneNumber.telnr_long as contactcardphonenumber preserving type ) AS PhoneNumber,
  cast(_DefaultMobilePhoneNumber.telnr_long as contactcardmobilephonenumber preserving type ) AS MobilePhoneNumber,
  cast(_DefaultFaxNumber.faxnr_long as contactcardfaxnumber preserving type ) AS FaxNumber,
  cast(_DefaultEmailAddress.smtp_addr as contactcardemailaddress preserving type ) AS EmailAddress,
  _OrgData.department AS Department,
  _OrgData.function AS FunctionalTitleName,
  'Creator' AS ContactCardRole,
  'User' AS ContactCardType,
  'User' AS ContactCardNavLinkSemanticObj,
  concat('User=', _User.bname) AS ContactCardNavLinkQueryPart
FROM usr21 AS _User
LEFT OUTER JOIN adrp AS _Person ON _Person.persnumber = Person AND _Person.persnumber <> '' AND _Person.nation = ''  -- association [0..1]
LEFT OUTER JOIN adcp AS _OrgData ON _OrgData.addrnumber = AddressID AND _OrgData.persnumber = Person  -- association [0..1]
LEFT OUTER JOIN adr2 AS _DefaultPhoneNumber ON _DefaultPhoneNumber.addrnumber = AddressID AND _DefaultPhoneNumber.persnumber = Person AND _DefaultPhoneNumber.r3_user = '1'  -- association [0..1]
LEFT OUTER JOIN adr3 AS _DefaultFaxNumber ON _DefaultFaxNumber.addrnumber = AddressID AND _DefaultFaxNumber.persnumber = Person AND flgdefault = 'X'  -- association [0..1]
LEFT OUTER JOIN adr2 AS _DefaultMobilePhoneNumber ON _DefaultMobilePhoneNumber.addrnumber = AddressID AND _DefaultMobilePhoneNumber.persnumber = Person AND _DefaultMobilePhoneNumber.r3_user = '3'  -- association [0..1]
LEFT OUTER JOIN adr6 AS _DefaultEmailAddress ON _DefaultEmailAddress.addrnumber = AddressID AND _DefaultEmailAddress.persnumber = Person AND _DefaultEmailAddress.flgdefault = 'X'  -- association [0..1]
;