Prices for installation

[former_member608976]

HI,

I am trying to get logic to fetch all historical prices applied for a installation. Also, link prices which are applied at register level.

Can anyone give me steps to do that?

Thanks,

Anjana Rao

[former_member608976]

Thanks, Why cant i accept your answer.

[srinivasankh · Accepted solution]

Hi Anjana,

You get those details from the Billing Documents linked to that Installations (from Contract).

Firstly, you need to gather all the Line Item Types for that Prices so that I will be easier to fetch those lines related to Prices.

Tables involved:

EVER (Contract and Installation)

ERCH (Billing Document)

DBERCHZ1 joining DBERCHZ3 (Billing Line Items table) - this should give all the historical prices applied.

Hope you can get the required details from the above. Let me know if you need any more details than this.

Thanks,

Srini

[TammyPowlas]

In my system, table ETTIFN (installation facts) stores this information.

[former_member608976]

Thanks for your response but that will give me just the installation facts.

Basically i am trying to get all prices that could have been applied for an installation historically, prices that might be deduced from rate category / rate / operands.

Cheers,

Anjana Rao