SAP ABAP Table PIQ_F4STUDENT_SEL (Selection Criteria)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-AD (Application Component) Administration
     ⤷ PMIQ (Package) Campus Management

Basic Data

Table Category	INTTAB	Structure
Structure	PIQ_F4STUDENT_SEL	Table Relationship Diagram
Short Description	Selection Criteria

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	.INCLUDE	☐				0	0	Student Search Criteria (Personal Data)
2	MATNR	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
3	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
4	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
5	MIDNM	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
6	BIRTHNAME	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
7	GBDAT	☐	PIQ_GBDAT	GBDAT	DATS	8	0	Date of Birth
8	GBLND	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
9	PRDNI	☐	PIQ_PRDNI	CHAR20	CHAR	20	0	Identification Number
10	KEY_DATE	☐	PIQKEYDATE	DATUM	DATS	8	0	Key Date
11	.INCLUDE	☐				0	0	Student Search Criteria (Status Data)
12	STATUS	☐	PIQHS_STSTATUS	SUBTYP	CHAR	4	0	Status	*
13	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
14	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
15	AYEAR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	*
16	PERID	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	*
17	MAXRECORDS	☐	DDSHMAXREC	DDSHMAXREC	INT4	10	0	Restrict length of list
18	LANDX	☐	PIQF4_GEBLANDX	TEXT15	CHAR	15	0	Name of Country of Birth
19	RESTRICT	☐	PIQ_RESTRICT	XFELD	CHAR	1	0	Do Not Restrict Hit List
20	STATUST	☐	PIQHS_STSTATUST	TEXT25	CHAR	25	0	Status (Description)
21	INCLUDE_ARCHIVE	☐	PIQ_F4INCLUDE_ARCH	XFELD	CHAR	1	0	Student Search Including Archivable Students

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQ_F4STUDENT_SEL	GBLND	T005	LAND1	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	464