SAP ABAP Table HRP1690 (DB Table for Infotype 1690)
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 TRANSP    Transparent table 
Transparent table HRP1690   Table Relationship Diagram
Short Description DB Table for Infotype 1690    
Delivery and Maintenance
Pool/cluster      
Delivery Class C   Customizing table, maintenance only by cust., not SAP import 
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   Extended Key Definition of PD Infotypes  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 PLVAR PLVAR PLVAR CHAR 2   0   Plan Version T778P
4 OTYPE OTYPE OTYPE CHAR 2   0   Object Type T778O
5 OBJID HROBJID HROBJID NUMC 8   0   Object ID PLOGI
6 SUBTY SUBTYP SUBTYP CHAR 4   0   Subtype *
7 ISTAT ISTAT_D ISTAT CHAR 1   0   Planning Status T778S
8 BEGDA BEGDATUM DATUM DATS 8   0   Start Date  
9 ENDDA ENDDATUM DATUM DATS 8   0   End Date  
10 VARYF VARYF CHAR10 CHAR 10   0   Variation Field for File PLOG  
11 SEQNR SEQNR NUM03 NUMC 3   0   Number of Infotype Record With Same Key  
12 INFTY INFOTYP INFOTYP CHAR 4   0   Infotype T778T
13 OTJID OTJID CHAR10 CHAR 10   0   Concatenation of Object Type and Object ID  
14 .INCLUDE       0   0   Infotype Administration Data  
15 AEDTM AEDTM DATUM DATS 8   0   Changed on  
16 UNAME USRNAME CHAR12 CHAR 12   0   User Name  
17 REASN REASN CHAR2 CHAR 2   0   Reason  
18 HISTO HISTO CHAR1 CHAR 1   0   Historical Record Flag  
19 ITXNR ITXNR NUM08 NUMC 8   0   Text Module for Infotype  
20 .INCLUDE       0   0   Infotype 1690 Fields (TNM attributes)  
21 FTNMS HRTNM_FTNMS HRTNM_FTNMS CHAR 4   0   TNM: feature FTNMS return value  
22 WERKS PERSA PERSA CHAR 4   0   Personnel Area T500P
23 BTRTL BTRTL BTRTL CHAR 4   0   Personnel Subarea T001P
24 MOLGA MOLGA MOLGA CHAR 2   0   Country Grouping T500L
25 ORGID HRTNM_ORGID HROBJID NUMC 8   0   TNM: Org. unit ID *
26 TRCAT HRTNM_TRCAT HRTNM_TRCAT CHAR 4   0   Trainer Category  
27 TRRAT HRTNM_TRRAT P_AMT07V CURR 13   2   Trainer Hourly Salary Rate  
28 WAERS WAERS WAERS CUKY 5   0   Currency Key *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 HRP1690 BTRTL T001P BTRTL KEY 1 CN
2 HRP1690 INFTY T778T INFTY KEY 1 CN
3 HRP1690 ISTAT T778S ISTAT KEY 1 CN
4 HRP1690 MANDT T000 MANDT KEY 1 CN
5 HRP1690 MOLGA T500L MOLGA KEY 1 CN
6 HRP1690 OBJID PLOGI OBJID KEY 1 CN
7 HRP1690 OTYPE T778O OTYPE KEY 1 CN
8 HRP1690 PLVAR T778P PLVAR KEY 1 CN
9 HRP1690 WERKS T500P PERSA KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 600