Skip to Content
author's profile photo
Former Member

List out all Purchase requisitions of production order

Hi All,

I need to display purchase requisition for a production order operation wise. I am doing it something like steps given below:

1) Verify all the PRs from table EBAN.

2) Go to table AFVC and find out all the purchase requisition and their corresponding Object id(BEDID).

3) Go to table AFKO and find out all the orders based on BEDID that were fetched form table AFVC.

Till this point it seems logical but I am not able to correlate between AFKO and AFVC, I mean If I know the order numbers from AFKO what is the relation between AFKO and AFVC apart from BEDID. As aufnr field is not present in table AFVC which is there in table AFKO.

In simple How can I extract all the operations details from table AFVC based on the order number in AFKO.

Thanks

Mark

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Jan 22, 2007 at 11:38 AM

    afko-aufpl = afvc-aufpl.

    regards

    shiba dutta

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 03, 2011 at 11:37 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded