S_SESUsersToAuthProfile

DDL: S_SESUSERSTOAUTHPROFILE SQL: SSESUSERAUTH Type: view Package: ODATA_MM_COMMONS_VH_WFL
1 Fields 2 Data Sources

Service Entry Sheet User to Authorization Profile

S_SESUsersToAuthProfile is a CDS View that provides data about "Service Entry Sheet User to Authorization Profile" in SAP S/4HANA. It reads from 2 data sources (S_MyInboxUser, S_SESAuthUser) and exposes 1 field. Part of development package ODATA_MM_COMMONS_VH_WFL.

Data Sources (2)

SourceAliasJoin Type
S_MyInboxUser _MyInboxAuth inner
S_SESAuthUser _SESAuth from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName SSESUSERAUTH view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Service Entry Sheet User to Authorization Profile view

Fields (1)

KeyFieldSource TableSource FieldDescription
UserID S_SESAuthUser UserID User Name

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 S_SESUsersToAuthProfile.
-- 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: SSESUSERAUTH

CREATE VIEW S_SESUsersToAuthProfile AS
SELECT
  _SESAuth.UserID AS UserID
FROM S_SESAuthUser AS _SESAuth
INNER JOIN S_MyInboxUser AS _MyInboxAuth ON /* join condition not captured in parsed metadata */
;

Learn More