| 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 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SSOUR | Allow NULL? |
| 3 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | VRSIO | Allow NULL? |
| 4 | SPMON | Period to analyze - month | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPMON | Allow NULL? |
| 5 | SPTAG | Period to analyze - current date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SPTAG | Allow NULL? |
| 6 | SPWOC | Period to analyze - week | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPWOC | Allow NULL? |
| 7 | SPBUP | Period to analyze - posting period | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPBUP | Allow NULL? |
| 8 | LIFNUM | Vendor Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | LFA1 | LIFNUM | Allow NULL? |
| 9 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 10 | QMART | Notification Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | TQ80 | QMART | Allow NULL? |
| 11 | MAWERK | Plant for Material | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | QMAWERKS | Allow NULL? |
| 12 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | PERIV | Allow NULL? |
| 13 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | VWDAT | Allow NULL? |
| 14 | BASME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | No | * | MEINS | Allow NULL? |
| 15 | ZHLMELD | No. of Notifications | int | 10 | 0 | INT4 | ((0)) | No | | QZHLMELD | Allow NULL? |
| 16 | ZHLMOFN | No. of Notifications with Status Outstanding | int | 10 | 0 | INT4 | ((0)) | No | | QZHLMOFN | Allow NULL? |
| 17 | ZHLMIAR | No. of Notifications with Status Being Processed | int | 10 | 0 | INT4 | ((0)) | No | | QZHLMIAR | Allow NULL? |
| 18 | ZHLMMAB | No. of Notifications with Status Completed | int | 10 | 0 | INT4 | ((0)) | No | | QZHLMMAB | Allow NULL? |
| 19 | ZHLMRST | No. of Notifications with Stauts Reset | int | 10 | 0 | INT4 | ((0)) | No | | QZHLMRST | Allow NULL? |
| 20 | ZHLMAOF | Number of Tasks with Status 'Outstanding' or 'Released' | int | 10 | 0 | INT4 | ((0)) | No | | QZHLMAOF | Allow NULL? |
| 21 | ZHLMASS | No. of Tasks | int | 10 | 0 | INT4 | ((0)) | No | | QZHLMASS | Allow NULL? |
| 22 | ZHLMAER | No. of Tasks with Status Completed | int | 10 | 0 | INT4 | ((0)) | No | | QZHLMAER | Allow NULL? |
| 23 | ZHLMERF | No. of Tasks with Status Successful | int | 10 | 0 | INT4 | ((0)) | No | | QZHLMERF | Allow NULL? |
| 24 | SMMGEIG | Total Defective Quantity (Internal) | decimal | 17 | 3 | QUAN | ((0)) | No | | QSMMGEIG | |
| 25 | SMMGFRD | Total Defective Quantity (External) | decimal | 17 | 3 | QUAN | ((0)) | No | | QSMMGFRD | |
| 26 | SMRKMNG | Total Complaint Quantity | decimal | 17 | 3 | QUAN | ((0)) | No | | QSMRKMNG | |
| 27 | SMRGMNG | Total Quantity Returned | decimal | 17 | 3 | QUAN | ((0)) | No | | QSMRGMNG | |
