Skip to Content
Author's profile photo Former Member

Details showing important Tables in SAP FI and CO Modules

I hope this document helps, but will welcome all the help we can improve this document.

Table Name

Description

Important Fields

Financial Accounting

FBAS

Financial Accounting “Basis”

BKPF

Accounting Document Header

MANDT / BUKRS / BELNR / GJAHR

BSEG

Accounting Document Segment

MANDT / BUKRS / BELNR / GJAHR / BUZEI

BSIP

Index for Vendor Validation of Double Documents

MANDT / BUKRS / LIFNR / WAERS / BLDAT / XBLNR / WRBTR / BELNR / GJAHR / BUZEI

BVOR

Inter Company Posting Procedure

MANDT / BVORG / BUKRS / GJAHR / BELNR

EBKPF

Accounting Document Header (docs from External Systems)

MANDT / GLSBK / BELNR / GJHAR / GLEBK

FRUN

Run Date of a Program

MANDT / PRGID

KLPA

Customer / Vendor Linking

MANDT / NKULI / NBUKR / NKOAR / PNTYP / VKULI / VBUKR / VKOAR

KNB4

Customer Payment History

MANDT / KUNNR / BUKRS

KNB5

Customer Master Dunning Data

MANDT / KUNNR / BUKRS / MABER

KNBK

Customer Master Bank Details

MANDT / KUNNR / BANKS / BANKL / BANKN

KNC1

Customer Master Transaction Figures

MANDT / KUNNR / BUKRS / GJHAR

KNC3

Customer Master Special GL Transactions Figures

MANDT / KUNNR / BUKRS / GJAHR / SHBKZ

LFB5

Vendor Master Dunning Data

MANDT / LIFNR / BUKRS / MABER

LFBK

Vendor Master Bank Details

MANDT / LIFNR / BANKS / BANKL / BANKN

LFC1

Vendor Master Transaction Figures

MANDT / LIFNR / BUKRS / GJHAR

LFC3

Vendor Master Special GL Transactions Figures

MANDT / LIFNR / BUKRS / GJHAR / SHBKZ

VBKPF

Document Header for Document Parking

MANDT / AUSBK / BUKRS / BELNR / GJHAR

FBASCORE

Financial Accounting General Services “Basis”

KNB1

Customer Master (Company Code)

MANDT / KUNNR / BUKRS

LFA1

Vendor Master (General Section)

MANDT / LIFNR

LFB1

Vendor Master (company Code Section)

MANDT / LIFNR / BUKRS

SKA1

G/L Account Master (Chart of Accounts)

MANDT / KTOPL / SAKNR

SKAT

G/L Account Master (Chart of Accounts – Description)

MANDT / SPRAS / KTOPL / SAKNR

MAHNS

Accounts Blocked by Dunning Selection

MANDT / KOART / BUKRS / KONKO / MABER

MHNK

Dunning Data (Account Entries)

MANDT / LAUFD / LAUFI / KOART / BUKRS / KUNNR / LIFNR / CPDKY / SKNRZE / SMABER / SMAHSK / BUSAB

FI-GL-GL (FBS)

General Ledger Accounting: Basic Functions- G/L Accounts

SKAS

G/L Account Master (Chart of Accounts – Key Word list)

MANDT / SPRAS / KTOPL / SAKNR / SCHLW

SKB1

G/L Account Master (Company Code)

MANDT / BUKRS / SAKNR

FI-GL-GL (FBSC)

General Ledger Accounting: Basic Functions – R/3 Customizing for G/L Accounts

FIGLREP

Settings for G/L Posting Reports

MANDT

TSAKR

Create G/L account with reference

MANDT / BUKRS / SAKNR

FI-GL-GL (FFE)

General Ledger Accounting: Basic Functions – Fast Data Entry

KOMU

Account Assignment Templates for G/L Account items

MANDT / KMNAM / KMZEI

FI-AR-AR (FBD)

Accounts Receivable: Basic Functions – Customers

KNKA

Customer Master Credit Management : Central Data

MANDT / KUNNR

KNKK

