| 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 | QMNUM | Notification No | nvarchar | 12 | 0 | CHAR | (N' ') | No | QMEL | QMNUM | Allow NULL? |
| 3 | MANUM | Consecutive Number of Activity | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | AKNUM | Allow NULL? |
| 4 | FENUM | Item Number in Item Record | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | QMFE | FELFD | Allow NULL? |
| 5 | URNUM | Sequential Number for Cause | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | URNUM | Allow NULL? |
| 6 | MNKAT | Catalog Type - Activities | char | 1 | 0 | CHAR | (N' ') | Yes | TQ15 | MFKAT | Allow NULL? |
| 7 | MNGRP | Code Group - Activities | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | QPGR | MFGRP | Allow NULL? |
| 8 | MNCOD | Activity Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | MFCOD | Allow NULL? |
| 9 | MNVER | Version Number | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | QVERSNR | Allow NULL? |
| 10 | MATXT | Activity Text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | MFTEXT | Allow NULL? |
| 11 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 12 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 13 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 14 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 15 | MAKLS | Task Class | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | MAKLS | Allow NULL? |
| 16 | KLAKZ | Indicator: Classification exists | char | 1 | 0 | CHAR | (N' ') | Yes | | KLAKZ | Allow NULL? |
| 17 | PSTER | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PSTERMA | Allow NULL? |
| 18 | PETER | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PETERMA | Allow NULL? |
| 19 | INDTX | Object Long Text Available | char | 1 | 0 | CHAR | (N' ') | Yes | | INDLTX | Allow NULL? |
| 20 | KZMLA | Primary language indicator for text segment | char | 1 | 0 | CHAR | (N' ') | Yes | | KZMLA | Allow NULL? |
| 21 | MNGFA | Quantity Factor for Activities | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | MNGFA | Allow NULL? |
| 22 | PSTUR | Start Time of Activity | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PSTURMA | Allow NULL? |
| 23 | PETUR | End Time of Activity | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PETURMA | Allow NULL? |
| 24 | ERZEIT | Time, at Which Record Was Added | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERZEIT | Allow NULL? |
| 25 | AEZEIT | Time of Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AEZEIT | Allow NULL? |
| 26 | KZLOESCH | Delete Data Record | char | 1 | 0 | CHAR | (N' ') | Yes | | KZLOESCH | Allow NULL? |
| 27 | QMANUM | Sort Number for Activity | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | QMANUM | Allow NULL? |
| 28 | AUTKZ | Data Record Created with Function 'Create with Copy Model' | char | 1 | 0 | CHAR | (N' ') | Yes | | QAUTKZ | Allow NULL? |
| 29 | KZACTIONBOX | Created Using Action Box | char | 1 | 0 | CHAR | (N' ') | Yes | | QNKZACTIONBOX | Allow NULL? |
| 30 | FUNKTION | Keys for Function in Action Box | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | QNFUNKTION | Allow NULL? |
