Important Tables in SAP FI & CO ( Controlling )

Its good to know about the important and frequently used tables in modules where we are working with.Here we are listing the tables in SAP FI & CO modules. List contains the table names with main field names and specific usage of that table.
Tables in CO Module
Tables in FI Module
Tables in Asset Accounting ( AA )

TABLES IN SAP CONTROLLING

Table Name : AUSP

Table Purpose : Characteristic Values

Fields:

• MANDT
• OBJEK
• ATINN
• ATZHL
• MAFID
• KLART
• ADZHL

CO-KBAS – Overhead Cost Controlling

Table Name : A132

Table Purpose : Price per CostCenter

Fields:

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

Table Name : A136

Table Purpose : Price per Controlling Area

Fields:

• MANDT
• KAPPL
• KSCHL
• KOKRS
• VERSN
• RESRC
• DATBI

Table Name : A137

Table Purpose : Price per Country / Region

Fields:

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

Table Name : COSC

Table Purpose : CO Objects: Assignment of Original Costing Sheets

Fields:

• MANDT
• OBJNR
• SCTYP
• VERSN
• GJAHR

Table Name : CSSK

Table Purpose : CostCenter / Cost Element

Fields:

• MANDT
• VERSN
• KOKRS
• GJAHR
• KOSTL
• KSTAR

Table Name : CSSL

Table Purpose : CostCenter / Activity Type

Fields:

• MANDT
• KOKRS
• KOSTL
• LSTAR
• GJAHR

Table Name : KAPS

Table Purpose : CO Period Locks

Fields:

• MANDT
• KOKRS
• GJAHR
• VERSN
• VRGNG
• PERBL

CO-KBASCORE – Overhead Cost Controlling: General Services

Table Name : CSKA

Table Purpose : Cost Elements (Data Dependent on Chart of Accounts)

Fields:

• MANDT
• KTOPL
• KSTAR

Table Name : CSKB

Table Purpose : Cost Elements (Data Dependent on Controlling Area)

Fields:

• MANDT
• KOKRS
• KSTAR
• DATBI

Table Name : CSKS

Table Purpose : CostCenter Master Data

Fields:

• MANDT
• KOKRS
• KOSTL
• DATBI

Table Name : CSLA

Table Purpose : Activity Master

Fields:

• MANDT
• KOKRS
• LSTAR
• DATBI

CO-OM (KACC) – Overhead Cost Controlling

Table Name : COBK

Table Purpose : CO Object: Document Header

Fields:

• MANDT
• KOKRS
• BELNR

Table Name : COEJ

Table Purpose : CO Object: Line Items (by Fiscal Year)

Fields:

• MANDT
• KOKRS
• BELNR
• BUZEI
• PERBL

Table Name : COEJL

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

Fields:

• MANDT
• KOKRS
• BELNR
• BUZEI
• PERBL

Table Name : COEJR

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

Fields:

• MANDT
• KOKRS
• BELNR
• BUZEI
• PERBL

Table Name : COEJT

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

Fields:

• MANDT
• KOKRS
• BELNR
• BUZEI
• PERBL

Table Name : COEP

Table Purpose : CO Object: Line Items (by Period)

Fields:

• MANDT
• KOKRS
• BELNR
• BUZEI

Table Name : COEPL

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

Fields:

• MANDT
• KOKRS
• BELNR
• BUZEI

Table Name : COEPR

Table Purpose : CO Object: Line Items for SKF (by Period)

Fields:

• MANDT
• KOKRS
• BELNR
• BUZEI

Table Name : COEPT

Table Purpose : CO Object: Line Items for Prices (by Period)

Fields:

• MANDT
• KOKRS
• BELNR
• BUZEI

Table Name : COKA

Table Purpose : CO Object: Control Data for Cost Elements

Fields:

• MANDT
• OBJNR
• GJAHR
• KSTAR
• HRKFT

Table Name : COKL

Table Purpose : CO Object: Control Data for Activity Types

Fields:

• MANDT
• LEDNR
• OBJNR
• GJAHR
• VERSN

Table Name : COKP

Table Purpose : CO Object: Control Data for Primary Planning

Fields:

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

Table Name : COKR

Table Purpose : CO Object: Control Data for Statistical Key Figures

