C_EDocMsg

DDL: C_EDOCMSG Type: view_entity CONSUMPTION
17 Fields 1 Data Sources 1 Associations

eDocument Inbound message Processing

C_EDocMsg is a Consumption CDS View that provides data about "eDocument Inbound message Processing" in SAP S/4HANA. It reads from 1 data source (R_EDocMsgTP) and exposes 17 fields with key field EDocMessageUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_EDocMsgTP R_EDocMsgTP projection

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_EDocMsgCriticality _StatusCriticality $projection.EDocMessageUUID = _StatusCriticality.EDocMessageUUID

Annotations (11)

NameValueLevelField
EndUserText.label eDocument Inbound message Processing view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions false view
UI.headerInfo.typeNamePlural Messages view
UI.headerInfo.typeName Inbound Message view
UI.headerInfo.title.value EDocMessageName view
UI.headerInfo.description.value ElectronicDocMessageType view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY EDocMessageUUID EDocMessageUUID
EDocMessageName EDocMessageName
ElectronicDocMessageType ElectronicDocMessageType
EDocMsgCompanyCode EDocMsgCompanyCode
CompanyCodeName _CompanyCode CompanyCodeName Company Name
EDocMsgReceivedAtDateTime EDocMsgReceivedAtDateTime Creation Date and Time
EDocMessageCountry EDocMessageCountry
CountryName
EDocMessageStatus EDocMessageStatus Status Description
EDocMessageStatusText
EDocMessageChangeDate EDocMessageChangeDate Changed Date
EDocMessageChangeTime EDocMessageChangeTime Changed Time
ElectronicDocType ElectronicDocType
EDocMessageChangedByUser EDocMessageChangedByUser
ElectronicDocUUID ElectronicDocUUID
_StatusCriticality _StatusCriticality
_Status _Status

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 C_EDocMsg.
-- 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 C_EDocMsg AS
SELECT
  EDocMessageUUID,
  EDocMessageName,
  ElectronicDocMessageType,
  EDocMsgCompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  EDocMsgReceivedAtDateTime,
  EDocMessageCountry,
  _Country._Text[1:Language = $session.system_language].CountryName AS CountryName,
  EDocMessageStatus,
  _Status._Text[1:Language = $session.system_language].EDocMessageStatusText AS EDocMessageStatusText,
  EDocMessageChangeDate,
  EDocMessageChangeTime,
  ElectronicDocType,
  EDocMessageChangedByUser,
  ElectronicDocUUID
FROM R_EDocMsgTP
LEFT OUTER JOIN C_EDocMsgCriticality AS _StatusCriticality ON EDocMessageUUID = _StatusCriticality.EDocMessageUUID  -- association [1..1]
;

Learn More