SAP ABAP Table P1785 (Infotype 1785)

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	Table Relationship Diagram
Short Description	Infotype 1785

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	Key Structure for Infotype Structures PNNNN
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
4	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
5	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
6	INFTY	☐	INFOTYP	INFOTYP	CHAR	4	0	Infotype	T778T
7	SUBTY	☐	SUBTYP	SUBTYP	CHAR	4	0	Subtype	*
8	ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
9	PRIOX	☐	PRIOX	CHAR2	CHAR	2	0	Priority
10	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
11	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
12	VARYF	☐	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
13	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
14	.INCLUDE	☐				0	0	Infotype Administration Data
15	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
16	UNAME	☐	USRNAME	CHAR12	CHAR	12	0	User Name
17	REASN	☐	REASN	CHAR2	CHAR	2	0	Reason
18	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
19	ITXNR	☐	ITXNR	NUM08	NUMC	8	0	Text Module for Infotype
20	.INCLUDE	☐				0	0	UCAS: Infotype 1785
21	STATUS	☐	PIQ_GB_UCAS_RESULT_STATUS	PIQ_GB_UCAS_RESULT_STATUS	CHAR	1	0	UCAS: Flag for previous/final results
22	MATCH_IND	☐	PIQ_GB_UCAS_MATCH_INDC	PIQ_GB_UCAS_MATCH_INDC	CHAR	1	0	UCAS: Match indicator	T7PIQ_GB_MATCH
23	EXTORGID	☐	PIQEXTORGID	HROBJID	NUMC	8	0	External Organization ID	*
24	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
25	SUMMER_A	☐	PIQ_GB_UCAS_SUMMER_A	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Summer (revised do not use)
26	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
27	SUMMER_AS	☐	PIQ_GB_UCAS_SUMMER_AS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Summer (revised do not use)
28	WINTER_A	☐	PIQ_GB_UCAS_WINTER_A	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Winter A-Levels
29	PREV_SUMMER_RES	☐	PIQ_GB_UCAS_PREV_RESULTS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of previous (revised do not use)
30	PREV_SUMMER_A	☐	PIQ_GB_UCAS_PREV_A	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of previous Summer A-Levels
31	PREV_AS	☐	PIQ_GB_UCAS_PREV_AS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of previous AS-Levels
32	HIGHERS	☐	PIQ_GB_UCAS_HIGHERS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	CM UCAS: No of Highers (revised do not use)
33	CSYS	☐	PIQ_GB_UCAS_CSYS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	CM UCAS: No of CSYS (revised do not use)
34	BTEC_FLAG	☐	PIQ_GB_UCAS_BTEC	PIQ_GB_UCAS_BTEC	CHAR	1	0	UCAS: BTEC Flag
35	HIG_FLAG	☐	PIQ_GB_UCAS_HHIQ_FLAG	PIQ_GB_UCAS_HHIQ_FLAG	CHAR	1	0	UCAS: HSC/IBAC Flag	T7PIQ_GB_HSC
36	IRISH_FLAG	☐	PIQ_GB_UCAS_IRISH_FLAG	PIQ_GB_UCAS_IRISH_FLAG	CHAR	1	0	UCAS: Irish Leaving Certification Flag
37	OTHER_RESULTS	☐	PIQ_GB_UCAS_OTHER_RESULTS	PIQ_GB_UCAS_OTHER_RESULTS	CHAR	1	0	UCAS: Other A/AS/Highers/CSYS Flag
38	REC_ACHIEVMNT	☐	PIQ_GB_UCAS_REC_ACHIEVMNT	PIQ_GB_UCAS_REC_ACHIEVMNT	CHAR	1	0	UCAS: Record of Achievement
39	REG_NUMBER	☐	PIQ_GB_UCAS_REG_NUM	PIQ_GB_UCAS_REG_NUM	CHAR	13	0	UCAS: BTEC/SQA Scottish Cand. Number
40	QEQ	☐	PIQ_GB_UCAS_QEQ	PIQ_GB_UCAS_QEQ	CHAR	1	0	UCAS: OEQ Flag	T7PIQ_GB_QEQ
41	SQA_FLAG	☐	PIQ_GB_UCAS_SQA_FLAG	PIQ_GB_UCAS_SQA_FLAG	CHAR	1	0	UCAS: Flag SQA applicant
42	GCEASN	☐	PIQ_GB_UCAS_TR_GCEASN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of GCE AS level
43	GCEASTS	☐	PIQ_GB_UCAS_TR_GCEASTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for GCE AS Level
44	VCEASN	☐	PIQ_GB_UCAS_TR_VCEASN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of VCE AS level
45	VCEASTS	☐	PIQ_GB_UCAS_TR_VCEASTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for VCE AS Level
46	GCEAN	☐	PIQ_GB_UCAS_TR_GCEAN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of GCE A level
47	GCEATS	☐	PIQ_GB_UCAS_TR_GCEATS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for GCE A Level
48	VCEAN	☐	PIQ_GB_UCAS_TR_VCEAN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of VCE A level
49	VCEATS	☐	PIQ_GB_UCAS_TR_VCEATS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for VCE A Level
50	KSQN	☐	PIQ_GB_UCAS_TR_KSQN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Key Skills
51	KSQTS	☐	PIQ_GB_UCAS_TR_KSQTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Key Skills qualification
52	UKSAN	☐	PIQ_GB_UCAS_TR_UKSAN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of 1-unit award Key Skills
53	UKSATS	☐	PIQ_GB_UCAS_TR_UKSATS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for 1-unit key skills award
54	SAHN	☐	PIQ_GB_UCAS_TR_SAHN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Advanced Higher
55	SAHTS	☐	PIQ_GB_UCAS_TR_SAHTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Advanced Higher
56	SHN	☐	PIQ_GB_UCAS_TR_SHN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Higher
57	SHTS	☐	PIQ_GB_UCAS_TR_SHTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Higher
58	SI2N	☐	PIQ_GB_UCAS_TR_SI2N	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Intermediate
59	SI2TS	☐	PIQ_GB_UCAS_TR_SI2TS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Intermediate 2
60	SSGCN	☐	PIQ_GB_UCAS_TR_SSGCN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Standard Grade Credit
61	SSGCTS	☐	PIQ_GB_UCAS_TR_SSGCTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Standard Grade Credit
62	SCSN	☐	PIQ_GB_UCAS_TR_SCSN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Core Skills
63	SCSTS	☐	PIQ_GB_UCAS_TR_SCSTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Core Skills
64	AEAN	☐	PIQ_GB_UCAS_TR_AEAN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Advanced Extension Awards
65	AEANTS	☐	PIQ_GB_UCAS_TR_AEANTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Advanced Extension Awards
66	TOTALTS	☐	PIQ_GB_UCAS_TR_TOTALTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Total Tariff Score
67	CACHEN	☐	PIQ_GB_UCAS_TR_CACHEN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of CACHE qualifications
68	CACHETS	☐	PIQ_GB_UCAS_TR_CACHETS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for CACHE qualifications
69	BTECN	☐	PIQ_GB_UCAS_TR_BTECN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of BTEC National
70	BTECTS	☐	PIQ_GB_UCAS_TR_BTECTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for BTEC National
71	IBTS	☐	PIQ_GB_UCAS_TR_IBTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for International Baccalaureate
72	ILCTS	☐	PIQ_GB_UCAS_TR_ILCTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for Irish Leaving Certificate
73	MDPATS	☐	PIQ_GB_UCAS_TR_MDPATS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for Music, Drama, Performing Arts
74	.INCLUDE	☐				0	0
75	TABNR	☐	HRTABNR	HRTABNR	CHAR	32	0	Reference Number to Table Part	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P1785	HIG_FLAG	T7PIQ_GB_HSC	HIG_FLAG		1	CN
2	P1785	INFTY	T778T	INFTY
3	P1785	ISTAT	T778S	ISTAT
4	P1785	MANDT	T000	MANDT
5	P1785	MATCH_IND	T7PIQ_GB_MATCH	MATCH_INDC		1	CN
6	P1785	OTYPE	T778O	OTYPE
7	P1785	PLVAR	T778P	PLVAR
8	P1785	QEQ	T7PIQ_GB_QEQ	QEQ		1	CN

History

Last changed by/on	SAP	20090218
SAP Release Created in