We are trying to customise a Pending PO report so as to match the PO's considered open by MRP.

Here we are taking the records from tdpur041 where
(qty_ord >0 and qty_del=0) or (qty_del >0 and back_ord >0)

but in certain cases the report fails.
Like qty_del = 0 and back_ord is manually updated to 0.

The PO is then processed and goes to step "Deleting Line".

But then as per the logic above the PO shows as OPEN. !!!.

which in incorrect.

Also there is no "status" field in tdpur041 or tdpur040

Is there any other way out to get the exact pending purchase order.

I do not think you can do it only with those tables. I use tdpur045 to get the purchase order line status.

Mark

Think accurate solution can be found only with the help of tdpur045. Status also is contained therein.