Data base table for amount entered

[Former Member]

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

[Former Member]

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

[sridhar_k1]

Check in tables REGUH and REGUP.

Regards

Sridhar

[Former Member]

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.

[Former Member]

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

Rob

[Former Member]

Have you looked in BSID (customer open items)?

Rob

[Former Member]

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