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: 

consumption of a month

Former Member
0 Kudos

Hi

How to identify the consumption of a particular month directly from table level .

Gaurav

5 REPLIES 5

Former Member
0 Kudos

Hi Gaurav,

you won't get it out of a specific table easily, because usually the ISU stores:

  • either reading results for a certain time period (can be e.g. January 5th - February 4th), but not the consumption value

  • consumption in the billing document for a certain time period (can be the similar to the meter reading period above), but not by month

  • or if defined in billing schema, it is stored as consumption in the consumption history (table DBERCHV) for a certain period (is similar to the billing period).

==> Conclusion. There is no special table where you can get the consumption by month.

However, using sales statistic in BW you can get the required information, because the sales statistic takes the existing billing documents and split the billing lines into monthly prorated pieces according to the weighting procedure and further on extracts it to BW.

Hope that helped.

Axel

0 Kudos

Can u bit elaborate the BW part i m into BW 3.5, is there any other way to extract it.

Whatu2019s the exact IS-U way to calculate it in which it's more exact to the Consumption in EL29?

From where in the consumption comes in at EL29, canu2019t it be stored some where or with say some key i can find out or extract.

Thanks for ur consideration.

0 Kudos

Hi,

is the ISU sales statistic content in BW activated? If so, the monthly consumption is available using the AB-date (0CALMONTH) as selection. This content is available in BW3.5 already.

EL29 does a kind of billing in the background. Means, the meter reading result is taken and transferred into a billing function module and then calculates the difference. In case of electricity and water, the consumption is just the difference between the 2 readings. However in case of gaz, it has to take thermal factors into account also.

So, the consumption you see in EL29 is not stored somewhere, it is shown during runtime only.

The sales statistic is usually similar to EL29, but it splits the consumption into months (that is not done in EL29 by the way), using similar rules as EL29 but it takes weighting factor (e.g. degree weighting) into account.

What is the process you need the EL29 consumption for?

Axel

0 Kudos

Very thanks,

I wanna go by the EL29 way, can you bit elaborate on the EL29 way, the functional way, the function module which is used to calculate the consumption, as well as different scenarios like what the consumption is: when the meter got change in one ADAT month, where the meter installed for the first time, where there's twice meter reading in 1 ADAT month.

Thanks a lot for your consideration, looking forward to ur valuable suggestion

0 Kudos

Basically your consumption is dynamically calculated as the difference between your previous meter reading result and the current meter reading result. EABL stores all your meter reading documents. If you select the documents for which results are entered in the system (you can either go by meter reading document status or actual meter read date in this table), you can calculate the consumption for each period as the difference between this period's meter read and the previous period's meter read.

Please note that I am using the term period, not month as meter reading periods may not be exactly fit into calendar months.

But you should take the route of using standard BW extractors. See some sample function modules below.

ISU_BW_CONSUMPTION_STATISTICS

ISU_BW_CONSUMPTION_INDEX_WRITE

ISU_BW_CONSUMPTION_MASS_R467

ISU_BW_CONSUMPTION_VAR_ADJUST

ISU_BW_CONSUMPTION_VAR_CREATE

ISU_BW_CONSUMPTION_DUMMY

ISU_BW_CONSUMPTION_STATISTICSP

Now if you want billed consumption as opposed to recorded consumption on the meter reading side, you can look into DBERCHV table.