SAP ABAP Table PIQEXCOUT_DIAL (Visiting Studies: Dialog for Outgoing 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	PIQEXCOUT_DIAL	Table Relationship Diagram
Short Description	Visiting Studies: Dialog for Outgoing 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: Outgoing Students (Keys and Text Fields)
5	.INCLUDE	☐				0	0	Visiting Studies: Outgoing Students
6	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
7	HOSTINST_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
8	HOSTINST_ID	☐	PIQEXCHOST_OBJID	HROBJID	NUMC	8	0	Host 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	FROM_YEAR	☐	PIQEXC_YEARFROM	PIQTRSESSIONYEAR	NUMC	4	0	External Academic Year in Which Visiting Studies Started
13	TO_YEAR	☐	PIQEXC_YEARTO	PIQTRSESSIONYEAR	NUMC	4	0	External Academic Year in Which Visiting Studies Ended
14	FROM_SESSION	☐	PIQEXC_SESSIONFROM	PIQTRSESSIONID	CHAR	4	0	External Academic Session in Which Visiting Studies Started	T7PIQTREXTSES
15	TO_SESSION	☐	PIQEXC_SESSIONTO	PIQTRSESSIONID	CHAR	4	0	External Academic Session for End of Visiting Studies	T7PIQTREXTSES
16	DISCIPLINE	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline	T7PIQSMDISZIP
17	APPROVE_DATE	☐	PIQEXCAPPRDATE	DATUM	DATS	8	0	Approval Date for Visiting Studies
18	CONTACT_ID	☐	PIQEXCCONTBUPA_ID	BU_PARTNER	CHAR	10	0	Contact: Business Partner ID	*
19	EXCH_STATUS	☐	PIQEXCSTATUS	PIQEXCSTATUS	CHAR	4	0	External Admission Status	T7PIQEXCSTATUS
20	EXCH_CHOICE	☐	PIQEXCCHOICE	NUMC2	NUMC	2	0	Visiting Studies Choice	T7PIQEXCCHOICE
21	ADDINFO	☐	PIQEXC_INFO	TEXT40	CHAR	40	0	Additional Information
22	HOSTINST_SHORT	☐	PIQEXCHOST_SHORT	TEXT12	CHAR	12	0	Host University (Abbreviation)
23	HOSTINST_TEXT	☐	PIQEXCHOST_STEXT	TEXT40	CHAR	40	0	Host University (Description)
24	EXCHPROGRAM_SHORT	☐	PIQEXCSX_SHORT	TEXT12	CHAR	12	0	Exchange Program Abbreviation
25	EXCHPROGRAM_TEXT	☐	PIQEXCSX_NAME	TEXT40	CHAR	40	0	Exchange Program Name
26	DISCIPLINE_TXT	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
27	EXCH_STATUS_TXT	☐	PIQEXCSTATUST	TEXT40	CHAR	40	0	External Admission Status (Description)
28	EXCH_CHOICE_TXT	☐	PIQEXCCHOICET	TEXT40	CHAR	40	0	Visiting Studies Choice (Description)
29	FROM_SESSION_TXT	☐	PIQEXC_SESSIONFROMT	TEXT20	CHAR	20	0	From External Academic Session (Description)
30	TO_SESSION_TXT	☐	PIQEXC_SESSIONTOT	TEXT20	CHAR	20	0	To External Academic Session (Description)
31	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	PIQEXCOUT_DIAL	DISCIPLINE	T7PIQSMDISZIP	DISZIP	REF	1	CN
2	PIQEXCOUT_DIAL	EXCH_CHOICE	T7PIQEXCCHOICE	CHOICE	REF	1	CN
3	PIQEXCOUT_DIAL	EXCH_STATUS	T7PIQEXCSTATUS	EXCSTATUS	REF	1	CN
4	PIQEXCOUT_DIAL	FROM_SESSION	T7PIQTREXTSES	SESSIONID	REF	1	CN
5	PIQEXCOUT_DIAL	TO_SESSION	T7PIQTREXTSES	SESSIONID	REF	1	CN

History

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