07-31-2010 1:03 PM
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
08-02-2010 1:27 AM
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
08-02-2010 1:27 AM
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
08-02-2010 9:13 AM
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
08-02-2010 6:08 PM
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.
08-04-2010 2:40 PM
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
08-05-2010 3:25 AM
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.