C_PublicSectorBRFMessageTP

DDL: C_PUBLICSECTORBRFMESSAGETP SQL: CPUBSECBRFMSGTP Type: view CONSUMPTION
28 Fields 1 Data Sources 3 Associations

BRF Message Transactional Processing

C_PublicSectorBRFMessageTP is a Consumption CDS View that provides data about "BRF Message Transactional Processing" in SAP S/4HANA. It reads from 1 data source (I_PublicSectorBRFMessageTP) and exposes 28 fields with key fields SystemMessageIdentification, SystemMessageNumber, PublicSectorFormBundleUUID, PubSecMessageIssuingObject, PublicSectorFormFieldName. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PublicSectorBRFMessageTP I_PublicSectorBRFMessageTP from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_PublicSectorFormBundleTP _FormBundle $projection.PublicSectorFormBundleUUID = _FormBundle.PublicSectorFormBundleUUID
[0..1] P_PubSecBRFMessageIdn _BRFMessageIdn $projection.PublicSectorFormBundleUUID = _BRFMessageIdn.PublicSectorFormBundleUUID and $projection.SystemMessageIdentification = _BRFMessageIdn.SystemMessageIdentification and $projection.SystemMessageNumber = _BRFMessageIdn.SystemMessageNumber and $projection.PubSecMessageIssuingObject = _BRFMessageIdn.PubSecMessageIssuingObject and $projection.PublicSectorFormFieldName = _BRFMessageIdn.PublicSectorFormFieldName and $projection.PubSecMsgIssuingFormLine = _BRFMessageIdn.PubSecMsgIssuingFormLine and $projection.PublicSectorBRFMessageUUID = _BRFMessageIdn.PublicSectorBRFMessageUUID
[0..1] I_UserContactCard _CreatedByUserContact $projection.CreatedByUser = _CreatedByUserContact.ContactCardID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPUBSECBRFMSGTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view
EndUserText.label BRF Message Transactional Processing view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY SystemMessageIdentification SystemMessageIdentification Message ID
KEY SystemMessageNumber SystemMessageNumber Message Number
KEY PublicSectorFormBundleUUID PublicSectorFormBundleUUID
KEY PubSecMessageIssuingObject PubSecMessageIssuingObject
KEY PublicSectorFormFieldName PublicSectorFormFieldName
KEY PubSecMsgIssuingFormLine PubSecMsgIssuingFormLine
KEY PublicSectorBRFMessageUUID PublicSectorBRFMessageUUID
SystemMessageType SystemMessageType Message type
SystemMessageVariable1 SystemMessageVariable1 Variable 1
SystemMessageVariable2 SystemMessageVariable2 Variable 2
SystemMessageVariable3 SystemMessageVariable3 Variable 3
SystemMessageVariable4 SystemMessageVariable4 Variable 4
CreationDate CreationDate Time Stamp
LastChangeDate LastChangeDate Time Stamp
CreationTime CreationTime Time of Change
LastChangeTime LastChangeTime Time changed
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
PublicSectorMessageStatus PublicSectorMessageStatus
SystemMessageText SystemMessageText Message Text
SystemMessageTypeCriticality _BRFMessageIdn SystemMessageTypeCriticality
PublicSectorFormDescription PublicSectorFormDescription
_FormBundle _FormBundle
_MessageStatus _MessageStatus
_MessageType _MessageType
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_CreatedByUserContact _CreatedByUserContact

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_PublicSectorBRFMessageTP.
-- 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: CPUBSECBRFMSGTP

CREATE VIEW C_PublicSectorBRFMessageTP AS
SELECT
  SystemMessageIdentification,
  SystemMessageNumber,
  PublicSectorFormBundleUUID,
  PubSecMessageIssuingObject,
  PublicSectorFormFieldName,
  PubSecMsgIssuingFormLine,
  PublicSectorBRFMessageUUID,
  SystemMessageType,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  CreationDate,
  LastChangeDate,
  CreationTime,
  LastChangeTime,
  CreatedByUser,
  LastChangedByUser,
  PublicSectorMessageStatus,
  SystemMessageText,
  _BRFMessageIdn.SystemMessageTypeCriticality AS SystemMessageTypeCriticality,
  PublicSectorFormDescription
FROM I_PublicSectorBRFMessageTP
LEFT OUTER JOIN C_PublicSectorFormBundleTP AS _FormBundle ON PublicSectorFormBundleUUID = _FormBundle.PublicSectorFormBundleUUID  -- association [1..1]
LEFT OUTER JOIN P_PubSecBRFMessageIdn AS _BRFMessageIdn ON PublicSectorFormBundleUUID = _BRFMessageIdn.PublicSectorFormBundleUUID AND SystemMessageIdentification = _BRFMessageIdn.SystemMessageIdentification AND SystemMessageNumber = _BRFMessageIdn.SystemMessageNumber AND PubSecMessageIssuingObject = _BRFMessageIdn.PubSecMessageIssuingObject AND PublicSectorFormFieldName = _BRFMessageIdn.PublicSectorFormFieldName AND PubSecMsgIssuingFormLine = _BRFMessageIdn.PubSecMsgIssuingFormLine AND PublicSectorBRFMessageUUID = _BRFMessageIdn.PublicSectorBRFMessageUUID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContact ON CreatedByUser = _CreatedByUserContact.ContactCardID  -- association [0..1]
;

Learn More