SAP ABAP Table PAD506_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	PAD506_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 506
36	SMSTATUS_X	☐	PIQSMSTATUS	PIQSMSTATUS	NUMC	2	0	Module Booking Status	T7PIQSMSTAT
37	STORREASON_X	☐	PIQSTORREASON	PIQSTORREASON	CHAR	4	0	Cancellation Reason	T7PIQWITHDRAWN
38	STORDATE_X	☐	PIQSTORDATE	PIQSTORDATE	DATS	8	0	Cancellation Date
39	CPATTEMP_X	☐	PIQCPATTEMP	PIQCP	QUAN	10	5	Attempted Credits
40	CPGAINED_X	☐	PIQCPGAINED	PIQCP	QUAN	10	5	Earned Credits
41	CPUNIT_X	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	T006
42	NORM_VAL_X	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
43	BOOKDATE_X	☐	PIQDATE	DATUM	DATS	8	0	Booking Date
44	BOOKTIME_X	☐	PIQWAITL_TIME	TIME	TIMS	6	0	Booking Time
45	SMRATING_X	☐	PIQSMRATING	PIQSMRATING	CHAR	3	0	Alternative Assessment Method for Module	T7PIQSMRATING
46	CHARGEFREE_X	☐	PIQCHARGE	PIQCHARGE	CHAR	1	0	Free of Charge
47	TRANSFERFLAG_X	☐	PIQTRANSFER	PIQTRANSFER	CHAR	1	0	External Academic Work or Qualification Transferred
48	PACKNUMBER_X	☐	PIQSLNUM	HROBJID	NUMC	8	0	Event Package	*
49	VARID_X	☐	PIQVARID	PIQVARID	CHAR	2	0	Session Variant	T7PIQVARY
50	PERID_X	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	T7PIQPERIOD
51	PERYR_X	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEAR
52	ALT_SCALEID_X	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
53	ID_X	☐	PIQMODREG_ID	SYSUUID_C	CHAR	32	0	Module Booking Identification
54	BOOKREASON_X	☐	PIQBOOKREASON	PIQBOOKREASON	CHAR	4	0	Module Booking Reason	T7PIQBOOKREASON
55	ANNULMENT_X	☐	PIQMODREG_ANNULMENT	PIQMODREG_ANNULMENT	CHAR	1	0	Exclusion Indicator for Module Bookings	T7PIQ_MR_ANNUL
56	LOCKFLAG_X	☐	PIQAWLOCKFLAG	FLAG	CHAR	1	0	Change Lock
57	COBOK_X	☐	PIQPEPE_COBOK	PIQPEPE_COBOK	CHAR	1	0	Conditional Booking
58	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PAD506_QUE	ALT_SCALEID_X	T7PIQSCALE	SCALEID
2	PAD506_QUE	ANNULMENT_X	T7PIQ_MR_ANNUL	ANNULMENT
3	PAD506_QUE	BOOKREASON_X	T7PIQBOOKREASON	BOOKREASON
4	PAD506_QUE	CPUNIT_X	T006	MSEHI
5	PAD506_QUE	PERID_X	T7PIQPERIOD	PERID		1	CN
6	PAD506_QUE	PERYR_X	T7PIQYEAR	PERYR	KEY	1	CN
7	PAD506_QUE	SMRATING_X	T7PIQSMRATING	SMRATING
8	PAD506_QUE	SMSTATUS_X	T7PIQSMSTAT	SMSTATUS
9	PAD506_QUE	STORREASON_X	T7PIQWITHDRAWN	STORREASON
10	PAD506_QUE	VARID_X	T7PIQVARY	VARID	KEY	1	CN

History

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