| 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 | DEVPROF | Deviation profile for batch records | nvarchar | 8 | 0 | CHAR | (N' ') | No | REBR3 | DEVPROF | Allow NULL? |
| 3 | ART | Inspection Type | nvarchar | 8 | 0 | CHAR | (N' ') | No | TQ30 | QPART | Allow NULL? |
| 4 | SELID_LOT | Status selection profile for inspection lots | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | TJ48 | SELID_LOT | Allow NULL? |
| 5 | FLG_EXIST | Missing inspection lot of inspection type is deviation | char | 1 | 0 | CHAR | (N' ') | Yes | | FLG_EXIST | Allow NULL? |
| 6 | FLG_VE | UD with valuation other than "acceptance" is deviation | char | 1 | 0 | CHAR | (N' ') | Yes | | FLG_VE | Allow NULL? |
| 7 | FLG_VE_LT | Long Text on Usage Decision is Deviation | char | 1 | 0 | CHAR | (N' ') | Yes | | FLG_VE_LT | Allow NULL? |
| 8 | FLG_PE | Insp. Result Valuation other than "Acceptance" is Deviation | char | 1 | 0 | CHAR | (N' ') | Yes | | FLG_PE | Allow NULL? |
| 9 | FLG_PE_DS | Comment on Dig. Signature for Inspection Result is Deviation | char | 1 | 0 | CHAR | (N' ') | Yes | | FLG_PE_DS | Allow NULL? |
| 10 | FLG_PE_LT | Long Text for Inspection Result is Deviation | char | 1 | 0 | CHAR | (N' ') | Yes | | FLG_PE_LT | Allow NULL? |
| 11 | FLG_FE_PL | Defects Found for Inspection Lot is Deviation | char | 1 | 0 | CHAR | (N' ') | Yes | | FLG_FE_PL | Allow NULL? |
| 12 | FLG_FE_ME | Defects Found for Inspection Characteristic is Deviation | char | 1 | 0 | CHAR | (N' ') | Yes | | FLG_FE_ME | Allow NULL? |
| 13 | FLG_FE_VG | Defects Found for Operation/Phase is Deviation | char | 1 | 0 | CHAR | (N' ') | Yes | | FLG_FE_VG | Allow NULL? |
