| 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 | STICHPRVER | Sampling Procedure | nvarchar | 8 | 0 | CHAR | (N' ') | No | | QSTPRVER | Allow NULL? |
| 3 | STICHPRART | Sampling Type | nvarchar | 3 | 0 | CHAR | (N' ') | No | QDSA | QSTPRART | Allow NULL? |
| 4 | BEWERTMOD | Valuation Mode | nvarchar | 3 | 0 | CHAR | (N' ') | No | QDBM | QBEWMOD | Allow NULL? |
| 5 | KZOHI | No Inspection Stage Change | char | 1 | 0 | CHAR | (N' ') | No | | QKZOHI | Allow NULL? |
| 6 | KZUMFS | Multiple Samples | char | 1 | 0 | CHAR | (N' ') | No | | QKZUMFS | Allow NULL? |
| 7 | KZNOCUT | Sample Size Not Reduced | char | 1 | 0 | CHAR | (N' ') | Yes | | QKZNOCUT | Allow NULL? |
| 8 | STPRANZ | Number of Samples for Multiple Samples | tinyint | 3 | 0 | INT1 | ((0)) | No | | QSTPRANZ | |
| 9 | STPRUMF | Number of Sampling Units in a Sample | int | 10 | 0 | INT4 | ((0)) | No | | QSTPRUMF | Allow NULL? |
| 10 | ANNAHMEZ | Acceptance Number | smallint | 5 | 0 | INT2 | ((0)) | No | | QANNAHMEZ | |
| 11 | KFAKTOR | K-Factor for a Variable Inspection | float | 15 | 16 | FLTP | ((0)) | No | | QKFAKTOR | |
| 12 | KFAKTORNI | Value Not Initial if Set | char | 1 | 0 | CHAR | (N' ') | No | | QNINITIAL | Allow NULL? |
| 13 | KZNVWSV | Sampling Procedure Cannot Be Used | char | 1 | 0 | CHAR | (N' ') | No | | QKZNVWSV | Allow NULL? |
| 14 | KZVWSVPL | Sampling Procedure Is Used in Inspection Plan | char | 1 | 0 | CHAR | (N' ') | No | | QKZVWSVPL | Allow NULL? |
| 15 | FBKEY | Identifier for the Sample Determination Rule | nvarchar | 2 | 0 | CHAR | (N' ') | No | QDFB | QFBKEY | Allow NULL? |
| 16 | FBKEYMFS | Code for Valuation Rule for Independent Multiple sampling | nvarchar | 2 | 0 | CHAR | (N' ') | No | QDFM | QFBKEYMFS | Allow NULL? |
| 17 | STPRPLAN | Sampling Scheme in Sampling Procedure | nvarchar | 3 | 0 | CHAR | (N' ') | No | QDPK | QSTPRPLANV | Allow NULL? |
| 18 | PRSCHAERFE | Inspection Severity in Sampling Procedure | nvarchar | 3 | 0 | NUMC | (N'000') | No | QDEP | QPRSCHAERV | Allow NULL? |
| 19 | AQLWERT | AQL Value in Sampling Procedure | decimal | 7 | 3 | DEC | ((0)) | No | | QAQLWERTV | |
| 20 | PROZUMF | Sample Size as Percentage of Lot Size | float | 15 | 16 | FLTP | ((0)) | No | | QPROZUMF | |
| 21 | PROZUMFNI | Value Not Initial if Set | char | 1 | 0 | CHAR | (N' ') | No | | QNINITIAL | Allow NULL? |
| 22 | PROZAZL | Acceptance Number as Percentage of Sample Size | float | 15 | 16 | FLTP | ((0)) | No | | QPROZAZL | |
| 23 | PROZAZLNI | Value Not Initial if Set | char | 1 | 0 | CHAR | (N' ') | No | | QNINITIAL | Allow NULL? |
| 24 | ERSTELLER | Name of User Who Created the Data Record | nvarchar | 12 | 0 | CHAR | (N' ') | No | | QERSTELLER | Allow NULL? |
| 25 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | CHAR | (N' ') | No | | QAENDERER | Allow NULL? |
| 26 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | QDATUMERST | Allow NULL? |
| 27 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | QDATUMAEND | Allow NULL? |
| 28 | KZRAST | Indicator: Sampling Procedure for Inspection Points | char | 1 | 0 | CHAR | (N' ') | No | | QKZRAST | Allow NULL? |
| 29 | RASTER | Inspection Frequency (Only for Inspection with Insp. Points) | nvarchar | 3 | 0 | NUMC | (N'000') | No | | QRASTER | Allow NULL? |
| 30 | QRKART | Control Chart Type | nvarchar | 3 | 0 | CHAR | (N' ') | No | QPSH | QQRKART | Allow NULL? |
