Skip to Content
avatar image
Former Member

search for pro oder no (AUFNR) based on WBS (PROJN) & MATNR

hi, all

i have WBS no (PROJN) and material no (MATNR). How can i get the production oder number (AUFNR)?

which table should i use?

thanks

JL

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 03, 2008 at 07:40 AM

    Hello

    1. Goto table PROJ and select OBJNR corresponding to your PROJN.

    2. Goto table PRPS with key OBJNR and select corresponding PSPNR.

    3. Goto table MSEG with key MATNR and PS_PSP_PNR.

    4. MSEG-AUFNR.

    Add comment
    10|10000 characters needed characters exceeded

    • dzed already gave the complete answer to you're question you just have to link the 2 last tables in you're query. with projects it is quite complex how the relations are defined but still you can work it out from that answer

      kind regards

      arthur

  • Sep 03, 2008 at 07:33 AM

    for the wbs element AUFK for the material RESB

    kind regards

    arthur de smidt

    Add comment
    10|10000 characters needed characters exceeded