P_ACMUniversalPartialTktData

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 P_ACMUniversalPartialTktData.
-- 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: PUNIVPTDATA

CREATE VIEW P_ACMUniversalPartialTktData AS
SELECT
  ACMUniversalTicketKey,
  ACMUniversalTicketItem,
  ACMUniversalTicketVersion,
  ACMUniversalTicketPurpose,
  ACMUniversalTicketSeqNo,
  TransactionCodeName,
  ACMDocumentNumber,
  ACMDocumentYear,
  ACMDocumentItemNumber,
  ACMDocumentType
FROM P_ACMUniversalTktErrorLog
LEFT OUTER JOIN I_ACMUniversalTicketHeader AS _TicketHead ON ACMUniversalTicketKey = _TicketHead.ACMUniversalTicketKey AND ACMUniversalTicketVersion = _TicketHead.ACMUniversalTicketVersion AND ACMUniversalTicketPurpose = _TicketHead.ACMUniversalTicketPurpose  -- association [1]
LEFT OUTER JOIN I_ACMUniversalTicketItem AS _TicketItem ON ACMUniversalTicketKey = _TicketItem.ACMUniversalTicketKey AND ACMUniversalTicketItem = _TicketItem.ACMUniversalTicketItem AND ACMUniversalTicketVersion = _TicketItem.ACMUniversalTicketVersion AND ACMUniversalTicketPurpose = _TicketItem.ACMUniversalTicketPurpose  -- association [1]
LEFT OUTER JOIN P_ACMUniversalTktErrorLog AS _TicketDocument ON ACMUniversalTicketKey = _TicketDocument.ACMUniversalTicketKey AND ACMUniversalTicketItem = _TicketDocument.ACMUniversalTicketItem AND ACMUniversalTicketVersion = _TicketDocument.ACMUniversalTicketVersion AND ACMUniversalTicketPurpose = _TicketDocument.ACMUniversalTicketPurpose  -- association [0..*]
;