SAP ABAP Table PIQEXCIN_DIAL (Visiting Studies: Dialog for Incoming Students)

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	PIQEXCIN_DIAL	Table Relationship Diagram
Short Description	Visiting Studies: Dialog for Incoming Students

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

History

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