How to change at the same time sales prices for one product and client for multiple dates?

[Former Member]

Hi all,

I have to change retroactively the price of many products in multiple dates. For example:

I have these prices for one product:

Client	Product	Date (From - To)	Price
C98200	3375000	09/02/2015 - 08/03/2015	1000
C98200	3375000	09/03/2015 - 08/04/2015	990
C98200	3375000	09/04/2015 - 08/05/2015	1001
C98200	3375000	09/05/2015 - 31/23/9999	1010

Now I have to change them to:

Client	Product	Date (From - To)	New Price
C98200	3375000	09/02/2015 - 08/03/2015	1001
C98200	3375000	09/03/2015 - 08/04/2015	1001
C98200	3375000	09/04/2015 - 08/05/2015	1010
C98200	3375000	09/05/2015 - 31/23/9999	1000

I can do it using VK12 transaction but I've to do these changes one to one and I've many products.

Can anyone say me how I can change all the prices at the same time? I'm thinking about one transaction where I can see all the prices at the same time and change them.

Regards

[former_member183879 · Accepted solution]

Hi Ruben,

There are 2 questions here.

If you want to see the values for a condition type for different materials, you can get that information directly from the tables. For example if the condition table you have used to maintain condition records is 901 then the values are stored in the table A901. In A901 you should give the condition type and get all the KNUMH. Then pass this KNUMH to KONP table KNUMH value, you will get all the pricing information.

Second question of updating the prices can be done easily by creating an LSMW. There are lot of tutorials on how to create an LSMW. Just a google search should help you on this.

[Former Member · Accepted solution]

Hi Navaneetha,

Thanks for your help. I'll study LSMW possiblities.

Regards

[former_member183879 · Accepted solution]

Thanks. Let us know if u have issues.