| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | SVGRP | Social Insurance Group Indicator | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | SVTAK | Social Insurance | char | 1 | 0 | | | | Allow NULL? |
| 5 | SVVNR | Social Security Sequence Number | char | 1 | 0 | | | | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | SVSRT | Social Security Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | MAXGR | Maximum Basis | decimal | 8 | 2 | | | | |
| 10 | FRNCH | Port.of Sal.Disreg.in Calc.Pen.Con. | decimal | 8 | 2 | | | | |
| 11 | WGSVP | Employer's Contribution to Social Insurance (%) | decimal | 5 | 3 | | | | |
| 12 | WNSVP | Employee's Contribution to Social Insurance (%) | decimal | 5 | 3 | | | | |
| 13 | SVDAY | Indicator for Calculation of SI Days | char | 1 | 0 | | | | Allow NULL? |
| 14 | SVMET | Calculation Method for Social Security Laws | char | 1 | 0 | | | | Allow NULL? |
| 15 | GRSLG | Baisis for Calculation of Contribution Amount | char | 1 | 0 | | | | Allow NULL? |
| 16 | AARDP | Type of the Contribution | char | 1 | 0 | | | | Allow NULL? |
| 17 | WNNEG | Employee's Contribution to Social Insurance (%) | decimal | 5 | 3 | | | | |
| 18 | APSCR | Apply Special Calculation Rules for Extra SI | char | 1 | 0 | | | | Allow NULL? |
| 19 | WGSV1 | Employer Contribution WGA-fixed | decimal | 5 | 3 | | | | |
| 20 | WGSV2 | Employer Contribution WGA-flex | decimal | 5 | 3 | | | | |
| 21 | WGSV3 | Employer Contribution ZW-flex | decimal | 5 | 3 | | | | |
| 22 | WNSV1 | Employee Contribution WGA-fixed | decimal | 5 | 3 | | | | |
| 23 | WNSV2 | Employee Contribution WGA-flex | decimal | 5 | 3 | | | | |