I_PublicSectorBRFMessageTP

DDL: I_PUBLICSECTORBRFMESSAGETP SQL: IPUBSECBRFMSGTP Type: view TRANSACTIONAL
29 Fields 1 Data Sources 1 Associations

Public Sector BRF Message Object View

I_PublicSectorBRFMessageTP is a Transactional CDS View that provides data about "Public Sector BRF Message Object View" in SAP S/4HANA. It reads from 1 data source (I_PublicSectorBRFMessage) and exposes 29 fields with key fields SystemMessageIdentification, SystemMessageNumber, PublicSectorFormBundleUUID, PubSecMessageIssuingObject, PublicSectorFormFieldName. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PublicSectorBRFMessage I_PublicSectorBRFMessage from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PublicSectorFormBundleTP _FormBundle $projection.PublicSectorFormBundleUUID = _FormBundle.PublicSectorFormBundleUUID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IPUBSECBRFMSGTP view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence PSBRFMSGTP view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Public Sector BRF Message Object View view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY SystemMessageIdentification SystemMessageIdentification Message ID
KEY SystemMessageNumber SystemMessageNumber Message Number
KEY PublicSectorFormBundleUUID PublicSectorFormBundleUUID Case Key
KEY PubSecMessageIssuingObject PubSecMessageIssuingObject Permit Issued By
KEY PublicSectorFormFieldName PublicSectorFormFieldName VAT Declaration Fld
KEY PubSecMsgIssuingFormLine PubSecMsgIssuingFormLine Parameter line
KEY PublicSectorBRFMessageUUID PublicSectorBRFMessageUUID Msg GUID
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
PublicSectorFormDescription
BusinessObjectType BusinessObjectType Object Type
PubSecMessageCreatedByAppl PubSecMessageCreatedByAppl Application
MessageIsClosedByUser MessageIsClosedByUser User close
_FormBundle _FormBundle
_MessageStatus _MessageStatus
_MessageType _MessageType
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_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: IPUBSECBRFMSGTP

CREATE VIEW I_PublicSectorBRFMessageTP AS
SELECT
  SystemMessageIdentification,
  SystemMessageNumber,
  PublicSectorFormBundleUUID,
  PubSecMessageIssuingObject,
  PublicSectorFormFieldName,
  PubSecMsgIssuingFormLine,
  PublicSectorBRFMessageUUID,
  SystemMessageType,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  CreationDate,
  LastChangeDate,
  CreationTime,
  LastChangeTime,
  CreatedByUser,
  LastChangedByUser,
  PublicSectorMessageStatus,
  cast ('Message Text' as ps_system_msg_text ) AS SystemMessageText,
  cast ('Form Description' as ps_form_description ) AS PublicSectorFormDescription,
  BusinessObjectType,
  PubSecMessageCreatedByAppl,
  MessageIsClosedByUser
FROM I_PublicSectorBRFMessage
LEFT OUTER JOIN I_PublicSectorFormBundleTP AS _FormBundle ON PublicSectorFormBundleUUID = _FormBundle.PublicSectorFormBundleUUID  -- association [1..1]
;

Learn More