C_TicketAdditionalQtyTP

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_TicketAdditionalQtyTP.
-- 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: CTKTADDNLQTY

CREATE VIEW C_TicketAdditionalQtyTP AS
SELECT
  NominationTicketKey,
  NominationTicketItem,
  NominationTicketVersion,
  TicketUnitOfMeasure,
  NominationDoc,
  NominationDocItem,
  NominationTicketPurpose,
  NominationTicketQuantity,
  TicketAdditionalQuantity,
  QuantityIsMarked,
  IsTicketQuantityEnabled,
  IsTicketUnitOfMeasureEnabled,
  IsQuantityEnabled,
  NominationDocIsBlocked,
  NominationTicketIsBlocked
FROM I_TicketAdditionalQtyTP
LEFT OUTER JOIN C_TicketHeadTP AS _TicketHeadTP ON NominationTicketKey = _TicketHeadTP.NominationTicketKey AND NominationTicketVersion = _TicketHeadTP.NominationTicketVersion  -- association [1..1]
LEFT OUTER JOIN C_TicketItemTP AS _TicketItemTP ON NominationTicketKey = _TicketItemTP.NominationTicketKey AND NominationTicketItem = _TicketItemTP.NominationTicketItem AND NominationTicketVersion = _TicketItemTP.NominationTicketVersion  -- association [1..1]
;