| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BAREA | Benefit area | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | INVGR | Benefit Savings Plan Investment Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | VESTI | Benefit vesting rules for employee contrib. to savings plans | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | ERCON | Employer's Benefits Contribution Variant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | AMTOK | Benefit Indicator: Contribution Type 'Amount' Allowed | char | 1 | 0 | | | | Allow NULL? |
| 10 | CMINA | Benefit minimum amount for pre-tax contribution | decimal | 13 | 2 | | | | |
| 11 | CMAXA | Benefit maximum pre-tax contribution amount | decimal | 13 | 2 | | | | |
| 12 | PMINA | Benefit minimum amount for post-tax contribution | decimal | 13 | 2 | | | | |
| 13 | PMAXA | Benefit maximum amount for post-tax contribution | decimal | 13 | 2 | | | | |
| 14 | PCTOK | Benefit Indicator: Contribution Type 'Percentage' Allowed | char | 1 | 0 | | | | Allow NULL? |
| 15 | CMINP | Benefit minimum percentage for pre-tax contribution | decimal | 5 | 2 | | | | |
| 16 | CMAXP | Benefit maximum percentage for pre-tax contribution | decimal | 5 | 2 | | | | |
| 17 | PMINP | Benefit minimum percentage for post-tax contribution | decimal | 5 | 2 | | | | |
| 18 | PMAXP | Benefit maximum percentage for post-tax contribution | decimal | 5 | 2 | | | | |
| 19 | WDRAW | Benefit withdrawals allowed | char | 1 | 0 | | | | Allow NULL? |
| 20 | LIMIT | Benefit maximum pre-tax contribution per annum | decimal | 13 | 2 | | | | |
| 21 | PREOK | Benefit indicator pre-tax contributions allowed | char | 1 | 0 | | | | Allow NULL? |
| 22 | PSTOK | Benefit indicator post-tax contributions allowed | char | 1 | 0 | | | | Allow NULL? |