topic Re: Link between GRN & MIRO Doc in Application Development and Automation Discussions

Link between GRN & MIRO Doc

Former Member — Fri, 18 Sep 2009 07:33:07 GMT

Hello Experts,

I want a link between mseg & ekbe(where vgabe = 2, RSEG belnr) ...besides matnr, ebeln and ebelp ..

I m not able to find a link that for which GRN which MIRO doc has been posted.

Plz suggest.

Aastha

Re: Link between GRN & MIRO Doc

sreeramkumar_madisetty — Fri, 18 Sep 2009 07:35:02 GMT

This message was moderated.

Re: Link between GRN & MIRO Doc

SuhaSaha — Fri, 18 Sep 2009 07:49:20 GMT

Hello Aastha,

What do you mean by

 want a link between mseg & ekbe(where vgabe = 2, RSEG belnr) ...besides matnr, ebeln and ebelp

Plz be clear in your requirement.

BR,

Suhas

Re: Link between GRN & MIRO Doc

Former Member — Fri, 18 Sep 2009 10:03:51 GMT

Hello Suhas,

I want mseg_{mblnr to be linked with ekbe}belnr.Here in table ekbe where vgabe = 2, it is the MIRO document.

In short i want GRN no to b mapped with its MIRO doc no line item wise.

Plz suggest.

Aastha

Re: Link between GRN & MIRO Doc

Former Member — Fri, 18 Sep 2009 10:26:09 GMT

Hi Aastha Gupta,

Check Out below fields for Relation between MSEG and EKBE...

MSEG-MBLNR == EKBE-BELNR

MSEG-MJAHR == EKBE-GJAHR

MSEG-ZEILE == EKBE-BUZEI

MSEG-EBELN == EKBE-EBELN 

MSEG-EBELP == EKBE-EBELP

MSEG-ZEKKN == EKBE-ZEKKN

and

EKBE-VGABE = '2' For Invoice Recipt

So you have full Primary Key of MSEG

MSEG-MJAHR

MSEG-ZEILE

MSEG-EBELN available in EKBE and further you can paas other data also...

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

Re: Link between GRN & MIRO Doc

Former Member — Fri, 18 Sep 2009 10:49:02 GMT

Hello Ilesh,

I don't want this, i get the GRN no from MSEG , I want MIRO no for this

it is wrong

MSEG-MBLNR == EKBE-BELNR

MSEG-MJAHR == EKBE-GJAHR

MSEG-ZEILE == EKBE-BUZEI

MSEG-EBELN == EKBE-EBELN

MSEG-EBELP == EKBE-EBELP

MSEG-ZEKKN == EKBE-ZEKKN

as i want RSEG_{BELNR , which is same as EKBE}BELNR , where vgabe = 2,

and i can't put MSEG-ZEILE == EKBE-BUZEI

Regards,

Aastha

Re: Link between GRN & MIRO Doc

Former Member — Fri, 18 Sep 2009 11:08:51 GMT

Have you checked RSEG-LFBNR, RSEG-LFGJA and RSEG-LFPOS?

If it is not populating then your invoice is not based on GR. If it is there then only you can get the reference.

I mean to say, in PO you can check that inside the tab Invoice (in item level) . If GR based IV is ticked then only you can get that refrence.

This tick is determined by the vendor master entry only so it depends for which vendor you are creating the PO.

For your ref I am giving the same question what I asked in forum may be helpful for you.

[;

Regards

Shiba Prasad Dutta