| 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 | EECON | Benefit Employee Contribution Rule Variant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | WDRAW | Benefit withdrawals allowed | char | 1 | 0 | | | | Allow NULL? |
| 11 | CUNIT | Benefit contribution unit (employee contribution) | decimal | 13 | 2 | | | | |
| 12 | PAPRO | Benefit Calculation Process for Participation Service | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | CRPRO | Benefit Calculation Process for Benefit Accrual Service | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | VEPRO | Benefit Calculation Process for Vesting Service | nvarchar | 4 | 0 | | | | Allow NULL? |