Skip to Content

Daily Report of Opening closing balance & Consumption

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Jun 19, 2010 at 01:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 19, 2010 at 02:11 PM

    Karad,

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

    Regards,

    Prasobh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 04:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 10:07 AM

    Check this link also helpful in developing report opening-and-closing-balance-of-a-material

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 11:37 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded