SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Consumer category-wise consumption report

Former Member

‎06-22-2008 11:36 AM

0 Kudos

Hi all,

Please guide me in getting consumer category-wise consumption report.

There are 10 categories of consumers. I want to generate consumption report for these consumers.

Thanks and Regds.,

Vijay

1 REPLY 1

Former Member

‎06-23-2008 2:09 PM

0 Kudos

Hi,

Not sure i followed your question completely..

lets say that customers are classified as 'Residential' - RES

and 'Commercial' - COM.

For these customers.. there will be Contract Accounts and contracts and installations associated to it.

In the installation check the field 'Billing Class' , so based on the type whether 'RES' or 'COM' you need to hit the table ERDK to fetch the invoices for the corresponding Contract Account and

check again the tables DBERCHZ1 to extract the consumption by passing the same invoice number(in sap the 'Print document' number -field ERDK-OPBEL).

Based on the category selected by the user on the selection-screen either RES or COM. you can display in output report

Hope it helps.

Regards

Vinay