I_TicketHeaderFld

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_TicketHeaderFld.
-- 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: ITICKETHEADFLDS

CREATE VIEW I_TicketHeaderFld AS
SELECT
  ticket_key AS NominationTicketKey,
  ticket_version AS NominationTicketVersion,
  ticket_purpose AS NominationTicketPurpose,
  ticket_type AS NominationTicketType,
  exttktnr AS TicketNumber,
  ticketnr AS TicketExternalNumber,
  tsyst AS TransportSystem,
  tktsubrc AS NominationTicketStatus,
  tplst AS TransportationPlanningPoint,
  erdat AS TicketCreationDate,
  ernam AS TicketCreatedByUser,
  aedat AS TicketChangedDate,
  aenam AS TicketChangedByUser,
  tktstatusru AS TicketApprovalStatus,
  carrier AS NominationCarrier,
  consigne AS ConsigneePartner,
  inspector AS NominationInspector,
  shipper AS NominationShipper,
  supplier AS TicketSupplier,
  Trader,
  tktselect AS NominationTicketIsBlocked
FROM oij_el_ticket_h
LEFT OUTER JOIN E_NominationTicketHead AS _TicketHeaderExtension ON NominationTicketKey = _TicketHeaderExtension.NominationTicketKey AND NominationTicketVersion = _TicketHeaderExtension.NominationTicketVersion AND NominationTicketPurpose = _TicketHeaderExtension.NominationTicketPurpose  -- association [1..1]
;