Customer Master Credit Management : Control Area Data

MANDT / KUNNR / KKBER

KNKKF1

Credit Management : FI Status data

MANDT / LOGSYS / KUNNR / KKBER / REGUL

RFRR

Accounting Data – A/R and A/P Information System

MANDT / RELID / SRTFD / SRTF2

FI-BL-PT (BFIBL_CHECK_D)

Bank Accounting: Payment Transactions – General Sections

PAYR

Payment Medium File

MANDT / ZBUKR / HBKID / HKTID / RZAWE / CHECT

PCEC

Pre-numbered Check

MANDT / ZBUKR / HBKID / HKTID / STAPL

FI-BL-PT-AP(FMZA)

Bank Accounting: Payment Transactions – Automatic Payments

F111G

Global Settings for Payment Program for Payment Requests

MANDT

FDZA

Cash Management Line Items in Payment Requests

MANDT / KEYNO

PAYRQ

Payment Requests

MANDT / KEYNO

FI-AA-AA (AA)

Asset Accounting: Basic Functions – Master Data

ANKA

Asset Classes: General Data

MANDT / ANLKL

ANKP

Asset Classes: Fld Cont Dpndnt on Chart of Depreciation

MANDT / ANLKL / AFAPL

ANKT

Asset Classes: Description

MANDT / SPRAS / ANLKL

ANKV

Asset Classes: Insurance Types

MANDT / ANLKL / VRSLFD

ANLA

Asset Master Record Segment

MANDT / BUKRS / ANLN1 / ANLN2

ANLB

Depreciation Terms

MANDT / BUKRS / ANLN1 / ANLN2 / AFABE / BDATU

ANLT

Asset Texts

MANDT / SPRAS / BUKRS / ANLN1 / ANLN2

ANLU

Asset Master Record User Fields

.INCLUDE / MANDT / BUKRS / ANLN1 /  ANLN2

ANLW

Insurable Values (Year Dependent)

MANDT / BUKRS / ANLN1 / ANLN2 / VRSLFD / GJAHR

ANLX

Asset Master Record Segment

MANDT / BUKRS / ANLN1 / ANLN2

ANLZ

Time Dependent Asset Allocations

MANDT / BUKRS / ANLN1 / ANLN2 / BDATU

FI-AA-AA (AA2)

Asset Accounting: Basic Functions – Master Data 2.0

ANAR

Asset Types

MANDT / ANLAR

ANAT

Asset Type Text

MANDT / SPRAS / ANLAR

FI-AA-AA (AB)

Asset Accounting: Basic Functions – Asset Accounting

ANEK

Document Header Asset Posting

MANDT / BUKRS / ANLN1 / ANLN2 / GJAHR / LNRAN

ANEP

Asset Line Items

MANDT / BUKRS / ANLN1 / ANLN2 / GJAHR / LNRAN / AFABE

ANEV

Asset Downpymt Settlement

MANDT / BUKRS / ANLN1 / ANLN2 / GJAHR / LNRANS

ANKB

Asset Class: Depreciation Area

MANDT / ANLKL / AFAPL / AFABE / BDATU

ANLC

Asset value Fields

MANDT / BUKRS / ANLN1 / ANLN2 / GJAHR / AFABE

ANLH

Main Asset Number

MANDT / BUKRS / ANLN1

ANLP

Asset Periodic Values

MANDT / BUKRS / GJAHR / PERAF / AFBNR / ANLN1 / ANLN2 / AFABER

FI-SL-VSR (GVAL)

Special Purpose Ledger: Validation, Substitution and Rules

GB03

Validation / Substitution User

VALUSER

GB92

Substitutions

MANDT / SUBSTID

GB93

Validation

MANDT / VALID

Controlling

AUSP

Characteristic Values

MANDT / OBJEK / ATINN / ATZHL / MAFID / KLART / ADZHL

CO-KBAS

Overhead Cost Controlling

A132

Price per Cost Center

MANDT / KAPPL / KSCHL / KOKRS / VERSN / RESRC / KOSTL / DATBI

A136

Price per Controlling Area

