| 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 | * | MANDT | Allow NULL? |
| 2 | VAGKY | Employer Key | nvarchar | 6 | 0 | CHAR | (N' ') | No | | VAGKY | 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 | ZVEID | SPI ID (Obsolete with ZVMP) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5D5Z | VZVID | Allow NULL? |
| 6 | VTSC1 | Structure of Distribution Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | VTSCHL | Allow NULL? |
| 7 | VTSC2 | Structure of Distribution Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | VTSCHL | Allow NULL? |
| 8 | VTSC3 | Structure of Distribution Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | VTSCHL | Allow NULL? |
| 9 | VTSC4 | Structure of Distribution Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | VTSCHL | Allow NULL? |
| 10 | VTSC5 | Structure of Distribution Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | VTSCHL | Allow NULL? |
| 11 | VTSC6 | Structure of Distribution Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | VTSCHL | Allow NULL? |
| 12 | VTSC7 | Structure of Distribution Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | VTSCHL | Allow NULL? |
| 13 | ERGA1 | Structure of Extra Line in Supplement to SP Notifications | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ERGAENZ | Allow NULL? |
| 14 | ERGA2 | Structure of Extra Line in Supplement to SP Notifications | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ERGAENZ | Allow NULL? |
| 15 | ERGA3 | Structure of Extra Line in Supplement to SP Notifications | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ERGAENZ | Allow NULL? |
| 16 | ERGA4 | Structure of Extra Line in Supplement to SP Notifications | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ERGAENZ | Allow NULL? |
| 17 | ADRE1 | Layout of Employee Address in SP Notifications | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ADREMA | Allow NULL? |
| 18 | ADRE2 | Layout of Employee Address in SP Notifications | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ADREMA | Allow NULL? |
| 19 | ADRE3 | Layout of Employee Address in SP Notifications | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ADREMA | Allow NULL? |
| 20 | ADRE4 | Layout of Employee Address in SP Notifications | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ADREMA | Allow NULL? |
| 21 | STVER | Tax Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PAUST | Allow NULL? |
| 22 | MOPAS | Maximum Amount of Monthly Flat-Rate Tax | decimal | 5 | 2 | CURR | ((0)) | Yes | | MOPAS | |
| 23 | JAPAS | Maximum Annual Amount of Flat-Rate Tax | decimal | 7 | 2 | CURR | ((0)) | Yes | | JAPAS | |
| 24 | STVMJ | Indicator: Tax Procedure Monthly or Annually | char | 1 | 0 | CHAR | (N' ') | Yes | | STVMJ | Allow NULL? |
