SAP ABAP Table HRP1691 (DB Table for Infotype 1691)

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	TRANSP	Transparent table
Transparent table	HRP1691	Table Relationship Diagram
Short Description	DB Table for Infotype 1691

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in