Purchasing Doc. No with reference of Material Document no?

[Former Member]

Hello Experts,

can you please help with the T-Code where I can find the Purchasing Document no with reference to the Material DOcument no?

Thanks in advance.

Regards,

Yawar Khan

[former_member187989 · Accepted solution]

ME80FN,in report,select purchase order,click change view,select purchase order history or

MB51,Click change layout,move purhcase order no. hidden in left side to right side,now you can find

purchase order no. with reference to material document no. item wise.

[Former Member · Accepted solution]

Hello Experts,

In my system MB51 report does not shown any field to enter material Document noI only have the material Document No with me) and now I want to check for the Purchasing Document no.

and I am also not able to change the Layout of MB51 report.

Please help.

Thanks for above inputs.

Regards,

Yawar Khan

[PollyGan · Accepted solution]

hi,

Please check the customizing

OLMB

->Reporting

->Define Field Selection for Material Document List

You can add "RM07DOCS MKPF MBLNR" to be selection field, and

"RM07DOCS MSEG EBELN" to be output field.

Then you can see those field in MB51.

Thanks and regards,

Polly

[Former Member · Accepted solution]

Hi Polly,

Thanks a Lot for your help, I was able to get the solution with your suggestion.

Points awarded..............

and thanks to all the other people Kilas, sangeeta, and jayakanth.

Regards,

Yawar Khan

Edited by: 1234_abcd on May 27, 2011 11:30 AM

[Former Member]

Hi,

Please run T. Code ME80FN.

Execute your report according to the selection parameters.

After getting the output, you will find a Button in the last at header level. Click on this button and select Purchase History. You will get all the details for the POs.

Hope this will serve your requirement.

Regards,

Neeraj

[Former Member]

In MB03,enter matl.doc number & yr press enter.Place the cursor in item material code & click on details from item it will give the PO number

[PollyGan]

HI,

Try MB51, and choose "purchase order" out from the layout, then you will be able to see the PO number linked to the material document.

Hope it helps.

Thanks and regards,

Polly

[kailas_ugale]

Hi

try Table EKBE

Regards

kailas Ugale

[Former Member]

Hi Kailas,

Thanks for the prompt reply,

I know the table, infact that could be taken from MSEG also choosing MBLR and EBELN as the output fields, I can do the job,

But it is for the End User that the requirement is, They can be given access to the Tables.

Please help with the T-Code.

Regards,

Yawar Khan

[Former Member]

In ME2N select in scope of list ALLEs that is everything possible you will get Material document number of both GR and MIRO but the layout is not in ALV grid format.

Regards

Sangeeta

[kailas_ugale]

Hi try this

In MB51 give your material number and plant execute it

and then double click on that material number open it and check purchase order tab in material doc you will get Po Number there

Regards

Kailas Ugale