Structure and relationship overview for FI-FI tables

Transferred from

Jack Wu's blog

Http://silverw0396.iteye.com/blog/229280

 

Fi-data table diagram

Description of the table in the figure.
Parking documents

Vbkpf Document Header for document parking
Premade credential Header

Vbsega document segment for document parking-asset database
Pre-fabricated credential segment-asset database

Vbsegd document segment for customer document parking
Pre-fabricated customer creden

Vbsegk document segment for vendor document parking
Pre-fabricated supplier creden

Vbsegs document segment for document parking-g/L account database
Pre-fabricated credential section-general ledger account database

Vbset document segment for taxes document parking
Pre-fabricated tax credential Section

(Real) Documents

Bkpf accounting document header
Accounting credential title

Bseg accounting document segment
Accounting credential segment

BSID accounting: secondary index for MERs
Accounting: the customer's second index (if the business is cleared, the corresponding records will be deleted from the table and transferred to bsad)

Bsad accounting: secondary index for MERs (cleared items)
Accounting: the customer's second index (settled items)

Bsik accounting: secondary index for vendors
Accounting: The second index of the supplier (if the business is cleared, the corresponding records will be deleted from the table and transferred to bsak)

Bsak accounting: secondary index for vendors (cleared items)
Accounting: The second index of the supplier (settled items)

BSIS accounting: secondary index for g/L accounts
Accounting: Used for the second index of the general ledger account (if the business is cleared, the corresponding records are deleted from the table and transferred to BSAs)

BSAs accounting: secondary index for g/L accounts (cleared items)
Accounting: The second index of the general ledger account (settled items)

Customer related

Kna1 general data in customer master
General data of the customer's master file

Knb1 customer master (company code)
Customer master data (company code)

Knc1 customer master (transaction figures)
Customer master record (transaction amount)

Knc3 customer master (Special g/L transaction figures)
Customer master data (special general ledger business amount)

Vendor related

Lfa1 Vendor Master (General Section)
Supplier master data (General Region)

Lfb1 Vendor Master (company code)
Supplier master data (company code)

Lfc1 Vendor Master (transaction figures)
Supplier master data (business amount)

Lfc3 Vendor Master (Special g/L transaction figures)
Primary supplier (special general ledger transaction chart)

G/L related
Ska1 g/L account master (Chart of Accounts)
Master ledger (subject)

Skb1 g/L account master (company code)
General Ledger subject master record (company code)

Glt0 g/L account master record transaction figures
General Ledger subject master record business amount

Bank related

Bnka bank master record
Bank master record

Other document segment

Bset tax data document segment
Tax data credential Section

Bsed bill of exchange fields document segment
Bill of exchange field credential Section

BSEs document control data
Credential Control Data

BSEC one-time account data document segment
One-time account data credential segment