‎2007 Mar 26 9:18 AM
Hi
KONV-KBETR. Where KONV-KSCHL = YPIN. Pick doc.record number fromVBRK and pick relevant records from KONV.
What is the logic of this statement because no field link between KONV and VBRK?
Regards
Smita
‎2007 Mar 26 9:19 AM
Hi Smita,
Welcome To SDN.
Could you be clear with the query.
Regards
‎2007 Mar 26 9:19 AM
the link between VBRk and KONV is KNUMV... chek out...
reward points if helpful
‎2007 Mar 26 10:07 AM
Hi Smitha,
Fisrt welcome to SDN world. Yes, As per tanuja solution it is absolutely right, link between VBRK and KONV is through field KNUMV.
Close thread if u will updated with answer.
Hope this helps you, reply for queries, Shall post you the updates.
Regards.
Kumar. .
‎2007 Mar 26 11:04 AM
Hi,
Write the Inner Join sql statement between konv and vbrk tables. You will get the results.
Regards,
Bhaskar