I_RSHMessageType

DDL: I_RSHMESSAGETYPE SQL: IRSHMSGTYP Type: view BASIC
3 Fields 1 Data Sources

Message Type

I_RSHMessageType is a Basic CDS View that provides data about "Message Type" in SAP S/4HANA. It reads from 1 data source (I_RSHGetDomainText) and exposes 3 fields with key field SystemMessageType.

Data Sources (1)

SourceAliasJoin Type
I_RSHGetDomainText I_RSHGetDomainText from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IRSHMSGTYP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey SystemMessageType view
EndUserText.label Message Type view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SystemMessageType Lower Value
SystemMessageTypeCriticality DomainText Short Description
SystemMessageTypeName

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_RSHMessageType.
-- 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: IRSHMSGTYP

CREATE VIEW I_RSHMessageType AS
SELECT
  cast(DomainValue as char1) AS SystemMessageType,
  DomainText AS SystemMessageTypeCriticality,
  concat(DomainText, ' Message') AS SystemMessageTypeName
FROM I_RSHGetDomainText
;

Learn More