Sales Order Billing plan change log

[Former Member]

HI Sd Gurus,

Our client has a requirement to develop a report in which they want display change log of billing plan net value, i.e if the sales order item is created in period 01 with the billing plan net value of rs 100/-, report should show 100 and if the value is changed in period 02 to rs.150/- it should show "latest-Initial Value= 150-100=50" in period 02. This value can be changed by any reason in the sales order( change in item price, setting ROR to the item etc..)

We initially developed a logic based on item cumulative condition price but this is not working if the billing plan has more that one line(i.e periodic billing) the total value is divided into periods and cumulative condition contains the value of only one line

Therefore I used value of CMPRE and developed a logic to calculate the net value by using formula( Value of CMPRE/1+taxes). This is working for all scenarios but sometimes CMPRE is not present on few items then this logic is getting failed.

Request any of you to help me to develop a logic to display correct value in all the scenarios, Its kind of emergency please

Regards,

Subash

[sez41 · Accepted solution]

Subash,

What about exploring CDHDR / CDPOS tables? If someone asks a change log for an SD document, those tables would be the first ones I'd take a look at.

[Former Member · Accepted solution]

I already tried them, but billing plan net value is not available there

[sez41 · Accepted solution]

There is a similar thread which seems unsolved: https://scn.sap.com/thread/3377922

To summarize, old billing plan values are not stored in database, per s comments.

[Former Member · Accepted solution]

I think I can use the change log of CMPRE here and convert it by formula, am not familiar with this field, Can anybody give me more details on CMPRE. On what basis this is derived in CDPOS table

[sez41 · Accepted solution]

Subash,

CMPRE is credit value; based on KOMP-CMPRE, assigned as "A" in subtotals field in your pricing procedure.

[moazzam_ali · Accepted solution]

Further to Bilgin's response CMPRE is changed automatically when credit price is changed due to some discount, surcharge or price updating factor. For this you need to check to which step sub total A is assigned.

Thank$