08-19-2005 12:25 AM
Hi,
Table EKBE shows all the GR and IR entries for a PO item but it does not link an invoice to the GRs that the invoice is posted for. There could be multiple GRs and IRs done for the same line item, and I need to know which IRs are for which GRs.
I've checked tables BKPF, BSEG, MKPF, and MSEG. There was a link between 'BP' document to invoice, but not between 'BP' document to matl. doc., so I still couldn't link GRs to IRs. Please help. Thanks.
Jocelyn Tom
08-19-2005 1:10 AM
Hi Jocelyn;
Have you check RBKP and RSEG? Those tables are populated by the invoice for the material document. I am suffering the same problem, I am not sure if the database is set up to look up from the IR as it is to look down from the PO. I think the big link is the invoice number, but I can't prove that obviously!
Cheers,
John
08-19-2005 1:10 AM
Hi Jocelyn;
Have you check RBKP and RSEG? Those tables are populated by the invoice for the material document. I am suffering the same problem, I am not sure if the database is set up to look up from the IR as it is to look down from the PO. I think the big link is the invoice number, but I can't prove that obviously!
Cheers,
John
08-19-2005 6:40 PM
Thanks for your suggestion John. Unfortunately RBKP and RSEG do not have link to the matl. document. I will keep looking. Any other ideas will be welcome.
Jocelyn Tom
08-19-2005 7:32 PM
unfortumately there is no link from a GR to a IR as the IR is create in reference to a PO/Item(s) and not a GR as there could be many to many links from GR to IR.
The only possible way to link them is bussiness oriented i.e. setting up rules within the businness to do this.
You could have the following scenario. Because the timing of the documents are Third Party (Vendor) Driven..........
<b>Document Qty Date</b>
PO1/ITEM1 100 01/01/2005
GR1 for PO1/ITEM1 25 02/01/2005
GR2 for PO1/ITEM1 25 03/01/2005
GR3 for PO1/ITEM1 25 04/01/2005
GR4 for PO1/ITEM1 25 05/01/2005
GR1 for PO1/ITEM1 45 05/01/2005
GR2 for PO1/ITEM1 55 06/01/2005
Hope that helps you understand!
Rishi
08-20-2005 12:10 AM
Thanks for your input Rishi. When running MIRO, it seems that IR is posted against whichever GRs are selected, not only against PO/item. Hence, I was hoping that there is a link between GRs and IRs somewhere on the system.
Specifically, I am working on an interface with a legacy system that require invoice information from SAP (includes PO, PO line item, invoice#, and lot number on the GR entries that the invoice is posted for). Since a PO line item can have multiple GRs and IRs, I need to know which IRs are for which GRs in order to extract the correct lot number. GR entries in EKBE contain XBLNR (lot number) but there's no link between the GRs and IRs within EKBE.
Other thoughts?!
Jocelyn Tom
08-20-2005 12:23 AM
You are partially right!
MIRO lets you post a invoice <b>up to the maximum qty</b> of the GR's received for the PO item, but you could change the number and post less/more based on tolerance vlues set in the system.
This means that if you had 3 GR's for qty 10 each, you you invoice up to 30 qty, but there is no one is to one link between the GR and the IR.
Rishi
08-27-2005 12:00 AM
Found a solution:
On ME21N and ME22N, in the 'invoice' tab of the PO line item, select the GR-based IV field. This will populate LFBJA, LFBNR, and LFPOS in MSEG (links GR to PO number) and RSEG (links GR, IR and PO number). The lot number on the GR entry will automatically be carried over to the IR entry in EKBE; exactly what I wanted!!
However, setting this field will force IR to be posted ONLY after GR is done (might be too restrictive for some businesses).
Jocelyn Tom
05-30-2007 10:10 AM
Hello Jocelyn,
Even I needed how GR is linked with IR,
After doing some research's , I have found some path to the question but not sure...
Through a Document No , both this GR and IR are linked.
for example..
check the table MSEG enter the PO No.
u will get MBLNR ( GR Doc) and LFBNR(Document No which will link to IR)
check the table RSEG enter the PO No
u will get BELNR( IR Doc) and LFBNR(Document No which links To GR).
I am not sure about it, But hopeful think it should be right...
Regards
Poornima.M