IS-U estimation

[former_member294762]

Hello all, for estimation purposesI have base period set as "Previous period" in installation.

However, the business now requires that estimation be based on an average of previous 6 months readings.

Can i get some guidance as to implement same?

[srinivasankh · Accepted solution]

Hi Vikram,

In SAP IS-U, there are many user-exits provided by SAP. You can try using any of those.

One of them is as follows:

Try enhacing the SAP Enhancement 'EDMLELHR', where in the changing parameter of the Function Module 'EXIT_SAPLELHR_001' is be used to chage the period length.

changing

xy_minproz = x_minproz

xy_periodel = periodel

where 'periodel' is used to fix the length of the meter reading result history in your case it is 6 months from the last meter reading result. This is in relation to period length maintained at PORTION level. You can override in this user-exit.

and 'x_minproz' is used to specify the minimum lenght of history to be considered for extrapolation. Normally this n\minimum pertion is configured at RATE level, you can override in this user-exit.

Few other user-exits which you can try are:

EDMLELHA

EDMLELHP... etc..

Hope this helps you to dig in further...

Regards,

Srini

[former_member294762]

Hi Srini,

Thanks for your reply.

I've tried all the user exits for the SAP enhancements :EDMLELHA

EDMLELHP

EDMLELHR

However, i cant find the one that changes the parameters u mentioned:

changing

xy_minproz = x_minproz

xy_periodel = periodel

I'm attaching the specs of the 'EXIT_SAPLELHR_001' function

FUNCTION EXIT_SAPLELHR_001.

*"----

---

""Lokale Schnittstelle:

*" IMPORTING

*" VALUE(X_EQUNR) LIKE EABL-EQUNR OPTIONAL

*" VALUE(X_ZWNUMMER) LIKE EABL-ZWNUMMER OPTIONAL

*" VALUE(X_GERAET) LIKE V_EGER-GERAET OPTIONAL

*" VALUE(X_ADATSOLL) LIKE EABL-ADATSOLL

*" VALUE(X_STANZVOR) LIKE EABL-STANZVOR OPTIONAL

*" VALUE(X_STANZNAC) LIKE EABL-STANZNAC OPTIONAL

*" VALUE(X_ABLBELNR) LIKE EABL-ABLBELNR OPTIONAL

*" VALUE(X_IGN_INCORR_MR) LIKE REGEN-KENNZX OPTIONAL

*" VALUE(X_ANLAGE) LIKE EANL-ANLAGE OPTIONAL

*" VALUE(X_ZWTYP) LIKE ETDZ-ZWTYP OPTIONAL

*" VALUE(X_LOGIKZW) LIKE ETDZ-LOGIKZW OPTIONAL

*" VALUE(X_IF) TYPE ISU17_INTERFACE_STRUCTURES OPTIONAL

*" VALUE(X_INST_FOR_BILLING) TYPE ISU2A_INST_STRUC OPTIONAL

*" VALUE(X_GEWKEY) LIKE TE266-GEWKEY OPTIONAL

*" EXPORTING

*" VALUE(Y_ZWSTERW) LIKE EABLH-I_ZWSTERW

*" VALUE(Y_VERBERW) LIKE EABLH-I_VERBERW

*" VALUE(Y_EXTRAPOLATION_BY_CUSTOMER) LIKE REGEN-KENNZX

*" TABLES

*" TX_EABL STRUCTURE EABL OPTIONAL

*" TX_EABLG STRUCTURE EABLG OPTIONAL

*" EXCEPTIONS

*" GENERAL_FAULT

[srinivasankh]

Vikram,

I am surpriced to see that, I am working on ECC 6 and I am sure that in 4.7 also it is there. Check what version you are working on.

FM: EXIT_SAPLELHR_001

Check whether there is a custom enhacement already implemented through CMOD.

Pelase find the FM parameters from my SAP IS-U ECC 6:

""Lokale Schnittstelle:

*" IMPORTING

*" VALUE(X_EQUNR) LIKE EABL-EQUNR OPTIONAL

