i_aps_iam_busr_rap_root

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_aps_iam_busr_rap_root.
-- 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_aps_iam_busr_rap_root AS
SELECT
  busr.UserID AS UserID,
  busr.UserName AS UserName,
  busr.GlobalUserID AS GlobalUserID,
  busr.FullName AS FullName,
  busr.FirstName AS FirstName,
  busr.LastName AS LastName,
  busr.WorkerID AS WorkerID,
  busr.PersonID AS PersonID,
  busr.EmailAddress AS EmailAddress,
  busr.PhoneNumber AS PhoneNumber,
  busr.Building AS Building,
  busr.Floor AS Floor,
  busr.Room AS Room,
  _Property.UserGroup AS UserGroup,
  _Property.PriceCategoryText AS PriceCategoryText,
  busr.ValidFrom AS ValidFrom,
  busr.ValidTo AS ValidTo,
  _Status.Valid AS Valid,
  _Status.ValidText AS ValidText,
  _Status.ValidTextHidden AS ValidTextHidden,
  _Status.Locked AS Locked,
  _Status.LockedText AS LockedText,
  _Status.LockedTextHidden AS LockedTextHidden,
  busr.LockStatus AS LockStatus,
  _Status.LoggedOn AS LoggedOn,
  _Status.LoggedOnText AS LoggedOnText,
  _Status.LoggedOnTextHidden AS LoggedOnTextHidden,
  _Codes.DecimalFormatID AS DecimalFormatID,
  _Codes.DecimalFormat AS DecimalFormat,
  _Codes.DateFormatID AS DateFormatID,
  _Codes.DateFormat AS DateFormat,
  _Codes.TimeZoneID AS TimeZoneID,
  _Codes.TimeZoneText AS TimeZoneText,
  _Codes.TimeFormatID AS TimeFormatID,
  _Codes.TimeFormat AS TimeFormat,
  _Codes.LanguageID AS LanguageID,
  _Codes.Language AS Language,
  _Count.BusinessRoleCount AS BusinessRoleCount,
  _Count.ApplicationJobCount AS ApplicationJobCount,
  _ModifyInfo.LastLogonDateTime AS LastLogonDateTime,
  _ModifyInfo.NeverLoggedOn AS NeverLoggedOn,
  _ModifyInfo.CreationUserName AS CreationUserName,
  _ModifyInfo.CreationDateTime AS CreationDateTime,
  _ModifyInfo.LastChangeUserName AS LastChangeUserName,
  _ModifyInfo.LastChangeDateTime AS LastChangeDateTime,
  busr.UserGroup AS UserGroupCheck,
  busr.RoleCategory AS RoleCategory,
  cast('' as boole_d preserving type) AS WorkerNavHidden,
  cast('X' as boole_d preserving type) AS WorkerNavWorkforcePersonHidden,
  cast('X' as boole_d preserving type) AS WorkerNavEmployeeHidden,
  cast('X' as boole_d preserving type) AS WorkerNavExtResourceHidden,
  '1' AS CriticalCodeError,
  '3' AS CriticalCodeSuccess
FROM aps_iam_busr_core AS busr
LEFT OUTER JOIN r_aps_iam_busr_rap_root_prop AS _Property ON _Property.UserID = UserID  -- association [0..1]
LEFT OUTER JOIN r_aps_iam_busr_rap_root_status AS _Status ON _Status.UserID = UserID  -- association [0..1]
LEFT OUTER JOIN r_aps_iam_busr_rap_root_codtxt AS _Codes ON _Codes.UserID = UserID  -- association [0..1]
LEFT OUTER JOIN r_aps_iam_busr_rap_root_count AS _Count ON _Count.UserID = UserID  -- association [0..1]
LEFT OUTER JOIN r_aps_iam_busr_rap_root_modify AS _ModifyInfo ON _ModifyInfo.UserID = UserID  -- association [0..1]
LEFT OUTER JOIN i_aps_iam_busr_rap_br AS _BusinessRoles ON /* condition not available in parsed metadata */  -- association [0..*]
;