MANDT / KAPPL / KSCHL / KOKRS / VERSN / RESRC / DATBI

A137

Price per Country / Region

MANDT / KAPPL / KSCHL / KOKRS / VERSN / RESRC / LAND1 / REGIO / DATBI

COSC

CO Objects: Assignment of Original Costing Sheets

MANDT / OBJNR / SCTYP / VERSN / GJAHR

CSSK

Cost Center / Cost Element

MANDT / VERSN / KOKRS / GJAHR / KOSTL / KSTAR

CSSL

Cost Center / Activity Type

MANDT / KOKRS / KOSTL / LSTAR / GJAHR

KAPS

CO Period Locks

MANDT / KOKRS / GJAHR / VERSN / VRGNG / PERBL

CO-KBASCORE

Overhead Cost Controlling: General Services

CSKA

Cost Elements (Data Dependent on Chart of Accounts)

MANDT / KTOPL / KSTAR

CSKB

Cost Elements (Data Dependent on Controlling Area)

MANDT / KOKRS / KSTAR / DATBI

CSKS

Cost Center Master Data

MANDT / KOKRS / KOSTL / DATBI

CSLA

Activity Master

MANDT / KOKRS / LSTAR / DATBI

CO-OM (KACC)

Overhead Cost Controlling

COBK

CO Object: Document Header

MANDT / KOKRS / BELNR

COEJ

CO Object: Line Items (by Fiscal Year)

MANDT / KOKRS / BELNR / BUZEI / PERBL

COEJL

CO Object: Line Items for Activity Types (by Fiscal Yr)

MANDT / KOKRS / BELNR / BUZEI / PERBL

COEJR

CO Object: Line Items for SKF (by Fiscal Year)

MANDT / KOKRS / BELNR / BUZEI / PERBL

COEJT

CO Object: Line Items for Prices (by Fiscal Year)

MANDT / KOKRS / BELNR / BUZEI / PERBL

COEP

CO Object: Line Items (by Period)

MANDT / KOKRS / BELNR / BUZEI

COEPL

CO Object: Line Items for Activity Types (by Period)

MANDT / KOKRS / BELNR / BUZEI

COEPR

CO Object: Line Items for SKF (by Period)

MANDT / KOKRS / BELNR / BUZEI

COEPT

CO Object: Line Items for Prices (by Period)

MANDT / KOKRS / BELNR / BUZEI

COKA

CO Object: Control Data for Cost Elements

MANDT / OBJNR / GJAHR / KSTAR / HRKFT

COKL

CO Object: Control Data for Activity Types

MANDT / LEDNR / OBJNR / GJAHR / VERSN

COKP

CO Object: Control Data for Primary Planning

MANDT / LEDNR / OBJNR / GJAHR / WRTTP / VERSN / KSTAR / HRKFT / VRGNG / VBUND / PARGB / BEKNZ / TWAER

COKR

CO Object: Control Data for Statistical Key Figures

MANDT / LEDNR / OBJNR / GJAHR / WRTTP / VERSN / STAGR / HRKFT / VRGNG

COKS

CO Object: Control Data for Secondary Planning

MANDT / LEDNR / OBJNR / GJAHR / WRTTP / VERSN / KSTAR / HRKFT / VRGNG / PAROB / USPOB / BEKNZ / TWAER

CO-OM-CEL (KKAL)

Cost Element Accounting (Reconciliation Ledger)

COFI01

Object Table for Reconciliation Ledger COFIT

MANDT / OBJNR

COFI02

Transaction Dependent Fields for Reconciliation Ledger

MANDT / OBJNR

COFIP

Single Plan Items for Reconciliation Ledger

RCLNT / GL_SIRID

COFIS

Actual Line Items for Reconciliation Ledger

RCLNT / GL_SIRID

CO-OM-CCA

Cost Center Accounting (Cost Accounting Planning RK-S) – What is RK-S

A138

Price per Company Code

MANDT / KAPPL / KSCHL / KOKRS /  VERSN / RESRC / BUKRS / GSBER / DATBI

A139

Price per Profit Center

