| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | SPMON | Period to analyze - month | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | SPTAG | Period to analyze - current date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | SPWOC | Period to analyze - week | nvarchar | 6 | 0 | | | | Allow NULL? |
| 7 | SPBUP | Period to analyze - posting period | nvarchar | 6 | 0 | | | | Allow NULL? |
| 8 | QMNUM | Notification No | nvarchar | 12 | 0 | | | | Allow NULL? |
| 9 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | EHTAG | Lead Time Unit (Day) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | ZHLMELD | No. of Notifications | int | 10 | 0 | | | | Allow NULL? |
| 13 | ZHLMOFN | No. of Notifications with Status Outstanding | int | 10 | 0 | | | | Allow NULL? |
| 14 | ZHLERL_TE | Number of Notifications Completed on Schedule | int | 10 | 0 | | | | Allow NULL? |
| 15 | SUMDLZT | Total Lead Time of Notifications | float | 15 | 16 | | | | |
| 16 | ZHLMASS | No. of Tasks | int | 10 | 0 | | | | Allow NULL? |
| 17 | ZHLMAOF | Number of Tasks with Status 'Outstanding' or 'Released' | int | 10 | 0 | | | | Allow NULL? |
| 18 | ZHLMERF | No. of Tasks with Status Successful | int | 10 | 0 | | | | Allow NULL? |