SAP table T5G30 (Pension Schemes)

SAP table T5G30 has 3 primary key fields being MANDT,SCHID,ENDDA.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
SCHID Pension scheme CHAR 3 0 P08_SCHID
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
PSCON Pension scheme contracted out number CHAR 9 0 P08_SCON
SCDAT Pension scheme set up date DATS 8 0 P08_SCDAT
PTYPE Pension scheme type CHAR 5 0 P08_PTYPE
APPS Appropriate personal pension scheme
CIMPS Contracted in money purchase scheme
CISRS Contracted in salary related scheme
COMPS Contracted out money purchase scheme
COSRS Contracted out salary related scheme
OTHER Unapproved scheme
QPENS Qualifying Pension Scheme CHAR 1 0 P08_QPENS
AEPNS Auto Enrolment Pension scheme CHAR 1 0 P08_AEPNS
TXRUK Entitled Worker Pension scheme CHAR 1 0 P08_TXRUK
PTIER Tier of certification for a pension scheme NUMC 1 0 P08_PTIER
PSTYP Pension Scheme Type CHAR 6 0 P08_PSTYP
DB Defined Benefit
DC Defined Contribution
HYBRID Hybrid Scheme (both)
TPED Pensions Auto Enrolment: Transitional Period End Date DATS 8 0 P08_PAE_TPED
TPCH Pensions Auto Enrolment: Transitional Period Deferral Choice CHAR 1 0 P08_PAE_TPCH
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) CHAR 2 0 P08_PAE_SLA1
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) CHAR 2 0 P08_PAE_SLA2
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
MINCK PAE: Minimum Entitlement Check CHAR 1 0 P08_PAE_MINCK
Check not applied
E Failure produces error
W Failure produces warning
MINTH PAE: Minimum Entitlement Check Thresholds CHAR 1 0 P08_PAE_MINTH
B Thresholds as at Pay Period Start Date
E Thresholds as at Pay Period End Date
S Thresholds prorated (if they change during the Pay Period)