on 06-28-2011 6:39 AM
Hi
Iu2019ll try to make a query to get a material number with the price (condition). I use the tables KONP and A304, but I get no results.
In table KONP Iu2019ve the condition record number and the amount; in table A304 Iu2019ve the condition record number and the material number. So I use as selection the material number in the table A304 to get the amount from KONP. But the query said no results.
When i use trx SE16 for both tables i'll will get the results that i want.
Can anyone tell me what Iu2019m doing wrong or better can give me the solution?
Thanks,
Peter
Hi Peter,
Go to Transaction SQVI and select the table join while creating the query and by default the tables are getting getting connected with many fields... remove all by right click on relation and join both the table with one field only i.e. "KNUMH" (condition record number)
please try it and confirm.
It is working fine.
Thanks & Regards,
Rahul Verulkar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Yadav
Thanks for the quick response.
I was under the impression that the numbers were the same condition. but indeed I see now that it is not.
Do you may have suggestions for other combinations?
Peter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can try in SQVI by table joining A304 table with KONV
thanks
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Peter,
The condition number in KONP and A304 are different. KONP consists of document condition number while A304 consists of condition record's condition number.
By chance both numbers are same in your case and your find match in SE16.
Try some other combination in your query.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
67 | |
14 | |
8 | |
6 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.