how to see MIRO No with reference MIGO

[Former Member]

Dear experts,

how to see miro number with reference to migo number in mass, is there any table to see ?, please help.

regards

rajakarthik

[Former Member · Accepted solution]

You can not do MIRO w.r.to MIGO, but you can do MIRO w.r.to Delivery Note

You can create a simple SAP Query by Joining tables MSEG,MKPF,RBKP & RSEG

[Former Member · Accepted solution]

thanks, how to join the table? we want to go for ABAP?

regards

karthik

[former_member529134 · Accepted solution]

Hello,

Use T.Code SQVI

Then give a quick view name and click create.

In the pop up block, give the description and select the data source as 'table join'

Make sure, basis mode is selected.

Then in the subsequent screen, select table join and give the tables u need to join in the sequence.

Once the table selection is over, make the fields to be needed in the report and in the selection screen and go for the report by executing.

Can contact your abaper if support needed.

Regards

Gregory Mathews

[Former Member]

Hi karthik,

You can get the value directly from the table RSEG .

Enter the reference document in the field : LFBNR Table :RSEG

Note : GR based Invoice Verification is mandatoryin PO.

Regards

Ramesh Ch

[Former Member]

Join the table RSEG & MSEG in SQVI (PO will be the common feild in both the table) toget the list of Miro against MIGO