SAP ABAP Table PIQEXC_STUDY_ALV (Visiting Studies: ALV Overview)

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_STUDY_ALV	Table Relationship Diagram
Short Description	Visiting Studies: ALV Overview

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	IN_OUT	☐	PIQEXC_INOUT	PIQEXC_INOUT	CHAR	3	0	Visiting Studies: Incoming/Outgoing Indicator
2	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
3	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
4	INST_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
5	INST_OBJID	☐	PIQEXCSEND_OBJID	HROBJID	NUMC	8	0	Home University Identification (ID)	*
6	INST_SHORT	☐	PIQEXCSEND_SHORT	TEXT12	CHAR	12	0	Home University (Abbreviation)
7	INST_STEXT	☐	PIQEXCSEND_STEXT	TEXT40	CHAR	40	0	Home University (Description)
8	EXCHPROG_OBJID	☐	PIQEXCSX_OBJID	HROBJID	NUMC	8	0	Exchange Program ID	*
9	EXCHPROG_SHORT	☐	PIQEXCSX_SHORT	TEXT12	CHAR	12	0	Exchange Program Abbreviation
10	EXCHPROG_STEXT	☐	PIQEXCSX_NAME	TEXT40	CHAR	40	0	Exchange Program Name
11	FROM_YEAR	☐	PIQEXC_YEARFROM	PIQTRSESSIONYEAR	NUMC	4	0	External Academic Year in Which Visiting Studies Started
12	TO_YEAR	☐	PIQEXC_YEARTO	PIQTRSESSIONYEAR	NUMC	4	0	External Academic Year in Which Visiting Studies Ended
13	FROM_SESSION	☐	PIQEXC_SESSIONFROM	PIQTRSESSIONID	CHAR	4	0	External Academic Session in Which Visiting Studies Started	*
14	FROM_SESSION_TXT	☐	PIQEXC_SESSIONFROMT	TEXT20	CHAR	20	0	From External Academic Session (Description)
15	TO_SESSION	☐	PIQEXC_SESSIONTO	PIQTRSESSIONID	CHAR	4	0	External Academic Session for End of Visiting Studies	*
16	TO_SESSION_TXT	☐	PIQEXC_SESSIONTOT	TEXT20	CHAR	20	0	To External Academic Session (Description)
17	DISCIPLINE	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline	*
18	DISCIPLINE_TXT	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
19	CONTACT_ID	☐	PIQEXCCONTBUPA_ID	BU_PARTNER	CHAR	10	0	Contact: Business Partner ID	*
20	CONTACT_NAME	☐	PIQEXCCONTBUPA_NAME	BU_TEXT50	CHAR	50	0	Contact Name
21	APPROVE_DATE	☐	PIQEXCAPPRDATE	DATUM	DATS	8	0	Approval Date for Visiting Studies
22	EXCH_STATUS	☐	PIQEXCSTATUS	PIQEXCSTATUS	CHAR	4	0	External Admission Status	*
23	EXCH_STATUS_TXT	☐	PIQEXCSTATUST	TEXT40	CHAR	40	0	External Admission Status (Description)
24	EXCH_CHOICE	☐	PIQEXCCHOICE	NUMC2	NUMC	2	0	Visiting Studies Choice	T7PIQEXCCHOICE
25	EXCH_CHOICE_TXT	☐	PIQEXCCHOICET	TEXT40	CHAR	40	0	Visiting Studies Choice (Description)
26	ADDINFO	☐	PIQEXC_INFO	TEXT40	CHAR	40	0	Additional Information
27	HOMEDEGRTYPE	☐	PIQEXCHOMEDEGRTPE	PIQQUAL_LEVEL	CHAR	4	0	Degree Type of Home University	T7PIQQUAL_LEVEL
28	HOMEDEGRTYPE_TXT	☐	PIQEXCHOMEDEGRTPET	TEXT40	CHAR	40	0	Degree Type of Home University (Description)
29	STUDCATEGORY	☐	PIQEXCSTCAT	PIQEXCSTCAT	CHAR	4	0	Visiting Student Category	T7PIQEXCSTCAT
30	STUDCATEGORY_TXT	☐	PIQEXCSTCATT	TEXT40	CHAR	40	0	Visiting Student Category (Description)
31	ENDOFSTAY	☐	PIQEXCENDSTAY	DATUM	DATS	8	0	Last Day of Visiting Studies
32	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQEXC_STUDY_ALV	EXCH_CHOICE	T7PIQEXCCHOICE	CHOICE	REF	1	CN
2	PIQEXC_STUDY_ALV	HOMEDEGRTYPE	T7PIQQUAL_LEVEL	QUAL_LEVEL	REF	1	CN
3	PIQEXC_STUDY_ALV	STUDCATEGORY	T7PIQEXCSTCAT	CATEGORY	REF	1	CN

History

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