SAP ABAP View V_TRAIN_PLAN (Planning Data per Training Item)
Hierarchy
☛
EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
⤷ IS-DFS-OF-PER (Application Component) Personnel Categories
⤷ HRTRAINING (Package) HR Training
⤷ IS-DFS-OF-PER (Application Component) Personnel Categories
⤷ HRTRAINING (Package) HR Training
Basic Data
View Type | C | Maintenance View |
Maintenance View | V_TRAIN_PLAN | |
Short Description | Planning Data per Training Item | |
Root table | TRAIN_PLAN_VAL | Planned Data for a Training Course |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | TRAIN_PLAN_VAL | TRAIN_PLAN_VAL | ||
2 | TRAIN_STAT | TRAIN_PLAN_VAL | FUNCT_ID | E |
3 | TRAIN_TRNGS | TRAIN_PLAN_VAL | TRAIN_ID | E |
4 | TRAIN_STAT_T | TRAIN_STAT | FUNCT_ID | I |
5 | TRAIN_FUNCT | TRAIN_STAT | FUNCT_ID | E |
6 | TRAIN_FUNCT_T | TRAIN_FUNCT | FUNCT_ID | I |
7 | TRAIN_PROG | TRAIN_FUNCT | TPROG_ID | E |
8 | TRAIN_PROG_T | TRAIN_PROG | TPROG_ID | I |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | TRAIN_PLAN_VAL | MANDT | MANDT | Client | |||
2 | TPROG_ID | TRAIN_PLAN_VAL | TPROG_ID | S | TPROG_ID | Training Program ID | ||
3 | FUNCT_ID | TRAIN_PLAN_VAL | FUNCT_ID | S | FUNCT_ID | Function ID | ||
4 | STATUS_ID | TRAIN_PLAN_VAL | STATUS_ID | S | TSTAT_ID | Training Status ID | ||
5 | TRAIN_ID | TRAIN_PLAN_VAL | TRAIN_ID | TRAIN_ID | Training ID | |||
6 | ENDDA | TRAIN_PLAN_VAL | ENDDA | ENDDA | End Date | |||
7 | BEGDA | TRAIN_PLAN_VAL | BEGDA | BEGDA | Start Date | |||
8 | MIN_VALUE | TRAIN_PLAN_VAL | MIN_VALUE | TMIN_VALUE | Minimum Training To Be Completed | |||
9 | PLAN_VALUE | TRAIN_PLAN_VAL | PLAN_VALUE | TPLAN_VALUE | Planned Amount of Training To Be Completed | |||
10 | UNIT_VALUE | TRAIN_PLAN_VAL | UNIT_VALUE | TUNIT_VALUE | Unit | |||
11 | TPROG_ID_T | TRAIN_PROG_T | TPROG_ID_T | S | TPROG_ID_T | Training Program ID Text | ||
12 | FUNCT_ID_T | TRAIN_FUNCT_T | FUNCT_ID_T | S | FUNCT_ID_T | Function ID Text | ||
13 | STATUS_ID_T | TRAIN_STAT_T | STATUS_ID_T | S | TSTAT_ID_T | Training Status Text | ||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
History
Last changed by/on | SAP | 20050705 |
SAP Release Created in | 600 |