SAP ABAP Table P1785_EXP (Infotype 1785 expanded structures)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-GB (Application Component) United Kingdom
     ⤷ PMIQ_GB (Package) Campus Management (Great Britain)

Basic Data

Table Category	INTTAB	Structure
Structure	P1785_EXP	Table Relationship Diagram
Short Description	Infotype 1785 expanded structures

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 1785
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	UCAS: Infotype 1785
22	STATUS	☐	PIQ_GB_UCAS_RESULT_STATUS	PIQ_GB_UCAS_RESULT_STATUS	CHAR	1	0	UCAS: Flag for previous/final results
23	MATCH_IND	☐	PIQ_GB_UCAS_MATCH_INDC	PIQ_GB_UCAS_MATCH_INDC	CHAR	1	0	UCAS: Match indicator	T7PIQ_GB_MATCH
24	EXTORGID	☐	PIQEXTORGID	HROBJID	NUMC	8	0	External Organization ID	*
25	SUMMER_GCE_A_AS	☐	PIQ_GB_UCAS_GCE_A_AS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Summer GCE A/AS-Levels
26	SUMMER_A	☐	PIQ_GB_UCAS_SUMMER_A	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Summer (revised do not use)
27	SUMMER_VCE_A_AS	☐	PIQ_GB_UCAS_VCE_A_AS_DB	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Summer VCE AS/A-Levels and Doubles
28	SUMMER_AS	☐	PIQ_GB_UCAS_SUMMER_AS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Summer (revised do not use)
29	WINTER_A	☐	PIQ_GB_UCAS_WINTER_A	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Winter A-Levels
30	PREV_SUMMER_RES	☐	PIQ_GB_UCAS_PREV_RESULTS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of previous (revised do not use)
31	PREV_SUMMER_A	☐	PIQ_GB_UCAS_PREV_A	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of previous Summer A-Levels
32	PREV_AS	☐	PIQ_GB_UCAS_PREV_AS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of previous AS-Levels
33	HIGHERS	☐	PIQ_GB_UCAS_HIGHERS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	CM UCAS: No of Highers (revised do not use)
34	CSYS	☐	PIQ_GB_UCAS_CSYS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	CM UCAS: No of CSYS (revised do not use)
35	BTEC_FLAG	☐	PIQ_GB_UCAS_BTEC	PIQ_GB_UCAS_BTEC	CHAR	1	0	UCAS: BTEC Flag
36	HIG_FLAG	☐	PIQ_GB_UCAS_HHIQ_FLAG	PIQ_GB_UCAS_HHIQ_FLAG	CHAR	1	0	UCAS: HSC/IBAC Flag	T7PIQ_GB_HSC
37	IRISH_FLAG	☐	PIQ_GB_UCAS_IRISH_FLAG	PIQ_GB_UCAS_IRISH_FLAG	CHAR	1	0	UCAS: Irish Leaving Certification Flag
38	OTHER_RESULTS	☐	PIQ_GB_UCAS_OTHER_RESULTS	PIQ_GB_UCAS_OTHER_RESULTS	CHAR	1	0	UCAS: Other A/AS/Highers/CSYS Flag
39	REC_ACHIEVMNT	☐	PIQ_GB_UCAS_REC_ACHIEVMNT	PIQ_GB_UCAS_REC_ACHIEVMNT	CHAR	1	0	UCAS: Record of Achievement
40	REG_NUMBER	☐	PIQ_GB_UCAS_REG_NUM	PIQ_GB_UCAS_REG_NUM	CHAR	13	0	UCAS: BTEC/SQA Scottish Cand. Number
41	QEQ	☐	PIQ_GB_UCAS_QEQ	PIQ_GB_UCAS_QEQ	CHAR	1	0	UCAS: OEQ Flag	T7PIQ_GB_QEQ
42	SQA_FLAG	☐	PIQ_GB_UCAS_SQA_FLAG	PIQ_GB_UCAS_SQA_FLAG	CHAR	1	0	UCAS: Flag SQA applicant
43	GCEASN	☐	PIQ_GB_UCAS_TR_GCEASN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of GCE AS level
44	GCEASTS	☐	PIQ_GB_UCAS_TR_GCEASTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for GCE AS Level
45	VCEASN	☐	PIQ_GB_UCAS_TR_VCEASN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of VCE AS level
46	VCEASTS	☐	PIQ_GB_UCAS_TR_VCEASTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for VCE AS Level
47	GCEAN	☐	PIQ_GB_UCAS_TR_GCEAN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of GCE A level
48	GCEATS	☐	PIQ_GB_UCAS_TR_GCEATS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for GCE A Level
49	VCEAN	☐	PIQ_GB_UCAS_TR_VCEAN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of VCE A level
50	VCEATS	☐	PIQ_GB_UCAS_TR_VCEATS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for VCE A Level
51	KSQN	☐	PIQ_GB_UCAS_TR_KSQN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Key Skills
52	KSQTS	☐	PIQ_GB_UCAS_TR_KSQTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Key Skills qualification
53	UKSAN	☐	PIQ_GB_UCAS_TR_UKSAN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of 1-unit award Key Skills
54	UKSATS	☐	PIQ_GB_UCAS_TR_UKSATS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for 1-unit key skills award
55	SAHN	☐	PIQ_GB_UCAS_TR_SAHN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Advanced Higher
56	SAHTS	☐	PIQ_GB_UCAS_TR_SAHTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Advanced Higher
57	SHN	☐	PIQ_GB_UCAS_TR_SHN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Higher
58	SHTS	☐	PIQ_GB_UCAS_TR_SHTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Higher
59	SI2N	☐	PIQ_GB_UCAS_TR_SI2N	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Intermediate
60	SI2TS	☐	PIQ_GB_UCAS_TR_SI2TS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Intermediate 2
61	SSGCN	☐	PIQ_GB_UCAS_TR_SSGCN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Standard Grade Credit
62	SSGCTS	☐	PIQ_GB_UCAS_TR_SSGCTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Standard Grade Credit
63	SCSN	☐	PIQ_GB_UCAS_TR_SCSN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Core Skills
64	SCSTS	☐	PIQ_GB_UCAS_TR_SCSTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Core Skills
65	AEAN	☐	PIQ_GB_UCAS_TR_AEAN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Advanced Extension Awards
66	AEANTS	☐	PIQ_GB_UCAS_TR_AEANTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Advanced Extension Awards
67	TOTALTS	☐	PIQ_GB_UCAS_TR_TOTALTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Total Tariff Score
68	CACHEN	☐	PIQ_GB_UCAS_TR_CACHEN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of CACHE qualifications
69	CACHETS	☐	PIQ_GB_UCAS_TR_CACHETS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for CACHE qualifications
70	BTECN	☐	PIQ_GB_UCAS_TR_BTECN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of BTEC National
71	BTECTS	☐	PIQ_GB_UCAS_TR_BTECTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for BTEC National
72	IBTS	☐	PIQ_GB_UCAS_TR_IBTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for International Baccalaureate
73	ILCTS	☐	PIQ_GB_UCAS_TR_ILCTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for Irish Leaving Certificate
74	MDPATS	☐	PIQ_GB_UCAS_TR_MDPATS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for Music, Drama, Performing Arts
75	.INCLUDE	☐				0	0
76	TABNR	☐	HRTABNR	HRTABNR	CHAR	32	0	Reference Number to Table Part	*
77	TABSEQNR	☐	HRTABSEQNR	NUM06	NUMC	6	0	Sequence Number in Table Part of Table Infotype
78	.INCLUDE	☐				0	0	UCAS: Table Section Infotype 1785
79	T_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
80	SUBJECT	☐	PIQSUBJECT	HROBJID	NUMC	8	0	School Subject, Academic Subject, or Qualification	*
81	ORGMARK	☐	PIQORGMARK	PIQORGMARK	CHAR	10	0	Original Grade	T7PIQ_GB_POINTS
82	QUALITY	☐	PIQ_GB_UCAS_GRADE_TYPE	PIQ_GB_UCAS_GRADE_TYPE	CHAR	4	0	UCAS: Grade type (Qualification)	T7PIQ_GB_RESTYP
83	GRADE_BAND	☐	PIQ_GB_UCAS_GRADE_BAND	PIQ_GB_UCAS_GRADE_BAND	CHAR	4	0	UCAS: Special paper grade band	*
84	GRADE_2	☐	PIQ_GB_UCAS_GRADE	PIQ_GB_UCAS_GRADE	CHAR	1	0	UCAS: Grade 2	T7PIQ_GB_POINTS
85	EXAM_BOARD	☐	PIQ_GB_UCAS_EX_BOARD	PIQ_GB_UCAS_EX_BOARD	CHAR	1	0	UCAS: Exam Board Code	T7PIQ_GB_EBOARD
86	MARKDATE	☐	PIQMARKDATE		DATS	8	0	Reference Date for Grade
87	EXAM_LEVEL_CODE	☐	PIQ_GB_EXAM_LEVEL_CODE	PIQ_GB_EXAM_LEVEL_CODE	CHAR	4	0	UCAS Exam Level Code	T7PIQ_GB_EXLVLCD
88	SITTING	☐	PIQ_GB_UCAS_SITTNG	PIQ_GB_UCAS_SITTNG	CHAR	1	0	UCAS: Sitting
89	LAST_UPDATED	☐	PIQ_GB_UCAS_LAST_UPDATED	DATS	DATS	8	0	UCAS: Last Updated Date
90	EXAM_YEAR	☐	PIQ_GB_UCAS_EXAM_YEAR	PIQPERYR	NUMC	4	0	UCAS: Exam Year	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P1785_EXP	EXAM_BOARD	T7PIQ_GB_EBOARD	EXAM_BOARD		1	CN
2	P1785_EXP	EXAM_LEVEL_CODE	T7PIQ_GB_EXLVLCD	EXAM_LEVEL_CODE
3	P1785_EXP	GRADE_2	T7PIQ_GB_POINTS	GRADE_2
4	P1785_EXP	HIG_FLAG	T7PIQ_GB_HSC	HIG_FLAG		1	CN
5	P1785_EXP	INFTY	T778T	INFTY
6	P1785_EXP	ISTAT	T778S	ISTAT
7	P1785_EXP	MANDT	T000	MANDT
8	P1785_EXP	MATCH_IND	T7PIQ_GB_MATCH	MATCH_INDC		1	CN
9	P1785_EXP	ORGMARK	T7PIQ_GB_POINTS	GRADE
10	P1785_EXP	OTYPE	T778O	OTYPE
11	P1785_EXP	PLVAR	T778P	PLVAR
12	P1785_EXP	QEQ	T7PIQ_GB_QEQ	QEQ		1	CN
13	P1785_EXP	QUALITY	T7PIQ_GB_RESTYP	QUALITY
14	P1785_EXP	T_OTYPE	T778O	OTYPE		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in