SAP ABAP View V_T7PIQ_GB_RESUL (UCAS: Selection View for Search help)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-GB (Application Component) United Kingdom
     ⤷ PMIQ_GB (Package) Campus Management (Great Britain)

Basic Data

View Type	D	Database View
Database View	V_T7PIQ_GB_RESUL
Short Description	UCAS: Selection View for Search help
Root table	T7PIQ_GB_BORDRES	UCAS: Mapping Exam Board Code -> Exam qualification

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	T7PIQ_GB_BORDRES	T7PIQ_GB_BORDRES
2	T7PIQ_GB_EBOARD
3	T7PIQ_GB_RESTYP
4	T7PIQ_GB_EBOARDT
5	T7PIQ_GB_RESTYPT
6	T7PIQ_GB_POINTS

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	T7PIQ_GB_EBOARD	MANDT	JL	EQ				0	0
2	T7PIQ_GB_BORDRES	MANDT	JR	EQ			AND	0	0
3	T7PIQ_GB_EBOARD	EXAM_BOARD	JL	EQ				0	0
4	T7PIQ_GB_BORDRES	EXAM_BOARD	JR	EQ			AND	0	0
5	T7PIQ_GB_RESTYP	MANDT	JL	EQ				0	0
6	T7PIQ_GB_BORDRES	MANDT	JR	EQ			AND	0	0
7	T7PIQ_GB_RESTYP	QUALITY	JL	EQ				0	0
8	T7PIQ_GB_BORDRES	EXAM_QUALITY	JR	EQ			AND	0	0
9	T7PIQ_GB_EBOARD	MANDT	JL	EQ				0	0
10	T7PIQ_GB_EBOARDT	MANDT	JR	EQ			AND	0	0
11	T7PIQ_GB_EBOARD	EXAM_BOARD	JL	EQ				0	0
12	T7PIQ_GB_EBOARDT	EXAM_BOARD	JR	EQ			AND	0	0
13	T7PIQ_GB_RESTYP	MANDT	JL	EQ				0	0
14	T7PIQ_GB_RESTYPT	MANDT	JR	EQ			AND	0	0
15	T7PIQ_GB_RESTYP	QUALITY	JL	EQ				0	0
16	T7PIQ_GB_RESTYPT	QUALITY	JR	EQ			AND	0	0
17	T7PIQ_GB_RESTYP	MANDT	JL	EQ				0	0
18	T7PIQ_GB_POINTS	MANDT	JR	EQ			AND	0	0
19	T7PIQ_GB_RESTYP	QUALITY	JL	EQ				0	0
20	T7PIQ_GB_POINTS	QUALITY	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	T7PIQ_GB_BORDRES	MANDT		☐	MANDT	☐	Client
2	EXAM_BOARD	T7PIQ_GB_BORDRES	EXAM_BOARD		☐	PIQ_GB_UCAS_EX_BOARD	☐	UCAS: Exam Board Code
3	EXAM_BOARDT	T7PIQ_GB_EBOARDT	DESCRIPTION		☐	PIQ_GB_UCAS_EX_BOARDT	☑	UCAS: Exam Board Name
4	EXAM_QUALITY	T7PIQ_GB_BORDRES	EXAM_QUALITY		☐	PIQ_GB_UCAS_GRADE_TYPE	☐	UCAS: Grade type (Qualification)
5	EXAM_QUALITYT	T7PIQ_GB_RESTYPT	DESCRIPTION		☐	PIQ_GB_UCAS_GRADE_TYPET	☑	UCAS: Qualification
6	GRADE_1	T7PIQ_GB_POINTS	GRADE		☐	PIQORGMARK	☐	Original Grade
7	GRADE_2	T7PIQ_GB_POINTS	GRADE_2		☐	PIQ_GB_UCAS_GRADE	☐	UCAS: Grade 2

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	20130529
SAP Release Created in	464