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

Hierarchy

☛ SAP_HRCFR (Software Component) Sub component SAP_HRCFR of SAP_HR
   ⤷ PY-FR (Application Component) France
     ⤷ P99S_TNM (Package) Training needs management

Basic Data

Table Category	INTTAB	Structure
Structure	PAD940_QUE	Table Relationship Diagram
Short Description	General Structure for Additional Data in Query 940

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 'Need'
36	WERKS_X	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
37	BTRTL_X	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T001P
38	NBPER_X	☐	HRTNM_NBPER	NUMC6	NUMC	6	0	Total of Attendees
39	NBWOM_X	☐	HRTNM_NBWOM	NUMC6	NUMC	6	0	Number of Women
40	FTEGC_X	☐	HRTNM_TEGRC	CHAR4	CHAR	4	0	Training Employee Group	T77TNM_TE
41	SIGN_X	☐	DDSIGN	DDSIGN	CHAR	1	0	Type of SIGN component in row type of a Ranges type
42	OPTI_X	☐	DDOPTION	DDOPTION	CHAR	2	0	Type of OPTION component in row type of a Ranges type
43	AGE_MIN_X	☐	HRTNM_MIN_AGE	NUMC3	NUMC	3	0	Training Needs Minimum Age
44	AGE_MAX_X	☐	HRTNM_MAX_AGE	NUMC3	NUMC	3	0	Training Needs Maximum Age

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PAD940_QUE	BTRTL_X	T001P	BTRTL	KEY	1	CN
2	PAD940_QUE	FTEGC_X	T77TNM_TE	TEGRC	KEY	1	CN
3	PAD940_QUE	WERKS_X	T500P	PERSA	KEY	1	CN

History

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