SAP ABAP Table PAD532_QUE (General Structure for Additional Data in Query)

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	PAD532_QUE	Table Relationship Diagram
Short Description	General Structure for Additional Data in Query

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
3	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
4	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
5	IT0_INFTY	☐	INFOTYP	INFOTYP	CHAR	4	0	Infotype
6	IT0_SUBTY	☐	SUBTYP	SUBTYP	CHAR	4	0	Subtype	*
7	IT0_ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	*
8	IT0_PRIOX	☐	PRIOX	CHAR2	CHAR	2	0	Priority
9	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
10	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
11	IT0_LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	*
12	IT0_SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
13	IT0_AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
14	IT0_UNAME	☐	USRNAME	CHAR12	CHAR	12	0	User Name
15	IT0_REASN	☐	REASN	CHAR2	CHAR	2	0	Reason
16	IT0_HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
17	IT0_ITXNR	☐	ITXNR	NUM08	NUMC	8	0	Text Module for Infotype
18	SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
19	STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
20	GDATE	☐	GDATE	DATUM	DATS	8	0	Delimitation date
21	IT1_RSIGN	☐	RSIGN	RSIGN	CHAR	1	0	Relationship Specification
22	IT1_RELAT	☐	RELAT	RELAT	CHAR	3	0	Relationship Between Objects	*
23	IT1_ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	*
24	IT1_PRIOX	☐	PRIOX	CHAR2	CHAR	2	0	Priority
25	IT1_BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
26	IT1_ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
27	IT1_AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
28	IT1_UNAME	☐	USRNAME	CHAR12	CHAR	12	0	User Name
29	IT1_REASN	☐	REASN	CHAR2	CHAR	2	0	Reason
30	IT1_HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
31	IT1_ITXNR	☐	ITXNR	NUM08	NUMC	8	0	Text Module for Infotype
32	IT1_SCLAS	☐	SCLAS	OTYPE	CHAR	2	0	Type of Related Object	*
33	IT1_SOBID	☐	SOBID	CHAR45	CHAR	45	0	ID of Related Object
34	IT1_PROZT	☐	PROZT	DEC3_2	DEC	5	2	Weighting Percentage
35	.INCLU-_X	☐				0	0	Additional Data for Relationship "Fulfills Qualification"
36	CPGAINED_X	☐	PIQCONFERQ_CPGAINEDOBS	PIQCP	QUAN	10	5	CM: OBSOLET
37	CPUNIT_X	☐	PIQCONFERQ_CPUNITOBS	MEINS	UNIT	3	0	CM: OBSOLET	T006
38	NORM_VAL_X	☐	PIQCONFERQ_NORMVALOBS	PIQSCALE_NORM_VAL	DEC	8	2	CM: OBSOLET
39	CQRATING_X	☐	PIQCONFERQ_CQRATINGOBS	PIQSMRATING	CHAR	3	0	CM: OBSOLET	T7PIQSMRATING
40	TRANSFERFLAG_X	☐	PIQTRANSFER	PIQTRANSFER	CHAR	1	0	External Academic Work or Qualification Transferred
41	SM_OBJID_X	☐	PIQCONFERQ_SMOBS	HROBJID	NUMC	8	0	CM: OBSOLET	*
42	.INCLUDE	☐				0	0
43	.INCLUDE	☐				0	0	Objects Referenced for Qualification Conferment
44	REFOBJ_OTYPE_X	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
45	REFOBJ_REALO_X	☐	SOBID	CHAR45	CHAR	45	0	ID of Related Object
46	PERIDFORCQ_X	☐	PIQCONFERQ_PERIDFORCQ	PIQPERCT	NUMC	3	0	Duration of Study Required to Achieve Qualification
47	PERIDFORCQUNIT_X	☐	PIQCONFERQ_PERIDFORCQUNIT	PIQCONFERQ_PERIDFORCQUNIT	CHAR	1	0	Unit for Number of Periods
48	PERID_X	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	*
49	PERYR_X	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	*
50	ID_X	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
51	COBOK_X	☐	PIQPEPE_COBOK	PIQPEPE_COBOK	CHAR	1	0	Conditional Booking
52	STAGE_X	☐	PIQLEVEL	PIQLEVEL	NUMC	2	0	Stage	T7PIQLEVEL
53	REFPROC_GUIDTYPE_X	☐	PIQCONFERQ_REFPROC_GUIDTYPE	PIQGUIDTYPE	CHAR	4	0	Reference to a Process	*
54	REFPROC_GUID_X	☐	PIQCONFERQ_REFPROC_GUID	SYSUUID_C	CHAR	32	0	Process Identification (ID)
55	ACADHONOR_SYM_X	☐	PIQCONFERQ_ACADHONOR_GRADESYM	PIQGRADESYM	CHAR	10	0	Academic Honors
56	ACADHONOR_GRADE_X	☐	PIQCONFERQ_ACADHONOR_GRADE	PIQSCALE_NORM_VAL	DEC	8	2	Academic Honors: Standard Value
57	ACADHONOR_SCALE_X	☐	PIQCONFERQ_ACADHONOR_SCALE	PIQSCALE_ID	CHAR	4	0	Academic Honors Scale	T7PIQSCALE
58	NOT_COMPLETED_X	☐	PIQCONFERQ_NOTCOMPL	PIQCONFERQ_NOTCOMPL	CHAR	1	0	Qualification Was Not Achieved
59	DIPLOMANAME_X	☐	PIQCONFERQ_DIPLOMANAME	TEXT80	CHAR	80	0	Diploma Name
60	FINALW_ID_X	☐	PIQCONFERQ_FINALW_ID	SYSUUID_C	CHAR	32	0	Module Booking ID of Individual Work
61	FINALW_TITLE_X	☐	PIQCONFERQ_FINALWTITLE	TEXT100	CHAR	100	0	Title of Qualifying Work
62	FINALW_LANGU_X	☐	PIQCONFERQ_FINALWLANGU	SPRAS	LANG	1	0	Original Language	T002
63	FINALW_TITLEALT_X	☐	PIQCONFERQ_FINALWTITLEALT	TEXT100	CHAR	100	0	Title of Qualifying Work in Other Language
64	FINALW_LANGUALT_X	☐	PIQCONFERQ_FINALWLANGUALT	SPRAS	LANG	1	0	Other Language	T002

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PAD532_QUE	ACADHONOR_SCALE_X	T7PIQSCALE	SCALEID
2	PAD532_QUE	CPUNIT_X	T006	MSEHI
3	PAD532_QUE	CQRATING_X	T7PIQSMRATING	SMRATING
4	PAD532_QUE	FINALW_LANGUALT_X	T002	SPRAS
5	PAD532_QUE	FINALW_LANGU_X	T002	SPRAS
6	PAD532_QUE	STAGE_X	T7PIQLEVEL	ACLEVEL

History

Last changed by/on	SAP	20050705
SAP Release Created in	472