topic Re: Data base table for amount entered in Application Development and Automation Discussions

Data base table for amount entered

Former Member — Wed, 25 Oct 2006 18:21:53 GMT

I am using F-29 transaction and posting customer payments, can any one tell me what's the database table where we can see the amount posted.

Example: If you are trying to pay $100.00 agnaist $1000.00. I need to know the database table where we can find $100.00 ie paid amount not netvalue. In BSAD-wrbtr table shows the total amount ($1000) not the paid amount.

Thank you,

Phani

Re: Data base table for amount entered

sridhar_k1 — Wed, 25 Oct 2006 18:30:52 GMT

Check in tables REGUH and REGUP.

Regards

Sridhar

Re: Data base table for amount entered

Former Member — Wed, 25 Oct 2006 18:31:37 GMT

Have you looked in BSID (customer open items)?

Rob

Re: Data base table for amount entered

Former Member — Wed, 25 Oct 2006 18:37:35 GMT

if you are looking for incoming payments

then these are the tables

RF05A - Work Fields for SAPMF05A

BSEG - Accounting Document Segment

AVIK - Payment Advice Header

BKPF - Accounting Document Header

Award points if useful

Prince

Re: Data base table for amount entered

Former Member — Wed, 25 Oct 2006 18:42:15 GMT

No luck with REGUH and REGUP.

I looked even in BSID table, it shows netvalue in BSID-wrbtr. I doesn't show the amount posted.

Re: Data base table for amount entered

Former Member — Wed, 25 Oct 2006 18:56:25 GMT

Are you saying that you have the same document in both BSID and BSAD?

Rob