Skip to Content
avatar image
Former Member

Purchase Requisitions

Hello all,

Please anyone tell me how to identify open pr's and closed pr's.

My requirement is I need to display the report open requisiiotns and when i specified the closed requisitions checkbox it should display closed reqn's.

I am selecting all the pr's from EBAN table..

Please tell me the condition based on which fields to fetch the PR's accordingly...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Aug 17, 2007 at 06:17 AM

    Hi

    Fetch the data from EBAN , you will get all PR's

    goto EKPO and pass this PR's to EKPO table and fetch the PO's data.

    check the Item wise Qty wise for each PR a PO has been done or not,

    by equating the PR item in EKPO table

    if you find the PO for that PR check the Qty's are same or not.

    if it is same then that PR is closed

    otherwise it is OPEN.

    <b>Reward points for useful Answers</b>

    Regards

    Anji

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Pls send me the code how should i take the condition.

      eg:select banfn from eban into table it_eban where .....

  • avatar image
    Former Member
    Aug 17, 2007 at 06:44 AM

    Hi,

    look for field BSMNG-Quantity Ordered Against this Purchase Requisition in table EBAN. If the quantity in BSMNG is equal to MENGE - Quantity Requested in table EBAN your PR should be closed

    Regards Vassko!

    Add comment
    10|10000 characters needed characters exceeded