Link between GRN & MIRO Doc

[Former Member]

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

[sreeramkumar_madisetty]

This message was moderated.

[SuhaSaha]

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

[Former Member]

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

[former_member387317]

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

[Former Member]

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

[Former Member]

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