SAP ABAP Table PAD530_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	PAD530_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 Relationship Data
36	CHOICE_NO_X	☐	PIQCHOICE_NO	PIQCHOICE_NO	NUMC	2	0	Program Choice	T7PIQCHOICES
37	ADM_AYEAR_X	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEARPRD
38	ADM_PERID_X	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	T7PIQYEARPRD
39	ADM_ACLEVEL_X	☐	PIQLEVEL	PIQLEVEL	NUMC	2	0	Stage	T7PIQLEVEL
40	ADM_PROGCLASS_X	☐	PIQPROGCLASS	PIQPROGCLASS	CHAR	4	0	Progress Classification	T7PIQPROGCLASS
41	ADM_PARTT_X	☐	PIQPARTT	XFELD	CHAR	1	0	Indicator: Part-Time Study
42	ADM_CATEG_X	☐	PIQADM_CATEG	PIQADM_CATEG	CHAR	2	0	Admission Category	T7PIQADMCATEG
43	ADM_ENRCATEG_X	☐	PIQENRCATEG	PIQENRCATEG	CHAR	2	0	Registration Type	T7PIQENRCATEG
44	ADM_CODE_X	☐	PIQADMCODE	CHAR12	CHAR	12	0	Admission Code
45	ADM_PERCT_X	☐	PIQPERCT	PIQPERCT	NUMC	3	0	Completed Length of Study
46	ADM_QMNUM_X	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
47	ADM_STATUS_SUP_X	☐	PIQADMSTSUP	PIQPROCESSSTSUP	CHAR	4	0	Status Supplement
48	ADM_DEC_X	☐	PIQADM_DEC	DATS	DATS	8	0	Decision Date of Rejection or Admission
49	ADM_RECPT_X	☐	PIQADM_RECPT	DATS	DATS	8	0	Date of Admission Application Receipt
50	ADM_WITH_DECL_X	☐	PIQADM_WITH_DECL	DATS	DATS	8	0	Date of Withdrawal or Declination
51	ADM_GUID_X	☐	PIQADM_GUID	SYSUUID_C	CHAR	32	0	Unique Key (GUID) of the Admission
52	COKEY_X	☐	COKEY_KK	COKEY_KK	CHAR	36	0	Correspondence key
53	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PAD530_QUE	ADM_ACLEVEL_X	T7PIQLEVEL	ACLEVEL	REF
2	PAD530_QUE	ADM_AYEAR_X	T7PIQYEARPRD	PERYR	KEY	1	CN
3	PAD530_QUE	ADM_CATEG_X	T7PIQADMCATEG	ADM_CATEG	REF
4	PAD530_QUE	ADM_ENRCATEG_X	T7PIQENRCATEG	ENRCATEG	REF
5	PAD530_QUE	ADM_PERID_X	T7PIQYEARPRD	PERID	KEY	1	CN
6	PAD530_QUE	ADM_PROGCLASS_X	T7PIQPROGCLASS	PROGCLASS	REF
7	PAD530_QUE	CHOICE_NO_X	T7PIQCHOICES	CHOICE_NO	KEY	1	CN

History

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