SAP FI tables

[Former Member]

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

[Former Member · Accepted solution]

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

[former_member266406]

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