I_BusEvtLogUserContactCard

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_BusEvtLogUserContactCard.
-- 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.

CREATE VIEW I_BusEvtLogUserContactCard AS
SELECT
  _User.UserID AS ContactCardID,
  _User.AddressPersonID AS Person,
  _AddressPersonName.GivenName AS FirstName,
  _AddressPersonName.FamilyName AS LastName,
  case when _AddressPersonName.PersonFullName is null or _AddressPersonName.PersonFullName is initial then _User.UserDescription else _AddressPersonName.PersonFullName end as FullName AS PersonFullNameendasFullName,
  cast(_User.UserDescription as ad_namtext preserving type) AS UserDescription,
  _User.AddressID AS AddressID,
  cast(_DefaultPhoneNumber.InternationalPhoneNumber as bel_contact_card_phone_number preserving type ) AS PhoneNumber,
  cast(_DefaultMobilePhoneNumber.InternationalPhoneNumber as bel_contact_card_mbl_ph_number preserving type ) AS MobilePhoneNumber,
  cast(_DefaultFaxNumber.InternationalFaxNumber as telfx ) AS FaxNumber,
  cast(_DefaultEmailAddress.EmailAddress as bel_contact_card_email_address preserving type ) AS EmailAddress,
  _OrgData.WorkplaceDepartmentName AS Department,
  _OrgData.WorkplaceFunctionalTitleName AS FunctionalTitleName,
  cast('Creator' as bel_contact_card_role) AS ContactCardRole,
  cast('User' as bel_contact_card_type) AS ContactCardType,
  'User' AS ContactCardNavLinkSemanticObj,
  concat('User=', _User.UserID) AS ContactCardNavLinkQueryPart
FROM I_User AS _User
LEFT OUTER JOIN I_AddressWorkplaceDetails AS _OrgData ON _OrgData.AddressID = AddressID AND _OrgData.AddressPersonID = Person  -- association [0..1]
LEFT OUTER JOIN I_AddressPhoneNumber_2 AS _DefaultPhoneNumber ON _DefaultPhoneNumber.AddressID = AddressID AND _DefaultPhoneNumber.AddressPersonID = Person AND _DefaultPhoneNumber.PhoneNumberType = '1'  -- association [0..1]
LEFT OUTER JOIN I_AddressFaxNumber_2 AS _DefaultFaxNumber ON _DefaultFaxNumber.AddressID = AddressID AND _DefaultFaxNumber.AddressPersonID = Person AND _DefaultFaxNumber.FaxNumberIsCurrentDefault = 'X'  -- association [0..1]
LEFT OUTER JOIN I_AddressPhoneNumber_2 AS _DefaultMobilePhoneNumber ON _DefaultMobilePhoneNumber.AddressID = AddressID AND _DefaultMobilePhoneNumber.AddressPersonID = Person AND _DefaultMobilePhoneNumber.PhoneNumberType = '3'  -- association [0..1]
LEFT OUTER JOIN I_AddressEmailAddress_2 AS _DefaultEmailAddress ON _DefaultEmailAddress.AddressID = AddressID AND _DefaultEmailAddress.AddressPersonID = Person AND _DefaultEmailAddress.EmailAddressIsCurrentDefault = 'X'  -- association [0..1]
;