Details showing important Tables in SAP FI and CO Modules

[Former Member]

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