| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | STPRPLAN | Sampling Scheme | nvarchar | 3 | 0 | | | | Allow NULL? |
| 3 | KZATTR | Indicator: Attributive Inspection | char | 1 | 0 | | | | Allow NULL? |
| 4 | KZVARS | Indicator: Variable Inspection According to S-Method | char | 1 | 0 | | | | Allow NULL? |
| 5 | KZOHNEBEWP | Without Valuation Parameters | char | 1 | 0 | | | | Allow NULL? |
| 6 | KZLOS | Indicator: Lot-Based Inspection | char | 1 | 0 | | | | Allow NULL? |
| 7 | KZTAKT | Interval-Related Inspection | char | 1 | 0 | | | | Allow NULL? |
| 8 | KZOHNEP | Indicator: No Parameter at Item Level | char | 1 | 0 | | | | Allow NULL? |
| 9 | KZAQL | Indicator: Use AQL Values | char | 1 | 0 | | | | Allow NULL? |
| 10 | KZNVWPK | Indicator: Sampling Scheme Cannot Be Used | char | 1 | 0 | | | | Allow NULL? |
| 11 | KZVWPKSV | Indicator: Sampling Scheme Is Used in Procedure | char | 1 | 0 | | | | Allow NULL? |
| 12 | ERSTELLER | Name of User Who Created the Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | ZEITERSTL | Time at which data record was created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | ZEITAEND | Time at which data record was last changed | nvarchar | 6 | 0 | | | | Allow NULL? |