SAP ABAP Table P1719_EXP (Expanded Structure for Infotype 1719)

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	P1719_EXP	Table Relationship Diagram
Short Description	Expanded Structure for Infotype 1719

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	Infotype 1719: External Transcripts
2	.INCLUDE	☐				0	0	Key Structure for Infotype Structures PNNNN
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
5	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
6	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
7	INFTY	☐	INFOTYP	INFOTYP	CHAR	4	0	Infotype	T778T
8	SUBTY	☐	SUBTYP	SUBTYP	CHAR	4	0	Subtype	*
9	ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
10	PRIOX	☐	PRIOX	CHAR2	CHAR	2	0	Priority
11	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
12	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
13	VARYF	☐	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
14	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
15	.INCLUDE	☐				0	0	Infotype Administration Data
16	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
17	UNAME	☐	USRNAME	CHAR12	CHAR	12	0	User Name
18	REASN	☐	REASN	CHAR2	CHAR	2	0	Reason
19	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
20	ITXNR	☐	ITXNR	NUM08	NUMC	8	0	Text Module for Infotype
21	.INCLUDE	☐				0	0	Infotype 1719: External Transcripts
22	.INCLUDE	☐				0	0	Transcripts (Header Data)
23	TRANS_GUID	☐	PIQTRTRANS_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique ID of External Transcript
24	TRANSTYPE	☐	PIQTRTRANSTYPE	PIQTRTRANSTYPE	CHAR	4	0	Transcript Category	T7PIQTRTRANSTYP
25	ISSEO	☐	PIQTRISSEO	HROBJID	NUMC	8	0	Issuing External Organization	*
26	TRANSEO	☐	PIQTRTRANSEO	HROBJID	NUMC	8	0	Transmitting External Organization	*
27	TRSTATUS	☐	PIQREPSTATE	PIQREPSTATE	CHAR	4	0	Transcript Status	T7PIQREPSTAT
28	REGPERIODFROM	☐	PIQTRREGPERIODFROM		DATS	8	0	Start Date of Registration at External Organization
29	REGPERIODTO	☐	PIQTRREGPERIODTO		DATS	8	0	End Date of Registration at External Organization
30	RANKING	☐	PIQTRRANKING		NUMC	4	0	Rank
31	SIZEOFCLASS	☐	PIQTRSIZEOFCLASS		NUMC	4	0	Class Size
32	RETURNINDIC	☐	PIQTRRETURNINDIC	PIQTRRETURNINDIC	CHAR	4	0	Eligibility to Return	T7PIQTRRETINDIC
33	RETURNDATE	☐	PIQTRRETURNDATE		DATS	8	0	Date of Eligibility to Return
34	TOTSELFGPA	☐	PIQTRTOTSELFREPGPA		CHAR	10	0	Self-Reported Average
35	TOTSELFGPANORM	☐	PIQTRTOTSELFGPANORM	PIQSCALE_NORM_VAL	DEC	8	2	Self-Reported Average (Standard Value)
36	TOTSELFGPASCALE	☐	PIQTRTOTSELFGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Self-Reported Average	T7PIQSCALE
37	TOTEXTGPA1	☐	PIQTRTOTEXTGPA1		CHAR	10	0	External Average 1
38	TOTEXTGPA1NORM	☐	PIQTRTOTEXTGPA1NORM	PIQSCALE_NORM_VAL	DEC	8	2	External Average 1 (Standard Value)
39	TOTEXTGPA1SCALE	☐	PIQTRTOTEXTGPA1SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 1	T7PIQSCALE
40	TOTEXTGPA2	☐	PIQTRTOTEXTGPA2		CHAR	10	0	External Average 2
41	TOTEXTGPA2NORM	☐	PIQTRTOTEXTGPA2NORM	PIQSCALE_NORM_VAL	DEC	8	2	External Average 2 (Standard Value)
42	TOTEXTGPA2SCALE	☐	PIQTRTOTEXTGPA2SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 2	T7PIQSCALE
43	TOTEXTGPA3	☐	PIQTRTOTEXTGPA3		CHAR	10	0	External Average 3
44	TOTEXTGPA3NORM	☐	PIQTRTOTEXTGPA3NORM	PIQSCALE_NORM_VAL	DEC	8	2	External Average 3 (Standard Value)
45	TOTEXTGPA3SCALE	☐	PIQTRTOTEXTGPA3SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 3	T7PIQSCALE
46	CALCGPAMANFLAG	☐	PIQTRCALCGPAMANFLAG		CHAR	1	0	Overwrite Calculated Average Manually
47	TOTCALCGPA	☐	PIQTRTOTCALCGPA		CHAR	10	0	Calculated Average
48	TOTCALCGPANORM	☐	PIQTRTOTCALCGPANORM	PIQSCALE_NORM_VAL	DEC	8	2	Calculated Average (Standard Value)
49	TOTCALCGPASCALE	☐	PIQTRTOTCALCGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Calculated Average	T7PIQSCALE
50	TOTEXTATMCRED	☐	PIQTRTOTEXTATMCRED	PIQCP	QUAN	10	5	Total Attempted Credits
51	TOTEXTGRDCRED	☐	PIQTRTOTEXTGRDCRED	PIQCP	QUAN	10	5	Total Graded Credits
52	TOTEXTERNCRED	☐	PIQTRTOTEXTERNCRED	PIQCP	QUAN	10	5	Total Earned Credits
53	TOTEXTCREDTYPE	☐	PIQTRTOTEXTCREDTYPE	MEINS	UNIT	3	0	Original Type of Total Credits	T7PIQCP
54	TOTCREDMANFLAG	☐	PIQTRTOTCREDMANFLAG		CHAR	1	0	Overwrite Converted Credits Manually
55	TOTINTATMCRED	☐	PIQTRTOTINTATMCRED	PIQCP	QUAN	10	5	Total Attempted Credits In Internal Credit Type
56	TOTINTGRDCRED	☐	PIQTRTOTINTGRDCRED	PIQCP	QUAN	10	5	Total Graded Credits In Internal Credit Type
57	TOTINTERNCRED	☐	PIQTRTOTINTERNCRED	PIQCP	QUAN	10	5	Total Earned Credits In Internal Credit Type
58	TOTINTCREDTYPE	☐	PIQTRTOTINTCREDTYPE	MEINS	UNIT	3	0	Converted Credit Type	T7PIQCP
59	TABNR	☐	HRTABNR	HRTABNR	CHAR	32	0	Reference Number to Table Part	*
60	TABSEQNR	☐	HRTABSEQNR	NUM06	NUMC	6	0	Sequence Number in Table Part of Table Infotype
61	.INCLUDE	☐				0	0	Infotype 1719: Table Section for Ext. Transcripts
62	DATATYPE	☐	PIQTRDATATYPE	PIQTRDATATYPE	NUMC	2	0	Record Type
63	.INCLUDE	☐				0	0	External Academic Qualifications
64	DEGREENR	☐	PIQTRDEGREENR		NUMC	2	0	Number of Degree/Qualification
65	DEGREEID	☐	PIQTRDEGREEID	HROBJID	NUMC	8	0	Degree/Qualification	*
66	PROGRAMID	☐	PIQTRPROGRAMID		CHAR	12	0	Registered Program
67	DEGERNFLAG	☐	PIQTRDEGERNFLAG	PIQTRDEGERNFLAG	CHAR	1	0	Indicator: Degree or Qualification Earned
68	DEGDATE	☐	PIQTRDEGDATE		DATS	8	0	(Anticipated) Completion Date
69	DEGEXTGRADE	☐	PIQTRDEGEXTMARK		CHAR	10	0	External Grade Achieved in Qualification
70	DEGEXTGRADENORM	☐	PIQTRDEGEXTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	External Grade of Achieved Qualification (Std Value)
71	DEGEXTSCALEID	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
72	DEGMANFLAG	☐	PIQTRDEGMANFLAG		CHAR	1	0	Overwrite Internal Grade of Qualification Manually
73	DEGINTGRADE	☐	PIQTRDEGINTGRADE		CHAR	10	0	Internal Grade of Achieved Qualification
74	DEGINTGRADENORM	☐	PIQTRDEGINTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	Internal Grade of Achieved Qualification (Std Value)
75	DEGINTSCALEID	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
76	DEGHONORS	☐	PIQTRDEGHONORS	PIQTRDEGHONORS	CHAR	4	0	Academic Honors in Qualification	T7PIQTRDEGHON
77	.INCLUDE	☐				0	0	External Academic Specializations
78	SPECDEGREENR	☐	PIQTRDEGREENR		NUMC	2	0	Number of Degree/Qualification
79	SPECID	☐	PIQTRDEGSPECID	PIQSMDISZIP	CHAR	16	0	Chosen Program Specialization	T7PIQSMDISZIP
80	SPECTYPE	☐	PIQTRDEGSPECTYPE	PIQMODGRPCAT	CHAR	4	0	Specialization Type	T7PIQMODGRPCAT
81	.INCLUDE	☐				0	0	Academic Session Data of External Organization
82	SESSIONID	☐	PIQTRSESSIONID	PIQTRSESSIONID	CHAR	4	0	External Academic Session	T7PIQTREXTSES
83	SESSIONYEAR	☐	PIQTRSESSIONYEAR	PIQTRSESSIONYEAR	NUMC	4	0	Year of Registration
84	SESBEGDATE	☐	PIQTRSESBEGDATE		DATS	8	0	Start Date of Academic Session
85	SESENDDATE	☐	PIQTRSESENDDATE		DATS	8	0	End Date of Academic Session
86	SESWITHDRDATE	☐	PIQTRSESWITHDRDATE		DATS	8	0	De-registration Date
87	SESDEGREEID	☐	PIQTRDEGREEID	HROBJID	NUMC	8	0	Degree/Qualification	*
88	SESPROGRAMID	☐	PIQTRPROGRAMID		CHAR	12	0	Registered Program
89	STAGEID	☐	PIQTRSTAGEID	PIQLEVEL	NUMC	2	0	Registered Program Stage	T7PIQLEVEL
90	PROGCLASSID	☐	PIQTRPROGCLASSID	PIQPROGCLASS	CHAR	4	0	Progress Classification	T7PIQPROGCLASS
91	PROGACST	☐	PIQTRPROGACST	PIQTRPROGACST	CHAR	4	0	External Academic Standing	T7PIQTRPROGAS
92	PROGSTAT	☐	PIQPROGSTATUS	PIQPROGSTATUS	NUMC	3	0	Program Progression Status	T7PIQPROGSTATUS
93	EXTSESGPA	☐	PIQTREXTSESGPA		CHAR	10	0	External Sessional Average
94	EXTSESGPANORM	☐	PIQTREXTSESGPANORM	PIQSCALE_NORM_VAL	DEC	8	2	Original Sessional Average Standard Value)
95	EXTSESGPASCALE	☐	PIQTREXTSESGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Original Sessional Average	T7PIQSCALE
96	SESGPAMANFLAG	☐	TRPIQSESGPAMANFLAG		CHAR	1	0	Overwrite Internal Sessional Average Manually
97	INTSESGPA	☐	PIQTRINTSESGPA		CHAR	10	0	Internal Sessional Average
98	INTSESGPANORM	☐	PIQTRINTSESGPANORM	PIQSCALE_NORM_VAL	DEC	8	2	Internal Sessional Average (Standard Value)
99	INTSESGPASCALE	☐	PIQTRINTSESGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Internal Sessional Average	T7PIQSCALE
100	EXTSESATMCRED	☐	PIQTREXTSESATMCRED	PIQCP	QUAN	10	5	Attempted Credits Per Academic Session
101	EXTSESGRDCRED	☐	PIQTREXTSESGRDCRED	PIQCP	QUAN	10	5	Graded Credits Per Academic Session
102	EXTSESERNCRED	☐	PIQTREXTSESERNCRED	PIQCP	QUAN	10	5	Earned Credits Per Academic Session
103	EXTSESCREDTYPE	☐	PIQTREXTSESCREDTYPE	MEINS	UNIT	3	0	External Credit Type of Sessional Credits	T7PIQCP
104	SESCREDMANFLAG	☐	PIQTRSESCREDMANFLAG		CHAR	1	0	Overwrite Converted Sessional Credits Manually
105	INTSESATMCRED	☐	PIQTRINTSESATMCRED	PIQCP	QUAN	10	5	Attempted Credits Per Session In Internal Credit Type
106	INTSESGRDCRED	☐	PIQTRINTSESGRDCRED	PIQCP	QUAN	10	5	Graded Credits Per Session In Internal Credit Type
107	INTSESERNCRED	☐	PIQTRINTSESERNCRED	PIQCP	QUAN	10	5	Earned Credits Per Session In Internal Credit Type
108	INTSESCREDTYPE	☐	PIQTRINTSESCREDTYPE	MEINS	UNIT	3	0	Credit Type of Converted Sessional Credits	T7PIQCP
109	.INCLUDE	☐				0	0	External Subject Data
110	COURSEID	☐	PIQTRCOURSEID	HROBJID	NUMC	8	0	Registered Subject	*
111	EXTGRADE	☐	PIQTREXTGRADE		CHAR	10	0	Original Grade in External Subject
112	EXTGRADENORM	☐	PIQTREXTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	Original Grade per Subject (Standard Value)
113	EXTGRADESCALE	☐	PIQTREXTGRADESCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Original Grade	T7PIQSCALE
114	GRADEMANFLAG	☐	PIQTRGRADEMANFLAG		CHAR	1	0	Overwrite Converted Original Grade of External Subject
115	INTGRADE	☐	PIQTRINTGRADE		CHAR	10	0	Original Grade in External Subject on Internal Grading Scale
116	INTGRADENORM	☐	PIQTRINTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	Converted Grade per Subject (Standard Value)
117	INTGRADESCALE	☐	PIQTRINTGRADESCALE	PIQSCALE_ID	CHAR	4	0	Internal Grading Scale for Converted Grade per Subject	T7PIQSCALE
118	COREPEATFLAG	☐	PIQTRCOREPEATFLAG		CHAR	1	0	Indicator: Repeated Subject
119	HONORSINDIC	☐	PIQTRHONORSINDIC		CHAR	1	0	Indicator: Honors Subject
120	EXTCOATMCRED	☐	PIQTREXTCOATMCRED	PIQCP	QUAN	10	5	Attempted Credits in External Subject
121	EXTCOGRDCRED	☐	PIQTREXTCOGRDCRED	PIQCP	QUAN	10	5	Graded Credits in External Subject
122	EXTCOERNCRED	☐	PIQTREXTCOERNCRED	PIQCP	QUAN	10	5	Earned Credits in External Subject
123	EXTCOCREDTYPE	☐	PIQTREXTCOCREDTYPE	MEINS	UNIT	3	0	Original Credit Type of External Subject	T7PIQCP
124	COCREDMANFLAG	☐	PIQTRCOCREDMANFLAG		CHAR	1	0	Overwrite Converted Credits Per External Subject Manually
125	INTCOATMCRED	☐	PIQTRINTCOATMCRED	PIQCP	QUAN	10	5	Attempted Credits in Ext. Subject in Internal Credit Type
126	INTCOGRDCRED	☐	PIQTRINTCOGRDCRED	PIQCP	QUAN	10	5	Graded Credits in Ext. Subject in Internal Credit Type
127	INTCOERNCRED	☐	PIQTRINTCOERNCRED	PIQCP	QUAN	10	5	Earned Credits in Ext. Subject in Internal Credit Type
128	INTCOCREDTYPE	☐	PIQTRINTCOCREDTYPE	MEINS	UNIT	3	0	Internal Credit Type	T7PIQCP
129	BASFORCOCRED	☐	PIQTRBASFORCOCRED	PIQTRBASFORCRED	CHAR	4	0	Basis for Accomplished Credits	T7PIQTRBASFORCP
130	COREFLAG	☐	PIQTRCOREFLAG		CHAR	1	0	Indicator for Core Subject
131	COWITHDRDATE	☐	PIQTRCOWITHDRDATE		DATS	8	0	Date of Withdrawal
132	COSESID	☐	PIQTRCOSESID	PIQTRSESSIONID	CHAR	4	0	Session In Which External Subject Was Taken	T7PIQTREXTSES
133	COSESYEAR	☐	PIQTRCOSESYEAR	PIQTRSESSIONYEAR	NUMC	4	0	Year In Which Subject Was Taken
134	COBEGDATE	☐	PIQTRCOBEGDATE		DATS	8	0	Start Date of Subject
135	COENDDATE	☐	PIQTRCOENDDATE		DATS	8	0	End Date of Subject
136	.INCLUDE	☐				0	0	Coded Notes
137	CODEDNOTEID	☐	PIQTRCODEDNOTEID	PIQTRCODEDNOTEID	CHAR	12	0	Coded Note	T7PIQTRCODNOTE
138	COMMENTLINE	☐	PIQTRCOMMENT	TEXT80	CHAR	80	0	Comment
139	.INCLUDE	☐				0	0	User-Defined Text
140	LINENR	☐	PIQTRLINENR		NUMC	4	0	Line Number in SAP TextEdit
141	FREETEXTLINE	☐	PIQTRFREETEXTLINE	TEXT79	CHAR	79	0	Comments

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P1719_EXP	BASFORCOCRED	T7PIQTRBASFORCP	BASISFORCP	KEY	1	CN
2	P1719_EXP	CODEDNOTEID	T7PIQTRCODNOTE	CODEDNOTEID	KEY	1	CN
3	P1719_EXP	COSESID	T7PIQTREXTSES	SESSIONID	KEY	1	CN
4	P1719_EXP	DEGEXTSCALEID	T7PIQSCALE	SCALEID	KEY	1	CN
5	P1719_EXP	DEGHONORS	T7PIQTRDEGHON	DEGHONORS	KEY	1	CN
6	P1719_EXP	DEGINTSCALEID	T7PIQSCALE	SCALEID	KEY	1	CN
7	P1719_EXP	EXTCOCREDTYPE	T7PIQCP	CPUNIT	KEY	1	CN
8	P1719_EXP	EXTGRADESCALE	T7PIQSCALE	SCALEID	KEY	1	CN
9	P1719_EXP	EXTSESCREDTYPE	T7PIQCP	CPUNIT	KEY	1	CN
10	P1719_EXP	EXTSESGPASCALE	T7PIQSCALE	SCALEID	KEY	1	CN
11	P1719_EXP	INFTY	T778T	INFTY
12	P1719_EXP	INTCOCREDTYPE	T7PIQCP	CPUNIT	KEY	1	CN
13	P1719_EXP	INTGRADESCALE	T7PIQSCALE	SCALEID	KEY	1	CN
14	P1719_EXP	INTSESCREDTYPE	T7PIQCP	CPUNIT	KEY	1	CN
15	P1719_EXP	INTSESGPASCALE	T7PIQSCALE	SCALEID	KEY	1	CN
16	P1719_EXP	ISTAT	T778S	ISTAT
17	P1719_EXP	MANDT	T000	MANDT
18	P1719_EXP	OTYPE	T778O	OTYPE
19	P1719_EXP	PLVAR	T778P	PLVAR
20	P1719_EXP	PROGACST	T7PIQTRPROGAS	PROGACST
21	P1719_EXP	PROGCLASSID	T7PIQPROGCLASS	PROGCLASS	KEY	1	CN
22	P1719_EXP	PROGSTAT	T7PIQPROGSTATUS	PROGSTATUS	KEY	1	CN
23	P1719_EXP	RETURNINDIC	T7PIQTRRETINDIC	RETURNINDIC	KEY	1	CN
24	P1719_EXP	SESSIONID	T7PIQTREXTSES	SESSIONID	KEY	1	CN
25	P1719_EXP	SPECID	T7PIQSMDISZIP	DISZIP	KEY	1	CN
26	P1719_EXP	SPECTYPE	T7PIQMODGRPCAT	CATEGORY	KEY	1	CN
27	P1719_EXP	STAGEID	T7PIQLEVEL	ACLEVEL	KEY	1	CN
28	P1719_EXP	TOTCALCGPASCALE	T7PIQSCALE	SCALEID	KEY	1	CN
29	P1719_EXP	TOTEXTCREDTYPE	T7PIQCP	CPUNIT	KEY	1	CN
30	P1719_EXP	TOTEXTGPA1SCALE	T7PIQSCALE	SCALEID	KEY	1	CN
31	P1719_EXP	TOTEXTGPA2SCALE	T7PIQSCALE	SCALEID	KEY	1	CN
32	P1719_EXP	TOTEXTGPA3SCALE	T7PIQSCALE	SCALEID	KEY	1	CN
33	P1719_EXP	TOTINTCREDTYPE	T7PIQCP	CPUNIT	KEY	1	CN
34	P1719_EXP	TOTSELFGPASCALE	T7PIQSCALE	SCALEID	KEY	1	CN
35	P1719_EXP	TRANSTYPE	T7PIQTRTRANSTYP	TRANSTYPE
36	P1719_EXP	TRSTATUS	T7PIQREPSTAT	REPSTATE		1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in	463