Skip to Content

bom of production order

hi sap experts, i am new in abap and have a question,can help me? i want to find the bom of a production order ,just bom of that operations that are confirmde, i use resb table but i have timed out errors.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

8 Answers

  • Posted on Jan 09, 2014 at 05:16 AM

    Hi Izadi,

    as paer as i know, you can have 2 alternate BOM for each material you have created, if you have created both of your BOM for the materials, you can use the following steps.

    If you have not created any bom, then also you can go through SPRO menu as given below to create BOM for your materials.

    Create Production Versions 01 and 02 and assign the alt BOM 1 for the PV 01 and 02 alt bom for PV 02.

    Goto SPRO : Production -> Shop Floor Control -> Define Order type dependent paramters ( Tcode : OPL8) : Define the Production Version Slection either 1 for manual and 2 for automatic. (if you use automatic system will select the version based on the material master selection method )

    Please see this link, which might help you

    http://scn.sap.com/thread/3208124

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 05:31 AM

    Try tables STKO & STPO.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 05:37 AM

    Hi,

    these tables are useful for you in finding BOM

    MAST, STKO, STPO, STAS, STZU


    or you can also use this function module "CSAP_MAT_BOM_READ' for the same purpose.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 05:53 AM

    hi and thanx for your reply.

    but in non of these tables i dont have aufnr(production order from afko) and vornr(operation from afvc table) field .

    actualy i want a report from components that you can see in component view in co03 transaction when you enter the production order, but just that operation that are confimed.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2014 at 06:27 AM

    Try AFVV

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 07:03 AM

    Hello mahdieh ,

    As mentioned by you and suggested here ,

    RESB is the table for Finding the BOM components involved while Creating a Production Order ( CO01 ).

    You just need to fine tune your SELECT statement accordingly.

    And For the Confirmations made for these Orders ( CO11N) data is present in AUFM table ( same BWART eq 261 logic here also , 261 is the movement type for components involved while producing a good )

    Add a comment
    10|10000 characters needed characters exceeded

    • Sijin,

      I am just referring to the point that each confirmation need not necessarily be configured to create a material document.

      In our organisation, goods issue to production order (261 movement) takes place first separately and confirmation happens when work in progress and when the work item gets over. Finally when quality gives UD, 101 movement will happen.

      Regards.

  • Posted on Jan 09, 2014 at 07:51 AM

    Hi Mahdieh,

    You can use 'BAPI_PRODORD_GET_DETAIL'.

    CALL FUNCTION 'BAPI_PRODORD_GET_DETAIL'
    EXPORTING
    NUMBER = TEMP-AUFNR
    ORDER_OBJECTS = OROB
    TABLES
    OPERATION = OPER
    COMPONENT = COMP.

    In comp, you will get BOM details.

    Arivazhagan S

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 07:53 AM

    i change my code in this shape:

    SELECT afko~aufnr afvc~vornr
    INTO CORRESPONDING FIELDS OF TABLE inf
    FROM AFKO
    JOIN AFVC ON AFKO~AUFPL EQ AFVC~AUFPL
    JOIN JCDS ON JCDS~OBJNR EQ AFVC~OBJNR
    WHERE UDATE IN DATE
    and afko~aufnr in order
    AND STAT EQ 'I0009'
    AND STEUS NE 'ZP04'
    AND jcds~inact EQ space.



    loop at inf.

    SELECT RESB~BAUGR RESB~MATNR SUM( RESB~BDMNG ) AS BDMNG
    FROM RESB
    INTO TABLE BO
    WHERE aufnr eq inf-aufnr
    and VORNR eq inf-vornr
    GROUP BY BAUGR MATNR
    ORDER BY BAUGR MATNR
    %_HINTS ORACLE 'INDEX("MATNR AUFNR" "RESB~MAT")'.
    READ TABLE BO INDEX 1.

    IF SY-SUBRC EQ 0.
    move-corresponding bo to total-bo.
    append total-bo to BORES.
    endif.

    endloop.

    now how can i group by my internal table BORES on BAUGR MATNR?

    Add a comment
    10|10000 characters needed characters exceeded

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.