| 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 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 9 | PRPLATZWRK | Plant/Work Center | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKARBPL | Allow NULL? |
| 10 | PRPLATZ | Work Center | nvarchar | 8 | 0 | CHAR | (N' ') | No | | QPRPLATZ | Allow NULL? |
| 11 | WERKSTPRUE | QMIS Plant/Master Inspection Characteristic | nvarchar | 12 | 0 | CHAR | (N' ') | No | | WERKSTPRUE | Allow NULL? |
| 12 | PLGRPLTYP | Combined Field Task List Type/Task List Group | nvarchar | 9 | 0 | CHAR | (N' ') | No | | QPLGRTYP | Allow NULL? |
| 13 | PPLNKN | Number of the task list node | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PLNKN | Allow NULL? |
| 14 | MERKNR | Inspection Characteristic Number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | QMERKNRP | Allow NULL? |
| 15 | WERK | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 16 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERIV | Allow NULL? |
| 17 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VWDAT | Allow NULL? |
| 18 | MASSEINHSW | Unit of Measurement, in Which Quantitative Data Is Stored | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | QMASSEH | Allow NULL? |
| 19 | ZHLN | Number of Inspected and Closed Samples | int | 10 | 0 | INT4 | ((0)) | Yes | | QZHLN | Allow NULL? |
| 20 | ZHLNA | Number of Accepted Samples | int | 10 | 0 | INT4 | ((0)) | Yes | | QZHLNA | Allow NULL? |
| 21 | ZHLNR | Number of Rejected Samples | int | 10 | 0 | INT4 | ((0)) | Yes | | QZHLNR | Allow NULL? |
| 22 | ZHLNF | No. of Defects | int | 10 | 0 | INT4 | ((0)) | Yes | | QZHLNF | Allow NULL? |
| 23 | ZHLNFEH | Number of Nonconforming Units | int | 10 | 0 | INT4 | ((0)) | Yes | | QZHLNFEH | Allow NULL? |
| 24 | ZHLNTOLU | Number of Values Below Lower Tolerance | int | 10 | 0 | INT4 | ((0)) | Yes | | QZHLNTOLU | Allow NULL? |
| 25 | ZHLNTOLO | Number of Values Above Upper Tolerance | int | 10 | 0 | INT4 | ((0)) | Yes | | QZHLNTOLO | Allow NULL? |
| 26 | ZHLNSTPF | Sample Size (No. of Valid Values in Sample) | int | 10 | 0 | INT4 | ((0)) | Yes | | QZHLNSTPF | Allow NULL? |
| 27 | SUMFANT | Total Nonconforming Shares | float | 15 | 16 | FLTP | ((0)) | Yes | | QSUMFANT | |
| 28 | SUMFEHEH | Total of Nonconforming Units | int | 10 | 0 | INT4 | ((0)) | Yes | | QSUMFEHLEH | Allow NULL? |
| 29 | PLNAL | Group Counter | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PLNAL | Allow NULL? |
| 30 | VORNR | QMIS Operation Number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | QMISVORNR | Allow NULL? |
| 31 | ZHLNSTAT | Number of Valid Single Values | int | 10 | 0 | INT4 | ((0)) | Yes | | QZHLNSTAT | Allow NULL? |
| 32 | SUMEW | Total of Valid Single Values | float | 15 | 16 | FLTP | ((0)) | Yes | | QSUMEW | |
| 33 | SUMMW | Total of Mean Values | float | 15 | 16 | FLTP | ((0)) | Yes | | QSUMMW | |
| 34 | SUMVARIN | Total of Single Value Variances | float | 15 | 16 | FLTP | ((0)) | Yes | | QSUMVARIN | |
| 35 | SUMSIGMAST | Total of Sample Dispersions | float | 15 | 16 | FLTP | ((0)) | Yes | | QSUMSIGMASTP | |
| 36 | SUMVAR | Total of Sample Variances | float | 15 | 16 | FLTP | ((0)) | Yes | | QSUMVAR | |
| 37 | TOLUN | Lower Tolerance Limit | float | 15 | 16 | FLTP | ((0)) | Yes | | QTOLUN | |
| 38 | TOLUNNI | Value Not Initial if Set | char | 1 | 0 | CHAR | (N' ') | Yes | | QNINITIAL | Allow NULL? |
| 39 | TOLOB | Upper Specification Limit | float | 15 | 16 | FLTP | ((0)) | Yes | | QTOLOB | |
| 40 | TOLOBNI | Value Not Initial if Set | char | 1 | 0 | CHAR | (N' ') | Yes | | QNINITIAL | Allow NULL? |
| 41 | CP | Process Capability Index (Cp Value) | float | 15 | 16 | FLTP | ((0)) | Yes | | QCP | |
| 42 | CPK | Process Capability Index (Cpk Value) | float | 15 | 16 | FLTP | ((0)) | Yes | | QCPK | |
| 43 | SIGMA | Standard Deviation | float | 15 | 16 | FLTP | ((0)) | Yes | | QMISSTD | |
| 44 | XQUER | Mean Value | float | 15 | 16 | FLTP | ((0)) | Yes | | QMISMITTEL | |
