/AIF/C_MsgComment

DDL: /AIF/C_MSGCOMMENT SQL: /AIF/CMSGCOMMENT Type: view_entity CONSUMPTION
8 Fields 1 Data Sources

Data message comments

/AIF/C_MsgComment is a Consumption CDS View that provides data about "Data message comments" in SAP S/4HANA. It reads from 1 data source (/AIF/I_MsgComment) and exposes 8 fields with key fields Namespace, InterfaceName, InterfaceVersion, MessageGuid, Counter.

Data Sources (1)

SourceAliasJoin Type
/AIF/I_MsgComment MsgComment from

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Search.searchable true view
EndUserText.label Data message comments view
VDM.viewType #CONSUMPTION view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Namespace /AIF/I_MsgComment ns Namespace
KEY InterfaceName /AIF/I_MsgComment ifname Interface Name
KEY InterfaceVersion /AIF/I_MsgComment ifver Interface Version
KEY MessageGuid
KEY Counter /AIF/I_MsgComment counter Version
Note /AIF/I_MsgComment note TradeRequest Comment
CreateUser /AIF/I_MsgComment create_user User Name
CreateTime /AIF/I_MsgComment processing_time Value

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_MsgComment.
-- 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/CMSGCOMMENT

CREATE VIEW /AIF/C_MsgComment AS
SELECT
  MsgComment.ns AS Namespace,
  MsgComment.ifname AS InterfaceName,
  MsgComment.ifver AS InterfaceVersion,
  cast(MsgComment.msgguid as abap.char(32)) AS MessageGuid,
  MsgComment.counter AS Counter,
  MsgComment.note AS Note,
  MsgComment.create_user AS CreateUser,
  MsgComment.processing_time AS CreateTime
FROM /AIF/I_MsgComment AS MsgComment
;

Learn More