topic Re: Purchase Requisitions in Application Development and Automation Discussions

Purchase Requisitions

Former Member — Fri, 17 Aug 2007 06:12:42 GMT

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

Re: Purchase Requisitions

Former Member — Fri, 17 Aug 2007 06:17:19 GMT

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

Re: Purchase Requisitions

Former Member — Fri, 17 Aug 2007 06:44:40 GMT

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!

Re: Purchase Requisitions

Former Member — Fri, 17 Aug 2007 06:53:10 GMT

Hi,

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

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