I Have Maintained Transactions For Purchase Order Payment Manually

E.g.

Pur-290001(type/doc.no)
Assinged The Supplier And Ledger Code;po;amount. Now The Tfacp200 Status Displays As Registered. And I Try To Match & Approve The Same ,status Now As Approved.

Now I Am Trying To Link To The Bank Payment To The Supplier The Status Again Shows As "registered" And Balance Amount Is 0.

I Am Trying To Create Sql Query /crystal Reports For Purchase Order Paid Or Not Paid Based On The Status. The Result Is Not Correctly Displaying.
I Can Track With Balance Amount? But There Could Be Some Time We Make Partial Amount To The Supplier And Balance Will Be There And Status Will Appear As Registered.

How To Extract The Report ? Is There Any Other Table Is Linking With Tfacp200 Table

Please Advice.

Which columns of tfacp200 did you use (as dutch man it isn't very easy)?
I'd try if t_tpay and / or t_tdoc have effect.