Purchase Requisitions

[Former Member]

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...

[Former Member]

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

[Former Member]

Hi,

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

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

[Former Member]

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!