SAP ABAP Table PIQTR_TESTRESULTSDISPLIST (Ext. Test Result 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	PIQTR_TESTRESULTSDISPLIST	Table Relationship Diagram
Short Description	Ext. Test Result 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	.INCLUDE	☐				0	0	Infotype 1721
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	External Test Results
22	.INCLUDE	☐				0	0	External Test Results (Header Data)
23	TEST_GUID	☐	PIQTRTEST_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique ID of External Test Results
24	TESTEO	☐	PIQTRISSEO	HROBJID	NUMC	8	0	Issuing External Organization	*
25	TRANSEO	☐	PIQTRTRANSEO	HROBJID	NUMC	8	0	Transmitting External Organization	*
26	TESTTYPE	☐	PIQTRTESTTYPE	PIQTRTESTTYPE	CHAR	12	0	Test Type	T7PIQTRTESTTYPE
27	SESSIONID	☐	PIQTRSESSIONID	PIQTRSESSIONID	CHAR	4	0	External Academic Session	T7PIQTREXTSES
28	SESSIONYEAR	☐	PIQTRSESSIONYEAR	PIQTRSESSIONYEAR	NUMC	4	0	Year of Registration
29	ENTRYDATE	☐	PIQTRENTRYDATE		DATS	8	0	Entry Date of External Test Results
30	TESTPASSFAIL	☐	PIQTRTESTPASSFAIL	PIQTRTESTPASSFAIL	CHAR	1	0	External Test Passed
31	TESTTOTRES	☐	PIQTREXTTOTRES		CHAR	10	0	Total Test Result
32	TESTTOTRESNORM	☐	PIQTREXTTOTRESNORM	PIQSCALE_NORM_VAL	DEC	8	2	Total Test Result (Standard Value)
33	TESTSCALE_ID	☐	PIQTRTESTSCALE_ID	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average	T7PIQSCALE
34	TOTALPERCENT1	☐	PIQTRTOTALPERCENT	PIQTRTOTALPERCENT	DEC	5	2	Student's Percentile Rank
35	TOTALPERCENT2	☐	PIQTRTOTALPERCENT2	PIQTRTOTALPERCENT	DEC	5	2	Additional Total Test Percentile
36	ENTRYMODE	☐	PIQTRENTRYMODE	PIQTRENTRYMODE	CHAR	4	0	Source of External Test Results	T7PIQTRENTRYMOD
37	RESULTSTATUS	☐	PIQTRTESTRESULTSTATUS	PIQTRTESTRESULTSTATUS	CHAR	3	0	External Test Result Status	T7PIQTRSTAT
38	STATUSREASON	☐	PIQTRINVALIDATEREASON	PIQTRINVALIDATESCOREREASON	CHAR	3	0	Reason for invalidating the Test Result	T7PIQINVRSN
39	.INCLUDE	☐				0	0
40	TABNR	☐	HRTABNR	HRTABNR	CHAR	32	0	Reference Number to Table Part	*
41	.INCLUDE	☐				0	0	Texts for External Test Results (Header Data)
42	TESTEO_SHORT	☐	PIQTR_TESTEO_SHORT	TEXT12	CHAR	12	0	External Testing Organization (ID)
43	TESTEO_STEXT	☐	PIQTR_TESTEO_STEXT	TEXT40	CHAR	40	0	External Testing Organization (Name)
44	TRANSEO_SHORT	☐	PIQTR_TRANSEO_SHORT	TEXT12	CHAR	12	0	Transmitting External Organization (ID)
45	TRANSEO_STEXT	☐	PIQTR_TRANSEO_STEXT	TEXT40	CHAR	40	0	Transmitting External Organization (Name)
46	TESTTYPETEXT	☐	PIQTRTESTTYPETEXT	TEXT50	CHAR	50	0	External Test Type (Description)
47	SESSIONT	☐	PIQTRSESSIONT	TEXT20	CHAR	20	0	External Academic Session (Description)
48	ENTRYMODETEXT	☐	PIQTRENTRYMODET	TEXT50	CHAR	50	0	Source of External Test Results (Description)
49	SCALETEXT	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQTR_TESTRESULTSDISPLIST	ENTRYMODE	T7PIQTRENTRYMOD	ENTRYMODE	KEY	1	CN
2	PIQTR_TESTRESULTSDISPLIST	INFTY	T778T	INFTY
3	PIQTR_TESTRESULTSDISPLIST	ISTAT	T778S	ISTAT
4	PIQTR_TESTRESULTSDISPLIST	MANDT	T000	MANDT
5	PIQTR_TESTRESULTSDISPLIST	OTYPE	T778O	OTYPE
6	PIQTR_TESTRESULTSDISPLIST	PLVAR	T778P	PLVAR
7	PIQTR_TESTRESULTSDISPLIST	RESULTSTATUS	T7PIQTRSTAT	STATUSCODE
8	PIQTR_TESTRESULTSDISPLIST	SESSIONID	T7PIQTREXTSES	SESSIONID	KEY	1	CN
9	PIQTR_TESTRESULTSDISPLIST	STATUSREASON	T7PIQINVRSN	REASONCODE
10	PIQTR_TESTRESULTSDISPLIST	TESTSCALE_ID	T7PIQSCALE	SCALEID	KEY	1	CN
11	PIQTR_TESTRESULTSDISPLIST	TESTTYPE	T7PIQTRTESTTYPE	TESTTYPE	KEY	1	CN

History

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