SAP ABAP Table PAD509_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	PAD509_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	Addt'l Data for Relationship "Uses"
36	TIMEP_X	☐	PIQTIMEPOINT	PIQTIMEPOINT	CHAR	4	0	Callup Point	T7PIQCHECKTP
37	ACLEVEL_X	☐	PIQLEVEL	PIQLEVEL	NUMC	2	0	Stage	T7PIQLEVEL
38	EXAMREG_X	☐	PIQEXAMREG	PIQEXAMREG	NUMC	4	0	Exam Regulations	T7PIQEXAMREG
39	PARAVAL_X	☐	PIQAUD_PARAVAL	TEXT40	CHAR	40	0	Parameter Value
40	CONDOPT_X	☐	PIQRULE_CONDOPTION	FLAG	CHAR	1	0	Conditional Booking Allowed (for Rule Checks)
41	REQELEMENT_X	☐	PIQREQELEMENT	PIQREQELEMENT	NUMC	4	0	Requirement	T7PIQREQELEMENT

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PAD509_QUE	ACLEVEL_X	T7PIQLEVEL	ACLEVEL	REF	1	CN
2	PAD509_QUE	EXAMREG_X	T7PIQEXAMREG	EXAMREG		1	CN
3	PAD509_QUE	REQELEMENT_X	T7PIQREQELEMENT	REQELEMENT
4	PAD509_QUE	TIMEP_X	T7PIQCHECKTP	TIMEPOINT	REF

History

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