*" VALUE(X_ZWNUMMER) LIKE EABL-ZWNUMMER OPTIONAL

*" VALUE(X_GERAET) LIKE V_EGER-GERAET OPTIONAL

*" VALUE(X_ADATSOLL) LIKE EABL-ADATSOLL

*" VALUE(X_STANZVOR) LIKE EABL-STANZVOR OPTIONAL

*" VALUE(X_STANZNAC) LIKE EABL-STANZNAC OPTIONAL

*" VALUE(X_ABLBELNR) LIKE EABL-ABLBELNR OPTIONAL

*" VALUE(X_IGN_INCORR_MR) LIKE REGEN-KENNZX OPTIONAL

*" VALUE(X_ANLAGE) LIKE EANL-ANLAGE OPTIONAL

*" VALUE(X_ZWTYP) LIKE ETDZ-ZWTYP OPTIONAL

*" VALUE(X_LOGIKZW) LIKE ETDZ-LOGIKZW OPTIONAL

*" VALUE(X_IF) TYPE ISU17_INTERFACE_STRUCTURES OPTIONAL

*" VALUE(X_INST_FOR_BILLING) TYPE ISU2A_INST_STRUC OPTIONAL

*" VALUE(X_HERKUNFT) LIKE REGEN-KENNZX OPTIONAL

*" VALUE(X_GEWKEY) LIKE TE266-GEWKEY OPTIONAL

*" VALUE(X_SPARTYP) LIKE ETDZ-SPARTYP OPTIONAL

*" VALUE(X_TEMP_AREA) LIKE V_EANL-TEMP_AREA OPTIONAL

*" VALUE(X_ABLESGR) LIKE EABLG-ABLESGR OPTIONAL

*" VALUE(X_EANL) LIKE V_EANL STRUCTURE V_EANL OPTIONAL

*" VALUE(X_EVER) LIKE EVER STRUCTURE EVER OPTIONAL

*" VALUE(X_BILA) LIKE REGEN-KENNZX DEFAULT SPACE

*" VALUE(X_SIM) LIKE REGEN-KENNZX DEFAULT SPACE

*" VALUE(X_DISCONNECTED) LIKE REGEN-KENNZX DEFAULT SPACE

*" EXPORTING

*" VALUE(Y_ZWSTERW) LIKE EABLH-I_ZWSTERW

*" VALUE(Y_VERBERW) LIKE EABLH-I_VERBERW

*" VALUE(Y_EXTRAPOLATION_BY_CUSTOMER) LIKE REGEN-KENNZX

*" TABLES

*" TX_EABL STRUCTURE EABL OPTIONAL

*" TX_EABLG STRUCTURE EABLG OPTIONAL

*" TX_VACTAB STRUCTURE VACSTRUC OPTIONAL

*" TX_EDISCOBJ STRUCTURE V_EDISCOBJ OPTIONAL

*" CHANGING

*" VALUE(XY_MINPROZ) LIKE ETRF-MINPROZ OPTIONAL

*" VALUE(XY_PERIODEL) LIKE REGEN-MAXCOUNT OPTIONAL

*" EXCEPTIONS

*" GENERAL_FAULT

*"----

---

Regards,

Srini

[former_member294762]

Hello. Thanks again for your reply.

Sorry for not having pointed out earlier. I'm indeed on version 4.7.

and the spec for the FM are as ive attached.

There are no custom SAP enhancement implemented.

The EXIT_SAPLELHR_001 FM exports the foll :-

*" EXPORTING

*" VALUE(Y_ZWSTERW) LIKE EABLH-I_ZWSTERW

*" VALUE(Y_VERBERW) LIKE EABLH-I_VERBERW

*" VALUE(Y_EXTRAPOLATION_BY_CUSTOMER) LIKE REGEN-KENNZX

Shoud i code to change these?

[srinivasankh]

Vikram,

Please check in the 'Changing' parameter of the FM 'EXIT_SAPLELHR_001'.

