Currently Being Moderated

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

Comments

Delete Document

Are you sure you want to delete this document?