/AIF/C_MsgProSta

DDL: /AIF/C_MSGPROSTA SQL: /AIF/CMSGPROSTA Type: view_entity CONSUMPTION Package: /AIF/MONITORING_CDS
9 Fields 1 Data Sources 1 OData Services

Message Process Status

/AIF/C_MsgProSta is a Consumption CDS View that provides data about "Message Process Status" in SAP S/4HANA. It reads from 1 data source (/AIF/I_MsgProSta) and exposes 9 fields with key fields MessageGuid, Namespace, InterfaceName, InterfaceVersion. It is exposed through 1 OData service (/AIF/MESSAGEMONITOR). Part of development package /AIF/MONITORING_CDS.

Data Sources (1)

SourceAliasJoin Type
/AIF/I_MsgProSta MsgProSta from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Message Process Status view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
/AIF/MESSAGEMONITOR /AIF/MSGMONITORING_CDS V4 C1 NOT_RELEASED

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MessageGuid
KEY Namespace /AIF/I_MsgProSta ns Namespace
KEY InterfaceName /AIF/I_MsgProSta ifname Interface Name
KEY InterfaceVersion /AIF/I_MsgProSta ifver Interface Version
Processor /AIF/I_MsgProSta assigned_processor Processor
Status /AIF/I_MsgProSta assigned_process_status Processing Status
CreatedUser /AIF/I_MsgProSta create_user User Name
ProcessingTime /AIF/I_MsgProSta processing_time Value
assigned_processorendasFormattedName

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 /AIF/C_MsgProSta.
-- 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: /AIF/CMSGPROSTA

CREATE VIEW /AIF/C_MsgProSta AS
SELECT
  cast(MsgProSta.msgguid as abap.char(32)) AS MessageGuid,
  MsgProSta.ns AS Namespace,
  MsgProSta.ifname AS InterfaceName,
  MsgProSta.ifver AS InterfaceVersion,
  MsgProSta.assigned_processor AS Processor,
  MsgProSta.assigned_process_status AS Status,
  MsgProSta.create_user AS CreatedUser,
  MsgProSta.processing_time AS ProcessingTime,
  case when MsgProSta.UserDescription is not null and MsgProSta.UserDescription <> '' then MsgProSta.UserDescription else MsgProSta.assigned_processor end as FormattedName AS assigned_processorendasFormattedName
FROM /AIF/I_MsgProSta AS MsgProSta
;

Learn More