I am sure I have seen this changing parameter in version 4.7 also.

Thanks,

Srini

[former_member294762]

Hello Srini,

As I've said, there are no changing parameters for this function. I'm copying it again as from my PROD envt :-

FUNCTION EXIT_SAPLELHR_001.

*"----

---

""Lokale Schnittstelle:

*" IMPORTING

*" VALUE(X_EQUNR) LIKE EABL-EQUNR OPTIONAL

*" VALUE(X_ZWNUMMER) LIKE EABL-ZWNUMMER OPTIONAL

*" VALUE(X_GERAET) LIKE V_EGER-GERAET OPTIONAL

*" VALUE(X_ADATSOLL) LIKE EABL-ADATSOLL

*" VALUE(X_STANZVOR) LIKE EABL-STANZVOR OPTIONAL

*" VALUE(X_STANZNAC) LIKE EABL-STANZNAC OPTIONAL

*" VALUE(X_ABLBELNR) LIKE EABL-ABLBELNR OPTIONAL

*" VALUE(X_IGN_INCORR_MR) LIKE REGEN-KENNZX OPTIONAL

*" VALUE(X_ANLAGE) LIKE EANL-ANLAGE OPTIONAL

*" VALUE(X_ZWTYP) LIKE ETDZ-ZWTYP OPTIONAL

*" VALUE(X_LOGIKZW) LIKE ETDZ-LOGIKZW OPTIONAL

*" VALUE(X_IF) TYPE ISU17_INTERFACE_STRUCTURES OPTIONAL

*" VALUE(X_INST_FOR_BILLING) TYPE ISU2A_INST_STRUC OPTIONAL

*" VALUE(X_GEWKEY) LIKE TE266-GEWKEY OPTIONAL

*" EXPORTING

*" VALUE(Y_ZWSTERW) LIKE EABLH-I_ZWSTERW

*" VALUE(Y_VERBERW) LIKE EABLH-I_VERBERW

*" VALUE(Y_EXTRAPOLATION_BY_CUSTOMER) LIKE REGEN-KENNZX

*" TABLES

*" TX_EABL STRUCTURE EABL OPTIONAL

*" TX_EABLG STRUCTURE EABLG OPTIONAL

*" EXCEPTIONS

*" GENERAL_FAULT

*"----

---

INCLUDE ZXELXU02 .

ENDFUNCTION.

May be the function version has changed in ECC 6.0 but apparently not in my installation of 4.7

Please advise.

[srinivasankh]

Hi Vikram,

Sorry for this late reply, I was stuck in my work.

Since you are telling that there are no 'Changing' parameters (I could not find out how?!!), you can still make use of the same user-exit using the export parameter.

*" EXPORTING

*" VALUE(Y_ZWSTERW) LIKE EABLH-I_ZWSTERW

*" VALUE(Y_VERBERW) LIKE EABLH-I_VERBERW

*" VALUE(Y_EXTRAPOLATION_BY_CUSTOMER) LIKE REGEN-KENNZX

Logic to populate the above fields in user-exit 'EXIT_SAPLELHR_001':

Make the field 'Y_EXTRAPOLATION_BY_CUSTOMER' = 'X' to override any of the SAP estimation.

For the current Installation, read the Meter Reading Results for last 6 months (depends on you whether to consider estimate reads also or only actual reads), then find the average as per your requirement.

Get the consumption value for the extrapolation period (say X).

Populate the field Y_VERBERW with above 'X'.

Then based on this identified consumption 'X', determine the Meter Reading (this depends on other DM settings like format of the read, decimals...etc.) and populate the field 'Y_ZWSTERW'.

P.S: You have to some experiements to get the format of your Meter Reading. Following factors you need to know:

1) Register category (E_ZWTYP)

2) Format of Meter Reading

3) Whether to override Periodic Consumption value or not!

4) ...etc.

My suggestion is to debug the standard code to get the details of how SAP is handling those.

Hope this helps you...

Thanks,

Srinivasan