SAP ABAP View QLAST_SBOOK_T (Example view)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-DIC (Application Component) ABAP Dictionary
     ⤷ SDDIC_VIEWPARSER (Package) DDIC Viewparser

Basic Data

View Type	D	Database View
Database View	QLAST_SBOOK_T
Short Description	Example view
Root table	SBOOK	Single Flight Booking

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SBOOK	SBOOK
2	DDDDLCHARTYPES
3	DDDDLCURRTYPES
4	DDDDLQUANTYPES

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SBOOK	CUSTOMID		NE	'90000013'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CARRIER	SBOOK	CARRID		☐	S_CARR_ID	☐	Airline Code
2	CONN	SBOOK	CONNID		☐	S_CONN_ID	☐	Flight Connection Number
3	BOOKID	SBOOK	BOOKID		☐	S_BOOK_ID	☐	Booking number
4	CUSTTYPE	DDDDLCHARTYPES	CCHAR8		☐		☐
5	PRICE_FOREIGN	DDDDLCURRTYPES	CURR15_2		☐		☐
6	CUKY_FOREIGN	SBOOK	FORCURKEY		☐	S_CURR	☐	Payment currency
7	PRICE_LOCAL	SBOOK	LOCCURAM		☐	S_L_CUR_PR	☐	Price of booking in local currency of airline
8	CUKY_LOCAL	SBOOK	LOCCURKEY		☐	S_CURRCODE	☐	Local currency of airline
9	SPECIAL_PRICE	DDDDLCURRTYPES	CURR18_2		☐		☐
10	MAX_WEIGHT	DDDDLQUANTYPES	QUAN8_4		☐		☐
11	WEIGHT_UNIT	SBOOK	WUNIT		☐	S_WEIUNIT	☐	Weight Unit

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	DDIC	20150523
SAP Release Created in	740