Report

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Smita,

Welcome To SDN.

Could you be clear with the query.

Regards

[Former Member]

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

reward points if helpful

[Former Member]

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]

Hi,

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

Regards,

Bhaskar