Tables for report purpose

[Former Member]

Hi,

To develop a new report few of fields i am not able to find out exactly from where i can pickup. Please guide me:

Opening balance of stock:

Receipt:

Taken for use in the manufacture:

Removed for home consumption:

Quantity of finished goods manufactured:

Finished goods manufactured of inputs:

Its very urgent for me can somebody guide me.

I had searched in forums not able to find the exact tables.

[Former Member]

It seems like MB5B already satisfies all your requirement.. it has opening and closing stock(check in list scopt).. you can add the relevant movements issue to manufacturing(261), quantity of good manufactured and etc..

Could you please eloborate what you want extra to MB5B?

you can get the stock details in MARD / MARDH tables and movement details in MSEG/MKPF tables.. But using MSEG/MKPF tables in custom report is not advisable as it will impact the performance of your system badly.. hence try to make use the existing reports in MB5B, MB52, MC.A(you get lot of useful feilds in layout)

[BijayKumarBarik]

Hi,

Check with T.Code: S_P00_07000139

OR

If the report with above t.code not meet your requirement,then go for developement

Regards,

Biju K

[tejyadav]

Check below link you will get list of All MM related Tables,

http://wiki.sdn.sap.com/wiki/display/ERPSCM/MM+Tables

[Former Member]

HI,

You have to use MB5B report logic as the require report to be developed based on movement type..

fetch the data from MSEG and MKPF,MARD tables.

Regards,