Question Re: Prices for installation in CRM and CX Q&A

Prices for installation

former_member608976 — Mon, 15 Feb 2021 13:58:13 GMT

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

Re: Prices for installation

TammyPowlas — Mon, 15 Feb 2021 16:00:26 GMT

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

Re: Prices for installation

former_member608976 — Mon, 15 Feb 2021 16:04:52 GMT

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

Re: Prices for installation

srinivasankh — Wed, 10 Mar 2021 14:53:34 GMT

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

Re: Prices for installation

former_member608976 — Wed, 10 Mar 2021 15:47:50 GMT

Thanks, Why cant i accept your answer.