SAP ABAP Table STICKET (Flight Ticket)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB (Application Component) ABAP Workbench, Java IDE and Infrastructure
     ⤷ SAPBC_DATAMODEL (Package) Data Model: BC_TRAVEL for Workbench Training and Docu.

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	STICKET	Table Relationship Diagram
Short Description	Flight Ticket

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	S_MANDT	MANDT	CLNT	3	0	Client	T000
2	CARRID	☑	S_CARR_ID	S_CARR_ID	CHAR	3	0	Airline Code	SCARR
3	CONNID	☑	S_CONN_ID	S_CONN_ID	NUMC	4	0	Flight Connection Number	SPFLI
4	FLDATE	☑	S_DATE	S_DATE	DATS	8	0	Flight date	SFLIGHT
5	BOOKID	☑	S_BOOK_ID	S_BOOK_ID	NUMC	8	0	Booking number	SBOOK
6	CUSTOMID	☑	S_CUSTOMER	S_BUSPANUM	NUMC	8	0	Customer Number	SCUSTOM
7	TICKET	☑	S_TICKET	CHAR1	CHAR	1	0	Ticket type
8	PLACE	☐	S_PLACE	CHAR40	CHAR	40	0	Ticket use location
9	ARCHIVE_	☐	S_ARCHIVE	NUMC4	NUMC	4	0	Internal SAP use

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	STICKET	BOOKID	SBOOK	BOOKID		1	CN
2	STICKET	CARRID	SCARR	CARRID	KEY	1	CN
3	STICKET	CONNID	SPFLI	CONNID
4	STICKET	CUSTOMID	SCUSTOM	ID	KEY	1	CN
5	STICKET	FLDATE	SFLIGHT	FLDATE	KEY	1	CN
6	STICKET	MANDT	T000	MANDT

History

Last changed by/on	SAP	20130604
SAP Release Created in