Why isn't my query executed?

[Former Member]

Hey!

I have been trying to execute different queries in the test area, but get all the time "No data was selected" text. I have made the selection criteria and defined the output option, and everything should be fine. The only thing I haven't been able to do is to define the layout on the last page, because I cannot do the selections. I hope someone would be able to tell me what's wrong, since I have tried almost everything but haven't found any solution.

Thank you,

Maria

[Former Member]

check whether join in infoset is corect- sometimes primary key of base table is not present in other table joins and this gives eror specified

sometimes the fields you are putting on selection screen should come from standard tabl- u canniot take from local or additional fiekds

which tables are u trying to join?

[Former Member]

Hi,

Thank you for your reply. I'm trying to join the tables VBKD, VBAK, AFKO, AFVV, S261, LIKP and QMEL. When I'm checking the link condition the system claims that the defined join conditions are correct. Am I just trying to join too many tables? Could that be the reason, despite the join conditions should be correct?

I've also changed the selection criteria and used fields that come from standard tables, but it doesn't help. For instance, I have used the PO-number from table VBKD and field BSTDK as a selection criteria.

Maria

[Former Member]

Dear Maria,

Try to separate the query by deleting several table. seems that all the joining key from several tables lead to inconsistency between one or more table.You may download it separately then join it in exceel or access.

[Former Member]

Hey again,

I deleted three tables; VBLB, LIKP and QMEL but I still have the same problem. And I cannot generate any other queries either. On the last page I have the field where I can make the selection criteria and then a field that asks me to specify the layout. For the layout I have three options; "User Specific", "Global" or "All". And when I'm trying to choose any of them, the system says "No selection" and gives this message "Message no. 0K205". So, the field remains empty. Could this be the problem? And if so, how could I get rid of it?

Maria