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

More References