| 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 | MOLGA | Country Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | No | T500L | MOLGA | Allow NULL? |
| 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | NUMC | (N'00') | No | | MOBDE | Allow NULL? |
| 4 | ZTART | Time Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T555A | PT_ZTART | Allow NULL? |
| 5 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 7 | CLTIM | Processing type/time type class | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CLTIM | Allow NULL? |
| 8 | WTYPTE1 | WTE time wage type for actual shifts YTD | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | P44_WTE_WTYPTE1 | Allow NULL? |
| 9 | WTYPTE2 | WTE time wage type for actual quota YTD from TE | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | P44_WTE_WTYPTE2 | Allow NULL? |
| 10 | WTYPPY1 | WTE payroll wage type for posting to FICO | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | P44_WTE_WTYPPY1 | Allow NULL? |
| 11 | WTYPPY2 | WTE dialog wage type for correcting amounts | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | P44_WTE_WTYPPY2 | Allow NULL? |
| 12 | KTART | Attendance or absence quota type | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | KTART | Allow NULL? |
| 13 | MOABW | Personnel subarea grouping for absence and attendance types | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | MOABW | Allow NULL? |
| 14 | FULLABS | WTE absence type for full day absence | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T554S | P44_WTE_AWART1 | Allow NULL? |
| 15 | HALFABS | WTE absence type for half day absence | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T554S | P44_WTE_AWART2 | Allow NULL? |
| 16 | TPKLA | Daily Work Schedule Class | char | 1 | 0 | CHAR | (N' ') | Yes | | TPKLA | Allow NULL? |