MANDT / KAPPL / KSCHL / KOKRS /  VERSN / RESRC / PRCTR / DATBI

CO-OM-OPA(KABR)

Overhead Orders: Application Development R/3 Cost Accounting Settlement

AUAA

Settlement Document: Receiver Segment

MANDT / BELNR / LFDNR

AUAB

Settlement Document: Distribution Rules

MANDT / BELNR / BUREG / LFDNR

AUAI

Settlement Rules per Depreciation Area

MANDT / BELNR / LFDNR / AFABE

AUAK

Document Header for Settlement

MANDT / BELNR

AUAO

Document Segment: CO Objects to be Settled

MANDT / BELNR / LFDNR

AUAV

Document Segment: Transactions

MANDT / BELNR / LFDNR

COBRA

Settlement Rule for Order Settlement

MANDT / OBJNR

COBRB

Distribution Rules Settlement Rule Order Settlement

MANDT / OBJNR / BUREG / LFDNR

CO-OM-OPA (KAUF)

Overhead Orders: Cost Accounting Orders

AUFK

Order Master Data

MANDT / AUFNR

AUFLAY0

Enttity Table: Order Layouts

MANDT / LAYOUT

EC-PCA (KE1)

Profit Center Accounting

CEPC

Profit Center Master Data Table

MANDT / PRCTR / DATBI / KOKRS

CEPCT

Texts for Profit Center Master Data

MANDT / SPRAS / PRCTR / DATBI / KOKRS

CEPC_BUKRS

Assignment of Profit Center to a Company Code

MANDT / KOKRS / PRCTR / BUKRS

GLPCA

EC-PCA: Actual Line Items

RCLNT / GL_SIRID

GLPCC

EC-PCA: Transaction Attributes

MANDT / OBJNR

GLPCO

EC-PCA: Object Table for Account Assignment Element

MANDT / OBJNR

GLPCP

EC-PCA: Plan Line Items

RCLNT / GL_SIRID

EC-PCA BS (KE1C)

PCA Basic Settings: Customizing for Profit Center Accounting

A141

Dependent on Material and Receiver Profit Center

MANDT / KAPPL / KSCHL / KOKRS / WERKS / MATNR / PPRCTR / DATBI

A142

Dependent on Material

MANDT / KAPPL / KSCHL / WERKS / MATNR / DATBI

A143

Dependent on Material Group

MANDT / KAPPL / KSCHL / WERKS / MATKL / DATBI

