SAP ABAP Table PIQNOTE (Auxiliary Structure for Student-Related Notes)

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	PIQNOTE	Table Relationship Diagram
Short Description	Auxiliary Structure for Student-Related Notes

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	T778U
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	SUTXT	☐	PIQNOTE_TEXT	TEXT25	CHAR	25	0	Note Type (Description)
15	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
16	UNAME	☐	PIQLUSER	TDUSER	CHAR	12	0	User Who Made the Last Change
17	FDATE	☐	PIQFDATE	DATUM	DATS	8	0	Created On
18	FUSER	☐	PIQFUSER	TDUSER	CHAR	12	0	User Who Created the Information
19	TRANSCRIPT	☐	PIQNOTE_TRANSCRIPT	FLAG	CHAR	1	0	Relevant for Transcripts
20	DEACTIVATE	☐	PIQNOTE_DEACTIVATE	FLAG	CHAR	1	0	Note Type Is Deactivated
21	.INCLUDE	☐				0	0	Note Reference (Fields and Descriptions)
22	.INCLUDE	☐				0	0	Note Reference (Key Fields)
23	SC_OBJID	☐	PIQNOTE_CONT_SCOBJID	HROBJID	NUMC	8	0	Note Reference to a Program	*
24	PROGCVAR	☐	PIQNOTE_CONT_PROGC_VAR	PIQPROGC_VAR	CHAR	4	0	Note Reference to a Program Type	T7PIQPROGCVAR
25	ACLEVEL	☐	PIQNOTE_CONT_LEVEL	PIQLEVEL	NUMC	2	0	Note Reference to a Stage	T7PIQLEVEL
26	PERYR	☐	PIQNOTE_CONT_PERYR	PIQPERYR	NUMC	4	0	Note Reference to an Academic Year	T7PIQYEAR
27	PERID	☐	PIQNOTE_CONT_PERID	PIQPERID	NUMC	3	0	Note Reference to an Academic Session	T7PIQPERIOD
28	.INCLUDE	☐				0	0	Note Reference (Description Fields)
29	SCTEXT	☐	PIQSCTXT	TEXT40	CHAR	40	0	Program Description
30	PROGC_VART	☐	PIQPROGC_VART	TEXT30	CHAR	30	0	Program Type (Description)
31	ACLEVELT	☐	PIQLEVELT	TEXT30	CHAR	30	0	Stage (Description)
32	PERYT	☐	PIQPERYT	TEXT20	CHAR	20	0	Academic Year (Description)
33	PERIT	☐	PIQPERIT	TEXT20	CHAR	20	0	Academic Session (Description)
34	.INCLUDE	☐				0	0	Header Data for Student-Related Notes
35	TDOBJECT	☐	TDOBJECT	TDOBJECT	CHAR	10	0	Texts: application object	TTXOB
36	TDID	☐	TDID	TDID	CHAR	4	0	Text ID	TTXID
37	TDNAME	☐	TDOBNAME	TDOBNAME	CHAR	70	0	Name
38	TDSPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
39	TDTITLE	☐	PIQNOTE_TITLE	TDTITLE	CHAR	50	0	Note Title

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQNOTE	ACLEVEL	T7PIQLEVEL	ACLEVEL
2	PIQNOTE	INFTY	T778T	INFTY
3	PIQNOTE	ISTAT	T778S	ISTAT
4	PIQNOTE	MANDT	T000	MANDT
5	PIQNOTE	OTYPE	T778O	OTYPE
6	PIQNOTE	PERID	T7PIQPERIOD	PERID
7	PIQNOTE	PERYR	T7PIQYEAR	PERYR
8	PIQNOTE	PLVAR	T778P	PLVAR
9	PIQNOTE	PROGCVAR	T7PIQPROGCVAR	PROGC_VAR
10	PIQNOTE	SUBTY	T778U	SUBTY
11	PIQNOTE	TDID	TTXID	TDID
12	PIQNOTE	TDOBJECT	TTXOB	TDOBJECT
13	PIQNOTE	TDSPRAS	T002	SPRAS

History

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