| 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 | MOABW | Personnel subarea grouping for absence and attendance types | nvarchar | 2 | 0 | NUMC | (N'00') | No | | MOABW | Allow NULL? |
| 3 | ANSTA | Employment status | char | 1 | 0 | NUMC | (N'0') | No | | ANSTA | Allow NULL? |
| 4 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 5 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 6 | CKODE | Pay/Abs. Modificator for "Karenz"-day(s) | char | 1 | 0 | CHAR | (N' ') | Yes | | CKODE | Allow NULL? |
| 7 | CARMA | Maximum days for "Karenz" | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CARMA | Allow NULL? |
| 8 | CARTI | Number "Karenz"-days (consealment) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CARTI | Allow NULL? |
| 9 | BEGZK | Absence type beginning sick leave | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T554T | BEGZK | Allow NULL? |
| 10 | ENDZK | Absence type end sickness | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T554T | ENDZK | Allow NULL? |
| 11 | BEGAO | Absence type beginning labour accident | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T554T | BEGAO | Allow NULL? |
| 12 | ENDAO | Absence type end work accident | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T554T | ENDAO | Allow NULL? |
| 13 | DAYSH | Maximum days in case of repeated sickness | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | DAYSH | Allow NULL? |
| 14 | NOPAY | Absence type not payed but booked | char | 1 | 0 | CHAR | (N' ') | Yes | | NOPAY | Allow NULL? |
