Cannot use SQL query to pull data from KONV table in SAP ECC

[#1]

System: SAP ERP-2005 release SP/FP stack: 27 (06/2015)

Issue: We have a business need to pull data from KONV table to perform VAT related analysis. To do this, we tried using a SQL query. However, since KONV is a cluster table we cannot directly use SQL query.

Given the one-time need for this extract, we do not consider developing an ABAP program is a best use of the time. Can you suggest an alternative way to extract data from KONV using SQL query? thanks.

[RaymondGiuseppi]

In the logical databases VAV and VFV, table KONV is accessed to retrieve pricing condition data. So you should be able to use those logical databases for your queries, create first an infose with SQ02 and select relevant informations from the LDB.

• Read 550764 - SAP Query FAQ.
• Look at transaction SE36 Logical databases.

[Lakshmipathi]

Execute SQVI > Select Table Join under Data Source > Input VAV (if you want to extract from sales order) or VFV (if you want to extract from billing) against Table/view and execute