I_MobileApplicationUser

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_MobileApplicationUser.
-- 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_MobileApplicationUser AS
SELECT
  user_guid AS MobileUserInternal,
  device_id AS MobileUserDeviceInternal,
  device_user_id AS MobileUserDeviceUser,
  server_id AS MobileUserServerInternal,
  mobile_app AS MobileUserApplication,
  group_id AS MobileUserGroupInternal,
  sap_userid AS MobileUser,
  _User.UserDescription AS MaintMobileApplicationUserName,
  last_sess_guid AS MobileUserLastSessionInternal,
  lock_flag AS MobileUserIsLocked,
  no_valid_role AS MobileUserProductRoleIsValid,
  source_system AS MobileUserLogicalSystem,
  smtp_addr AS MobileUserEmailAddress,
  http_addr AS MobileUserWebAddress,
  default_addr AS MobileUserDefaultAddressType,
  _DefaultAddressTypeText[Language = $session.system_language].MntMblAppUsrDfltAddrTypeName AS MntMblAppUsrDfltAddrTypeName,
  created_by AS MobileUserCreatedBy,
  created_ts AS MobileUserCreationDateTime,
  changed_by AS MobileUserChangedBy,
  changed_ts AS MobileUserChangeDateTime,
  tstmp_to_dats( created_ts, abap_system_timezone( $session.client, 'NULL' ), $session.client, 'NULL' ) as CreationDate AS clientNULLasCreationDate
FROM /syclo/mdw00
LEFT OUTER JOIN I_User AS _User ON _User.UserID = MobileUser  -- association [1..1]
LEFT OUTER JOIN I_MntMblAppUsrDfltAddrTypeText AS _DefaultAddressTypeText ON _DefaultAddressTypeText.MobileUserDefaultAddressType = MobileUserDefaultAddressType  -- association [0..*]
;