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
Showing results for 
Search instead for 
Did you mean: 

Report on Unbilled Usage

Former Member
0 Kudos

Hello Experts,

I wanted to create a report that will give me the list of Devices that are consuming the utility but are not being billed.

Or the list of devices that should be billed but are not billed.

Can you please help me out.

Thanks and Regards,

Pratap Sone

1 ACCEPTED SOLUTION

AmlanBanerjee
Active Contributor
0 Kudos

Hi Pratap,

You need to create a customise report which would retrieve the following informations-

(a) Contracts with u2018NOT billableu2019 (ETRG-TRIGSTAT=1) billing orders status

(b) Contracts with u2018Billableu2019 status (ETRG-TRIGSTAT=2) in the billing order and outsorted billing document (NOT Released)(ECRH-TOBRELEASD=''X")

(c) Contracts with u2018Billableu2019 status in the billing order and NO billing document

After you get the above informations for a specific period, you can retrieve the Business master data and technical master data for the contracts using FM ISU_GET _OBJECTS and display it in the report.

Hope it helps.......

Thanks,

Amlan

View solution in original post

5 REPLIES 5

AmlanBanerjee
Active Contributor
0 Kudos

Hi Pratap,

You need to create a customise report which would retrieve the following informations-

(a) Contracts with u2018NOT billableu2019 (ETRG-TRIGSTAT=1) billing orders status

(b) Contracts with u2018Billableu2019 status (ETRG-TRIGSTAT=2) in the billing order and outsorted billing document (NOT Released)(ECRH-TOBRELEASD=''X")

(c) Contracts with u2018Billableu2019 status in the billing order and NO billing document

After you get the above informations for a specific period, you can retrieve the Business master data and technical master data for the contracts using FM ISU_GET _OBJECTS and display it in the report.

Hope it helps.......

Thanks,

Amlan

0 Kudos

HI Pratap,

Please find some more options which will be usefull in case of Unbilled cases.

1. Get all the connected devices & Installations from EASTS tableEASTS.BIS=31-12-9999 & EASTS. ZWNABR

not equal to null.

2. Pass the above installations to EVER table and get all the contracts & Move-in dates EVER.AUSZDAT=31-12-9999

3. Pass these contracts to ERCH table and check whether any bill document exist for this contract from the date of

move-in date(ERCH.ERDAT>= move-in date ).

BR,

Rajani

Former Member
0 Kudos

Check out sap query ISU_CONT_NOT_BILLED_IS in SQ02. This query provides the list of unbilled contracts. Probably you will have to enhance this to achieve your requirements.

Former Member
0 Kudos

Hey Pratap,

Couldn't the list of devices that should be billed but are not billed be found via EL31 or EL32 (program RELMADUE)?

Thanks,

Tom

william_eastman
Advisor
Advisor
0 Kudos

Pratap:

Have you investigated the standard Unbilled Revenue transactions - EAMS00 and EAMS01. They are designed to provide data about installations which have not billed. Of course, since those transactions generate simulated billing documents then some billing errors will still cause issues. [Help for unbilled revenue|http://help.sap.com/saphelp_erp60/helpdata/en/5f/196c3509196041e10000009b38f839/frameset.htm] Under Planning, then Unbilled Revenue.

regards,

bill.