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.

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
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
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
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
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
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