cancel
Showing results for 
Search instead for 
Did you mean: 

Material wise report.

Former Member
0 Kudos

What t-code can I use to see the following details (summary) -

1. Number of PO's (Material wise)
2. PO Value
3. GR Value
4. IR Value
5. Balance

Accepted Solutions (1)

Accepted Solutions (1)

ravindra_devarapalli
Active Contributor
0 Kudos

Hi ,

      In standard there is no such a report available. You can search these values from following way

MB5S for (GR/IR balances) Balances

You can take  GR value and IR value from EKBE   table , pass transaction event key "1", the entry related to GR  and pass transaction event key "2 ", the entry related to IR for particularly Po  .

or

In MB5S, you can take IR and GR value but you should  select cleared item if you want to know what are Po's cleared, if you want to balances (still pending) don't select cleared items.

PO amount will get from ME2N or you can take from EKPO table.

Number of Po's you can take from ME2M or you can use EKPO table.

Why i am giving these table details, it is helpful  if you want develop the new report.

Former Member
0 Kudos

Thanks Ravindra for sharing the table names too.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

There is no standard report to get details of your requirement. This can be achieved by writing SAP QUERY by joining tables (EKKO, EKPO, MSEG, MKPF, RSEG, RBKP )  or by a custom report with the help of ABAP'er.

NM

Prasoon
Active Contributor
0 Kudos

Hi,

  

1. Number of PO's (Material wise) : ME2M

2. PO Value : ME2N

3. GR Value : ME2N / MB5S

4. IR Value  : ME2N/MB5S

5. Balance   : MB5S

Hope its helpful.

Regards,

AKPT

BijayKumarBarik
Active Contributor
0 Kudos

Hi,

No direct single standard report available for your requirement.You can cross check following t.codes or else go for development.

1. MB5S

2. ME80FN

3. S_P00_07000139

Regards,

Biju K

Former Member
0 Kudos

Thanks Bijay Sir.