what tables do I use to find material docs for matnr and serial #

[Former Member]

Here's an easy way to get some points -- assuming you already know the answer

I need to create a z abap report that lists all material docs (mkpf, mseg) for a material number and serial number.

If I know the material number and serial number, how do I find the material documents?

Thanks in advance!

Den

[Former Member]

Hi Den,

May be you can leverage the std SAP report RM07DOCS

which takes in a material number and displays a list of material documents. It does many more things , may be you can make a copy and change it as you need .

Cheers

VJ

[Former Member]

Hi Den,

You can also leverage or use the BAPI --> BAPI_GOODSMVT_GETITEMS

It makes life easier to leverage from existing std objects

Cheers

VJ

[RichHeilman]

Hi Den, maybe I'm missing your point, but MKPF and MSEG are the material document tables. MBLNR is the material document number. You can select from these tables or maybe use the BAPI that Vijayendra has suggested.

Regards,

Rich Heilman

[Former Member]

Hi !

Here we go...

First you need to read the OBJK with MATNR + SERNR.

Then you'll get the OBKNR-Key of this object.

Then go to the SER03 using the OBKNR and you'll get all the Materialdocuments (by number) of this serialnumber.

Regards

Rainer

Points are allways welcome