| 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 | ZWGRUPPE | Register Group | nvarchar | 8 | 0 | CHAR | (N' ') | No | | E_ZWGRUPPE | Allow NULL? |
| 3 | ZWNUMMER | Register | nvarchar | 3 | 0 | NUMC | (N'000') | No | | E_ZWNUMMER | Allow NULL? |
| 4 | LOESCHVM | Deletion Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEVM | Allow NULL? |
| 5 | BEGRU | Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BEGRU | Allow NULL? |
| 6 | SPARTYP | Division category for device management | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SPARTYP_G1 | Allow NULL? |
| 7 | ZWART | Register type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TE523 | E_ZWART | Allow NULL? |
| 8 | BLIWIRK | Reactive, apparent, or active registers | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | BLIWIRK | Allow NULL? |
| 9 | ZWTYP | Register category | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | E_ZWTYP | Allow NULL? |
| 10 | STANZVOR | Places before the decimal point in a register | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | STANZVOR | Allow NULL? |
| 11 | STANZNAC | Places after the decimal in a register | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | STANZNAC | Allow NULL? |
| 12 | ZWFAKT | Register factor | decimal | 12 | 5 | DEC | ((0)) | Yes | | E_ZWFAKT | |
| 13 | MASSREAD | Unit of measurement for meter reading | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | E_MASSREAD | Allow NULL? |
| 14 | THGBER | Inclusion of factors in thermal gas billing | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | THGBER | Allow NULL? |
| 15 | ZWKENN | Register identification | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TE065 | E_ZWKENN | Allow NULL? |
| 16 | UEBERVER | Transformation ratio | decimal | 10 | 3 | DEC | ((0)) | Yes | | UEBERVER | |
| 17 | ZSPANNP | Register factor: primary transformer voltage | decimal | 6 | 0 | DEC | ((0)) | Yes | | E_ZSPANNP | |
| 18 | ZSPANNS | Register factor: secondary transformer voltage | decimal | 4 | 1 | DEC | ((0)) | Yes | | E_ZSPANNS | |
| 19 | ZSTROMP | Register factor: primary transformer current | decimal | 5 | 1 | DEC | ((0)) | Yes | | E_ZSTROMP | |
| 20 | ZSTROMS | Register factor: secondary transformer current | decimal | 5 | 2 | DEC | ((0)) | Yes | | E_ZSTROMS | |
| 21 | ANZERG | Number of meter reading results per meter reading | decimal | 2 | 0 | DEC | ((0)) | Yes | | ANZERG | |
| 22 | ZWNABR | Register not relevant to billing | char | 1 | 0 | CHAR | (N' ') | Yes | | E_ZWNABR | Allow NULL? |
| 23 | ANZART | Register display type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TE059 | ANZART | Allow NULL? |
| 24 | KENNZIFF | Code for Identifying a Register | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | KENNZIFF | Allow NULL? |
| 25 | SUCHBEG | Matchcode search term for register group | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TE525 | SUCHBEGZ | Allow NULL? |
| 26 | ZWINFO | Free entry field for register | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | E_ZWINFO | Allow NULL? |
| 27 | KZMESSW | Nonmetering register | char | 1 | 0 | CHAR | (N' ') | Yes | | KZMESSW | Allow NULL? |
| 28 | STEUERGRP | Control group for multiple meter reading order creation | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE629 | STEUERGRP | Allow NULL? |
| 29 | KZDEFAULT | Propose register during installation/replacement | char | 1 | 0 | CHAR | (N' ') | Yes | | KZ_DEFAULT_ZW | Allow NULL? |
| 30 | PRUEFKL | Validation class for independent validations | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PRUEFKL | Allow NULL? |
| 31 | NABLESEN | Do Not Read Register | char | 1 | 0 | CHAR | (N' ') | Yes | | E_NABLESEN | Allow NULL? |
| 32 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 33 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 34 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 35 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 36 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | E_MASSBILL | Allow NULL? |
| 37 | GEWKEY | Weighting key | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TE266 | GEWKEY | Allow NULL? |
| 38 | INTSIZEID | Interval Length ID | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | INTSIZEID | Allow NULL? |
| 39 | TOUPERIOD | Time-of-use type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | E_TOUPERIOD | Allow NULL? |
| 40 | VEE_CODE | External VEE Code | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | E_AMI_VEE_CODE | Allow NULL? |
