SAP ABAP Table P1783_EXP (Infotype 1783 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	P1783_EXP	Table Relationship Diagram
Short Description	Infotype 1783 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 1783
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 Student's Choices (GB)
22	CWD_FLAG	☐	PIQ_GB_UCAS_CWD_FLAG	PIQ_GB_UCAS_CWD_FLAG	CHAR	1	0	UCAS: Choice withdrew totally or re-instatement
23	CWD_DATE	☐	PIQ_GB_UCAS_CWD_DATE	DATE	DATS	8	0	UCAS:CWD withraw date
24	ROUTE_B	☐	PIQ_GB_UCAS_ROUTE_B	PIQ_GB_UCAS_INTERV_PRIO	CHAR	1	0	UCAS: I want route B	*
25	EXTRA_CHOICE	☐	PIQ_GB_UCAS_EXTRA_CHOICE	NUMC3	NUMC	3	0	UCAS: Extra choice round
26	CHOICE_TRANS	☐	PIQ_GB_UCAS_CHOICE_TRANS	PIQ_GB_UCAS_CHOICE_TRANS	CHAR	1	0	UCAS: Choices all transparent flag
27	TABNR	☐	HRTABNR	HRTABNR	CHAR	32	0	Reference Number to Table Part	*
28	TABSEQNR	☐	HRTABSEQNR	NUM06	NUMC	6	0	Sequence Number in Table Part of Table Infotype
29	.INCLUDE	☐				0	0	UCAS Table Section Student's Choices (GB)
30	CHOICE_NO	☐	PIQCHOICE_NO	PIQCHOICE_NO	NUMC	2	0	Program Choice	*
31	INSTITUTION	☐	PIQ_GB_UCAS_INST_ID	PIQ_GB_UCAS_INST_ID	CHAR	4	0	UCAS: Institution Code	T7PIQ_GB_INST
32	COURSE	☐	PIQ_GB_UCAS_COURSE	PIQ_GB_UCAS_COURSE	CHAR	6	0	UCAS: Course Code	T7PIQ_GB_COURSE
33	SC_OBJID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
34	CAMPUS	☐	PIQ_GB_UCAS_CAMPUS	PIQ_GB_UCAS_CAMPUS	CHAR	1	0	UCAS: Campus Id	*
35	FACULTY	☐	PIQ_GB_UCAS_FACULTY	PIQ_GB_UCAS_FACULTY	CHAR	1	0	UCAS: Faculty Id	*
36	DECISION	☐	PIQ_GB_UCAS_DECISION	PIQ_GB_UCAS_DECISION	CHAR	1	0	UCAS: Decision made by the institution	T7PIQ_GB_DECIS
37	REPLY	☐	PIQ_GB_UCAS_REPLY	PIQ_GB_UCAS_REPLY	CHAR	1	0	UCAS: Reply made by applicant	T7PIQ_GB_REPLY
38	CONDITIONS	☐	PIQ_GB_UCAS_CONDITIONS_SUM	PIQ_GB_UCAS_CONDITIONS_SUM	CHAR	6	0	UCAS: Summary of conditions	*
39	ENTRY_DATE	☐	PIQ_GB_UCAS_ENTRY_DATE	PIQ_GB_UCAS_ENTRY_DATE	DATS	8	0	UCAS: Date of Entry
40	CHOICE_CANCEL	☐	PIQ_GB_UCAS_CHOICE_CANCEL	PIQ_GB_UCAS_CHOICE_CANCEL	CHAR	1	0	UCAS:Choice cancelled by applicant
41	AEDTM_UCAS	☐	PIQ_GB_UCAS_AEDTM	DATS	DATS	8	0	UCAS: Date of the last change made by UCAS
42	UCAS_ACTION	☐	PIQ_GB_UCAS_ACTION	PIQ_GB_UCAS_ACTION	CHAR	1	0	UCAS: UCAS action	T7PIQ_GB_UCASAC
43	SUBSTITUTION	☐	PIQ_GB_UCAS_SUBSTITUTION	PIQ_GB_UCAS_SUBSTITUTION	CHAR	1	0	UCAS: Substitution	T7PIQ_GB_SUBSTI
44	AMENDMENT	☐	PIQ_GB_UCAS_AMENDMENT	PIQ_GB_UCAS_AMENDMENT	CHAR	1	0	UCAS: Amendment	*
45	PREV_COURSE	☐	PIQ_GB_UCAS_COURSE_OLD	PIQ_GB_UCAS_COURSE	CHAR	6	0	UCAS: Previous Course code MARVIN	*
46	CONF_STATUS	☐	PIQ_GB_UCAS_CONF_STATUS	PIQ_GB_UCAS_CONF_STATUS	CHAR	1	0	UCAS:Confirmation status	T7PIQ_GB_STATUS
47	CONF_HIST	☐	PIQ_GB_UCAS_CONF_HIST	PIQ_GB_UCAS_CONF_HIST	CHAR	1	0	UCAS: Confirmation History	T7PIQ_GB_CON_HI
48	ENTRY_POINT	☐	PIQ_GB_UCAS_ENTRY_POINT	PIQ_GB_UCAS_ENTRY_POINT	CHAR	1	0	UCAS: Point of Entry	T7PIQ_GB_ENT_PN
49	INTERV_PRIO	☐	PIQ_GB_UCAS_INTERV_PRIO	PIQ_GB_UCAS_INTERV_PRIO	CHAR	1	0	UCAS: Priority of the interview	T7PIQ_GB_INT_PRI
50	HOME_INDIC	☐	PIQ_GB_UCAS_HOME_IND	PIQ_GB_UCAS_HOME_IND	CHAR	1	0	UCAS: Live at home indicator
51	.INCLUDE	☐				0	0	UCAS: Administration data
52	AEDTM_INST	☐	PIQ_GB_UCAS_AEDTM_INST	DATS	DATS	8	0	UCAS: Date of change made by the institution
53	UNAME_INST	☐	USRNAME	CHAR12	CHAR	12	0	User Name
54	COURSE_INST	☐	PIQ_GB_UCAS_COURSE_ID_INST	PIQ_GB_UCAS_COURSE	CHAR	6	0	UCAS: MARVIN course code institution	T7PIQ_GB_COURSE
55	CAMPUS_INST	☐	PIQ_GB_UCAS_CAMPUS_ID_INST	PIQ_GB_UCAS_CAMPUS	CHAR	1	0	UCAS: Campus Id Changed by Institution
56	ENTRY_MONTH_INST	☐	PIQ_GB_UCAS_ENTRY_MONTH_INST		NUMC	2	0	UCAS: obsolet (Entry month changed by Institution)
57	ENTRY_YEAR_INST	☐	PIQ_GB_UCAS_ENTRY_YEAR_INST	JAHR	NUMC	4	0	-CM UCAS: Year of Entry changed by Institution
58	ENTRY_POINT_INST	☐	PIQ_GB_UCAS_ENTRY_POINT_INST	PIQ_GB_UCAS_ENTRY_POINT	CHAR	1	0	-CM UCAS: Point of Entry changed by Institution	T7PIQ_GB_ENT_PN
59	TRANSACTION_INST	☐	PIQ_GB_UCAS_TRANSACTION_INST	PIQ_GB_UCAS_TRANSACTION	CHAR	2	0	-CM UCAS: Last Transaction sent to UCAS	T7PIQ_GB_TRANS
60	DECISION_INST	☐	PIQ_GB_UCAS_TRANSACTION_INST	PIQ_GB_UCAS_TRANSACTION	CHAR	2	0	-CM UCAS: Last Transaction sent to UCAS	*
61	CONDITIONS_INST1	☐	PIQ_GB_UCAS_CONDITIONS_INST	PIQ_GB_UCAS_CONDITIONS	CHAR	197	0	UCAS: Final conditions set by institution
62	CONDITIONS_INST2	☐	PIQ_GB_UCAS_CONDITIONS_INST	PIQ_GB_UCAS_CONDITIONS	CHAR	197	0	UCAS: Final conditions set by institution
63	CONDITIONS_INST3	☐	PIQ_GB_UCAS_CONDITIONS_INST	PIQ_GB_UCAS_CONDITIONS	CHAR	197	0	UCAS: Final conditions set by institution
64	ADJ_STATUS	☐	PIQ_GB_UCAS_CHOICEADJSTATUS	PIQ_GB_UCAS_CHOICEADJSTATUS	CHAR	1	0	UCAS: Adjustment Status for Adjustment Choice
65	INTERVIEW_DATE	☐	PIQ_GB_UCAS_INTERVIEWDATE	DATS	DATS	8	0	UCAS: Date of Interview
66	INTERVIEW_RESP	☐	PIQ_GB_UCAS_IRESP	PIQ_GB_UCAS_IRESP	CHAR	1	0	UCAS: Interview Response of the Applicant
67	YR_APPLIED	☐	PIQ_GB_UCAS_YR_APPLD	PIQ_GB_UCAS_YR_APPLD	CHAR	4	0	Year Applied for Choice Details
68	APPL_SCHEME_CODE	☐	PIQ_GB_UCAS_APPLSCHCODE	CHAR4	CHAR	4	0	UCAS: Application Scheme Code
69	DEFER_ENTRY	☐	PIQ_GB_UCAS_DEFER_ENTRY	PIQ_GB_UCAS_DEFER_ENTRY	CHAR	1	0	UCAS: Defer entry for choice details
70	INSTDESCDATE	☐	PIQ_GB_UCAS_INSTDECDATE	DATS	DATS	8	0	Institution#s Decision Date
71	REFDATE	☐	PIQ_GB_UCAS_REFERRALDATE	DATS	DATS	8	0	Date When Choice Was Referred
72	OFFER_LEVEL	☐	PIQ_GB_UCAS_OFFERLEVEL	PIQ_GB_UCAS_OFFERLEVEL	CHAR	1	0	UCAS: Student Offer Level	T7PIQ_GB_OFFRLEV

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P1783_EXP	CONF_HIST	T7PIQ_GB_CON_HI	CONF_HIST		1	CN
2	P1783_EXP	CONF_STATUS	T7PIQ_GB_STATUS	CONF_STATUS		1	CN
3	P1783_EXP	COURSE	T7PIQ_GB_COURSE	COURSE_ID		1	CN
4	P1783_EXP	COURSE_INST	T7PIQ_GB_COURSE	COURSE_ID		1	CN
5	P1783_EXP	DECISION	T7PIQ_GB_DECIS	DECISION		1	CN
6	P1783_EXP	ENTRY_POINT	T7PIQ_GB_ENT_PN	POINT_OF_ENTRY		1	CN
7	P1783_EXP	ENTRY_POINT_INST	T7PIQ_GB_ENT_PN	POINT_OF_ENTRY		1	CN
8	P1783_EXP	INFTY	T778T	INFTY
9	P1783_EXP	INSTITUTION	T7PIQ_GB_INST	INSTITUTION_ID		1	CN
10	P1783_EXP	INTERV_PRIO	T7PIQ_GB_INT_PRI	INTERV_PRIO		1	CN
11	P1783_EXP	ISTAT	T778S	ISTAT
12	P1783_EXP	MANDT	T000	MANDT
13	P1783_EXP	OFFER_LEVEL	T7PIQ_GB_OFFRLEV	OFFER_LEVEL
14	P1783_EXP	OTYPE	T778O	OTYPE
15	P1783_EXP	PLVAR	T778P	PLVAR
16	P1783_EXP	REPLY	T7PIQ_GB_REPLY	REPLY		1	CN
17	P1783_EXP	SUBSTITUTION	T7PIQ_GB_SUBSTI	SUBSTITUTION		1	CN
18	P1783_EXP	TRANSACTION_INST	T7PIQ_GB_TRANS	UCAS_TRANSACTION		1	CN
19	P1783_EXP	UCAS_ACTION	T7PIQ_GB_UCASAC	UCAS_ACTION		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in