For a good receipt (GR), get the corresponding invoice (IR).

[Former Member]

Hi All,

How can i get the corresponding invoice number (IR) for a good receipt (GR)?

What are the tables and linkages b/w those tables?

Thanks in advance.

[Former Member]

EKBE table with give you all the information

Or if you want the report then use

ME2N with scope of list as ALLES

and seleection parameter is GUTSCHRIFT

[Former Member]

Hi Charlie,

Thanks for the reply.

Yes i know that EKBE table can be used But now question is how to get 1:1 relationship b/w the GR and IR? What are the fields which can be used for this?

Regards,

Sanjay.

[Former Member]

You need to use PO history category

why don't use then ME2N report

this will give you wiht that 1:1 relation

[Former Member]

I need to write a report so i am in search of some logic to get it.

I checked ME2N also but i think this is not what I require.

I also searched the ekbe. I guess i can use LFBNR, LFPOS and BEWTP.

[Former Member]

Make the logic based on the the three field you have mentioned along with the field

XBLNR.