This documentation is available to agents as Markdown at https://docs.synthesized.io/tdk/latest/user_guide/070_integrations/sap/table_reference/fi.md. For the complete documentation index, see llms.txt.

SAP process table reference: Finance (FI)

Tables touched by each Finance (FI) business process, shown side by side for SAP ECC and S/4HANA.

10 processes · 130 tables · Back to the process index

FI-01 · Manual G/L / journal posting (incl. VAT)

16 tables · 2 differ between ECC and S/4HANA.

I. Master data

ECC S/4HANA Description Notes

SKA1

SKA1

G/L account master at chart-of-accounts level — the account numbers you post to.

SKB1

SKB1

G/L account master at company-code level — field status, currency, and controls.

SKAT

SKAT

G/L account names and descriptions, per language.

II. Configuration

ECC S/4HANA Description Notes

T001

T001

Company code definitions — the legal entities you post within.

T003

T003

Document types (SA, KR, DR…) that classify each posting.

T007A

T007A

Tax codes — the VAT keys applied to a line.

T007S

T007S

Tax code names.

T030

T030

Automatic account determination — maps transactions to the accounts they post to.

III. Documents

ECC S/4HANA Description Notes

BKPF

BKPF

Accounting document header — one row per FI document.

S/4: Header only in S/4 — posted amounts live in ACDOCA.

BSEG

BSEG

Accounting document line items — the debit/credit lines.

—

ACDOCA

Universal Journal line items — the single source of truth for postings in S/4 (uses RCLNT/RBUKRS).

S/4HANA only

IV. Tax & index

ECC S/4HANA Description Notes

BSET

BSET

Tax line items — VAT and base amounts split out per document.

BSIS

BSIS

Open G/L account line-item index (secondary index for reporting).

S/4: Compatibility view over ACDOCA — query the physical source.

BSAS

BSAS

Cleared G/L account line-item index.

S/4: Compatibility view over ACDOCA — query the physical source.

GLT0

—

G/L account period totals — replaced by on-the-fly aggregation of ACDOCA in S/4.

Removed in S/4HANA

V. Number ranges

ECC S/4HANA Description Notes

NRIV

NRIV

Number range intervals — the current document-number counters.

FI-02 · Cross-company code posting (PC & PPC)

15 tables · 1 differs between ECC and S/4HANA.

I. Master data

ECC S/4HANA Description Notes

SKA1

SKA1

G/L account master, chart-of-accounts level.

SKB1

SKB1

G/L account master, company-code level.

CEPC

CEPC

Profit centre master data.

CEPCT

CEPCT

Profit centre names.

II. Configuration

ECC S/4HANA Description Notes

T001

T001

Company codes — a cross-company posting spans two of them.

T030

T030

Account determination, including cross-company clearing accounts.

SETNODE

SETNODE

Set hierarchy nodes — used for profit-centre groups.

SETLEAF

SETLEAF

Set leaf values — the individual members of those groups.

III. Documents

ECC S/4HANA Description Notes

BKPF

BKPF

Accounting document header — one document per company code.

S/4: Header only in S/4 — amounts in ACDOCA.

BSEG

BSEG

Accounting document line items.

—

ACDOCA

Universal Journal line items (uses RCLNT/RBUKRS).

S/4HANA only

IV. Cross-company & splitting

ECC S/4HANA Description Notes

BVOR

BVOR

Cross-company transaction index — links the two documents posted in each company code.

FAGL_SPLINFO

FAGL_SPLINFO

Document splitting information — how each line was split by profit centre/segment.

FAGL_SPLINFO_VAL

FAGL_SPLINFO_VAL

Document splitting amounts that accompany the split information.

V. Tax

ECC S/4HANA Description Notes

BSET

BSET

Tax line items per document.

FI-03 · Accounts payable (vendor invoice)

20 tables · 1 differs between ECC and S/4HANA.

I. Master data

ECC S/4HANA Description Notes

LFA1

LFA1

Vendor master, general data — name, address number, country.

LFB1

LFB1

Vendor master, company-code data — reconciliation account, payment terms.

LFBK

LFBK

Vendor bank details.

BUT000

BUT000

Business partner general data — the BP behind the vendor.

BUT020

BUT020

Business partner address assignments.

BUT100

BUT100

Business partner roles (uses MANDT).

CVI_VEND_LINK

CVI_VEND_LINK

Maps the business partner to the classic vendor number (uses CLIENT).

II. Configuration

ECC S/4HANA Description Notes

T001

T001

Company codes.

T003

T003

Document types.

T007A

T007A

Tax codes.

T074

T074

Special G/L account determination (down payments etc.).

T030

T030

Automatic account determination.

III. Documents

ECC S/4HANA Description Notes

BKPF

BKPF

Accounting document header.

S/4: Header only in S/4 — amounts in ACDOCA.

BSEG

BSEG

Accounting document line items.

—

ACDOCA

Universal Journal line items.

S/4HANA only

IV. Index & tax

ECC S/4HANA Description Notes

BSIK

BSIK

Open vendor line-item index.

S/4: Compatibility view over ACDOCA/BSEG.

BSAK

BSAK

Cleared vendor line-item index.

S/4: Compatibility view over ACDOCA/BSEG.

BSET

BSET

Tax line items.

WITH_ITEM

WITH_ITEM

Withholding tax line items per document.

V. Addresses

ECC S/4HANA Description Notes

ADRC

ADRC

Central address data (uses CLIENT) — referenced by both LFA1 and BUT020, so include both address numbers.

FI-04 · Accounts receivable (customer invoice)

17 tables · 1 differs between ECC and S/4HANA.

I. Master data

ECC S/4HANA Description Notes

KNA1

KNA1

Customer master, general data.

KNB1

KNB1

Customer master, company-code data.

BUT000

BUT000

Business partner general data.

BUT020

BUT020

Business partner address assignments.

BUT100

BUT100

Business partner roles (uses MANDT).

CVI_CUST_LINK

CVI_CUST_LINK

Maps the business partner to the classic customer number (uses CLIENT).

II. Configuration

ECC S/4HANA Description Notes

T001

T001

Company codes.

T003

T003

Document types.

T007A

T007A

Tax codes.

T074

T074

Special G/L account determination.

III. Documents

ECC S/4HANA Description Notes

BKPF

BKPF

Accounting document header.

S/4: Header only in S/4 — amounts in ACDOCA.

BSEG

BSEG

Accounting document line items.

—

ACDOCA

Universal Journal line items.

S/4HANA only

IV. Index & tax

ECC S/4HANA Description Notes

BSID

BSID

Open customer line-item index.

S/4: Compatibility view over ACDOCA/BSEG.

BSAD

BSAD

Cleared customer line-item index.

S/4: Compatibility view over ACDOCA/BSEG.

BSET

BSET

Tax line items.

V. Addresses

ECC S/4HANA Description Notes

ADRC

ADRC

Central address data (uses CLIENT).

FI-05 · Bank accounting (house banks & statement)

13 tables · 1 differs between ECC and S/4HANA.

I. Master data

ECC S/4HANA Description Notes

BNKA

BNKA

Bank master (bank keys / SWIFT) — has a MANDT column.

T012

T012

House banks per company code.

T012K

T012K

House bank accounts.

T012T

T012T

House bank account names.

BUT0BK

BUT0BK

Business partner bank details (S/4 BP model).

LFBK

LFBK

Vendor bank details.

KNBK

KNBK

Customer bank details.

II. Documents

ECC S/4HANA Description Notes

BKPF

BKPF

Accounting document header.

S/4: Header only in S/4 — amounts in ACDOCA.

BSEG

BSEG

Accounting document line items.

—

ACDOCA

Universal Journal line items.

S/4HANA only

III. Bank statement

ECC S/4HANA Description Notes

FEBKO

FEBKO

Electronic bank statement header.

FEBEP

FEBEP

Electronic bank statement line items.

FEBRE

FEBRE

Bank statement reference / clearing information.

FI-06 · Automatic payment program (F110)

15 tables · 1 differs between ECC and S/4HANA.

I. Master data

ECC S/4HANA Description Notes

LFA1

LFA1

Vendor master, general data.

LFB1

LFB1

Vendor master, company-code data.

LFBK

LFBK

Vendor bank details.

BNKA

BNKA

Bank master.

T012K

T012K

House bank accounts used for the payment.

II. Configuration

ECC S/4HANA Description Notes

T042

T042

Payment program company-code configuration.

T042Z

T042Z

Payment methods.

III. Payment run

ECC S/4HANA Description Notes

REGUV

REGUV

Payment run control and status header.

REGUH

REGUH

Payment run settlement data — one row per payment (payee, bank, amount).

REGUP

REGUP

Processed open items — the invoices each payment settles.

REGUT

REGUT

Payment medium / TemSe reference data.

IV. Accounting

ECC S/4HANA Description Notes

BKPF

BKPF

Payment document header.

S/4: Header only in S/4 — amounts in ACDOCA.

BSEG

BSEG

Payment document line items.

—

ACDOCA

Universal Journal line items.

S/4HANA only

BSAK

BSAK

Cleared vendor items after payment.

S/4: Compatibility view over ACDOCA/BSEG.

FI-07 · Dunning (F150)

10 tables · no differences between ECC and S/4HANA.

I. Master data

ECC S/4HANA Description Notes

KNA1

KNA1

Customer master, general data.

KNB1

KNB1

Customer master, company-code data.

KNB5

KNB5

Customer dunning data per company code (dunning level, last dunned).

II. Configuration

ECC S/4HANA Description Notes

T047A

T047A

Dunning procedures.

T047B

T047B

Dunning levels.

T047C

T047C

Dunning charges.

T047M

T047M

Dunning procedure keys / texts.

III. Run & index

ECC S/4HANA Description Notes

MHNK

MHNK

Dunning data header per account.

MHND

MHND

Dunning data line items — which open items were dunned.

BSID

BSID

Open customer items feeding the dunning run.

S/4: Compatibility view over ACDOCA/BSEG.

FI-08 · Tax on sales & purchases

8 tables · 1 differs between ECC and S/4HANA.

I. Configuration

ECC S/4HANA Description Notes

T007A

T007A

Tax codes.

T007S

T007S

Tax code names.

T030K

T030K

Tax account determination — accounts posted per tax code.

T005

T005

Country global settings (tax procedure per country).

II. Documents

ECC S/4HANA Description Notes

BKPF

BKPF

Accounting document header.

S/4: Header only in S/4 — amounts in ACDOCA.

BSEG

BSEG

Accounting document line items.

—

ACDOCA

Universal Journal line items.

S/4HANA only

III. Tax

ECC S/4HANA Description Notes

BSET

BSET

Tax line items — the VAT amounts and base amounts.

FI-09 · Foreign currency valuation

9 tables · 1 differs between ECC and S/4HANA.

I. Configuration

ECC S/4HANA Description Notes

T001

T001

Company codes.

TCURR

TCURR

Exchange rates.

TCURV

TCURV

Exchange rate types.

TCURF

TCURF

Exchange rate conversion factors.

T030H

T030H

Valuation / adjustment account determination.

II. Documents & index

ECC S/4HANA Description Notes

—

ACDOCA

Universal Journal line items — the valuation postings.

S/4HANA only

BSID

BSID

Open customer items being valued.

S/4: Compatibility view over ACDOCA/BSEG.

BSIK

BSIK

Open vendor items being valued.

S/4: Compatibility view over ACDOCA/BSEG.

BSIS

BSIS

Open G/L items being valued.

S/4: Compatibility view over ACDOCA.

FI-10 · Customer / vendor down payments

7 tables · 1 differs between ECC and S/4HANA.

I. Configuration

ECC S/4HANA Description Notes

T074

T074

Special G/L account determination — the down-payment accounts.

T030

T030

Automatic account determination.

II. Documents

ECC S/4HANA Description Notes

BKPF

BKPF

Accounting document header.

S/4: Header only in S/4 — amounts in ACDOCA.

BSEG

BSEG

Accounting document line items.

—

ACDOCA

Universal Journal line items.

S/4HANA only

III. Index

ECC S/4HANA Description Notes

BSID

BSID

Customer open items incl. special-G/L down payments.

S/4: Compatibility view over ACDOCA/BSEG.

BSIK

BSIK

Vendor open items incl. special-G/L down payments.

S/4: Compatibility view over ACDOCA/BSEG.

Other functional areas