topic Re: Report in Application Development and Automation Discussions

Report

Former Member — Mon, 26 Mar 2007 08:18:05 GMT

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

Former Member — Mon, 26 Mar 2007 08:19:38 GMT

Hi Smita,

Welcome To SDN.

Could you be clear with the query.

Regards

Former Member — Mon, 26 Mar 2007 08:19:55 GMT

the link between VBRk and KONV is KNUMV... chek out...

reward points if helpful

Former Member — Mon, 26 Mar 2007 09:07:45 GMT

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. .

Former Member — Mon, 26 Mar 2007 10:04:33 GMT

Hi,

Write the Inner Join sql statement between konv and vbrk tables. You will get the results.

Regards,

Bhaskar