Which table has the sales price and Art.no?

[Former Member]

Hello,

I want to export the sales prices of parts to a excel,so who can give me the table which includes this field?

Thanks in advance

Helai

[Former Member · Accepted solution]

Hi lai,

Check KONV table using the t code SE16.

Thanks,

Swamy H P

[Former Member · Accepted solution]

Hello,

In table KONV ,I can't find a field to input the art.no ,and also I can't do a query by joining this two tables KONV and VBAK,

Actually I want to get the netprice of the part from the report ME1M

Thanks,

Helai

[Former Member · Accepted solution]

Hi Lai

Please get it from the price master.

A004 is material specific .. A005 Customer/ Material Prices.

Get the KNUMH from A004/ A0005 table and pss this to KONP Table. KBETR givesyou the price.

Regs.

Sai

[Former Member · Accepted solution]

Thanks All

In A005 I get nothing after a certain part no inputted

In A004 I get the several CondrecNo ,but no customer no.linked in this table,so I don't know which customer will get what price when I pass the CondRecNo to KONP,although I know it already includes all sales prices

So still can't get the "NETPR" for a certain part.

Any advices for a query for getting sales prices for a certain part

Best Regards,

Helai

Edited by: lai he on May 6, 2009 7:17 AM

[Former Member · Accepted solution]

HI Lai

If you want NETPR link with material number and sales order number please check Table VBAP.

Goto Tcode SE11 and find the details.

[Former Member · Accepted solution]

here is the problem

that the price is only linked with a certain customer ,and no any sales order created for this customer ,and later this price can be adopt as a default price for preparing to sale to this customer . so VBAP is only right to grab the history price ,may be this price exist in one list

[Former Member · Accepted solution]

Hi Lai

Now what do you want?

[Former Member · Accepted solution]

I know why I can't find the preset price due to they didn't maintain it yet.

so A004 +KNOP are right for me

Thanks all

[Former Member]

Hi

You can get these details in KONV table. Pass KNUMV fro VBAK to KONV table to get the details for a particular sales order.

[Former Member]

Hello

check the access sequence assigned to the condition type in v/06 , then go to v/05 to go to access sequqnce

the tables that are used to store the pricing information can be any of the listed tables in the access sequence

check for the entries in se16 and donwload them to excel

hope this helps

Thanks

akasha