SAP ABAP Table HRTNM_S_TN_ASSIGN_TN (TNM: TN assignment report - training needs structure)

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	HRTNM_S_TN_ASSIGN_TN	Table Relationship Diagram
Short Description	TNM: TN assignment report - training needs structure

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	Information Data for Training Plan
2	OBJTP	☐	HRTNM_OBJTP	NUM08	NUMC	8	0	TNM: Training Plan ID
3	BEGTP	☐	HRTNM_BEGTP	DATUM	DATS	8	0	Training Plan Start Date
4	ENDTP	☐	HRTNM_ENDTP	DATUM	DATS	8	0	Training Plan End Date
5	SHRTP	☐	HRTNM_SHRTP	TEXT12	CHAR	12	0	TNM: Training Plan Short Name (Object Abbreviation)
6	NAMTP	☐	HRTNM_NAMTP	TEXT40	CHAR	40	0	TNM: Trainig Plan Long Name (Object Name)
7	PARID	☐	HRTNM_PARID	NUM08	NUMC	8	0	Parent Object Id
8	.INCLUDE	☐				0	0	TNM: tree structure
9	.INCLUDE	☐				0	0	Work Area for Database PCH
10	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
11	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
12	OBJID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
13	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
14	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
15	ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
16	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
17	SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
18	STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
19	REALO	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
20	NODE_KEY	☐	TV_NODEKEY	TM_CHAR12	CHAR	12	0	Tree Control: Node Key
21	IDFAT	☐	HRTNM_IDFAT	HROBJID	NUMC	8	0	TNM: Parent Object ID	*
22	.INCLUDE	☐				0	0	TNM: TN assign. report - regulatory compliance structure
23	TTYPE	☐	HRTNM_TTYPE	HRTNM_TTYPE	CHAR	3	0	Training Type
24	TTYPE_TXT	☐	HRTNM_TTYPE_TXT	HRTNM_TTYPE_TXT	CHAR	100	0	Training Type Text
25	TPCAT	☐	HRTNM_TPCAT	HRTNM_TPCAT	CHAR	2	0	Training Plan Category Code
26	TPCAT_TXT	☐	HRTNM_TPCAT_TXT	HRTNM_TPCAT_TXT	CHAR	100	0	Plan Category Label
27	TFCAT	☐	HRTNM_TFCAT	HRTNM_TFCAT	CHAR	2	0	Training Fund Category
28	TFCAT_TXT	☐	HRTNM_TFCAT_TXT	HRTNM_TFCAT_TXT	CHAR	100	0	Training Fund Category Label
29	RCHRS	☐	HRTNM_NBHRS	DEC6_2	DEC	8	2	Number of Training Hours
30	RCOWT	☐	HRTNM_HDOWT	DEC6_2	DEC	8	2	Number of Hours Done Outside Working Time
31	.INCLUDE	☐				0	0	TNM: TN assignment report - business event type structure
32	OTBET	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
33	OBBET	☐	HRTNM_OBBET		NUMC	8	0	TNM: Business Event Type object ID
34	SHBET	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
35	BEGBET	☐	BEGDA	DATUM	DATS	8	0	Start Date
36	ENDBET	☐	ENDDA	DATUM	DATS	8	0	End Date
37	ICOND	☐	HRTNM_ICDIS	ICONNAME	CHAR	30	0	TNM: Display Icon

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HRTNM_S_TN_ASSIGN_TN	ISTAT	T778S	ISTAT
2	HRTNM_S_TN_ASSIGN_TN	OTYPE	T778O	OTYPE
3	HRTNM_S_TN_ASSIGN_TN	PLVAR	T778P	PLVAR

History

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