Important Tables in SAP FI
Financial Accounting
FBAS – Financial Accounting “Basis”
Table Name : BKPF
Table Purpose : Accounting Document Header
Fields:
- BUKRS
- BELNR
- GJAHR
Table Name : BSEG
Table Purpose : Accounting Document Segment
Fields:
- BUKRS
- BELNR
- GJAHR
- BUZEI
Table Name : BSIP
Table Purpose : Index for Vendor Validation of Double Documents
Fields:
- BUKRS
- LIFNR
- WAERS
- BLDAT
- XBLNR
- WRBTR
- BELNR
- GJAHR
- BUZEI
Table Name : BVOR
Table Purpose : Inter Company Posting Procedure
Fields:
- BVORG
- BUKRS
- GJAHR
- BELNR
Table Name : EBKPF
Table Purpose : Accounting Document Header (docs from External Systems)
Fields:
- GLSBK
- BELNR
- GJHAR
- GLEBK
Table Name : FRUN
Table Purpose : Run Date of a Program
Fields:
- PRGID
Table Name : KLPA
Table Purpose : Customer / Vendor Linking
Fields:
- NKULI
- NBUKR
- NKOAR
- PNTYP
- VKULI
- VBUKR
- VKOAR
Table Name : KNB4
Table Purpose : Customer Payment History
Fields:
- KUNNR
- BUKRS
Table Name : KNB5
Table Purpose : Customer Master Dunning Data
Fields:
- KUNNR
- BUKRS
- MABER
Table Name : KNBK
Table Purpose : Customer Master Bank Details
Fields:
- KUNNR
- BANKS
- BANKL
- BANKN
Table Name : KNC1
Table Purpose : Customer Master Transaction Figures
Fields:
- KUNNR
- BUKRS
- GJHAR
Table Name : KNC3
Table Purpose : Customer Master Special GL Transactions Figures
Fields:
- KUNNR
- BUKRS
- GJAHR
- SHBKZ
Table Name : LFB5
Table Purpose : Vendor Master Dunning Data
Fields:
- LIFNR
- BUKRS
- MABER
Table Name : LFBK
Table Purpose : Vendor Master Bank Details
Fields:
- LIFNR
- BANKS
- BANKL
- BANKN
Table Name : LFC1
Table Purpose : Vendor Master Transaction Figures
Fields:
- LIFNR
- BUKRS
- GJHAR
Table Name : LFC3
Table Purpose : Vendor Master Special GL Transactions Figures
Fields:
- LIFNR
- BUKRS
- GJHAR
- SHBKZ
Table Name : VBKPF
Table Purpose : Document Header for Document Parking
Fields:
- AUSBK
- BUKRS
- BELNR
- GJHAR
FBASCORE : Financial Accounting General Services “Basis”
Table Name : KNB1
Table Purpose : Customer Master (Company Code)
Fields:
- KUNNR
- BUKRS
Table Name : LFA1
Table Purpose : Vendor Master (General Section)
Fields:
- LIFNR
Table Name : LFB1
Table Purpose : Vendor Master (company Code Section)
Fields:
- LIFNR
- BUKRS
Table Name : SKA1
Table Purpose : G/L Account Master (Chart of Accounts)
Fields:
- KTOPL
- SAKNR
Table Name : SKAT
Table Purpose : G/L Account Master (Chart of Accounts – Description)
Fields:
- SPRAS
- KTOPL
- SAKNR
Table Name : MAHNS
Table Purpose : Accounts Blocked by Dunning Selection
Fields:
- KOART
- BUKRS
- KONKO
- MABER
Table Name : MHNK
Table Purpose : Dunning Data (Account Entries)
Fields:
- LAUFD
- LAUFI
- KOART
- BUKRS
- KUNNR
- LIFNR
- CPDKY
- SKNRZE
- SMABER
- SMAHSK
- BUSAB
FI-GL-GL (FBS) General Ledger Accounting: Basic Functions- G/L Accounts
Table Name : SKAS
Table Purpose : G/L Account Master (Chart of Accounts – Key Word list)
Fields:
- SPRAS
- KTOPL
- SAKNR
- SCHLW
Table Name : SKB1
Table Purpose : G/L Account Master (Company Code)
Fields:
- BUKRS
- SAKNR
FI-GL-GL (FBSC) General Ledger Accounting: Basic Functions – R/3 Customizing for G/L Accounts
Table Name : FIGLREP
Table Purpose : Settings for G/L Posting Reports
Fields:
- MANDT
Table Name : TSAKR
Table Purpose : Create G/L account with reference
Fields:
- BUKRS
- SAKNR
FI-GL-GL (FFE) General Ledger Accounting: Basic Functions – Fast Data Entry
Table Name : KOMU
Table Purpose : Account Assignment Templates for G/L Account items
Fields:
- KMNAM
- KMZEI
FI-AR-AR (FBD) Accounts Receivable: Basic Functions – Customers
Table Name : KNKA
Table Purpose : Customer Master Credit Management : Central Data
Fields:
- KUNNR
Table Name : KNKK
Table Purpose : Customer Master Credit Management : Control Area Data
Fields:
- KUNNR
- KKBER
Table Name : KNKKF1
Table Purpose : Credit Management : FI Status data
Fields:
- LOGSYS
- KUNNR
- KKBER
- REGUL
Table Name : RFRR
Table Purpose : Accounting Data – A/R and A/P Information System
Fields:
- RELID
- SRTFD
- SRTF2
FI-BL-PT – Bank Accounting: Payment (BFIBL_CHECK_D) Transactions – General Sections
Table Name : PAYR
Table Purpose : Payment Medium File
Fields:
- ZBUKR
- HBKID
- HKTID
- RZAWE
- CHECT
Table Name : PCEC
Table Purpose : Pre-numbered Check
Fields:
- ZBUKR
- HBKID
- HKTID
- STAPL
FI-BL-PT-AP(FMZA)Bank Accounting: Payment Transactions – Automatic Payments
Table Name : F111G
Table Purpose : Global Settings for Payment Program for Payment Requests
Fields:
- MANDT
Table Name : FDZA
Table Purpose : Cash Management Line Items in Payment Requests
Fields:
- KEYNO
Table Name : PAYRQ
Table Purpose : Payment Requests
Fields:
- KEYNO