SAP ABAP Table TRAIN_PLAN_VAL (Planned Data for a Training Course)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS-OF-PER (Application Component) Personnel Categories
     ⤷ HRTRAINING (Package) HR Training

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TRAIN_PLAN_VAL	Table Relationship Diagram
Short Description	Planned Data for a Training Course

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	TPROG_ID	☑	TPROG_ID	TPROG_ID	CHAR	15	0	Training Program ID	TRAIN_STAT
3	FUNCT_ID	☑	FUNCT_ID	FUNCT_ID	CHAR	15	0	Function ID	TRAIN_STAT
4	STATUS_ID	☑	TSTAT_ID	CHAR15	CHAR	15	0	Training Status ID	TRAIN_STAT
5	TRAIN_ID	☑	TRAIN_ID	CHAR15	CHAR	15	0	Training ID	TRAIN_TRNGS
6	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
7	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
8	MIN_VALUE	☐	TMIN_VALUE	DEC_8_2	DEC	8	2	Minimum Training To Be Completed
9	PLAN_VALUE	☐	TPLAN_VALUE	DEC_8_2	DEC	8	2	Planned Amount of Training To Be Completed
10	UNIT_VALUE	☐	TUNIT_VALUE	MEINS	UNIT	3	0	Unit	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TRAIN_PLAN_VAL	FUNCT_ID	TRAIN_STAT	FUNCT_ID	KEY	1	CN
2	TRAIN_PLAN_VAL	STATUS_ID	TRAIN_STAT	STATUS_ID	KEY	1	CN
3	TRAIN_PLAN_VAL	TPROG_ID	TRAIN_STAT	TPROG_ID	KEY	1	CN
4	TRAIN_PLAN_VAL	TRAIN_ID	TRAIN_TRNGS	TRAIN_ID	KEY	1	CN

History

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