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

work center and operation details for a particular material.

Hi Gurus

my requirement is

user will give material number (DU)

he want to fetch production order number, operation number(vornr) and concerned work center from that production order.

please provide table details.

pls help.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jul 20, 2016 at 08:40 AM

    Hello,

    Based on the material number you will get the production order numbers from AFPO.

    Pass AFPO-MATNR and Get AFPO-AUFNR, there can be multiple production orders for a single material number

    Based on AFPO-AUFNR Get Plan no.f.oper. from AFKO-AUFPL (This will be one to one for production order)

    You will get the operations from AFVC passing AFKO-AUFPL also you will get the object ID of the work center AFKO-ARBID and operations AFKO-VORNR.

    Based on the object ID you can get the work center details from CRHD table passing CRHD-OBJTY (Object Type) = A and CRHD-OBJID = AFKO-ARBID.

    Hope this logic helps 😊.

    Another way to get the production order details once you have the order number is to use BAPI BAPI_PRODORD_GET_DETAIL.

    Best Regards,

    Ameya Beri

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 20, 2016 at 07:43 AM

    Hi Satish,

    Have you checked COOIS report.

    In the selection screen you need to select Operations for filed List

    Regards

    Praveen


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 20, 2016 at 07:56 AM

    Dear Kumar,

    See the attachment for details.

    Go to T-code COOIS and select List as Operation and give Material (if you give plant also your output will be displayed fast) then you can get the Production order,Operation number and related work center.

    Thanks,

    Naresh.


    Capture.PNG (58.5 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 20, 2016 at 08:56 AM

    Dear Sathish,

    As said by the experts you can take the details from standard report itself, in case if you want the logic to be given to the ABAPer, please use the following

    Pass the Order number (AUFNR) into AFKO-AUFNR and get AFKO-AUFPL (Plan no of operation)

    Pass the AFKO-AUFPL into AFVC-AUFPL and get AFVC-VORNR (Operation number) and AFVC-ARBID (Object number).

    Pass the AFVC-ARBID into CRHD-OBJID and get CRHD-ARBPL (Work Center)

    Using the above logic you can fetch the operation no and work center against an order.

    Kindly write me back for any further clarifications.

    Best Regards

    Senthil Nathan Karunanithi

    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.