SAP ABAP Table P1681_EXP (Infotype 1681 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	P1681_EXP	Table Relationship Diagram
Short Description	Infotype 1681 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 1681
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 1681 Fields
23	TLREF	☐	HRTNM_TLREF	HRTNM_TLREF	CHAR	3	0	Training Legal Reference	T77TNM_LR
24	TOTDU	☐	HRTNM_TOTDU	DEC6_2	DEC	8	2	Training Total Duration
25	MOLGA	☐	MOLGA	MOLGA	CHAR	2	0	Country Grouping	T500L
26	SCLAS	☐	SCLAS	OTYPE	CHAR	2	0	Type of Related Object	*
27	SOBID	☐	SOBID	CHAR45	CHAR	45	0	ID of Related Object
28	NDAYS	☐	DAYCT	DEC4	DEC	4	0	Effective duration in days
29	.INCLUDE	☐				0	0
30	TABNR	☐	HRTABNR	HRTABNR	CHAR	32	0	Reference Number to Table Part	*
31	TABSEQNR	☐	HRTABSEQNR	NUM06	NUMC	6	0	Sequence Number in Table Part of Table Infotype
32	.INCLUDE	☐				0	0	Regulatory compliance financing data
33	TTYPE	☐	HRTNM_TTYPE	HRTNM_TTYPE	CHAR	3	0	Training Type	T77TNM_TY
34	TPCAT	☐	HRTNM_TPCAT	HRTNM_TPCAT	CHAR	2	0	Training Plan Category Code	T77TNM_PC
35	TFCAT	☐	HRTNM_TFCAT	HRTNM_TFCAT	CHAR	2	0	Training Fund Category	T77TNM_FC
36	NBHRS	☐	HRTNM_NBHRS	DEC6_2	DEC	8	2	Number of Training Hours
37	HDOWT	☐	HRTNM_HDOWT	DEC6_2	DEC	8	2	Number of Hours Done Outside Working Time

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P1681_EXP	INFTY	T778T	INFTY
2	P1681_EXP	ISTAT	T778S	ISTAT
3	P1681_EXP	LANGU	T002	SPRAS
4	P1681_EXP	MANDT	T000	MANDT
5	P1681_EXP	MOLGA	T500L	MOLGA	KEY	1	CN
6	P1681_EXP	OTYPE	T778O	OTYPE
7	P1681_EXP	PLVAR	T778P	PLVAR
8	P1681_EXP	SUBTY	T778U	SUBTY
9	P1681_EXP	TFCAT	T77TNM_FC	TFCAT	KEY	1	CN
10	P1681_EXP	TLREF	T77TNM_LR	TLREF	KEY	1	CN
11	P1681_EXP	TPCAT	T77TNM_PC	TPCAT	REF	1	CN
12	P1681_EXP	TTYPE	T77TNM_TY	TTYPE	KEY	1	CN

History

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