table for sp and mrp

[Former Member]

what is the table name for selling price and maximum retail price of article

[Former Member · Accepted solution]

Hello,

Sales price is stored in tables A073/KONP (Article, Distribution Chain level) or in A071/KONP (Article, Site, Distribution Chain level). Condition record number (KNUMH) is the linkage between A07* and KONP.

Thanks,

Venu

[Former Member · Accepted solution]

Hi Venu,

could u plz help me in detail. when i i am executing A071&A073 tables i am not getting MRP and SP of the articles.

plz explain me step by step for getting mrp and sp of articles from tables.

is there any other way to get this data much faster?

[Former Member]

answered

[Former Member]

Hi

You will get the details in WKBP table also which is related to pricing document

OW ,you can join the two tables A073 and Konp in SQVI for getting the details

If you have any further clarifications let me know

Regards

[Former Member]

Hello,

How do you display SP and MRP in Application? We use VKP* transactions. When you carry out sales pricing, it will be stored in one or more of the condition tables. We have to figure out which are those condition tables in your case.

Thanks,

Venu

[Former Member]

we are using vkp0 condition for MRP and ZZSP for SP.