| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MOABW | Personnel subarea grouping for absence and attendance types | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | GBART | Type of birth | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | FVMIN | Minimum period before delivery | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | FVMAX | Maximum period before delivery | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | FNMIN | Minimum period after delivery | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | FNMAX | Maximum period after delivery | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | ZEIN1 | Time/Measurement Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | DAUMA | Maximum duration of an absence | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | DAUMI | Minimum duration of an absence | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | ZEIN2 | Time/Measurement Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | GEWHR | Allowance period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | ZEIN3 | Time/Measurement Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | ANTRF | Minimum application period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | ZEIN4 | Time/Measurement Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | GESCH | Gender Key | char | 1 | 0 | | | | Allow NULL? |
| 20 | ENTMR | Include Delivery Date in Calculation | char | 1 | 0 | | | | Allow NULL? |
| 21 | FLAG1 | Indicator if Actual Delivery Date was After Expected Date | char | 1 | 0 | | | | Allow NULL? |
| 22 | FLAG2 | Indicator if actual delivery date is before expected date | char | 1 | 0 | | | | Allow NULL? |
| 23 | REAK1 | Reaction indicator for protection period before delivery | char | 1 | 0 | | | | Allow NULL? |
| 24 | REAK2 | Reaction indicator for protection period after delivery | char | 1 | 0 | | | | Allow NULL? |
| 25 | REAK3 | Reaction indicator if absence duration is incorrect | char | 1 | 0 | | | | Allow NULL? |
| 26 | REAK4 | Reaction indic.for allowance period and application period | char | 1 | 0 | | | | Allow NULL? |
| 27 | ZEIN5 | Time/Measurement Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 28 | AUSW1 | Should period be used for default generation? | char | 1 | 0 | | | | Allow NULL? |
| 29 | AUSW2 | Should period be used for default generation? | char | 1 | 0 | | | | Allow NULL? |
| 30 | AUSW3 | Should period be used for default generation? | char | 1 | 0 | | | | Allow NULL? |
| 31 | AUSW4 | Should period be used for default generation? | char | 1 | 0 | | | | Allow NULL? |
| 32 | SNAME | Symbolic program name | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | VORGN | Previous absence | nvarchar | 4 | 0 | | | | Allow NULL? |
