S_Tickets

DDL: S_TICKET SQL: S_TicketV Type: view
9 Fields 1 Data Sources 2 Associations

Tickets

S_Tickets is a CDS View that provides data about "Tickets" in SAP S/4HANA. It reads from 1 data source (sticket) and exposes 9 fields with key fields CarrierId, ConnectionId, FlightDate, BookId, CustomerId. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
sticket sticket from

Associations (2)

CardinalityTargetAliasCondition
[1] S_Customers _Customer $projection.CustomerId = _Customer.CustomerId
[1] S_Bookings _Booking $projection.BookId = _Booking.BookId

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName S_TicketV view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Tickets view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CarrierId carrid Carrier
KEY ConnectionId connid Flight Number
KEY FlightDate fldate Flight Date
KEY BookId bookid Booking number
KEY CustomerId customid Customer Number
KEY ticket ticket Ticket type
place place Place of Issue
_Customer _Customer
_Booking _Booking

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 S_Tickets.
-- 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: S_TicketV

CREATE VIEW S_Tickets AS
SELECT
  carrid AS CarrierId,
  connid AS ConnectionId,
  fldate AS FlightDate,
  BookId,
  customid AS CustomerId,
  ticket,
  place
FROM sticket
LEFT OUTER JOIN S_Customers AS _Customer ON CustomerId = _Customer.CustomerId  -- association [1]
LEFT OUTER JOIN S_Bookings AS _Booking ON BookId = _Booking.BookId  -- association [1]
;

Learn More