SEPMRA_C_SalesOrderReviser

DDL: SEPMRA_C_SALESORDERREVISER Type: view Package: S_ODATA_EPMRA_SO_MAN
6 Fields 1 Data Sources

User

SEPMRA_C_SalesOrderReviser is a CDS View that provides data about "User" in SAP S/4HANA. It reads from 1 data source (SEPMRA_I_Employee) and exposes 6 fields. Part of development package S_ODATA_EPMRA_SO_MAN.

Data Sources (1)

SourceAliasJoin Type
SEPMRA_I_Employee SEPMRA_I_Employee from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SEPMRASOREVISER view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label User view
UI.headerInfo.typeName User view
UI.headerInfo.typeNamePlural Users view
UI.headerInfo.title.value UserID view
UI.headerInfo.description.value FullName view
UI.headerInfo.imageUrl EmployeePictureURL view

Fields (6)

KeyFieldSource TableSource FieldDescription
UserIDisrequiredasakeyfieldbytheBOmodel
makesureitisexposedkeySystemUserasUserID
FullName FullName Name
EmailAddress EmailAddress E-Mail Address
PhoneNumber PhoneNumber Telephone no.
EmployeePictureURL EmployeePictureURL

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 SEPMRA_C_SalesOrderReviser.
-- 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 SEPMRA_C_SalesOrderReviser AS
SELECT
  make sure it is exposed key SystemUser as UserID AS makesureitisexposedkeySystemUserasUserID,
  FullName,
  EmailAddress,
  PhoneNumber,
  EmployeePictureURL
FROM SEPMRA_I_Employee
;

Learn More