SAP ABAP Table PIQEXC_INT (Visiting Studies: Incoming Students (Keys and Text Fields))

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	PIQEXC_INT	Table Relationship Diagram
Short Description	Visiting Studies: Incoming Students (Keys and Text Fields)

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	Visiting Studies: Incoming Students
2	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
3	SENDINGINST_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
4	SENDINGINST_ID	☐	PIQEXCSEND_OBJID	HROBJID	NUMC	8	0	Home University Identification (ID)	*
5	EXCHPROGRAM_ID	☐	PIQEXCSX_OBJID	HROBJID	NUMC	8	0	Exchange Program ID	*
6	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
7	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
8	ADDINFO	☐	PIQEXC_INFO	TEXT40	CHAR	40	0	Additional Information
9	STUDCATEGORY	☐	PIQEXCSTCAT	PIQEXCSTCAT	CHAR	4	0	Visiting Student Category	T7PIQEXCSTCAT
10	ENDOFSTAY	☐	PIQEXCENDSTAY	DATUM	DATS	8	0	Last Day of Visiting Studies
11	DISCIPLINE	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline	T7PIQSMDISZIP
12	HOMEDEGRTYPE	☐	PIQEXCHOMEDEGRTPE	PIQQUAL_LEVEL	CHAR	4	0	Degree Type of Home University	T7PIQQUAL_LEVEL
13	CONTACT_ID	☐	PIQEXCCONTBUPA_ID	BU_PARTNER	CHAR	10	0	Contact: Business Partner ID	*
14	SENDINGINST_SHORT	☐	PIQEXCSEND_SHORT	TEXT12	CHAR	12	0	Home University (Abbreviation)
15	SENDINGINST_TEXT	☐	PIQEXCSEND_STEXT	TEXT40	CHAR	40	0	Home University (Description)
16	EXCHPROGRAM_SHORT	☐	PIQEXCSX_SHORT	TEXT12	CHAR	12	0	Exchange Program Abbreviation
17	EXCHPROGRAM_TEXT	☐	PIQEXCSX_NAME	TEXT40	CHAR	40	0	Exchange Program Name
18	STUDCATEGORY_TXT	☐	PIQEXCSTCATT	TEXT40	CHAR	40	0	Visiting Student Category (Description)
19	DISCIPLINE_TXT	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
20	HOMEDEGRTYPE_TXT	☐	PIQEXCHOMEDEGRTPET	TEXT40	CHAR	40	0	Degree Type of Home University (Description)
21	CONTACT_NAME	☐	PIQEXCCONTBUPA_NAME	BU_TEXT50	CHAR	50	0	Contact Name

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQEXC_INT	DISCIPLINE	T7PIQSMDISZIP	DISZIP	REF	1	CN
2	PIQEXC_INT	HOMEDEGRTYPE	T7PIQQUAL_LEVEL	QUAL_LEVEL	REF	1	CN
3	PIQEXC_INT	STUDCATEGORY	T7PIQEXCSTCAT	CATEGORY	REF	1	CN

History

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