Skip to Content
avatar image
Former Member

SAP FI tables

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 15, 2010 at 07:29 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 15, 2010 at 07:29 AM

    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

    Add comment
    10|10000 characters needed characters exceeded