Daily Report of Opening closing balance & Consumption

[former_member225891]

Dear Experts,

We are implementing for dairy industry (PI) and here is requirement to develop a report which shows daily raw milk consumption ( Movement type 261) and daily opening and closing balances of raw as well as finished milk, Finished milk is produced using strategy 40 by repetitive manufacturing, please suggest me table and fields to get the data for such report.

Thanks & Regards,

Karad D D

Edited by: Devidas Karad on Jun 19, 2010 10:38 AM

[Former Member]

The opening and closing balances can be well handled by the report Mb5B and the results for the dalily consumption can easily tracked the transaction Mb51 which displays the Material Documents use MVMT 261 in it.

Regards,

Mandar.

[former_member187989]

Check this link also helpful in developing report

[Former Member]

Hello,

I would suggest the use of LIS tables S226, and S225, along with MSEG table to develop the custom report. If you have a online production confirmation system, then I would suggest you to develop a custom table to capture the data at a specific predefined time( say 12:00 hrs) so that comparisons can be made. The Custom table will be helpful to analyze the pattern of consumption.

BR

Guru

[former_member196398]

Karad,

Look at transaction MB5B, it would help you in designing your custom program.

Regards,

Prasobh

[former_member196530]

Dear ,

We had similar kind of report called -Material Balance Report for Finished Product .I am providing you the necessary tabel which I have utlised in my functinal spec.

You can use the following table for your requirement for developing daily consumption report

MBEWH - Stock with period and year

MBEW - Stock wtih current period and year

MSEG - Material Movement data details

MKPF - Material Movement data

You can make use the below tabel and data element to fetch some of the required information for finsihed good :

AUFNR AFKO-AUFNR, "Proc. Order No.

RSNUM AFKO-RSNUM, "Reservation No.

PLNBEZ AFKO-PLNBEZ, "Header Material No.

GSTRI AFKO-GSTRI, "Actual Start Date

GLTRI AFKO-GLTRI, "Actual Finish Date

WERKS AUFK-WERKS, "Plant

BDMNG RESB-BDMNG, "Required Qty.

ENMNG RESB-ENMNG, "Quantity Withdrawn

EXTISS RESB-ENMNG, "Extra Issue

BALQTY RESB-ENMNG, "Balance Qty.

MATNR RESB-MATNR, "Component No.

MAKTX MAKT-MAKTX, "Component Description

Hope this will be useful

Regards

JH