on 07-15-2010 8:18 AM
Dear all,
Can anybody tell me which are standard SAP tables used for GL posting, payment vendor invoice and payment customer invoice and where to find them?
Regards,
Sudish
Moderator: Please, search SDN
Hi,
There are a lot of tables involved. I will outline some important one:-
BKPF - For all document Header data
BSEG - For all documents Line Item Data
BSIS - For G/L Open Items
BSAS - For G/L Cleared Items
BSID - For Customer Open Items (Invoice, Payments etc.)
BSAD - For Customer Cleared Items (Invoices, Payments etc.)
BSIK - For Vendors Open Items (Invoice, Payments etc.)
BSAK - For Vendor Cleared Items (Invoices, Payments etc.)
REGUH - For Payment Run - Payment Documents Data
REGUP - For Payment Run - Line Items data
BSET - For Tax Lines in a document
Let me know if you need to know anything specific.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
All Financial documents are stored BKPF (header) BSEG (lines)
Tables for Accounts payable
BSIK - Vendor Open Items
BSAK- Vendor cleared items
LFA1, LFB1, LFBK, LFBW,ADRC, ADR6 u2013 Vendor master
BKPF, BSEG, BSIS, BSAD, BSAK - Documents
Tables for Accounts Receivable
BSID - Customer Open Items
BSAD- Customer cleared items
KNA1, KNB1, KNBK ( KN*) u2013 Customer master
BKPF, BSEG, BSIS, BSAD, BSAK - Documents
Regards
Prasad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.