| 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 | | DEVPROF | Allow NULL? |
| 3 | FLG_PICOMM | Comment messages are deviations | char | 1 | 0 | CHAR | (N' ') | Yes | | FLG_PICOMM | Allow NULL? |
| 4 | FLG_SHDEVI | Dig. signature for deviations in PI sheet is deviation | char | 1 | 0 | CHAR | (N' ') | Yes | | FLG_SHDEVI | Allow NULL? |
| 5 | FLG_DSSHPR | Comment on signat. for process step in PI sheet is deviation | char | 1 | 0 | CHAR | (N' ') | Yes | | FLG_DSSHPR | Allow NULL? |
| 6 | FLG_VERST | Comment on batch record version is deviation | char | 1 | 0 | CHAR | (N' ') | Yes | | FLG_VERST | Allow NULL? |
| 7 | SELID_ORDER | Status selection profile for process orders | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | TJ48 | SELID_ORDER | Allow NULL? |
| 8 | SELID_EBR | Status Selection Profile for Batch Records | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | TJ48 | SELID_EBR | Allow NULL? |
| 9 | DEVPROG | Program for deviation analysis in batch records | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | DEVPROG | Allow NULL? |
| 10 | CHECKFORM | FORM routine for deviation analysis for batch records | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | DEVFORM | Allow NULL? |
| 11 | PRINTFORM | FORM routine for printing deviations for batch record | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | DEVPRINTFORM | Allow NULL? |
| 12 | FORMULAR | Form Name | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TDFORM | Allow NULL? |
| 13 | FLG_AUTO_ARCH | Automatically archive deviations for batch record | char | 1 | 0 | CHAR | (N' ') | Yes | | FLG_AUTO_ARCH | Allow NULL? |
| 14 | FORM_PDF | Name of Form Object | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | FPNAME | Allow NULL? |
