I_PrepaymentPostingMessagesTP

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_PrepaymentPostingMessagesTP.
-- 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: IPPMGAPMSTP

CREATE VIEW I_PrepaymentPostingMessagesTP AS
SELECT
  ApprovalMessage.PrepaymentPostingMessageUUID AS PrepaymentPostingMessageUUID,
  ApprovalMessage.PrepaymentApprovalUUID AS PrepaymentApprovalUUID,
  ApprovalMessage.PrepaymentAgreement AS PrepaymentAgreement,
  ApprovalMessage.SystemMessageType AS SystemMessageType,
  ApprovalMessage.SystemMessageIdentification AS SystemMessageIdentification,
  ApprovalMessage.SystemMessageNumber AS SystemMessageNumber,
  ApprovalMessage.SystemMessageText AS SystemMessageText,
  ApprovalMessage.SystemMessageVariable1 AS SystemMessageVariable1,
  ApprovalMessage.SystemMessageVariable2 AS SystemMessageVariable2,
  ApprovalMessage.SystemMessageVariable3 AS SystemMessageVariable3,
  ApprovalMessage.SystemMessageVariable4 AS SystemMessageVariable4,
  ApprovalMessage.CreationDateTime AS CreationDateTime,
  ApprovalMessage.LastChangedByUser AS LastChangedByUser,
  ApprovalMessage.LastChangeDateTime AS LastChangeDateTime
FROM I_PrepaymentPostingMessages AS ApprovalMessage
LEFT OUTER JOIN I_PrepaymentApprovalTP AS _AgreementApproval ON PrepaymentApprovalUUID = _AgreementApproval.PrepaymentApprovalUUID  -- association [1..1]
LEFT OUTER JOIN E_PrepaymentPostingMessages AS _Extension ON PrepaymentPostingMessageUUID = _Extension.PrepaymentPostingMessageUUID  -- association [0..1]
;