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