report in MM ( pr, po, gr, iv)

[Former Member]

Dear all,

I want to make a report which should have the following information for one comlete month.

the number of PR released during a particular month.

the date on which the PO was released.

the date on which all the materials or the last receipt was received.

The date on which all the invoice or the last invoice was verified.

I want to know the tables and fields. I would be very thankful if you tell about any methodology of finding out the tables and fields if we do not know the table and field. the method of f1 followed by f4 on placing the cursor on the field does not work all the time. This is an urgent requirement from my client.

regards

[Former Member]

Hi,

Following are the tables -

1) PO - EKKO for header level data

EKPO for item level data

2) PR - EBAN

3) GRN - MSEG. For invoice, you will get the number in this table.

Hope this helps.

Regards,

Prashant

• - Reward points if answer is helpful

[Former Member]

PO History

EKBE

GRN

MKPF--- Header

MSEG-- Item level

Invoice

RBKP-- Header level

RSEG-- Item Level

Edited by: Manohar Raju on Mar 30, 2008 5:13 PM