topic SQVI problem in Application Development and Automation Discussions

SQVI problem

Former Member — Tue, 26 Jan 2010 20:16:30 GMT

Hello everyone,

I am not sure if t-code SQVI should be posted in the ABAP form area, but I think it is ok.

I need to make a list of my costumers, and their AKONT in Excel so I am using SQVI.

I am trying to join KNA1 a KNB1. So in the selection window I choose u2018Table joinu2019. In the u2018Choose data sourceu2019 screen I choose tables KNA1 and KNB, because the primary key is not correctly selected, I drag the link line to KNB1-KUNNR. I press F3 and in the configuration screen I select the fields I want.

The problem is, when I execute the query, the system says there is no data selected. I do not understand why.

I have tried to do a simple SQVI from KNA1 and it selects data, but if I join the tables I get that information.

Thanks in advance

Re: SQVI problem

brad_bohn — Tue, 26 Jan 2010 20:23:58 GMT

Did you remove any incorrect joins propsed by the system and are your customers extended to the company codes for which you are selecting?

Re: SQVI problem

Former Member — Tue, 26 Jan 2010 20:26:12 GMT

Hello Friend,

the steps are correct...

did you checked KNB1 has data or not....

may be you can try to test in different client of the same system...

Thanks

Krish