SAP ABAP Table P1786_EXP (Infotype 1786 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	P1786_EXP	Table Relationship Diagram
Short Description	Infotype 1786 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 1786
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 1786
22	REFSTATUS	☐	PIQ_GB_UCAS_REF_STAT	PIQ_GB_UCAS_REF_STAT	CHAR	1	0	CM: UCAS Referral Status
23	ENTRY_POINT	☐	PIQ_GB_UCAS_ENTRY_POINT	PIQ_GB_UCAS_ENTRY_POINT	CHAR	1	0	UCAS: Point of Entry	T7PIQ_GB_ENT_PN
24	ENTRY_YEAR	☐	PIQ_GB_UCAS_ENTRY_YEAR	JAHR	NUMC	4	0	UCAS: Entry year
25	ENTRY_MONTH	☐	PIQ_GB_UCAS_ENTRY_MONTH	MONTH	NUMC	2	0	UCAS: Entry month
26	.INCLUDE	☐				0	0
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 Clearing Infotype
30	REFERRAL	☐	PIQFLAG	FLAG	CHAR	1	0	General Indicator
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_CRS_INS
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	T7PIQ_GB_INST_OR
35	FACULTY	☐	PIQ_GB_UCAS_FACULTY	PIQ_GB_UCAS_FACULTY	CHAR	1	0	UCAS: Faculty Id	T7PIQ_GB_INST_OR
36	REF_METHOD	☐	PIQ_GB_UCAS_REFMETHOD	PIQ_GB_UCAS_REFMETHOD	NUMC	1	0	CM: UCAS Referral Method
37	OUTCOME	☐	PIQ_GB_UCAS_OUTCOME	PIQ_GB_UCAS_OUTCOME	CHAR	1	0	CM: UCAS Outcome

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P1786_EXP	CAMPUS	T7PIQ_GB_INST_OR	CAMPUS	REF	1	CN
2	P1786_EXP	COURSE	T7PIQ_GB_CRS_INS	COURSE_ID	REF	1	CN
3	P1786_EXP	ENTRY_POINT	T7PIQ_GB_ENT_PN	POINT_OF_ENTRY	REF	1	CN
4	P1786_EXP	FACULTY	T7PIQ_GB_INST_OR	FACULTY	REF	1	CN
5	P1786_EXP	INFTY	T778T	INFTY
6	P1786_EXP	INSTITUTION	T7PIQ_GB_INST	INSTITUTION_ID	REF	1	CN
7	P1786_EXP	ISTAT	T778S	ISTAT
8	P1786_EXP	MANDT	T000	MANDT
9	P1786_EXP	OTYPE	T778O	OTYPE
10	P1786_EXP	PLVAR	T778P	PLVAR

History

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