I_Somi_Usr_Identity

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_Somi_Usr_Identity.
-- 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: ISOMI_USR_IDEN

CREATE VIEW I_Somi_Usr_Identity AS
SELECT
  identity.dataprovidername AS SocialDataProviderName,
  identity.useridindataprovider AS UserIdInSocialDataProvider,
  identity.counter AS SocialMediaIdentityCounter,
  identity.socialmediachannel AS SocialMediaChannel,
  identity.socialuser AS SocialUserID,
  identity.isloginidentity AS IsLogInSocialMediaIdentity,
  identity.nickname AS NickName,
  identity.isallowedforlogin AS IsAllowedForLogIn,
  identity.isexpiredsession AS IsExpiredSession,
  identity.lastlogintimestamp_utc AS LastLogInTimeStampUTC,
  identity.photourl AS SocialMediaProfilePhotoURL,
  identity.thumbnailurl AS SocialMediaProfileThumbnailURL,
  identity.firstname AS FirstName,
  identity.lastname AS LastName,
  identity.gender AS GenderCode,
  identity.age AS AgeOfSocialUser,
  identity.birthday AS DayOfBirth,
  identity.birthmonth AS MonthOfBirth,
  identity.birthyear AS YearOfBirth,
  identity.email AS EmailIDOfSocialUser,
  identity.countrycode AS CountryCode,
  identity.state AS RegionName,
  identity.city AS CityName,
  identity.zip AS PostalCode,
  identity.profileurl AS SocialMediaProfileURL,
  identity.proxiedemail AS ProxyEmailAddress,
  identity.address AS AddressText,
  identity.languages AS LanguagesKnownBySocialUser,
  identity.professionalheadline AS ProfessionalHeadLine,
  identity.bio AS BiographyOfSocialUser,
  identity.industry AS IndustryName,
  identity.specialities AS SocialUserSpecializationInfo,
  identity.religion AS Religion,
  identity.politicalview AS PoliticalView,
  identity.interestedin AS InterestedIn,
  identity.relationshipstatus AS RelationshipStatusText,
  identity.hometown AS HomeTown,
  identity.followerscount AS FollowersCountOfSocialUser,
  identity.followingcount AS SocialUserFollowingCount,
  identity.username AS SocialMediaUserName,
  identity.locale AS LocaleLanguage,
  identity.isverified AS IsVerifiedSocialProfile,
  identity.usertimezone AS SocialUserTimeZone
FROM smi_usr_identity AS identity
LEFT OUTER JOIN I_Somi_Usr_Education AS _Somi_Usr_Education ON identity.dataprovidername = _Somi_Usr_Education.SocialDataProviderName AND identity.useridindataprovider = _Somi_Usr_Education.UserIdInSocialDataProvider  -- association [0..*]
LEFT OUTER JOIN I_Somi_Usr_Profile AS _Somi_Usr_Profile ON identity.dataprovidername = _Somi_Usr_Profile.SocialDataProviderName AND identity.useridindataprovider = _Somi_Usr_Profile.UserIdInSocialDataProvider  -- association [0..1]
LEFT OUTER JOIN I_Somi_Usr_Likes AS _Somi_Usr_Likes ON identity.dataprovidername = _Somi_Usr_Likes.SocialDataProviderName AND identity.useridindataprovider = _Somi_Usr_Likes.UserIdInSocialDataProvider  -- association [0..*]
LEFT OUTER JOIN I_Somi_Usr_Workexp AS _Somi_Usr_Workexp ON identity.dataprovidername = _Somi_Usr_Workexp.SocialDataProviderName AND identity.useridindataprovider = _Somi_Usr_Workexp.UserIdInSocialDataProvider  -- association [0..*]
LEFT OUTER JOIN I_Somi_Usr_Phone AS _Somi_Usr_Phone ON identity.dataprovidername = _Somi_Usr_Phone.SocialDataProviderName AND identity.useridindataprovider = _Somi_Usr_Phone.UserIdInSocialDataProvider  -- association [0..*]
LEFT OUTER JOIN I_Somi_Usr_Publications AS _Somi_Usr_Publications ON identity.dataprovidername = _Somi_Usr_Publications.SocialDataProviderName AND identity.useridindataprovider = _Somi_Usr_Publications.UserIdInSocialDataProvider  -- association [0..*]
LEFT OUTER JOIN I_Somi_Usr_Certification AS _Somi_Usr_Certification ON identity.dataprovidername = _Somi_Usr_Certification.SocialDataProviderName AND identity.useridindataprovider = _Somi_Usr_Certification.UserIdInSocialDataProvider  -- association [0..*]
LEFT OUTER JOIN I_Somi_Usr_Patent AS _Somi_Usr_Patent ON identity.dataprovidername = _Somi_Usr_Patent.SocialDataProviderName AND identity.useridindataprovider = _Somi_Usr_Patent.UserIdInSocialDataProvider  -- association [0..*]
LEFT OUTER JOIN I_Somi_Usr_Favorite AS _Somi_Usr_Favorite ON identity.dataprovidername = _Somi_Usr_Favorite.SocialDataProviderName AND identity.useridindataprovider = _Somi_Usr_Favorite.UserIdInSocialDataProvider  -- association [0..*]
LEFT OUTER JOIN I_Somi_Usr_Skill AS _Somi_Usr_Skill ON identity.dataprovidername = _Somi_Usr_Skill.SocialDataProviderName AND identity.useridindataprovider = _Somi_Usr_Skill.UserIdInSocialDataProvider  -- association [0..*]
LEFT OUTER JOIN I_Somi_Usr_Custom AS _Somi_Usr_Custom ON identity.dataprovidername = _Somi_Usr_Custom.SocialDataProviderName AND identity.useridindataprovider = _Somi_Usr_Custom.UserIdInSocialDataProvider  -- association [0..*]
;