I_TICKETHEADERFLD

CDS View

Ticket Header Fields

I_TICKETHEADERFLD is a CDS View in S/4HANA. Ticket Header Fields. It contains 17 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_NominationMultiTickets view left_outer CONSUMPTION List of Tickets for Nomination
I_NominationTicketInfo view left_outer COMPOSITE Nomination Ticket Information
I_NominationTicketStatus view left_outer COMPOSITE Ticket Status for Mobile Ticketing
I_TicketErrorLog view inner BASIC Nomination Ticket Error Log
I_TicketHeadTP view from TRANSACTIONAL Ticket Header Information
I_TicketInfoFld view inner COMPOSITE Ticket Information Fields

Fields (17)

KeyField CDS FieldsUsed in Views
KEY NominationTicketKey NominationTicketKey 1
KEY NominationTicketVersion NominationTicketVersion 1
NominationTicketIsBlocked NominationTicketIsBlocked 3
NominationTicketPurpose NominationTicketPurpose 1
NominationTicketStatus NominationTicketStatusCode 1
NominationTicketType NominationTicketType 5
TicketApprovalStatus TicketApprovalStatus 1
TicketChangedByUser TicketChangedByUser 1
TicketChangedDate TicketChangedDate 1
TicketCreatedByUser TicketCreatedByUser 1
TicketCreationDate TicketCreationDate 1
TicketExternalNumber TicketExternalNumber,TicketNumber 5
TicketNumber TicketNumber 2
TicketSupplier TicketSupplier 1
Trader Trader 1
TransportationPlanningPoint TransportationPlanningPoint 1
TransportSystem TransportSystem 1

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.

-- Ticket Header Fields
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TICKETHEADERFLD (
    NOMINATIONTICKETKEY,
    NOMINATIONTICKETVERSION,
    NOMINATIONTICKETISBLOCKED,
    NOMINATIONTICKETPURPOSE,
    NOMINATIONTICKETSTATUS,
    NOMINATIONTICKETTYPE,
    TICKETAPPROVALSTATUS,
    TICKETCHANGEDBYUSER,
    TICKETCHANGEDDATE,
    TICKETCREATEDBYUSER,
    TICKETCREATIONDATE,
    TICKETEXTERNALNUMBER,
    TICKETNUMBER,
    TICKETSUPPLIER,
    TRADER,
    TRANSPORTATIONPLANNINGPOINT,
    TRANSPORTSYSTEM,
    PRIMARY KEY (NOMINATIONTICKETKEY, NOMINATIONTICKETVERSION)
);