| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDANT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | CTYP | Certificate Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | TQ05 | QZGTYP | Allow NULL? |
| 3 | VORLNR | Certificate Profile Number | nvarchar | 12 | 0 | CHAR | (N' ') | No | QCVK | QVORLNR | Allow NULL? |
| 4 | VERSION | Version Number of Certificate Profile | nvarchar | 6 | 0 | CHAR | (N' ') | No | | QCVERSION | Allow NULL? |
| 5 | BLOCKNR | Number of Characteristic Block | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | QBLOCKNR | Allow NULL? |
| 6 | MERKMALNR | Consecutive Characteristic Number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | QMKNR | Allow NULL? |
| 7 | SORTNR | Sort Number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | QSORTNR | Allow NULL? |
| 8 | TEXT_ELEM | Assignment of a Characteristic to a Form Text Element | nvarchar | 4 | 0 | CHAR | (N' ') | No | | QCTEXTELEM | Allow NULL? |
| 9 | KATEGORIE | Characteristic Category for Certificates | char | 1 | 0 | CHAR | (N' ') | No | | QCCHARCAT | Allow NULL? |
| 10 | ZAEHLER | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | WERKS_D | Allow NULL? |
| 11 | MKMNR | Master Inspection Characteristics | nvarchar | 8 | 0 | CHAR | (N' ') | No | QPMK | QMERKNR | Allow NULL? |
| 12 | VERSIONMK | Version Number of the Master Inspection Characteristic | nvarchar | 6 | 0 | CHAR | (N' ') | No | | QVERSNRMK | Allow NULL? |
| 13 | CMERKMALID | Internal characteristic | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | * | ATINN | Allow NULL? |
| 14 | KZHERKWERT | Origin of the Characteristic Result on the Certificate | nvarchar | 2 | 0 | CHAR | (N' ') | No | TQ61 | QKZHERKWT | Allow NULL? |
| 15 | KZHERKTEXT | Origin of Characteristic Short Text | nvarchar | 2 | 0 | CHAR | (N' ') | No | TQ64 | QKZHERKTXT | Allow NULL? |
| 16 | KZAUSGFMT | Characteristic Output Format | nvarchar | 2 | 0 | CHAR | (N' ') | No | | QKZAUSGFMT | Allow NULL? |
| 17 | KZMETHODE | Output Inspection Method | nvarchar | 2 | 0 | CHAR | (N' ') | No | | QKZMETHODE | Allow NULL? |
| 18 | KZESEL | Level for Result Selection | char | 1 | 0 | CHAR | (N' ') | No | | QKZESEL | Allow NULL? |
| 19 | KZHERKVG | Origin of Inspection Specifications | nvarchar | 2 | 0 | CHAR | (N' ') | No | TQ63 | QKZHERKVG | Allow NULL? |
| 20 | KZSTRSKIP | Output Strategy for Skip Characteristics | nvarchar | 2 | 0 | CHAR | (N' ') | No | TQ62 | QKZSTRSKIP | Allow NULL? |
| 21 | MASSEINHSW | Unit of Measurement, in Which Quantitative Data Is Stored | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | QMASSEH | Allow NULL? |
| 22 | AUSGLEN | Output Length | tinyint | 3 | 0 | INT1 | ((0)) | No | | QLAENGE | |
| 23 | STELLEN | Number of Places to the Right of a Decimal Point (Accuracy) | tinyint | 3 | 0 | INT1 | ((0)) | No | | QSTELLEN | |
| 24 | KZEXPDS | Indicator: Exponential Notation | char | 1 | 0 | CHAR | (N' ') | No | | QKZEXPDS | Allow NULL? |
| 25 | KZOFFSPTX | Additional Text When Result Is Outside Specifications | char | 1 | 0 | CHAR | (N' ') | No | | QKZOFFSPTX | Allow NULL? |
| 26 | KZOBL | Indicator: Characteristic Required | char | 1 | 0 | CHAR | (N' ') | No | | QKZMKOBL | Allow NULL? |
| 27 | VMSORTNR | Sort Number in List of Materials for Certificate Profile | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | QCSORTNR | Allow NULL? |
| 28 | COLUMNSORT | Display by Columns | char | 1 | 0 | CHAR | (N' ') | Yes | | QCCOLSORT | Allow NULL? |
| 29 | COLUMNS | Number of Columns | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | QCCOLUMNS | Allow NULL? |
| 30 | UNITNRSORT | Sort by Term for Inspected Unit | char | 1 | 0 | CHAR | (N' ') | Yes | | QCUNITSORT | Allow NULL? |
| 31 | CHARACT_ID1 | Characteristic Description for Quality Data Exchange | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | QCHARACT_ID1 | Allow NULL? |
