SAP ABAP Table IDREPFW_STR_DEMO_SBOOK (Reporting Framework: Demo structure SBOOK)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-REP_FRWK (Package) International Development: Reporting Framework

Basic Data

Table Category	INTTAB	Structure
Structure	IDREPFW_STR_DEMO_SBOOK	Table Relationship Diagram
Short Description	Reporting Framework: Demo structure SBOOK

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	INTKEY	☐	IDREPFW_INTKEY	IDREPFW_INTKEY	CHAR	40	0	Internal Key
2	.INCLUDE	☐				0	0	Single Flight Booking
3	MANDT	☐	S_MANDT	MANDT	CLNT	3	0	Client	T000
4	CARRID	☐	S_CARR_ID	S_CARR_ID	CHAR	3	0	Airline Code	SCARR
5	CONNID	☐	S_CONN_ID	S_CONN_ID	NUMC	4	0	Flight Connection Number	SPFLI
6	FLDATE	☐	S_DATE	S_DATE	DATS	8	0	Flight date	SFLIGHT
7	BOOKID	☐	S_BOOK_ID	S_BOOK_ID	NUMC	8	0	Booking number
8	CUSTOMID	☐	S_CUSTOMER	S_BUSPANUM	NUMC	8	0	Customer Number	SCUSTOM
9	CUSTTYPE	☐	S_CUSTTYPE	S_CUSTTYPE	CHAR	1	0	Customer type
10	SMOKER	☐	S_SMOKER	S_SMOKER	CHAR	1	0	Smoker
11	LUGGWEIGHT	☐	S_LUGWEIGH	S_LUGWEIGH	QUAN	8	4	Weight of Luggage
12	WUNIT	☐	S_WEIUNIT	MEINS	UNIT	3	0	Weight Unit	T006
13	INVOICE	☐	S_INVFLAG	S_FLAG	CHAR	1	0	Invoice flag
14	CLASS	☐	S_CLASS	S_CLASS	CHAR	1	0	Flight Class
15	FORCURAM	☐	S_F_CUR_PR	S_PRICE	CURR	15	2	Booking price in foreign currency (dependent on location)
16	FORCURKEY	☐	S_CURR	S_CURR	CUKY	5	0	Payment currency	SCURX
17	LOCCURAM	☐	S_L_CUR_PR	S_PRICE	CURR	15	2	Price of booking in local currency of airline
18	LOCCURKEY	☐	S_CURRCODE	S_CURR	CUKY	5	0	Local currency of airline	SCURX
19	ORDER_DATE	☐	S_BDATE	S_BDATE	DATS	8	0	Booking Date
20	COUNTER	☐	S_COUNTNUM	S_COUNTNUM	NUMC	8	0	Number of sales office	SCOUNTER
21	AGENCYNUM	☐	S_AGNCYNUM	S_BUSPANUM	NUMC	8	0	Travel Agency Number	STRAVELAG
22	CANCELLED	☐	S_CANCEL	S_CANCEL	CHAR	1	0	Cancelation flag
23	RESERVED	☐	S_RESERV	S_RESERV	CHAR	1	0	Reservation flag
24	PASSNAME	☐	S_PASSNAME	S_CUSTNAME	CHAR	25	0	Name of the Passenger
25	PASSFORM	☐	S_FORM	S_TEXT15	CHAR	15	0	Form of address
26	PASSBIRTH	☐	S_BIRTHDAT	S_DATE	DATS	8	0	Date of Birth of a Passenger	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IDREPFW_STR_DEMO_SBOOK	AGENCYNUM	STRAVELAG	AGENCYNUM	REF	1	CN
2	IDREPFW_STR_DEMO_SBOOK	CARRID	SCARR	CARRID
3	IDREPFW_STR_DEMO_SBOOK	CONNID	SPFLI	CONNID	KEY	1	CN
4	IDREPFW_STR_DEMO_SBOOK	COUNTER	SCOUNTER	COUNTNUM	REF	1	CN
5	IDREPFW_STR_DEMO_SBOOK	CUSTOMID	SCUSTOM	ID	KEY	1	CN
6	IDREPFW_STR_DEMO_SBOOK	FLDATE	SFLIGHT	FLDATE	KEY	1	CN
7	IDREPFW_STR_DEMO_SBOOK	FORCURKEY	SCURX	CURRKEY	REF	1	CN
8	IDREPFW_STR_DEMO_SBOOK	LOCCURKEY	SCURX	CURRKEY	REF	1	CN
9	IDREPFW_STR_DEMO_SBOOK	MANDT	T000	MANDT	KEY	1	CN
10	IDREPFW_STR_DEMO_SBOOK	WUNIT	T006	MSEHI

History

Last changed by/on	SAP	20130529
SAP Release Created in	607