| 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 | PRUEFGR | Validation group for dependent validations | nvarchar | 4 | 0 | CHAR | (N' ') | No | TE413 | PRUEFGR | Allow NULL? |
| 3 | POPCODE | Dependent validation | nvarchar | 2 | 0 | CHAR | (N' ') | No | TE625 | POPCODE | Allow NULL? |
| 4 | FEHLKLAS | Error class for validations | char | 1 | 0 | CHAR | (N' ') | Yes | | FEHLKLAS | Allow NULL? |
| 5 | COSPHIFEST | Fixed value for dependent cosine phi validation (energy) | decimal | 4 | 3 | DEC | ((0)) | Yes | | COSPHIFEST | |
| 6 | PROZCOS | Maximum deviation from cosine phi in percent | decimal | 3 | 1 | DEC | ((0)) | Yes | | PROZCOS | |
| 7 | MAXRELABW | Maximum relative deviation of consumption ratio | decimal | 3 | 1 | DEC | ((0)) | Yes | | MAXRELABW | |
| 8 | MAXABWHA | Maximum deviation of primary meter from secondary meter | decimal | 3 | 1 | DEC | ((0)) | Yes | | MAXABWHA | |
| 9 | MAXABWKO | Deviation of Clearing and Control Meters | decimal | 3 | 1 | DEC | ((0)) | Yes | | MAXABWKO | |
| 10 | ABWNAKST | Deviating decimal places | char | 1 | 0 | NUMC | (N'0') | Yes | | ABWNAKST | Allow NULL? |
| 11 | REGRATIO | Fixed value for consumption ratio | decimal | 3 | 1 | DEC | ((0)) | Yes | | MAXABWFIX | |
| 12 | NPERIVGL_COSPHI | Number of comparison periods (cosine phi validation) | char | 1 | 0 | NUMC | (N'0') | Yes | | NPERIVGL_COSPHI | Allow NULL? |
| 13 | NPERIVGL_VERBVER | Number of comparison periods (consumption ratio) | char | 1 | 0 | NUMC | (N'0') | Yes | | NPERIVGL_VERBVER | Allow NULL? |