P_ACMUniversalTicketData

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_ACMUniversalTicketData.
-- 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: PUNIVTDATA

CREATE VIEW P_ACMUniversalTicketData AS
SELECT
  ACMUniversalTicketKey,
  ACMUniversalTicketItem,
  ACMUniversalTicketVersion,
  ACMUniversalTicketPurpose,
  ACMUniversalTicketSeqNo,
  TransactionCodeName,
  lpad(Base.ACMUniversalTicketDocNumber, 20, '0') AS ACMDocumentNumber,
  ACMDocumentYear,
  ACMDocumentItemNumber,
  ACMDocumentType
FROM I_ACMUniversalTicketDocFlow AS Base
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 I_ACMUniversalTicketDocFlow AS _TicketDocument ON ACMUniversalTicketKey = _TicketDocument.ACMUniversalTicketKey AND ACMUniversalTicketItem = _TicketDocument.ACMUniversalTicketItem AND ACMUniversalTicketVersion = _TicketDocument.ACMUniversalTicketVersion AND ACMUniversalTicketPurpose = _TicketDocument.ACMUniversalTicketPurpose  -- association [0..*]
LEFT OUTER JOIN P_ACMUniversalPartialTktData AS _TicketErrorLog ON ACMUniversalTicketKey = _TicketErrorLog.ACMUniversalTicketKey AND ACMUniversalTicketItem = _TicketErrorLog.ACMUniversalTicketItem AND ACMUniversalTicketVersion = _TicketErrorLog.ACMUniversalTicketVersion AND ACMUniversalTicketPurpose = _TicketErrorLog.ACMUniversalTicketPurpose  -- association [0..*]
;