| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | SCREF | Pension scheme reference | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SCREF | Allow NULL? |
| 3 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 4 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 5 | PTYPE | Pension category | char | 1 | 0 | CHAR | (N' ') | Yes | | PENTY | Allow NULL? |
| 6 | SCNAM | Name of pension scheme | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | SCNAM | Allow NULL? |
| 7 | NETPC | Tax-free percentage of deduction | decimal | 7 | 2 | DEC | ((0)) | Yes | | NETPC | |
| 8 | HOLCL | Leave for calculating pension insurance | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | HOLCL | Allow NULL? |
| 9 | COYRE | End of fiscal year (Pension fund GB) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | COYRE | Allow NULL? |
| 10 | LOLEV | Low band level | decimal | 9 | 2 | CURR | ((0)) | Yes | | BTRPK | |
| 11 | UPLEV | Low band level | decimal | 9 | 2 | CURR | ((0)) | Yes | | BTRPK | |
| 12 | PCTEE | Employee percentage of lower band | decimal | 7 | 4 | DEC | ((0)) | Yes | | PCTEE | |
| 13 | PCTER | Employer percentage of lower band | decimal | 7 | 4 | DEC | ((0)) | Yes | | PCTER | |
| 14 | PCMEE | Percentage | decimal | 7 | 4 | DEC | ((0)) | Yes | | PRZTG | |
| 15 | PCMER | Percentage | decimal | 7 | 4 | DEC | ((0)) | Yes | | PRZTG | |
| 16 | PCHIE | Percentage | decimal | 7 | 4 | DEC | ((0)) | Yes | | PRZTG | |
| 17 | PCHIR | Percentage | decimal | 7 | 4 | DEC | ((0)) | Yes | | PRZTG | |
| 18 | FTREE | Low band level | decimal | 9 | 2 | CURR | ((0)) | Yes | | BTRPK | |
| 19 | FTRER | Low band level | decimal | 9 | 2 | CURR | ((0)) | Yes | | BTRPK | |
| 20 | CALEE | Employee calculation | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | CALEE | Allow NULL? |
| 21 | CALER | Employer calculation | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | CALER | Allow NULL? |
| 22 | FTMEE | Employee flat rate of lower band | decimal | 9 | 2 | CURR | ((0)) | Yes | | FTREE | |
| 23 | FTMER | Employer flat rate of lower band | decimal | 9 | 2 | CURR | ((0)) | Yes | | FTRER | |
| 24 | FTHEE | Employee flat rate of lower band | decimal | 9 | 2 | CURR | ((0)) | Yes | | FTREE | |
| 25 | FTHER | Employer flat rate of lower band | decimal | 9 | 2 | CURR | ((0)) | Yes | | FTRER | |
| 26 | COMNT | Initial month of company pension year | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | COMTH | Allow NULL? |
| 27 | CODAY | Initial day of company pension year | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CODAY | Allow NULL? |
| 28 | PSCON | Pension fund SCON number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | PSCON | Allow NULL? |
| 29 | PNTYP | Pension scheme type | char | 1 | 0 | CHAR | (N' ') | Yes | | PB08_PNTYP | Allow NULL? |