Fields:

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

Table Name : COKS

Table Purpose : CO Object: Control Data for Secondary Planning

Fields:

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

CO-OM-CEL (KKAL) –  Cost Element Accounting (Reconciliation Ledger)

Table Name : COFI01

Table Purpose : Object Table for Reconciliation Ledger COFIT

Fields:

• MANDT
• OBJNR

Table Name : COFI02

Table Purpose : Transaction Dependent Fields for Reconciliation Ledger

Fields:

• MANDT
• OBJNR

Table Name : COFIP

Table Purpose : Single Plan Items for Reconciliation Ledger

Fields:

• RCLNT
• GL_SIRID

Table Name : COFIS

Table Purpose : Actual Line Items for Reconciliation Ledger

Fields:

• RCLNT
• GL_SIRID

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

Table Name : A138

Table Purpose : Price per Company Code

Fields:

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

Table Name : A139

Table Purpose : Price per ProfitCenter

Fields:

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

CO-OM-OPA(KABR) – Overhead Orders: Application Development R/3 Cost Accounting Settlement

Table Name : AUAA

Table Purpose : Settlement Document: Receiver Segment

Fields:

• MANDT
• BELNR
• LFDNR

Table Name : AUAB

Table Purpose : Settlement Document: Distribution Rules

Fields:

• MANDT
• BELNR
• BUREG
• LFDNR

Table Name : AUAI

Table Purpose : Settlement Rules per Depreciation Area

Fields:

• MANDT
• BELNR
• LFDNR
• AFABE

Table Name : AUAK

Table Purpose : Document Header for Settlement

Fields:

• MANDT
• BELNR

Table Name : AUAO

Table Purpose : Document Segment: CO Objects to be Settled

Fields:

• MANDT
• BELNR
• LFDNR

Table Name : AUAV

Table Purpose : Document Segment: Transactions

Fields:

• MANDT
• BELNR
• LFDNR

Table Name : COBRA

Table Purpose : Settlement Rule for Order Settlement

Fields:

• MANDT
• OBJNR

Table Name : COBRB

Table Purpose : Distribution Rules Settlement Rule Order Settlement

Fields:

• MANDT
• OBJNR
• BUREG
• LFDNR

CO-OM-OPA(KAUF) – Overhead Orders: Cost Accounting Orders

Table Name : AUFK

Table Purpose : Order Master Data

Fields:

• MANDT
• AUFNR

Table Name : AUFLAY0

Table Purpose : Enttity Table: Order Layouts

Fields:

• MANDT
• LAYOUT

EC-PCA (KE1) – Profit Center Accounting

Table Name : CEPC

Table Purpose : ProfitCenter Master Data Table

Fields:

• MANDT
• PRCTR
• DATBI
• KOKRS

Table Name : CEPCT

Table Purpose : Texts for ProfitCenter Master Data

Fields:

• MANDT
• SPRAS
• PRCTR
• DATBI
• KOKRS

Table Name : CEPC_BUKRS

Table Purpose : Assignment of ProfitCenter to a Company Code

Fields:

• MANDT
• KOKRS
• PRCTR
• BUKRS

Table Name : GLPCA

Table Purpose : EC-PCA: Actual Line Items

Fields:

• RCLNT
• GL_SIRID

Table Name : GLPCC

Table Purpose : EC-PCA: Transaction Attributes

Fields:

• MANDT
• OBJNR

Table Name : GLPCO

Table Purpose : EC-PCA: Object Table for Account Assignment Element

Fields:

• MANDT
• OBJNR

Table Name : GLPCP

Table Purpose : EC-PCA: Plan Line Items

Fields:

• RCLNT
• GL_SIRID

EC-PCA BS (KE1C) – PCA Basic Settings: Customizing for Profit Center Accounting

Table Name : A141

Table Purpose : Dependent on Material and ReceiverProfitCenter

Fields:

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

Table Name : A142

Table Purpose : Dependent on Material

Fields:

• MANDT
• KAPPL
• KSCHL
• WERKS
• MATNR
• DATBI

Table Name : A143

Table Purpose : Dependent on Material Group

Fields:

• MANDT
• KAPPL
• KSCHL
• WERKS
• MATKL
• DATBI