- Home
- Resources
- SAP Tables
- T5G30 - Pension Schemes
SAP Table T5G30
Pension Schemes
T5G30 (Pension Schemes) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T5G30 to other SAP tables.
Source: T5G30 (Pension Schemes)
T5G30 table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
| SCHID |
Pension scheme |
P08_SCHID |
|
CHAR |
|
3 |
0 |
|
| ENDDA |
End Date |
ENDDA |
|
DATS |
|
8 |
0 |
|
| BEGDA |
Start Date |
BEGDA |
|
DATS |
|
8 |
0 |
|
| PSCON |
Pension scheme contracted out number |
P08_SCON |
|
CHAR |
|
9 |
0 |
|
| SCDAT |
Pension scheme set up date |
P08_SCDAT |
|
DATS |
|
8 |
0 |
|
| PTYPE |
Pension scheme type |
P08_PTYPE |
|
CHAR |
|
5 |
0 |
Possible values
| COSRS |
Contracted out salary related scheme |
| COMPS |
Contracted out money purchase scheme |
| APPS |
Appropriate personal pension scheme |
| OTHER |
Unapproved scheme |
| CIMPS |
Contracted in money purchase scheme |
| CISRS |
Contracted in salary related scheme |
|
| QPENS |
Qualifying Pension Scheme |
P08_QPENS |
|
CHAR |
|
1 |
0 |
|
| AEPNS |
Auto Enrolment Pension scheme |
P08_AEPNS |
|
CHAR |
|
1 |
0 |
|
| TXRUK |
Entitled Worker Pension scheme |
P08_TXRUK |
|
CHAR |
|
1 |
0 |
|
| PTIER |
Tier of certification for a pension scheme |
P08_PTIER |
|
NUMC |
|
1 |
0 |
|
| PSTYP |
Pension Scheme Type |
P08_PSTYP |
|
CHAR |
|
6 |
0 |
Possible values
| DB |
Defined Benefit |
| DC |
Defined Contribution |
| HYBRID |
Hybrid Scheme (both) |
|
| TPED |
Pensions Auto Enrolment: Transitional Period End Date |
P08_PAE_TPED |
|
DATS |
|
8 |
0 |
|
| TPCH |
Pensions Auto Enrolment: Transitional Period Deferral Choice |
P08_PAE_TPCH |
|
CHAR |
|
1 |
0 |
Possible values
| A |
TNA/TNB at Staging + Transitional Period for EJH at Staging |
| B |
GNA/GNB at Staging + Transitional Period for EJH in Payroll |
| C |
GNA/GNB at Staging + Transitional Period for EJH at Staging |
|
| SLA1 |
PAE: Days until AE Notice Sent (SLA Driven) |
P08_PAE_SLA1 |
|
CHAR |
|
2 |
0 |
Possible values
| NULL |
No SLA in place |
| 00 |
Immediate |
| 01 |
1 Day |
| 02 |
2 Days |
| 03 |
3 Days |
| 04 |
4 Days |
| 05 |
5 Days |
| 06 |
6 Days |
| 07 |
7 Days |
| 08 |
8 Days |
| 09 |
9 Days |
| 10 |
10 Days |
| 11 |
11 Days |
| 12 |
12 Days |
| 13 |
13 Days |
| 14 |
14 Days |
| 15 |
15 Days |
| 16 |
16 Days |
| 17 |
17 Days |
| 18 |
18 Days |
| 19 |
19 Days |
| 20 |
20 Days |
| 21 |
21 Days |
| 22 |
22 Days |
| 23 |
23 Days |
| 24 |
24 Days |
| 25 |
25 Days |
| 26 |
26 Days |
| 27 |
27 Days |
| 28 |
28 Days |
| 29 |
29 Days |
| 30 |
30 Days |
| 31 |
31 Days |
| W1 |
1 Working Day |
| W2 |
2 Working Days |
| W3 |
3 Working Days |
| W4 |
4 Working Days |
| W5 |
5 Working Days |
| W6 |
6 Working Days |
| W7 |
7 Working Days |
| W8 |
8 Working Days |
| W9 |
9 Working Days |
| WA |
10 Working Days |
| WB |
11 Working Day |
| WC |
12 Working Days |
| WD |
13 Working Days |
| WE |
14 Working Days |
| WF |
15 Working Days |
| WG |
16 Working Days |
| WH |
17 Working Days |
| WI |
18 Working Days |
| WJ |
19 Working Days |
| WK |
20 Working Days |
|
| SLA2 |
PAE: Days until Ts&Cs Sent (SLA Driven) |
P08_PAE_SLA2 |
|
CHAR |
|
2 |
0 |
Possible values
| NULL |
No SLA in place |
| 00 |
Immediate |
| 01 |
1 Day |
| 02 |
2 Days |
| 03 |
3 Days |
| 04 |
4 Days |
| 05 |
5 Days |
| 06 |
6 Days |
| 07 |
7 Days |
| 08 |
8 Days |
| 09 |
9 Days |
| 10 |
10 Days |
| 11 |
11 Days |
| 12 |
12 Days |
| 13 |
13 Days |
| 14 |
14 Days |
| 15 |
15 Days |
| 16 |
16 Days |
| 17 |
17 Days |
| 18 |
18 Days |
| 19 |
19 Days |
| 20 |
20 Days |
| 21 |
21 Days |
| 22 |
22 Days |
| 23 |
23 Days |
| 24 |
24 Days |
| 25 |
25 Days |
| 26 |
26 Days |
| 27 |
27 Days |
| 28 |
28 Days |
| 29 |
29 Days |
| 30 |
30 Days |
| 31 |
31 Days |
| W1 |
1 Working Day |
| W2 |
2 Working Days |
| W3 |
3 Working Days |
| W4 |
4 Working Days |
| W5 |
5 Working Days |
| W6 |
6 Working Days |
| W7 |
7 Working Days |
| W8 |
8 Working Days |
| W9 |
9 Working Days |
| WA |
10 Working Days |
| WB |
11 Working Day |
| WC |
12 Working Days |
| WD |
13 Working Days |
| WE |
14 Working Days |
| WF |
15 Working Days |
| WG |
16 Working Days |
| WH |
17 Working Days |
| WI |
18 Working Days |
| WJ |
19 Working Days |
| WK |
20 Working Days |
|
T5G30 foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| T5G30 |
MANDT |
T5G30 |
MANDT |
T000 |
Clients |
MANDT |
