The CONSUMPT table in SAP ERP or S/4HANA stores Utilities: Consumption Single-Rate Meter data. There are total 9 fields in CONSUMPT table. The Utilities: Consumption Single-Rate Meter table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CONSUMPT table. It is in Package for Product Set Types of IBU Utilities (Sales) (CRM_PRODUCT_SRV_UTIL) ABAP package and is part of the Utilities Industry: Sales (CRM-IU-S) module.
SAP CONSUMPT Table Fields
Following is the list of fields that are available in SAP CONSUMPT table. The primary key fields of the table are CLIENT (Client), FRG_GUID (Set GUID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| FRG_GUID | Set GUID | COMT_FRG_GUID | RAW (16) | |
| VALID_FROM | Valid From (Time Stamp) | COMT_VALID_FROM | DEC (15) | |
| VALID_TO | Valid To (Time Stamp) | COMT_VALID_TO | DEC (15) | |
| UPNAME | Name of the User Who Last Changed the Set | COMT_UPNAME | CHAR (12) | |
| HISTEX | History Exists | COMT_HISTEX | CHAR (1) | |
| LOGSYS | Original System | COMT_LOGSYS | CHAR (10) | |
| CONSUMPT | Utilities: Annual Consumption | ANNUALCONSUMPTION | NUMC (14) | |
| METERREAD | Utilities: Meter Reading | METERREADING | CHAR (36) |
