SAP ABAP Table P1691_EXP (Infotype 1691 expanded structures)

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	P1691_EXP	Table Relationship Diagram
Short Description	Infotype 1691 expanded structures

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	.INCLUDE	☐				0	0	Infotype 1691
2	.INCLUDE	☐				0	0	Key Structure for Language-Dependent IT Structures PNNNN
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
5	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
6	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
7	INFTY	☐	INFOTYP	INFOTYP	CHAR	4	0	Infotype	T778T
8	SUBTY	☐	SUBTYP	SUBTYP	CHAR	4	0	Subtype	T778U
9	ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
10	PRIOX	☐	PRIOX	CHAR2	CHAR	2	0	Priority
11	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
12	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
13	LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
14	FILLER	☐	DUMMY_9	CHAR9	CHAR	9	0	Dummy Function With Length 9
15	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
16	.INCLUDE	☐				0	0	Infotype Administration Data
17	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
18	UNAME	☐	USRNAME	CHAR12	CHAR	12	0	User Name
19	REASN	☐	REASN	CHAR2	CHAR	2	0	Reason
20	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
21	ITXNR	☐	ITXNR	NUM08	NUMC	8	0	Text Module for Infotype
22	.INCLUDE	☐				0	0	Infotype 1691 fields trainer costs
23	MOLGA	☐	MOLGA	MOLGA	CHAR	2	0	Country Grouping	T500L
24	TRTYP	☐	HRTNM_TRTYP	HRTNM_ATTTY	CHAR	2	0	Trainer Object Type
25	TROBJ	☐	HRTNM_TROBJ	HROBJID	NUMC	8	0	Trainer Object ID	*
26	.INCLUDE	☐				0	0	Infotype 1036 fields
27	.INCLUDE	☐				0	0	Substructure of infotype 1036: Costs
28	KOBES	☐	KOBES	KOBES	CHAR	8	0	Cost item	T77KB
29	PRDIR	☐	PRDIR	CHAR1_X	CHAR	1	0	Direct entry of price
30	PRICE	☐	PRICE	WERT8	CURR	15	2	Proposed amount
31	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
32	BUNIT	☐	BUNIT	BUNIT	CHAR	1	0	Reference unit
33	BZGME	☐	PEBZGME	MEINS	UNIT	3	0	Time Unit	T006
34	.INCLU-001	☐				0	0	Substructure of infotype 1036: Costs
35	KOBES001	☐	KOBES	KOBES	CHAR	8	0	Cost item	T77KB
36	PRDIR001	☐	PRDIR	CHAR1_X	CHAR	1	0	Direct entry of price
37	PRICE001	☐	PRICE	WERT8	CURR	15	2	Proposed amount
38	WAERS001	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
39	BUNIT001	☐	BUNIT	BUNIT	CHAR	1	0	Reference unit
40	BZGME001	☐	PEBZGME	MEINS	UNIT	3	0	Time Unit	T006
41	.INCLU-002	☐				0	0	Substructure of infotype 1036: Costs
42	KOBES002	☐	KOBES	KOBES	CHAR	8	0	Cost item	T77KB
43	PRDIR002	☐	PRDIR	CHAR1_X	CHAR	1	0	Direct entry of price
44	PRICE002	☐	PRICE	WERT8	CURR	15	2	Proposed amount
45	WAERS002	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
46	BUNIT002	☐	BUNIT	BUNIT	CHAR	1	0	Reference unit
47	BZGME002	☐	PEBZGME	MEINS	UNIT	3	0	Time Unit	T006
48	.INCLU-003	☐				0	0	Substructure of infotype 1036: Costs
49	KOBES003	☐	KOBES	KOBES	CHAR	8	0	Cost item	T77KB
50	PRDIR003	☐	PRDIR	CHAR1_X	CHAR	1	0	Direct entry of price
51	PRICE003	☐	PRICE	WERT8	CURR	15	2	Proposed amount
52	WAERS003	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
53	BUNIT003	☐	BUNIT	BUNIT	CHAR	1	0	Reference unit
54	BZGME003	☐	PEBZGME	MEINS	UNIT	3	0	Time Unit	T006
55	.INCLU-004	☐				0	0	Substructure of infotype 1036: Costs
56	KOBES004	☐	KOBES	KOBES	CHAR	8	0	Cost item	T77KB
57	PRDIR004	☐	PRDIR	CHAR1_X	CHAR	1	0	Direct entry of price
58	PRICE004	☐	PRICE	WERT8	CURR	15	2	Proposed amount
59	WAERS004	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
60	BUNIT004	☐	BUNIT	BUNIT	CHAR	1	0	Reference unit
61	BZGME004	☐	PEBZGME	MEINS	UNIT	3	0	Time Unit	T006
62	.INCLU-005	☐				0	0	Substructure of infotype 1036: Costs
63	KOBES005	☐	KOBES	KOBES	CHAR	8	0	Cost item	T77KB
64	PRDIR005	☐	PRDIR	CHAR1_X	CHAR	1	0	Direct entry of price
65	PRICE005	☐	PRICE	WERT8	CURR	15	2	Proposed amount
66	WAERS005	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
67	BUNIT005	☐	BUNIT	BUNIT	CHAR	1	0	Reference unit
68	BZGME005	☐	PEBZGME	MEINS	UNIT	3	0	Time Unit	T006
69	.INCLU-006	☐				0	0	Substructure of infotype 1036: Costs
70	KOBES006	☐	KOBES	KOBES	CHAR	8	0	Cost item	T77KB
71	PRDIR006	☐	PRDIR	CHAR1_X	CHAR	1	0	Direct entry of price
72	PRICE006	☐	PRICE	WERT8	CURR	15	2	Proposed amount
73	WAERS006	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
74	BUNIT006	☐	BUNIT	BUNIT	CHAR	1	0	Reference unit
75	BZGME006	☐	PEBZGME	MEINS	UNIT	3	0	Time Unit	T006
76	.INCLU-007	☐				0	0	Substructure of infotype 1036: Costs
77	KOBES007	☐	KOBES	KOBES	CHAR	8	0	Cost item	T77KB
78	PRDIR007	☐	PRDIR	CHAR1_X	CHAR	1	0	Direct entry of price
79	PRICE007	☐	PRICE	WERT8	CURR	15	2	Proposed amount
80	WAERS007	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
81	BUNIT007	☐	BUNIT	BUNIT	CHAR	1	0	Reference unit
82	BZGME007	☐	PEBZGME	MEINS	UNIT	3	0	Time Unit	T006
83	.INCLU-008	☐				0	0	Substructure of infotype 1036: Costs
84	KOBES008	☐	KOBES	KOBES	CHAR	8	0	Cost item	T77KB
85	PRDIR008	☐	PRDIR	CHAR1_X	CHAR	1	0	Direct entry of price
86	PRICE008	☐	PRICE	WERT8	CURR	15	2	Proposed amount
87	WAERS008	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
88	BUNIT008	☐	BUNIT	BUNIT	CHAR	1	0	Reference unit
89	BZGME008	☐	PEBZGME	MEINS	UNIT	3	0	Time Unit	T006
90	.INCLUDE	☐				0	0
91	WERKS001	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
92	BTRTL001	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T001P
93	PERNR001	☐	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
94	WERKS002	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
95	BTRTL002	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T001P
96	PERNR002	☐	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
97	.INCLUDE	☐				0	0
98	TABNR	☐	HRTABNR	HRTABNR	CHAR	32	0	Reference Number to Table Part	*
99	TABSEQNR	☐	HRTABSEQNR	NUM06	NUMC	6	0	Sequence Number in Table Part of Table Infotype
100	.INCLUDE	☐				0	0	Fields for Table Part of Infotype 1691 (trainer costs)
101	BEGDT	☐	HRTNM_BEGDT	DATS	DATS	8	0	Date
102	NBHRS	☐	HRTNM_STHRS	DEC6_2	DEC	8	2	Time Unit: standard hours
103	OVHRS	☐	HRTNM_SPHRS	DEC6_2	DEC	8	2	Time Unit: special hours
104	ABHRS	☐	HRTNM_ABHRS	DEC6_2	DEC	8	2	Absence hours
105	RESON	☐	HRTNM_REASN	CHAR2	CHAR	2	0	Absence Reason	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P1691_EXP	BTRTL001	T001P	BTRTL		1	CN
2	P1691_EXP	BTRTL002	T001P	BTRTL		1	CN
3	P1691_EXP	BZGME	T006	MSEHI
4	P1691_EXP	BZGME001	T006	MSEHI
5	P1691_EXP	BZGME002	T006	MSEHI
6	P1691_EXP	BZGME003	T006	MSEHI
7	P1691_EXP	BZGME004	T006	MSEHI
8	P1691_EXP	BZGME005	T006	MSEHI
9	P1691_EXP	BZGME006	T006	MSEHI
10	P1691_EXP	BZGME007	T006	MSEHI
11	P1691_EXP	BZGME008	T006	MSEHI
12	P1691_EXP	INFTY	T778T	INFTY
13	P1691_EXP	ISTAT	T778S	ISTAT
14	P1691_EXP	KOBES	T77KB	KOBES
15	P1691_EXP	KOBES001	T77KB	KOBES
16	P1691_EXP	KOBES002	T77KB	KOBES
17	P1691_EXP	KOBES003	T77KB	KOBES
18	P1691_EXP	KOBES004	T77KB	KOBES
19	P1691_EXP	KOBES005	T77KB	KOBES
20	P1691_EXP	KOBES006	T77KB	KOBES
21	P1691_EXP	KOBES007	T77KB	KOBES
22	P1691_EXP	KOBES008	T77KB	KOBES
23	P1691_EXP	LANGU	T002	SPRAS
24	P1691_EXP	MANDT	T000	MANDT
25	P1691_EXP	MOLGA	T500L	MOLGA	KEY	1	CN
26	P1691_EXP	OTYPE	T778O	OTYPE
27	P1691_EXP	PLVAR	T778P	PLVAR
28	P1691_EXP	SUBTY	T778U	SUBTY
29	P1691_EXP	WAERS	TCURC	WAERS
30	P1691_EXP	WAERS001	TCURC	WAERS
31	P1691_EXP	WAERS002	TCURC	WAERS
32	P1691_EXP	WAERS003	TCURC	WAERS
33	P1691_EXP	WAERS004	TCURC	WAERS
34	P1691_EXP	WAERS005	TCURC	WAERS
35	P1691_EXP	WAERS006	TCURC	WAERS
36	P1691_EXP	WAERS007	TCURC	WAERS
37	P1691_EXP	WAERS008	TCURC	WAERS
38	P1691_EXP	WERKS001	T500P	PERSA		1	CN
39	P1691_EXP	WERKS002	T500P	PERSA		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in