SAP table EZWG (Register Group)

SAP table EZWG has 3 primary key fields being MANDT,ZWGRUPPE,ZWNUMMER.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
ZWGRUPPE Register Group CHAR 8 0 E_ZWGRUPPE
ZWNUMMER Register NUMC 3 0 E_ZWNUMMER
LOESCHVM Deletion Indicator CHAR 1 0 LOEVM
BEGRU Authorization Group CHAR 4 0 BEGRU
SPARTYP Division category for device management NUMC 2 0 SPARTYP_G1
01 Electricity
02 Gas
03 Water
04 Waste water
05 District heating
06 Waste management
99 Others
ZWART Register type CHAR 2 0 TE523 E_ZWART
BLIWIRK Reactive, apparent, or active registers NUMC 2 0 BLIWIRK
01 Reactive register
02 Active register
03 Apparent current register
ZWTYP Register category NUMC 2 0 E_ZWTYP
01 Cumulating demand meter
02 Balancing demand meter
03 Resetting register
04 Balancing consumption register
05 Cumulating consumption register
06 Other register
STANZVOR Places before the decimal point in a register NUMC 2 0 STANZVOR
STANZNAC Places after the decimal in a register NUMC 2 0 STANZNAC
ZWFAKT Register factor DEC 12 5 E_ZWFAKT
MASSREAD Unit of measurement for meter reading UNIT 3 0 T006 E_MASSREAD
THGBER Inclusion of factors in thermal gas billing CHAR 2 0 THGBER
00 Register includes no thermal gas factors
01 Register includes temperature
02 Register includes temperature and pressure
03 Register includes temperature, pressure and compressibility
ZWKENN Register identification CHAR 2 0 TE065 E_ZWKENN
UEBERVER Transformation ratio DEC 10 3 UEBERVER
ZSPANNP Register factor: primary transformer voltage DEC 6 0 E_ZSPANNP
ZSPANNS Register factor: secondary transformer voltage DEC 4 1 E_ZSPANNS
ZSTROMP Register factor: primary transformer current DEC 5 1 E_ZSTROMP
ZSTROMS Register factor: secondary transformer current DEC 5 2 E_ZSTROMS
ANZERG Number of meter reading results per meter reading DEC 2 0 ANZERG
ZWNABR Register not relevant to billing CHAR 1 0 E_ZWNABR
ANZART Register display type CHAR 2 0 TE059 ANZART
KENNZIFF Code for Identifying a Register CHAR 15 0 KENNZIFF
SUCHBEG Matchcode search term for register group CHAR 8 0 TE525 SUCHBEGZ
ZWINFO Free entry field for register CHAR 25 0 E_ZWINFO
KZMESSW Nonmetering register CHAR 1 0 KZMESSW
STEUERGRP Control group for multiple meter reading order creation CHAR 4 0 TE629 STEUERGRP
KZDEFAULT Propose register during installation/replacement CHAR 1 0 KZ_DEFAULT_ZW
PRUEFKL Validation class for independent validations CHAR 4 0 PRUEFKL
NABLESEN Do Not Read Register CHAR 1 0 E_NABLESEN
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
MASSBILL Unit of measurement for billing UNIT 3 0 E_MASSBILL
GEWKEY Weighting key CHAR 8 0 TE266 GEWKEY
INTSIZEID Interval Length ID CHAR 4 0 INTSIZEID
TOUPERIOD Time-of-use type CHAR 10 0 E_TOUPERIOD
VEE_CODE External VEE Code NUMC 4 0 E_AMI_VEE_CODE

EZWG foreign key relationships

Table Field Check Table Check Field
0 EZWG ANZART TE059 Register Display Types MANDT
0 EZWG ANZART TE059 Register Display Types ANZART
1 EZWG GEWKEY TE266 User-Defined Weighting Keys MANDT
0 EZWG MANDT T000 Clients MANDT
1 EZWG MASSREAD T006 Units of Measurement MANDT
1 EZWG MASSREAD T006 Units of Measurement MSEHI
0 EZWG STEUERGRP TE629 Control of Variable Scheduled Meter Reading Dates MANDT
0 EZWG STEUERGRP TE629 Control of Variable Scheduled Meter Reading Dates STEUERGRP
1 EZWG SUCHBEG TE525 Search Term for Register Grp MANDT
1 EZWG SUCHBEG TE525 Search Term for Register Grp SPARTYP
0 EZWG ZWART TE523 Register Types MANDT
0 EZWG ZWART TE523 Register Types ZWART
1 EZWG ZWKENN TE065 Register Identif. MANDT
1 EZWG ZWKENN TE065 Register Identif. SPARTYP