Download Pricing Information with SQVI

[Former Member]

Dear all,

I've seen by using the search function, that my issue had appeared for a few times, but unfortunately I wasn't able to solve the issue with the found information.

I would like to link MARA and MARC tables to the price conditions per material. I'm looking for the global sales price and for the local sales price which is stored as a condition (normally viewed by Transaction VK13). I tried to retrieve this information by using Tables A301 to A309, with table KOND, KONH etc. but I wasn't able to retrieve any data. I first thought about wrong join options, but I even cannot retrieve data from the KOND table if I just using the KOND or KONH table.

The only thing which has worked until now are logical tables like VAV and VFV, but if I using them, I cannot link them to MARA and MARC in SQVI.

Does anybody have an idea how I can retrieve the pricing data in combination with MARA and MARC data?

Thank you for your help in advance!

[VeselinaPeykova · Accepted solution]

I don't know what data exactly you expect to get from MARC, but as for retrieving condition records information, did you try getting KNUMH from your A* table, then checking with this number in KONP or KONM? Using SQVI to retrieve the data is not going to be easy, because you can have different settings for different conditions. It might be slightly easier if you use V/LD, export the result to Excel, reformat (the output is ugly) and make the additional mappings with vlookup. We actually use a custom-made ALV report for pricing data, because the standard ones, provided by SAP, are far from user-friendly and usable. If your company can afford some development budget, then your users will be grateful, believe me.