| 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 | MOPGK | Employee Subgroup Grouping for Time Quota Types | char | 1 | 0 | CHAR | (N' ') | No | | MOPGK | Allow NULL? |
| 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | NUMC | (N'00') | No | | MOZKO | Allow NULL? |
| 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | NUMC | (N'00') | No | | MOBDE | Allow NULL? |
| 5 | QUOMO | Quota type selection rule group | nvarchar | 2 | 0 | CHAR | (N' ') | No | | QUOMO | Allow NULL? |
| 6 | ACCNR | Selection rule for absence quota types | nvarchar | 3 | 0 | NUMC | (N'000') | No | T559L | ACCNR | Allow NULL? |
| 7 | ENDDT | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 8 | BEGDT | Period start date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PAU_ACBEG | Allow NULL? |
| 9 | KTART | Attendance or absence quota type | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | KTART | Allow NULL? |
| 10 | RULES | Rule for base entitlement for leave accrual | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | RULNO | Allow NULL? |
| 11 | ANBDT | Seniority based on anniversary begin date | char | 1 | 0 | CHAR | (N' ') | Yes | | PAU_ANBDT | Allow NULL? |
| 12 | INCPS | Switch for include or exclude Prior service | char | 1 | 0 | CHAR | (N' ') | Yes | | PAU_INPRI | Allow NULL? |