SAP ABAP Table PA0495 (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 | TRANSP | Transparent table |
| Transparent table | PA0495 |
|
| Short Description | HR-PS-SG: Pensions Scheme |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| 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 | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
0 | 0 | Key for HR Master Data | |||||
| 3 | |
PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | PA0003 | |
| 4 | |
SUBTY | SUBTY | CHAR | 4 | 0 | Subtype | ||
| 5 | |
OBJPS | OBJPS | CHAR | 2 | 0 | Object Identification | ||
| 6 | |
SPRPS | SPRPS | CHAR | 1 | 0 | Lock Indicator for HR Master Data Record | ||
| 7 | |
ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
| 8 | |
BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
| 9 | |
SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
| 10 | |
0 | 0 | HR Master Record: Control Field | |||||
| 11 | |
AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
| 12 | |
AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
| 13 | |
HISTO | CHAR1 | CHAR | 1 | 0 | Historical Record Flag | ||
| 14 | |
ITXEX | XFELD | CHAR | 1 | 0 | Text Exists for Infotype | ||
| 15 | |
PRFEX | XFELD | CHAR | 1 | 0 | Reference Fields Exist (Primary/Secondary Costs) | ||
| 16 | |
ORDEX | XFELD | CHAR | 1 | 0 | Confirmation Fields Exist | ||
| 17 | |
ITBLD | CHAR2 | CHAR | 2 | 0 | Infotype Screen Control | ||
| 18 | |
PREAS | PREAS | CHAR | 2 | 0 | Reason for Changing Master Data | T530E | |
| 19 | |
NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
| 20 | |
NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
| 21 | |
NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
| 22 | |
NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
| 23 | |
NUSED2 | NUSED2 | CHAR | 2 | 0 | Reserved Field/Unused Field of Length 2 | ||
| 24 | |
NUSED2 | NUSED2 | CHAR | 2 | 0 | Reserved Field/Unused Field of Length 2 | ||
| 25 | |
PCCE_GPVAL | PCCE_GPVAL | CHAR | 4 | 0 | Grouping Value for Personnel Assignments | ||
| 26 | |
0 | 0 | HR-PS-SG: Pensions Scheme | |||||
| 27 | |
P25_STYPE | P25_STYPE | CHAR | 6 | 0 | Superannuation Scheme | T5RPBS8A | |
| 28 | |
P25_PTYPE | P25_PTYPE | CHAR | 6 | 0 | Payment Option | T5RPBS8B | |
| 29 | |
P25_FUTDTE | DATUM | DATS | 8 | 0 | Date of payment for CPF payment | ||
| 30 | |
P25_LIAMT | P_AMT07V | CURR | 13 | 2 | Liability amount | ||
| 31 | |
P25_PBSAMT | BETRG | CURR | 9 | 2 | SG Public Sector Pensions Scheme Basic Salary Per Annum | ||
| 32 | |
P25_PAAMT | BETRG | CURR | 9 | 2 | SG PS Pensions Scheme Pensionable Allowance Per Annum | ||
| 33 | |
P25_RESECT | TEXT50 | CHAR | 50 | 0 | SG PS Pensions Scheme Relevant Section of Pensions Act | ||
| 34 | |
P25_REFOPT | P25_REFOPT | CHAR | 1 | 0 | Refund Option | ||
| 35 | |
P25_REFACT | CHECKBOX | CHAR | 1 | 0 | Flag to indicate whether CPF contributions already refunded | ||
| 36 | |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
| 37 | |
P25_AMTOPT | BETRG | CURR | 9 | 2 | Employer's CPF contribution amount to be refunded | ||
| 38 | |
P25_AMTACT | BETRG | CURR | 9 | 2 | Employer's CPF contribution amount already refunded | ||
| 39 | |
P25_DTREF | DATUM | DATS | 8 | 0 | Date of payment for refund of Govt's CPF share | ||
| 40 | |
P25_REFRNO | TEXT20 | CHAR | 20 | 0 | SG PS Pensions Receipt No for Refund of CPF Contributions | ||
| 41 | |
P25_REFRDT | DATUM | DATS | 8 | 0 | SG PS Pensions Receipt Date for Refund of CPF Contributions | ||
| 42 | |
P25_REFENO | TEXT20 | CHAR | 20 | 0 | SG PS Pensions Enclosure No for Refund of CPF Contributions | ||
| 43 | |
P25_RECPFA | P_AMT07V | CURR | 13 | 2 | CPF minimum top up sum paid to officer's CPF account | ||
| 44 | |
P25_PROCF | CHECKBOX | CHAR | 1 | 0 | Flag to indicate whether Ee has been processed for Pensions | ||
| 45 | |
P25_OPUPF | CHECKBOX | CHAR | 1 | 0 | Indicator for Pensions Scheme Option selected via report | ||
| 46 | |
P25_OPMPF | CHECKBOX | CHAR | 1 | 0 | Indicator for Scheme Option maintained manually by user | ||
| 47 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 48 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 49 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 50 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 51 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 52 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 53 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 54 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 55 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 56 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 57 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 58 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 59 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 60 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 61 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 62 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 63 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 64 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 65 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 66 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 67 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 68 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 69 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 70 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 71 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 72 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 73 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 74 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 75 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 76 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 77 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 78 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 79 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 80 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 81 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 82 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 83 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 84 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 85 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 86 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 87 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 88 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 89 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 90 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 91 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 92 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 93 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 94 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 95 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 96 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 97 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 98 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 99 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 100 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 101 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 102 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 103 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 104 | |
P25_ACODE | P25_ACODE | CHAR | 4 | 0 | Absence Code for absences not counted as pensionable service | * | |
| 105 | |
P25_BEGDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme Start Date | ||
| 106 | |
P25_ENDDA | DATUM | DATS | 8 | 0 | SG Public Sector Pensions Scheme End Date | ||
| 107 | |
P25_PENSAL | P_AMT07V | CURR | 13 | 2 | Pensionable Salary for Computation of Govt's share of CPF | ||
| 108 | |
P25_NPESAL | P_AMT07V | CURR | 13 | 2 | Non-Pensionable Salary for Computing Govt's share of CPF | ||
| 109 | |
P25_GUABS | P_AMT07V | CURR | 13 | 2 | Guaranteed Basic Salary | ||
| 110 | |
P25_GUAPA | P_AMT07V | CURR | 13 | 2 | Guaranteed Pensionable Allowance | ||
| 111 | |
P25_CPFPY | P_AMT07V | CURR | 13 | 2 | CPF Payment amount to CPF board | ||
| 112 | |
P25_BENTY | P25_BENTY | CHAR | 3 | 0 | Superannuation option | T5RPBS8U | |
| 113 | |
P25_DEDPC | DEC03_2 | DEC | 5 | 2 | Deduction Percentage due to discipline | ||
| 114 | |
P25_PEACD | P25_PEACD | CHAR | 3 | 0 | Pensions Act Code | T5RPBS8T | |
| 115 | |
P25_PENS | P25_PENS | CHAR | 1 | 0 | Flag for Pension scheme 2006 | ||
| 116 | |
0 | 0 |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | PA0495 | BENTY | |
|
|||
| 2 | PA0495 | MANDT | |
|
KEY | 1 | CN |
| 3 | PA0495 | PEACD | |
|
|||
| 4 | PA0495 | PERNR | |
|
|||
| 5 | PA0495 | PREAS | |
|
|||
| 6 | PA0495 | PTYPE | |
|
|||
| 7 | PA0495 | STYPE | |
|
|||
| 8 | PA0495 | WAERS | |
|
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |