SAP Tech Pro

SAP Technical Blog
Topprice Price Comparison

Finance (FI) Tables

Finance (FI) Tables

Financial Documents

BKPF

Header Details

BSEG

Item Details

BSET

Tax Details

BSEC

One-Time Account Item Details

Accounts Receivable

BSID

Open Items

BSAD

Cleared Items

General Ledger

SKA1

Chart of Accounts

SKB1

Company Code

BSIS

Open Items

BSAS

Cleared Items

 

Cost Center

CSKS

Cost Center Master

CSKT

Cost Center Text

 

Listing/Exclusion

KOTG001- KOTG999

Listing/Exclusion Master Data (based on access sequences)

 

Finance (FI)

There are several different types of SAP transactions which can create a document both in FI as well as in the corresponding functional area of the activity. A few examples may be a material movement document, incoming payment from a customer, outgoing payment to a vendor, as well as direct postings in FI. FI tables can be viewed as a catch all for business transactions that have any direct impact on financial reporting. Because of the manner in which data is accumulated in FI, it becomes apparent just how much information is stored in these tables. This is an important piece of information to keep in mind at the onset of report design and code.

BKPF Accounting document header

This table is the header level table for accounting documents. Mainly consisting of transaction data, it contains information regarding the dates of creation, posting, clearing, as well as fiscal year and fiscal period of the posting of an accounting document. It is important to realize that fiscal year and period are different from calendar year and month, and are determined through the use of a fiscal year variant. This maps out the beginning and ending of each fiscal period and year to the calendar year.

The majority of financial reports are centered around activities for a given fiscal period or year. This information is contained in the header table BKPF. Also contained are several reference fields which contain the number of the document which was responsible for triggering the FI document in the first place. This is often the only means of linking an FI document to another functional area, i.e. SD or MM. These links are often necessary when additional information is required for a given business transaction that is simply not available in the accounting document.

BSEG Accounting document line item

This is the line item table related to BKPF, sharing the same document number as the key, as well as the line item number to distinguish all of the line items of a particular accounting document. This table is concerned with tracking of actual dollars and accounts and basically tracks values into and out of the general ledger. Supplemental information is abundant in this table including cost center, document number of the clearing document, tax information, and posting keys. BSEG may be one of the largest tables in SAP and can single-handily destroy performance of a report if not used carefully.

BSID Open items in accounting documents

This table could be considered a sub-set of BSEG. It only contains items from BSEG that have not yet been cleared. This is an advantage as far as performance is concerned and should be used as long as this matches the functional requirements of the report.

BSAD Cleared items

This is also a sub-set of BSEG. It contains the documents of BSEG that were not included in BSID since they have been cleared and thus have a clearing date and clearing document number. This is also very useful for the same reasons as described in the usage of the BSID table.

SKA1 G/L Account master, Chart of accounts

This table contains all general ledger accounts for a specific chart of accounts. The information contained therein is not company code specific, as there is master data for a G/L account that applies to all company codes. This table consists entirely of master data.

SKB1 G/L Account master, Company Code

This table is similar to the previous table regarding master data for G/L accounts. The main difference is that the data contained is specific to a general ledger accounts for a given company code. The same account may appear in this table multiple times but contain different information according to the company code. This table consists entirely of master data.

Add comment

Before Buying, Compare Prices at Topprice.in

Topprice.in