Important Tables in SAP FI & CO ( Controlling )

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