Skip to Content
author's profile photo Former Member
Former Member

Daily to be Produce Report for Shop-floor user

Hi Gurus,

Requirement is for Shop floor user, need report in which user entered Dates (single or Range) with other option (like plant, work center etc.), and get the output value which shows what to be produce basis on the selection criteria. example

Material - RF-100

Production Order - 0000001

Quantity - 1000 EA

Scheduled Start Date - 13.11.2012

Scheduled Fin Date - 22.11.2012

Material - RF-200

Production Order - 0000002

Quantity - 1000 EA

Scheduled Start Date - 13.11.2012

Scheduled Fin Date - 16.11.2012

User enter Selection criteria as

Plant = 1000

Date = 13.11.2012

Output as

Production order

Production Order Material Total Qty Qty on Selected Period 0000001 RF-100 1000 100 0000002 RF-200 1000 250

other details are;

No CRP active,

Lot size = EX (in material master MRP-1)

looking for best support 😊

regards

Muhammad Shoaib

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 16, 2012 at 02:12 PM

    Hi to All,

    Job Done, with CRP Active, all done through SQ01 after creating Info set (SQ02) and no ABAP help 😊. that was great experience and learning, now you can the see the report out in attached screen shot.

    further summarized overview ;

    Table Use

    Field (Production order Header) Name AFKO-GAMNG Total order quantity AFKO-PLNBEZ Material Number AFKO-AUFNR Order Number AFKO-GLTRS Scheduled finish AFKO-GLUZS Scheduled finish time AFKO-GSUZS Scheduled Start (Time) AFKO-GSTRS Scheduled start AFKO-IGMNG Yield confirmed from order confirmation AFKO-BMENGE Base quantity

    Field Name AFVC-VORNR (Prod Order Opr Details) Operation/Activity Number AFVV-BMSCH (

    (DB structure of the quantities/dates/values in the operation)

    Base Quantity

    Field (Work Center & Material Desp) Name CRHD-ARBPL Work center MAKT-MAKTX Material Description (Short Text)

    Field ( Order Item Details) Name AFPO-NDISR Ind.: Material in order item is not relevant for MRP AFPO-DNREL Indicator: Order item not relevant for MRP AFPO-MILL_OC_RUMNG Confirmed Quantity for Item AFPO-IAMNG Expected surplus/deficit for goods receipt AFPO-WEMNG Quantity of goods received for the order item AFPO-DWERK Plant

    Overview:

    our Working time for the each work center of all production plant are same, which shorten work. take base qty of Routing form AFVV-BMSCH, and extract the time from Scheduled start Schedule Finished (Date and Time), and calculate both value. to take the qty to produce on specific date (which local field and selection Mandaotry entry).

    if anyone interested pls let me know, i can share the details through max. you can reach at any of the following contact details

    Skype - shaibeezz

    Gtalk - texengg

    Gmail - texnegg@gmail.com

    LinkedIn - http://pk.linkedin.com/in/muhammadshoaibasadkhalid


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I believe Perfection is one of the best illusions around.

      The intention for me to post was to help you evaluate the use of ABAP report / enhancement as it has been ruled out (not sure if it was thoroughly evaluated).

      I am not aware up to what level of accuracy the report should be, but if the day to day operational planning is to be based on this, then I believe it has to be accurate to the last detail.

      If you want the report to provide the output you're looking for, then you will need to add a few lines of code, be it in Infoset or a regular report or maybe even outside of SAP with some other prog. language. But if programming is definitely not allowed / possible / to be used, then the only other option I can think of is using capacity evaluation reports or capacity levelling reports (if levelling is done).

  • author's profile photo Former Member
    Former Member
    Posted on Nov 14, 2012 at 05:12 AM

    Hi,

    Thanks to all for the value input, i already stated the i need something without help of ABAPer, any how i try to re-explain my query again

    on above example (mentioned on Main question),

    When shop floor supervisor comes to start production on 14.nov.2012, he wants to know

    * Which production to be proceed and

    * What quantity to be produce

    How and what report he / she will use (standard) is there any report?

    pls guide

    regards

    Muhammad Shoaib

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 15, 2012 at 11:49 AM

    hi to all,

    i worked a lot, and back to solution (might not be 100% fit but useful),

    if we can get source of data from Data Base of CM01 transaction (if CRP is ON), and interface these value (mentioned under) with the Standard Value of operation esp the Base Qty. then multiple it will daily Requirement HR of specific date of spf Order and get daily to be produce qty; details are as;

    From CM01

    Structure.

    RC65D Fields of the detailed capacity list overview (need to know its Table)

    Field -

    • PERIOD (time period)
    • BED_VERUR (Peg Req -Order)
    • MATNR ( Material )
    • BEDARF (Requirement HR)

    TableAFKO (Production order Header)
    Field -

    • AUFNR - (Order Number)
    • AUFPL - (Routing number of operations in the order - to link with AFVV to get Base Qty and value)

    AFVV (Quantities/dates/values in the Order Operation)Field -

    • AUFPL (Routing number of operations in the order)
    • BMSCH (Base Qty)

    so in SQ01 query designer user local field for the formula as

    BMSCH (Base Qty -from AFVV) X BEDARF (Requirement HR - from RC65D)

    pls guide if any thing is missing and especially help to find out the source table for the Structure (RC65D).

    regards

    Muhammad shoaib

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 13, 2012 at 07:42 AM

    Did you check COOIS?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 13, 2012 at 08:55 PM

    dear,

    request abaper for new custom rep

    good luck

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2012 at 06:34 AM

    Hi ,

    I agree with Mr.Jeevan.

    If your requirement is for finished goods then you can use "coois" and can save the desired fields for display as a variant. You can find maximum information of an order and selection screen criteria will also match your requirement as per my understanding of your post.

    Please reply if this did not worked out

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Arvind,

      Agree about COOIS report compatibility, but pls guide me is there any field to enter the date through user can get the report for plan to be produce in the COOIS selection screen , as per my knowledge (which is not much vast), Date Selection field in COOIS, is for "Start" and "Finish" Date (for Basic, Schedule, Actual), no field field for the in between date input. another think is client is not using daily requirement plan.

      Pls guide

      regards

      Muhammad Shoaib

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.