| 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 | * | 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 | PRUEFLOS | Inspection Lot Number | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | * | QPLOS | Allow NULL? |
| 9 | STAT27 | Inspection Lot is an R/2 Inspection Lot | char | 1 | 0 | CHAR | (N' ') | No | | QSTAT27 | Allow NULL? |
| 10 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERIV | Allow NULL? |
| 11 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VWDAT | Allow NULL? |
| 12 | BASME_QM | Base Unit of Measure for The Inspection Lot Quantity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | QLOSMENGEH | Allow NULL? |
| 13 | PROME | Base Unit of Measure for the Sample Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | QPROBEMGEH | Allow NULL? |
| 14 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 15 | WERK | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 16 | LIFNR | Vendor Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | ELIFN | Allow NULL? |
| 17 | HERSTELLER | Number of Manufacturer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | QLIFNR | Allow NULL? |
| 18 | KUNNR | Account Number of Customer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | EKUNN | Allow NULL? |
| 19 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T024E | EKORG | Allow NULL? |
| 20 | ART | Inspection Type | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TQ30 | QPART | Allow NULL? |
| 21 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | QHERK | Allow NULL? |
| 22 | LOSMENGE | Inspection Lot Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QLOSMENGE | |
| 23 | LMENGEIST | Actual Lot Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QLMENGEIST | |
| 24 | LMENGEPR | Quantity Actually Inspected | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QLMENGEPR | |
| 25 | GESSTICHPR | Sample Size | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QGESTICH | |
| 26 | ERSTELDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | QDATUMERST | Allow NULL? |
| 27 | KZSKIPLOT | Lot Skipped | char | 1 | 0 | CHAR | (N' ') | Yes | | QKZSKIPLOT | Allow NULL? |
| 28 | OFFENNLZMK | Number of Outstanding Short-Term Chars Which Require Conf. | smallint | 5 | 0 | INT2 | ((0)) | Yes | | QOFFENLZMK | |
| 29 | OFFEN_LZMK | Number of Outstanding Long-Term Chars Which Require Conf. | smallint | 5 | 0 | INT2 | ((0)) | Yes | | QOFFELZMK | |
| 30 | ZUSMKZAEHL | Number of Characteristics Recorded Additionally | smallint | 5 | 0 | INT2 | ((0)) | Yes | | QZUSMKZHL | |
| 31 | LMENGE01 | Quantity Posted to Unrestricted-Use Stock | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QLMENGE01F | |
| 32 | LMENGE02 | Quantity Posted to Scrap | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QLMENGE02F | |
| 33 | LMENGE03 | Quantity Posted to Sample | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QLMENGE03F | |
| 34 | LMENGE04 | Quantity Posted to Blocked Stock | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QLMENGE04F | |
| 35 | LMENGE05 | Quantity Posted to Reserves | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QLMENGE05F | |
| 36 | LMENGE06 | Quantity Posted to Another Material | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QLMENGE06F | |
| 37 | LMENGE07 | Quantity Returned to Vendor | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QLMENGE07F | |
| 38 | LMENGE08 | Other Quantity Posted from Inspection Lot Stock | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QLMENGE08F | |
| 39 | LMENGE09 | Other Quantity (2) Posted from Inspection Lot Stock | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QLMENGE09F | |
| 40 | LMENGEZER | Quantity Destroyed During Inspection | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QLMENGEZER | |
| 41 | LMENGEZUB | Quantity That Must Be Posted | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QLMENGEZUB | |
| 42 | LMENGELZ | Sample Quantity for Long-Term Characteristics | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QLMENGELZ | |
| 43 | ANTEIL | Share of Scrap in Inspection Lot | float | 15 | 16 | FLTP | ((0)) | Yes | | QAUSANTEIL | |
| 44 | CHARG | Batch Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CHARG_D | Allow NULL? |
