C_PurReqnReplicationMessages

DDL: C_PURREQNREPLICATIONMESSAGES SQL: CPURREQREPLMSG Type: view CONSUMPTION
12 Fields 1 Data Sources

Purchase Requisition Errors

C_PurReqnReplicationMessages is a Consumption CDS View that provides data about "Purchase Requisition Errors" in SAP S/4HANA. It reads from 1 data source (I_PurReqnReplicationMessages) and exposes 12 fields with key fields PurchaseRequisition, PurReqnMessageSequenceNumber, PurReqnExternalSystemId.

Data Sources (1)

SourceAliasJoin Type
I_PurReqnReplicationMessages I_PurReqnReplicationMessages from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPURREQREPLMSG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Purchase Requisition Errors view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition PurchaseRequisition Requisition
KEY PurReqnMessageSequenceNumber PurReqnMessageSequenceNumber Sort sequence
KEY PurReqnExternalSystemId PurReqnExternalSystemId External System ID
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
SystemMessageType SystemMessageType Message type
SystemMessageIdentification SystemMessageIdentification Message ID
SystemMessageNumber SystemMessageNumber Message Number
SystemMessageVariable1 SystemMessageVariable1 Variable 1
SystemMessageVariable2 SystemMessageVariable2 Variable 2
SystemMessageVariable3 SystemMessageVariable3 Variable 3
SystemMessageVariable4 SystemMessageVariable4 Variable 4
SystemMessageText SystemMessageText Message Text

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_PurReqnReplicationMessages.
-- 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: CPURREQREPLMSG

CREATE VIEW C_PurReqnReplicationMessages AS
SELECT
  PurchaseRequisition,
  PurReqnMessageSequenceNumber,
  PurReqnExternalSystemId,
  PurchaseRequisitionItem,
  SystemMessageType,
  SystemMessageIdentification,
  SystemMessageNumber,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  SystemMessageText
FROM I_PurReqnReplicationMessages
;

Learn More