SAP ABAP Table RSISD_S_ABC_SFLIGHT (SFLIGHT Expands With Own Fields)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-PLA (Application Component) Planning
     ⤷ RSISD (Package) Intelligent Services Demo

Basic Data

Table Category	INTTAB	Structure
Structure	RSISD_S_ABC_SFLIGHT	Table Relationship Diagram
Short Description	SFLIGHT Expands With Own Fields

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Flight
2	MANDT	☐	S_MANDT	MANDT	CLNT	3	0	Client	T000
3	CARRID	☐	S_CARR_ID	S_CARR_ID	CHAR	3	0	Airline Code	SCARR
4	CONNID	☐	S_CONN_ID	S_CONN_ID	NUMC	4	0	Flight Connection Number	SPFLI
5	FLDATE	☐	S_DATE	S_DATE	DATS	8	0	Flight date	*
6	PRICE	☐	S_PRICE	S_PRICE	CURR	15	2	Airfare
7	CURRENCY	☐	S_CURRCODE	S_CURR	CUKY	5	0	Local currency of airline	SCURX
8	PLANETYPE	☐	S_PLANETYE	S_PLANE	CHAR	10	0	Aircraft Type	SAPLANE
9	SEATSMAX	☐	S_SEATSMAX	S_SEATS	INT4	10	0	Maximum capacity in economy class
10	SEATSOCC	☐	S_SEATSOCC	S_SEATS	INT4	10	0	Occupied seats in economy class
11	PAYMENTSUM	☐	S_SUM	S_SUM	CURR	17	2	Total of current bookings
12	SEATSMAX_B	☐	S_SMAX_B	S_SEATS	INT4	10	0	Maximum capacity in business class
13	SEATSOCC_B	☐	S_SOCC_B	S_SEATS	INT4	10	0	Occupied seats in business class
14	SEATSMAX_F	☐	S_SMAX_F	S_SEATS	INT4	10	0	Maximum capacity in first class
15	SEATSOCC_F	☐	S_SOCC_F	S_SEATS	INT4	10	0	Occupied seats in first class
16	ABC	☐	RSISD_E_ABC		CHAR	4	0	ABC Field
17	PERCENTAGE	☐	RSISD_E_PERCENTAGE		DEC	16	0	Percentage

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RSISD_S_ABC_SFLIGHT	CARRID	SCARR	CARRID
2	RSISD_S_ABC_SFLIGHT	CONNID	SPFLI	CONNID	KEY	1	CN
3	RSISD_S_ABC_SFLIGHT	CURRENCY	SCURX	CURRKEY	REF	1	N
4	RSISD_S_ABC_SFLIGHT	MANDT	T000	MANDT	KEY	1	CN
5	RSISD_S_ABC_SFLIGHT	PLANETYPE	SAPLANE	PLANETYPE	REF	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	400