SAP ABAP View WDR_TEST_SFBOOKV (View for Tables Sflight and Sbook)

Hierarchy

☛ SAP_UI (Software Component) User Interface Technology
   ⤷ BC-WD-ABA (Application Component) Web Dynpro ABAP
     ⤷ SWDP_TEST (Package) Web Dynpro: Tests

Basic Data

View Type	D	Database View
Database View	WDR_TEST_SFBOOKV
Short Description	View for Tables Sflight and Sbook
Root table	SFLIGHT	Flight

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SFLIGHT	SFLIGHT
2	SBOOK

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SFLIGHT	MANDT	JL	EQ				0	0
2	SBOOK	MANDT	JR	EQ			AND	0	0
3	SFLIGHT	CARRID	JL	EQ				0	0
4	SBOOK	CARRID	JR	EQ			AND	0	0
5	SFLIGHT	CONNID	JL	EQ				0	0
6	SBOOK	CONNID	JR	EQ			AND	0	0
7	SFLIGHT	FLDATE	JL	EQ				0	0
8	SBOOK	FLDATE	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CARRID	SFLIGHT	CARRID		☐	S_CARR_ID	☐	Airline Code
2	CONNID	SFLIGHT	CONNID		☐	S_CONN_ID	☐	Flight Connection Number
3	FLDATE	SFLIGHT	FLDATE		☐	S_DATE	☐	Flight date
4	PRICE	SFLIGHT	PRICE		☐	S_PRICE	☐	Airfare
5	PAYMENTSUM	SFLIGHT	PAYMENTSUM		☐	S_SUM	☐	Total of current bookings
6	BOOKID	SBOOK	BOOKID		☐	S_BOOK_ID	☐	Booking number
7	CUSTOMID	SBOOK	CUSTOMID		☐	S_CUSTOMER	☐	Customer Number
8	CURRENCY	SFLIGHT	CURRENCY		☐	S_CURRCODE	☐	Local currency of airline

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

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