Important Tables in SAP FI-CO

Go To SE11  Click on Database Table Enter * and press F4  Select the Development Class  Press F4  You get a list of Objects and also – SAP Applications button⇒  Click on that ⇒ Select Financial Accounting

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
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s