SAP ABAP View QLAST_PEOPLE_T (Example for Union)

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_PEOPLE_T
Short Description	Example for Union
Root table	SNWD_BPA_CONTACT	EPM: Business Partner Contacts

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SNWD_BPA_CONTACT	SNWD_BPA_CONTACT	SNWD_BPA_CONTACT	U
2	QLAST_SDDL_EMPL		QLAST_SDDL_EMPL	U
3	T002		T002	U
4	DDDDLCHARTYPES		DDDDLCHARTYPES	U

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	QLAST_SDDL_EMPL	LANGUAGE	JL	EQ				0	0
2	T002	SPRAS	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	SNWD_BPA_CONTACT	CLIENT		☐	MANDT	☐	Client
2	FIRST_NAME	SNWD_BPA_CONTACT	FIRST_NAME		☐	SNWD_FIRST_NAME	☐	EPM: First Name
3	LAST_NAME	SNWD_BPA_CONTACT	LAST_NAME		☐	SNWD_LAST_NAME	☐	EPM: Last Name
4	MIDDLE_NAME	SNWD_BPA_CONTACT	MIDDLE_NAME		☐	SNWD_MIDDLE_NAME	☐	EPM: Middle Name
5	NICKNAME	DDDDLCHARTYPES	CCHAR8		☐		☐
6	SEX	SNWD_BPA_CONTACT	SEX		☐	SNWD_SEX	☐	EPM: Sex
7	LANGUAGE	DDDDLCHARTYPES	CCHAR2		☐		☐
8	PHONE_NUMBER	SNWD_BPA_CONTACT	PHONE_NUMBER		☐	SNWD_PHONE_NUMBER	☐	EPM: Phone Number
9	MANDT	QLAST_SDDL_EMPL	CLIENT		☐	MANDT	☐	Client
10	FIRST_NAME	QLAST_SDDL_EMPL	FIRST_NAME		☐	SNWD_FIRST_NAME	☐	EPM: First Name
11	LAST_NAME	QLAST_SDDL_EMPL	LAST_NAME		☐	SNWD_LAST_NAME	☐	EPM: Last Name
12	MIDDLE_NAME	QLAST_SDDL_EMPL	MIDDLE_NAME		☐	SNWD_MIDDLE_NAME	☐	EPM: Middle Name
13	NICKNAME	DDDDLCHARTYPES	CCHAR8		☐		☐
14	SEX	QLAST_SDDL_EMPL	SEX		☐	SNWD_SEX	☐	EPM: Sex
15	LANGUAGE	T002	LAISO		☐	LAISO	☐	2-Character SAP Language Code
16	PHONE_NUMBER	QLAST_SDDL_EMPL	PHONE_NUMBER		☐	SNWD_PHONE_NUMBER	☐	EPM: Phone Number

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