| 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 | PRUEFKL | Validation class for independent validations | nvarchar | 4 | 0 | CHAR | (N' ') | No | TE408 | PRUEFKL | Allow NULL? |
| 3 | FEHLKLAS | Error class for validations | char | 1 | 0 | CHAR | (N' ') | No | | FEHLKLAS | Allow NULL? |
| 4 | ZWABLBER | Include interim meter readings | char | 1 | 0 | CHAR | (N' ') | Yes | | E_ZWABLBER | Allow NULL? |
| 5 | FESTABW | Deviation fixed value for disconnected installations/devs | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | FESTABW | Allow NULL? |
| 6 | FABW_LST | Deviation fixed value for vacant installations | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | FABW_LST | Allow NULL? |
| 7 | KARNEUBR | Interval days for new calculation of expected quantity | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | KARNEUBR | Allow NULL? |
| 8 | NPERIVGL | Number of comparison periods | char | 1 | 0 | NUMC | (N'0') | Yes | | NPERIVGL | Allow NULL? |
| 9 | NULLVERB | Interval days for zero consumption | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | NULLVERB | Allow NULL? |
| 10 | BENUTZSTD | Usage hours | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TE221 | BENUTZSTD | Allow NULL? |
| 11 | PROZBSTD | Maximum deviation of usage hours in percent | decimal | 3 | 1 | DEC | ((0)) | Yes | | PROZBSTD | |
| 12 | MAXLOPER | Permitted maximum demand | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TE221 | MAXLOPER | Allow NULL? |
| 13 | MINLOPER | Permitted minimum demand | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TE221 | MINLOPER | Allow NULL? |
| 14 | DEACT_VAL96 | Deactivate validation for fixed value deviation | char | 1 | 0 | CHAR | (N' ') | Yes | | DEACT_VAL96 | Allow NULL? |