SAP ABAP Table P0495 (HR-PS-SG: Pensions Scheme)
Hierarchy
☛ SAP_HRCSG (Software Component) Sub component SAP_HRCSG of SAP_HR
   ⤷ PY-SG-PS (Application Component) Public Sector
     ⤷ P25P4 (Package) HR-PS-SG: Public Sector Singapore (Pensions Scheme)
Basic Data
Table Category INTTAB    Structure 
Structure P0495   Table Relationship Diagram
Short Description HR-PS-SG: Pensions Scheme    
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   Headers for Infotype Records  
2 .INCLUDE       0   0   Keys for HR Master Data  
3 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
4 INFTY INFTY INFOTYP CHAR 4   0   Infotype T582A
5 SUBTY SUBTY SUBTY CHAR 4   0   Subtype  
6 OBJPS OBJPS OBJPS CHAR 2   0   Object Identification  
7 SPRPS SPRPS SPRPS CHAR 1   0   Lock Indicator for HR Master Data Record  
8 ENDDA ENDDA DATUM DATS 8   0   End Date  
9 BEGDA BEGDA DATUM DATS 8   0   Start Date  
10 SEQNR SEQNR NUM03 NUMC 3   0   Number of Infotype Record With Same Key  
11 .INCLUDE       0   0   HR Master Record: Control Field  
12 AEDTM AEDAT DATUM DATS 8   0   Last Changed On  
13 UNAME AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
14 HISTO HISTO CHAR1 CHAR 1   0   Historical Record Flag  
15 ITXEX ITXEX XFELD CHAR 1   0   Text Exists for Infotype  
16 REFEX PRFEX XFELD CHAR 1   0   Reference Fields Exist (Primary/Secondary Costs)  
17 ORDEX ORDEX XFELD CHAR 1   0   Confirmation Fields Exist  
18 ITBLD ITBLD CHAR2 CHAR 2   0   Infotype Screen Control  
19 PREAS PREAS PREAS CHAR 2   0   Reason for Changing Master Data T530E
20 FLAG1 NUSED NUSED CHAR 1   0   Reserved Field/Unused Field  
21 FLAG2 NUSED NUSED CHAR 1   0   Reserved Field/Unused Field  
22 FLAG3 NUSED NUSED CHAR 1   0   Reserved Field/Unused Field  
23 FLAG4 NUSED NUSED CHAR 1   0   Reserved Field/Unused Field  
24 RESE1 NUSED2 NUSED2 CHAR 2   0   Reserved Field/Unused Field of Length 2  
25 RESE2 NUSED2 NUSED2 CHAR 2   0   Reserved Field/Unused Field of Length 2  
26 GRPVL PCCE_GPVAL PCCE_GPVAL CHAR 4   0   Grouping Value for Personnel Assignments  
27 .INCLUDE       0   0   HR-PS-SG: Pensions Scheme  
28 STYPE P25_STYPE P25_STYPE CHAR 6   0   Superannuation Scheme T5RPBS8A
29 PTYPE P25_PTYPE P25_PTYPE CHAR 6   0   Payment Option T5RPBS8B
30 FUTDTE P25_FUTDTE DATUM DATS 8   0   Date of payment for CPF payment  
31 APEAMT P25_LIAMT P_AMT07V CURR 13   2   Liability amount  
32 PBSAMT P25_PBSAMT BETRG CURR 9   2   SG Public Sector Pensions Scheme Basic Salary Per Annum  
33 PAAMT P25_PAAMT BETRG CURR 9   2   SG PS Pensions Scheme Pensionable Allowance Per Annum  
34 RESECT P25_RESECT TEXT50 CHAR 50   0   SG PS Pensions Scheme Relevant Section of Pensions Act  
35 REFOPT P25_REFOPT P25_REFOPT CHAR 1   0   Refund Option  
36 REFACT P25_REFACT CHECKBOX CHAR 1   0   Flag to indicate whether CPF contributions already refunded  
37 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
38 AMTOPT P25_AMTOPT BETRG CURR 9   2   Employer's CPF contribution amount to be refunded  
39 AMTACT P25_AMTACT BETRG CURR 9   2   Employer's CPF contribution amount already refunded  
40 DTREF P25_DTREF DATUM DATS 8   0   Date of payment for refund of Govt's CPF share  
41 REFRNO P25_REFRNO TEXT20 CHAR 20   0   SG PS Pensions Receipt No for Refund of CPF Contributions  
42 REFRDT P25_REFRDT DATUM DATS 8   0   SG PS Pensions Receipt Date for Refund of CPF Contributions  
43 REFENO P25_REFENO TEXT20 CHAR 20   0   SG PS Pensions Enclosure No for Refund of CPF Contributions  
44 RECPFA P25_RECPFA P_AMT07V CURR 13   2   CPF minimum top up sum paid to officer's CPF account  
45 PROCF P25_PROCF CHECKBOX CHAR 1   0   Flag to indicate whether Ee has been processed for Pensions  
46 OPUPF P25_OPUPF CHECKBOX CHAR 1   0   Indicator for Pensions Scheme Option selected via report  
47 OPMPF P25_OPMPF CHECKBOX CHAR 1   0   Indicator for Scheme Option maintained manually by user  
48 ACO01 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
49 BEG01 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
50 END01 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
51 ACO02 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
52 BEG02 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
53 END02 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
54 ACO03 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
55 BEG03 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
56 END03 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
57 ACO04 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
58 BEG04 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
59 END04 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
60 ACO05 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
61 BEG05 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
62 END05 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
63 ACO06 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
64 BEG06 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
65 END06 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
66 ACO07 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
67 BEG07 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
68 END07 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
69 ACO08 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
70 BEG08 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
71 END08 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
72 ACO09 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
73 BEG09 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
74 END09 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
75 ACO10 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
76 BEG10 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
77 END10 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
78 ACO11 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
79 BEG11 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
80 END11 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
81 ACO12 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
82 BEG12 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
83 END12 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
84 ACO13 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
85 BEG13 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
86 END13 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
87 ACO14 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
88 BEG14 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
89 END14 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
90 ACO15 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
91 BEG15 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
92 END15 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
93 ACO16 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
94 BEG16 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
95 END16 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
96 ACO17 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
97 BEG17 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
98 END17 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
99 ACO18 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
100 BEG18 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
101 END18 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
102 ACO19 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
103 BEG19 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
104 END19 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
105 ACO20 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service *
106 BEG20 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
107 END20 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
108 PENSAL P25_PENSAL P_AMT07V CURR 13   2   Pensionable Salary for Computation of Govt's share of CPF  
109 NPESAL P25_NPESAL P_AMT07V CURR 13   2   Non-Pensionable Salary for Computing Govt's share of CPF  
110 FROSAL P25_GUABS P_AMT07V CURR 13   2   Guaranteed Basic Salary  
111 GUAPA P25_GUAPA P_AMT07V CURR 13   2   Guaranteed Pensionable Allowance  
112 CPFPY P25_CPFPY P_AMT07V CURR 13   2   CPF Payment amount to CPF board  
113 BENTY P25_BENTY P25_BENTY CHAR 3   0   Superannuation option T5RPBS8U
114 DEDPC P25_DEDPC DEC03_2 DEC 5   2   Deduction Percentage due to discipline  
115 PEACD P25_PEACD P25_PEACD CHAR 3   0   Pensions Act Code T5RPBS8T
116 PENS P25_PENS P25_PENS CHAR 1   0   Flag for Pension scheme 2006  
117 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 P0495 BENTY T5RPBS8U BENTY    
2 P0495 INFTY T582A INFTY    
3 P0495 PEACD T5RPBS8T PEACD    
4 P0495 PREAS T530E PREAS    
5 P0495 PTYPE T5RPBS8B PTYPE    
6 P0495 STYPE T5RPBS8A STYPE    
7 P0495 WAERS TCURC WAERS    
History
Last changed by/on SAP  20130529 
SAP Release Created in