Assigned Tags

      35 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sudhir S
      Sudhir S

      Hi Denis Souza,

         Really good content.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      can still improve ... but it helped me a lot!

      Author's profile photo Former Member
      Former Member

      Hi,

      Good content...it wil be great if you can give lil more explanation. So that beginners likes us can understand it easily.

      Regards,

      Chandra.

      Author's profile photo Sudhir S
      Sudhir S

      Hi Denis ,

          Could you add a similar content like this for MM & SD tables with the important fields so that will be very helpful.

      Thanks in advance.

      With Regards,

      Sudhir S

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Sorry, I don't have list from MM and SD tables... but I publish a list with FI-AA Tables and fields (Link below).

      rgds.

      Denis

      Important Tables in SAP AA

      Author's profile photo Former Member
      Former Member

      Hi Denis,

      Greetings,

      This being a very good doc. on Tables. I would be obliged if you could give me the T.Codes where we can see these FI and CO related tables, thanks.

      Thanking in Advance,

      Raghav.

      Author's profile photo Narasimhulu Konnipati
      Narasimhulu Konnipati

      FI Guys...This document may help you in searching of tables.

      You can have a quick reference to tables and important fields through this document.

      Thanks,

      Narasimhulu

      Author's profile photo Former Member
      Former Member

      Hi Narasimha Garu,

      Thanks for sharing this doc on tables. However, I have a small query, like, I need VAT report, so I would be obliged if you could suggest me on this.

      Im missing logic somewhere, thanks.

      Thanking in Advance,

      Raghav.

      Author's profile photo Former Member
      Former Member

      what all tables needs to be joined ?

      Author's profile photo Former Member
      Former Member

      Hi Raghav,

      Explore BSET Table.

      BSET - Tax Document Table.

      Regards,

      Jaymin R. Bhatt

      Author's profile photo Former Member
      Former Member

      Hi Jaymin,

      Greetings for the Day,

      Sure will work on this & let you know.

      Thanking in Advance,

      Raghav.

      Author's profile photo Former Member
      Former Member

      what all tables needs to be joined ?

      Author's profile photo Sachin Dhurve
      Sachin Dhurve

      i am little expecting indepth analysis for  FI-AR table  can you help me on that .

      it will be greatful ..

      Author's profile photo Muhammad Hussain
      Muhammad Hussain

      good content!!!!

      Author's profile photo Hamid Zahoor
      Hamid Zahoor

      its really very good content

      Author's profile photo Former Member
      Former Member

      Hi

      Good details but still some basic tables are missing vendor and Customer.

      Regards,

      Nitin

      Author's profile photo Former Member
      Former Member

      Hi Denis,

      Appreciate your efforts. Really a good content.

      But as you said the same has good scope for improvement.

      You may refer to the link given below which you will find very helpful for improvement.

      http://www.recercat.cat/bitstream/handle/2072/5419/PFCLopezRuizAnnex3.pdf?sequence=4

      Regards

      Chirag Shah

      Author's profile photo Former Member
      Former Member

      Very Good Content.

      Regards,

      Umamageshwaran.S

      Author's profile photo Former Member
      Former Member

      Hi Denis Souza, good document

      Regards

      ACR.Ruben

      Author's profile photo George Koshy
      George Koshy

      Very good content..

      I would like add some more to the CO list.

      SETNODE -Lower-level sets in set (basically gives the relation with different in nodes in hierarchies {or groups for cost center(s), cost element(s), account group(s)..etc}

      SETLEAF - Values in Sets {basically gives the relation between node to their related members like cost center(s), cost element(s), account(s)..etc}

      COSP - CO Object: Cost Totals for External Postings

      COSS - CO Object: Cost Totals for Internal Postings

      Author's profile photo Former Member
      Former Member

      good content, and a great start for reference purposes.

      Author's profile photo Former Member
      Former Member

      Thanks a lot.Really helpful.

      Regards,

      Monami.

      Author's profile photo Former Member
      Former Member

      Good document

      Arvind

      Author's profile photo bhawna sajwani
      bhawna sajwani

      Thumbs up! useful content...forever in bookmark!

      Author's profile photo Former Member
      Former Member

      It is really handy to have such information. Thanks a lot for sharing

      Author's profile photo Ganesh Sadula
      Ganesh Sadula

      Hi,Denis Souza,

      its really very Helpful Document ,

      Thank you very much,

      with regards,

      Ganesh

      Author's profile photo Former Member
      Former Member

      Good preparation.

      Regards,

      M.Mohan.

      Author's profile photo Ranu Eugene
      Ranu Eugene

      Hi Denis,

      Very well prepared Document and very helpful.

      Keep up the good work. 🙂

      Best of Luck.

      Regards

      Eugene

      Author's profile photo Lakshmi Sama
      Lakshmi Sama

      Hi Denis,

      Really it is a Good Document 🙂 and thanks for sharing such a wonderful document.

      Regrads,

      Lakshmi S

      Author's profile photo Erwin Leitner
      Erwin Leitner

      Hello,

      really very excellent content.

      thank you. ➕

      all the best

      Erwin

      Author's profile photo CA. Prasad Atmakuri
      CA. Prasad Atmakuri

      Hi

      Nice document

      Thanks for sharing

      Regards

      Prasad

      Author's profile photo Former Member
      Former Member

      Nice document.

      Author's profile photo Prashant Govind Rane
      Prashant Govind Rane

      Very Nice and Thanks for sharing!

      B/R

      Prashant Rane

      Author's profile photo Former Member
      Former Member

      Really good content in a single location

      Author's profile photo Siva Sankar
      Siva Sankar

      Rlevant stuff at one place thanks for providing comprehensive information...