list sales prices

[Former Member]

Hello,

I need to a list with the sales prices for around 200 materials. I know that the sales prices are entered in VK11. VK13 shows the price for only one material at a time.

I was wondering if there is something like a mass display or maybe a report that shows the sales prices for multiple material numbers?

Thanks

Anne

[Former Member · Accepted solution]

Hi,

The easy way of displaying all the values that are stored in VK11/12 with you knowing the condition type and not knowing other parameteres is

a. GO to VK13

b. Enter the condition type and click on 'Condition Information' button.

c. Blank out all the details in all the fields and then execute.

It will give you all the condition records that are maintained for a particular condition type.

Now, if you want to filter it for certain materials, you can follow step a and b. In step c, put all the materail numbers (your 200 materails for which you want check the price) in the materail number field and then execute.

You should get a number of tables in which the values are stored.

Also, you can check in VK33 transaction.

V/LD is another good way of checking the price of the material

Hope this helps...

Thanks

Mukund S

Edited by: MukundHS on Jul 28, 2010 5:36 PM

[Former Member · Accepted solution]

Hi MukundHS,

I tried the first way, you suggested. I used VK13 and it gave me a list with all the materials as result. But the list only has the columns: Sales Org, Distribution Channel, Customer, Material, Valid on, Valid to.

It has no price. I have to display each line individually to see the price.

It would be just perfect, if that list would have an additional column that shows the price for each line. Is that somehow possible?

Thanks

Anne

[Former Member · Accepted solution]

Hi again,

I got the list I needed with transaction VK33.

But there seems to be no option to output the list into a file, (excel file).

Is there a way to do that?

Thanks

Anne

[megadisc]

VK33 works from ME in R3

thanks .

[Former Member]

Hello,

Try V/LX Transaction V/LD also you can use.