Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SQVI - No Data was Selected Error

former_member1139791
Member

‎2015 May 14 4:32 PM

0 Likes
3,347

Hi All.

I require some help with SQVI please.  All I require is two fields from another table KONP.  I have created a join with tables A902 and KONP (view screenshot below).  I require the selection fields of Condition Record Number and Material Number Only.  I then list a few fields from the A902 table and the two fields from the KONP table (Amount -  KBETR).  When I execute the query and input either a condition record number or material number, it comes up with the "No Data was Selected Error". I have also chosen one record and checked that the same record exists on both tables with SE16.  Could somebody please assist.  It would be highly appreciated.  Regards.

Preview file
122 KB

Hi All.

I require some help with SQVI please.  All I require is two fields from another table KONP.  I have created a join with tables A902 and KONP (view screenshot below).  I require the selection fields of Condition Record Number and Material Number Only.  I then list a few fields from the A902 table and the two fields from the KONP table (Amount -  KBETR).  When I execute the query and input either a condition record number or material number, it comes up with the "No Data was Selected Error". I have also chosen one record and checked that the same record exists on both tables with SE16.  Could somebody please assist.  It would be highly appreciated.  Regards.

Reply
2 REPLIES 2
Read only

Former Member

‎2015 May 16 12:50 PM

0 Likes
1,913

Hello Gerald,

Please check that internal format of each field used for the link between tables are identical.

When you check SE16 do you use all fields that are involve in the link ?

Regards

Read only

jogeswararao_kavala
Active Contributor

‎2015 May 16 2:07 PM

0 Likes
1,913

Hello Gerald,

System by default connects all similar fields. This many a time becomes a reason for No DATA. So you should remove few joins. Start by removing DATBI, KFRST, MATNR links and see. I'm referring to A902 fields. (The fields of KONP are not seen to which these fields connect. IF it does not improve remove some other join. I hope you know how to remove a join. Right click on the connecting line and Delete. at some point of you want to restore original joins click on one table and choose the join conditions icon in the Application toolbar.

KJogeswaraRao