SAP ABAP Table P1686_EXP (Infotype 1686 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	P1686_EXP	Table Relationship Diagram
Short Description	Infotype 1686 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 1686
2	.INCLUDE	☐				0	0	Key Structure for Infotype 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	VARYF	☐	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
14	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
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	Fields for Infotype 1686
22	MOLGA	☐	MOLGA	MOLGA	CHAR	2	0	Country Grouping	T500L
23	BISTA	☐	HRTNM_BISTA	HRTNM_BISTA	CHAR	2	0	TNM: batch input status
24	.INCLUDE	☐				0	0
25	TABNR	☐	HRTABNR	HRTABNR	CHAR	32	0	Reference Number to Table Part	*
26	TABSEQNR	☐	HRTABSEQNR	NUM06	NUMC	6	0	Sequence Number in Table Part of Table Infotype
27	.INCLUDE	☐				0	0	Fields for Table Part of Infotype 1686
28	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
29	BEGDT	☐	HRTNM_BEGDT	DATS	DATS	8	0	Date
30	TTYPE	☐	HRTNM_TTYPE	HRTNM_TTYPE	CHAR	3	0	Training Type	T77TNM_TY
31	TPCAT	☐	HRTNM_TPCAT	HRTNM_TPCAT	CHAR	2	0	Training Plan Category Code	T77TNM_PC
32	ATTHT	☐	HRTNM_ATTHT	DEC6_2	DEC	8	2	Attendance HTT
33	NBHRS	☐	HRTNM_HOURS	DEC6_2	DEC	8	2	Time Unit: Hours
34	RESON	☐	HRTNM_REASN	CHAR2	CHAR	2	0	Absence Reason	T77TNM_RS
35	ATTTY	☐	HRTNM_ATTTY	HRTNM_ATTTY	CHAR	2	0	TNM: attendee type
36	TFCAT	☐	HRTNM_TFCAT	HRTNM_TFCAT	CHAR	2	0	Training Fund Category

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P1686_EXP	INFTY	T778T	INFTY
2	P1686_EXP	ISTAT	T778S	ISTAT
3	P1686_EXP	MANDT	T000	MANDT
4	P1686_EXP	MOLGA	T500L	MOLGA	KEY	1	CN
5	P1686_EXP	OTYPE	T778O	OTYPE
6	P1686_EXP	PLVAR	T778P	PLVAR
7	P1686_EXP	RESON	T77TNM_RS	RESON	KEY	1	CN
8	P1686_EXP	SUBTY	T778U	SUBTY
9	P1686_EXP	TPCAT	T77TNM_PC	TPCAT	KEY	1	CN
10	P1686_EXP	TTYPE	T77TNM_TY	TTYPE	KEY	1	CN

History

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