cancel
Showing results for 
Search instead for 
Did you mean: 

database tables for Special GL - down payment

Former Member
0 Kudos

As per my knowledge

All vendor open items or with BSAK database table

All vendor cleared items or with BSIK database table

All customer open items or with BSAD database table

All customer cleared items or with BSID database table

My question is in which table following transaction will be saved (Special GL transactions)

1. Down payment request to customer / vendor

2. Down payment made to vendor and received from customer

3. Clearing down payment in both cases

I request you to give me database table names in above cases

thanking you

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

.

Former Member
0 Kudos

Hi,

1. Down payment request to customer / vendor - BSIK/BSID (UMSKZ - 'F' and BSTAT - 'S')

2. Down payment made to vendor and received from customer - BSIK/BSID (filter with the field UMSKZ)

3. Clearing down payment in both cases - BSAK/BSAD (Filter with the field UMSKZ)

Hope this helps.

thanks and regrards,

anit

Edited by: Anit Mangat on Nov 26, 2010 3:58 PM

Former Member
0 Kudos

Hi, they stored at the same tables.

down payment request in BSIK,BSAK,BSEG , similar for customer

Edited by: alex ice on Nov 26, 2010 10:37 AM