Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Data base table for amount entered

Former Member
0 Likes
742

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

5 REPLIES 5
Read only

sridhar_k1
Active Contributor
0 Likes
698

Check in tables REGUH and REGUP.

Regards

Sridhar

Read only

0 Likes
698

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.

Read only

0 Likes
698

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

Rob

Read only

Former Member
0 Likes
698

Have you looked in BSID (customer open items)?

Rob

Read only

Former Member
0 Likes
698

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