creating Z report for material stock (plant maintenance module)

[Former Member]

hello,

we are implemented Plant maintenance module (SAP PM) in our organization.

our requirement is to create a stock report which will incldue

followings:-

1)material number

2)plant number

3) storage location

4) material type

5)valuation type

6)Opening Stock

7) OpValue

8)Received Stock

9) ReceiptValue

10) Issue Stock

11) IssueValue

12) Closing Stock

13) Closing Value

we want above details in ALV grid format.

to gert all the details for perticular material, we calcute closing stock and closing value in following manner:-

opening stock + received stock - issue stock = closing stock

opening value + recipt value - issue value = closing value

we are unable to find table name for accessing opening stock, received stock , issue stock & opening value ,recipt value , issue value from system. please suggest table name information for getting above details for creating Z report

[former_member184701]

Dear friend,

Before to make a decision to bulid a custom report make sure you have checked out the following standard transactions:

MB5T Stock in Transit

MMBE Stock Overview

MD04 Stock/Reqs list

MB53 Plant Stock Availability

MB52 Warehouse Stock

MB5M Expiration Date list

MB5B Stock for Posting Date

MB5T Stock in Transit

MBBS Valuated Special Stock

MBLB Stock with Subcontractor

The possible tables are:

MARA, MARD, MARC, VBEP, VBAK(VBAP), EKKO(EKPO), EKBE, EBAN, EBEW, MSEG, MKPF,...

Good luck!