Query Infoset t-code SQ02 with table KONV

[Former Member]

Hi All,

I want to create a Query infoset using t-code SQ02,

I want to join table VBAK and KONV for showing all condition types in the Sales order.

However the program disapear error "Table KONV cannot be used in a join"....

Is there other method I can join them using the Query infoset ?

Thanks.

Terry

[gilmarluiz_puntel · Accepted solution]

Hello Kin,

Searching for a solution, I found a Logical Database for sales orders, that have all the information that you need.

Using like reference the post of Bhagavatula, in the same transaction SQVI you can use, instead of the suggested join, you can select a logical database called VAV in Data source.

This logical database links the tables, VBAK, VBAP, VBUK and KONV that is the central point of the question.

You can list the information of logical database using the transaction SLDB.

In 'Logical Database' inform VAV.

Press F8 to list all the fields.

More information about logical database in:

Link: SAP Logical Database

See this thread that I wrote some days ago:

Link:[Thread 7371137|;

Regards,

[Former Member · Accepted solution]

Yes, Yes,

This VAV logical database is just what I need. coz I am not good in ABAP....

Thank you very very much.

[Former Member]

Hi,

Join the tables VBAK & KONV on KNUMV in your query. You can also write the code in Query itself.

Some inputs from any technical guy on ABAP code will help you.

Regards,

Vijay

[Former Member]

Terry,

U cant retrieve records directly from the KONV. because its Cluster table. so u have to take help of abaper to write a small ABAP code for retrieving it.

Thanks,

Raja

[Former Member]

Hi Raja,

Thanks for your quick reply.

I want to write the ABAP code too, do you have any example for me?

I know there is optional in SQ02 when create the infoset, I can using a Data retrieval by program,

it allow data structure such as KONV,

but how can I join VBAK and KONV together ?

I want to list out all lines of Condition type in the query...

for e.g.

Sales Order Condition type Condition currency value

16000033 ZS00 USD 100

16000033 ZS01 USD 200

:

:

Terry

[Former Member]

Hi Terry,

Check this thread

Thanks,

Raja