| 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 | TRFAR | Pay scale type | nvarchar | 2 | 0 | CHAR | (N' ') | No | T510A | TRFAR | Allow NULL? |
| 3 | TRFGB | Pay Scale Area | nvarchar | 2 | 0 | CHAR | (N' ') | No | T510G | TRFGB | Allow NULL? |
| 4 | TRFKZ | ES grouping for collective agreement provision | char | 1 | 0 | CHAR | (N' ') | No | | TRFKZ | Allow NULL? |
| 5 | CDMAT | Accrual indicator | nvarchar | 2 | 0 | CHAR | (N' ') | No | T5ITF1 | P15_CDMAT | Allow NULL? |
| 6 | PROGR | Sequential number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | P15_PROGR | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 8 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 9 | LIMIT | Range | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P15_LIMIT | Allow NULL? |
| 10 | TPLIM | Limit type | char | 1 | 0 | CHAR | (N' ') | Yes | | P15_TPLIM | Allow NULL? |
| 11 | QTAAC | Annual provision quantity | decimal | 5 | 2 | DEC | ((0)) | Yes | | P15_QTAAC | |
| 12 | DVACC | Provision quantity divisor | decimal | 4 | 2 | DEC | ((0)) | Yes | | P15_DVACC | |
| 13 | IMACC | Provision yearly amount | decimal | 12 | 2 | CURR | ((0)) | Yes | | P15_IMACC | |
| 14 | DIANN | Yearly provision amount divisor | decimal | 4 | 2 | DEC | ((0)) | Yes | | P15_DIANN | |
| 15 | WTQTA | Wage type: quantity to be generated | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | P15_WTQTA | Allow NULL? |
| 16 | WTIMP | Wage type: amount to be generated | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | P15_WTIMP | Allow NULL? |
| 17 | WTMTM | Wage type for multiplication factor | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | P15_WTMTM | Allow NULL? |
| 18 | WTAME | Wage-type monthly provision | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | P15_WTAME | Allow NULL? |
| 19 | WTRMS | Wage type: not accrued quantity | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | P15_WTRMS | Allow NULL? |
| 20 | WTGAM | Wage type: monthly provision contributions | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | P15_WTGAM | Allow NULL? |
| 21 | WTRCM | Wage type: base for provision contributions | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | P15_WTRCM | Allow NULL? |
