I_ExtendedPurgDocDistrMessages

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_ExtendedPurgDocDistrMessages.
-- 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: IDISTRMSGS

CREATE VIEW I_ExtendedPurgDocDistrMessages AS
SELECT
  message_seqnumber AS SequenceNumber,
  responsemessageguid AS DistrResponseMessageUUID,
  PurchasingDocument,
  PurchasingDocumentCategory,
  ExtContractForPurg,
  LogicalSystem,
  messagetype AS SystemMessageType,
  messageidentification AS SystemMessageIdentification,
  messagenumber AS SystemMessageNumber,
  parametername AS PurgDocMsgParamName,
  parameterline AS PurgDocMsgParamLineVal,
  messagevariable1 AS SystemMessageVariable1,
  messagevariable2 AS SystemMessageVariable2,
  messagevariable3 AS SystemMessageVariable3,
  messagevariable4 AS SystemMessageVariable4,
  cast ('' as abap.char( 220 )) AS SystemMessageText,
  resp_recd_at AS DistrResponseReceivedDateTime
FROM mmprc_hub_msgs
LEFT OUTER JOIN I_CentralPurchaseContract AS _CentralPurchaseContract ON PurchasingDocument = _CentralPurchaseContract.CentralPurchaseContract  -- association [1..1]
;