STICKET

Transparent Table Application Table
9 Fields 1 CDS Views

Flugticket

STICKET is an SAP database table in S/4HANA. Flugticket. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
S_Tickets view from Tickets

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt s_mandt Client
KEY carrid s_carr_id Airline
KEY connid s_conn_id Flight Number
KEY fldate s_date Date
KEY bookid s_book_id Booking number
KEY customid s_customer Customer Number
KEY ticket s_ticket Ticket type
place s_place Location
archive_ s_archive Archive ID

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Flugticket
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STICKET (
    MANDT,     -- Client [s_mandt]
    CARRID,    -- Airline [s_carr_id]
    CONNID,    -- Flight Number [s_conn_id]
    FLDATE,    -- Date [s_date]
    BOOKID,    -- Booking number [s_book_id]
    CUSTOMID,  -- Customer Number [s_customer]
    TICKET,    -- Ticket type [s_ticket]
    PLACE,     -- Location [s_place]
    ARCHIVE_,  -- Archive ID [s_archive]
    PRIMARY KEY (MANDT, CARRID, CONNID, FLDATE, BOOKID, CUSTOMID, TICKET)
);

Learn More