material consumption report!!!!!!

[Former Member]

hai abap experts,

"A report that displays the amount of all the material consumed by a particular plant for that fiscal year. "

what are the table and fields ?

bye

[Former Member]

TABLE MSEG

FIELD DMBTR

[Former Member]

Hi,

Use MARD table for this.

How can you expect people to give the field names for your requirement?

You should know based on your requirement,

it appears that you are jsut reading the lines some resume and asking us to give the details.

Check MMBE Tcode and as per that output design your report.

are you really asking this to work on this or just for interview purpose?

regards,

Anji

[Former Member]

hi

it is material related data...check...

MARA

MARC

MARD

MBEW

<b>see the functionality behind this is</b>

1.A material can be present in different plants " table marc

2.further a plant can have multiple storage locations "tables mard .

so material consumption will be to check how much material is consumed in a year .

This u can do by first calulating the stock present during the year ( as on jan 1 2006) say total stock for that material is 10,000 units (mara-meins)

so in the fiscal year 2006 how much was the material consumed means i need to see how much stock was posted during the year .

say stock avaliable as of 2006 december 31 is 3700 units

so now my material consumption is

10000 (stock present at the start of the year ) - 3700 ( stock present at the end of the year ) = 6300

so 6300 will be ur material consumed .

these details can be fetched from MARD table s

so finally the report will show 10000 37000 and 6300

try to understand the relation between mara marc and mard tables rest is numeric calulation in the internal tables.

i took the dates for example generally it will be posting dates for fiscal year .

regards,

ravish

<b>plz reward points if helpful</b>