How to find 'price key' based on TOUPeriod and RESULTNO?

[Former Member]

Hi Experts,

I have successfully determined profile value with RTPCOMP, RTPCOMPCODE and RESULTNO per time interval(let's say, 15 minutes).

Based on the RTPCOMP, RTPCOMPCODE, I could determine the 'TOUPERIOD' via table ERTPCOMPCODE

Based on RESULTNO and RTPINTERFACE(already unknown), I could determine the 'Operand Category' OPTYP in ERTPIFACERES.

My question is, how to determine the PRICE KEY?

In table EKDI, I could get PRICE KEY per OPERAND, but how to determine the OPERAND based on the information available? Thanks very much!

Regards,

Wulumuqi road

[Former Member]

hi

As per my understanding

1. From the table ERTPCOMPCODE, when u enter your respected TOU  period you will get your RTP component.
2. Enter that RTP component in  the field ERTPIFACECOMP-RTPCOMP of the table ERTPIFACECOMP. From the table ERTPIFACECOMP you will get the RTP INTERFACE
3. Enter the corresponding RTP interface in the field ETRF-RTPINTERFACE  of the table ETRF
4. Then u will get the corresponding Rate key (field -->ETRF-TARIFNR) from the table ETRF
5. Enter this Rate key in the field EKDI-TARIFNR then in the corresponding operand for price will be shown and Price key will be available in the field EKDI - STRING

If u have any doubts pls be free to revert back at any time

cheers

ROHIT

[Former Member]

Hi Rohit,

Thanks for your reply.

However, I am afraid TARIFNR is NOT good enough.

TARIFNR is per installation, it's rate category if I am not wrong.

In EKDI table, it determines Price key(String1) with TARIFNR and OPERAND, and OPERAND plays an important role. OPERAND is time dependent(peak, offpeak etc), it relates to installation, register but also depends on different time interval(for example, from 3:00 - 4:00 we should use this price, from 4:01 - 7:00 we shall use another price). It is not so easy.....

[Former Member]

hi

  can u please explain your senario  and what do u want exactly ?

Rohit

[Former Member]

Hi Rohit,

1. I get Consumption value per time interval, with RTPComp, RTPCompCode, and RESULTNO per time interval

2. I want to get the price rate for each interval, multiplied with consumption value, and generate a graph - Dollar value per interval.

The price rate changes per interval, depending on peak hour/non-peak hour/weekend/ etc etc. It's the tricky part.

Very appreciate that you could kindly help! Thanks

[Former Member]

hi

price for every interval .. so are u giving a price profile in your RTP interface ????or for each results (qunatity ) for RTP interface are u giving a separate operand for price in your rate step?? which one are u following

Rohit

[Former Member]

Hi Rohit,

Standard SAP determines price key based on day(summer, winter, weekend, weekday, holiday etc), time(peak hour, off-peak hour etc).

I have already determined peak/off-peak per time interval(15 minutes) for each consumption result, but I need to understand how the pricing engine works to determine the price key. Thanks.

[Former Member]

Hi,

I am not sure if you are using RTP or AMI.

But the calculation based on profiles happens during the billing execution/simulation.

Probably it would be best if you can debug the fm for the RTP formula been used in your RTP Interface (in case of RTP) or the TOU formula for your TOU Interface(in case of AMI).

Please check.

Cheers,

Rakesh..

[former_member605412]

1.As per your specification " I get Consumption value per time interval", if by interval you mean "peak hour/non-peak hour/weekend/ etc etc", you must have maintained different operands to store all these consumption values received from your result parameters.

In that case If you want to generate a graph based on the time interval after billing has been executed,You can see the source of each billing document line on tab Internal Billing Data. Here you can see the variant which created the line, Billing schema, internal schema step number, billing schema step, etc so you can trace back the line to the pricing procedure which in IS-U is called billing schema.

Also there are some other informatins on tab price / rate.

2.In case you are using price profile to evaluate consumption per interval ,chk this link

http://scn.sap.com/thread/1947419

3.The price key is the name of a price; the price key is also called "price".The actual values are stored in the prices. Historical price amounts are also managed in the prices.

A price key is assigned to a price operand(peak hour/non-peak hour/weekend/etc) in a rate step.

During billing run, the system checks whether there is any historical value assigned to the price key for the current billing period , if the current billing period falls in any of the historical slabs maintained in the price key. the price key is used for billing, otherwise the system generates an error message.

Regards

Tathagata

[Former Member]

Thanks everyone for your helpful replies!

The interval is time interval, for example, 30 minutes.

For the unbilled consumption, in order to generate its dollar amout per 30 minutes, seems I will have to simulate the bill, get all the price keys, and deternine which is for peak/off-peak depending on the naming convention? Thanks.