💵SAP FI/CO: Mastering Tables and Relationships

Pesquisar

---

🇧🇷 Ver este post na versão em Português ↗
Welcome!
By Felipe Lamounier, state of Minas Gerais, Brazil – powered by 🙂My Easy B.I.

• LinkedIn
• Amazon
• Google
• E-mail
• Imagens
• Twitter
• Facebook

---

In this article we will identify the tables that are part of the SAP FI/CO module (Financial Accounting and Controlling) in the SAP ECC on HANA version.

In addition to listing the tables, their relationships and key fields will be shown. This way you will have an overview of the structure/architecture of SAP FI / CO.

---

---

📑 Table of Contents – Relationships:

• SAP FI/CO – Overview
• SAP FI/CO – Table mapping
• SAP FI/CO – Financial Accounting
• SAP FI/CO – General Ledger
• SAP FI/CO – Accounts Payable
• SAP FI/CO – Accounts Receivable
• SAP FI/CO – Master Data

📑 Table of Contents – Tables:

• BKPF – Accounting Document Header
• BSAD – Accounting: Secondary Index for Customers (Cleared Items)
• BSAK – Accounting: Secondary Index for Vendors (Cleared Items)
• BSAS – Accounting: Secondary Index for G/L Accounts (Cleared Items)
• BSEC – One-Time Account Data Document Segment
• BSED – Bill of Exchange Fields Document Segment
• BSEG – Accounting Document Segment
• BSES – Document Control Data (Obsolete)
• BSET – Tax Data Document Segment
• BSID – Accounting: Secondary Index for Customers
• BSIK – Accounting: Secondary Index for Vendors
• BSIP – Index for Vendor Validation of Double Documents
• BSIS – Accounting: Secondary Index for G/L Accounts
• BVOR – Intercompany posting procedures
• CEPC – Profit Center Master Data Table
• CEPCT – Texts for Profit Center Master Data
• COBK – CO Object: Document Header
• COEP – CO Object: Line Items (by Period)
• COFIO1 – Object Table for Reconciliation Ledger COFIT
• COFIO2 – Transaction-dependent fields for reconciliation ledger
• COFIT – Totals Records for Reconciliation Ledger
• COSP – CO Object: Cost Totals for External Postings
• CSKA – Cost Elements (Data Dependent on Chart of Accounts)
• CSKB – Cost Elements (Data Dependent on Controlling Area)
• CSKS – Cost Center Master Record
• CSKT – Cost Center Texts
• CSKU – Cost Element Texts
• GLPCA – EC-PCA: Actual Line Items
• GLPCC – EC-PCA: Transaction Attributes
• GLPCO – EC-PCA: Object Table for Account Assignment Elements
• GLPCT – EC-PCA: Totals Table
• KNA1 – General Data in Customer Master
• KNB1 – Customer Master (Company Code)
• KNB5 – Customer master (dunning data)
• KNC1 – Customer master (transaction figures)
• KNVD – Customer master record sales request form
• KNVP – Customer Master Partner Functions
• KNVV – Customer Master Sales Data
• LFA1 – Vendor Master (General Section)
• LFB1 – Vendor Master (Company Code)
• LFB5 – Vendor master (dunning data)
• LFBK – Vendor Master (Bank Details)
• LFC1 – Vendor master (transaction figures)
• LFM1 – Vendor master record purchasing organization data
• LFM2 – Vendor Master Record: Purchasing Data
• RFBLG – Cluster for accounting document
• PAYR – Payment Medium File
• SKA1 – G/L Account Master (Chart of Accounts)
• SKAT – G/L Account Master Record (Chart of Accounts: Description)
• SKB1 – G/L account master (company code)

Get more content

---

---

---

SAP FI/CO – Overview

---

SAP FI/CO – Table mapping

SAP FI/CO – Financial Accounting

---

SAP FI/CO – General Ledger

SAP FI/CO – Accounts Payable

---

SAP FI/CO – Accounts Receivable

---

SAP FI/CO – Master Data

Get more content

---

BKPF – Accounting Document Header

🔑 BUKRS – Company Code | (CHAR 4)
🔑 BELNR – Document Number of an Accounting Document | (CHAR 10)
🔑 GJAHR – Fiscal Year | (NUMC 4)

---

BSAD – Accounting: Secondary Index for Customers (Cleared Items)

🔑 BUKRS – Company Code | (CHAR 4)
🔑 KUNNR – Customer Number | (CHAR 10)
🔑 UMSKS – Special G/L Transaction Type | (CHAR 1)
🔑 UMSKZ – Special G/L Indicator | (CHAR 1)
🔑 AUGDT – Clearing Date | (DATS 8)
🔑 AUGBL – Document Number of the Clearing Document | (CHAR 10)
🔑 ZUONR – Assignment number | (CHAR 18)
🔑 GJAHR – Fiscal Year | (NUMC 4)
🔑 BELNR – Document Number of an Accounting Document | (CHAR 10)
🔑 BUZEI – Number of Line Item Within Accounting Document | (NUMC 3)

BSAK – Accounting: Secondary Index for Vendors (Cleared Items)

🔑 BUKRS – Company Code | (CHAR 4)
🔑 LIFNR – Account Number of Supplier | (CHAR 10)
🔑 UMSKS – Special G/L Transaction Type | (CHAR 1)
🔑 UMSKZ – Special G/L Indicator | (CHAR 1)
🔑 AUGDT – Clearing Date | (DATS 8)
🔑 AUGBL – Document Number of the Clearing Document | (CHAR 10)
🔑 ZUONR – Assignment number | (CHAR 18)
🔑 GJAHR – Fiscal Year | (NUMC 4)
🔑 BELNR – Document Number of an Accounting Document | (CHAR 10)
🔑 BUZEI – Number of Line Item Within Accounting Document | (NUMC 3)

---

BSAS – Accounting: Secondary Index for G/L Accounts (Cleared Items)

🔑 BUKRS – Company Code | (CHAR 4)
🔑 HKONT – General Ledger Account | (CHAR 10)
🔑 AUGDT – Clearing Date | (DATS 8)
🔑 AUGBL – Document Number of the Clearing Document | (CHAR 10)
🔑 ZUONR – Assignment number | (CHAR 18)
🔑 GJAHR – Fiscal Year | (NUMC 4)
🔑 BELNR – Document Number of an Accounting Document | (CHAR 10)
🔑 BUZEI – Number of Line Item Within Accounting Document | (NUMC 3)

---

Get more content

---

BSEC – One-Time Account Data Document Segment

🔑 BUKRS – Company Code | (CHAR 4)
🔑 BELNR – Document Number of an Accounting Document | (CHAR 10)
🔑 GJAHR – Fiscal Year | (NUMC 4)
🔑 BUZEI – Number of Line Item Within Accounting Document | (NUMC 3)

BSED – Bill of Exchange Fields Document Segment

🔑 BUKRS – Company Code | (CHAR 4)
🔑 BELNR – Document Number of an Accounting Document | (CHAR 10)
🔑 GJAHR – Fiscal Year | (NUMC 4)
🔑 BUZEI – Number of Line Item Within Accounting Document | (NUMC 3)

---

BSEG – Accounting Document Segment

🔑 BUKRS – Company Code | (CHAR 4)
🔑 BELNR – Document Number of an Accounting Document | (CHAR 10)
🔑 GJAHR – Fiscal Year | (NUMC 4)
🔑 BUZEI – Number of Line Item Within Accounting Document | (NUMC 3)

---

BSES – Document Control Data (Obsolete)

🔑 BUKRS – Company Code | (CHAR 4)
🔑 BELNR – Document Number of an Accounting Document | (CHAR 10)
🔑 GJAHR – Fiscal Year | (NUMC 4)
🔑 BUZEI – Number of Line Item Within Accounting Document | (NUMC 3)

---

BSET – Tax Data Document Segment

🔑 BUKRS – Company Code | (CHAR 4)
🔑 BELNR – Document Number of an Accounting Document | (CHAR 10)
🔑 GJAHR – Fiscal Year | (NUMC 4)
🔑 BUZEI – Number of Line Item Within Accounting Document | (NUMC 3)

BSID – Accounting: Secondary Index for Customers

🔑 BUKRS – Company Code | (CHAR 4)
🔑 KUNNR – Customer Number | (CHAR 10)
🔑 UMSKS – Special G/L Transaction Type | (CHAR 1)
🔑 UMSKZ – Special G/L Indicator | (CHAR 1)
🔑 AUGDT – Clearing Date | (DATS 8)
🔑 AUGBL – Document Number of the Clearing Document | (CHAR 10)
🔑 ZUONR – Assignment number | (CHAR 18)
🔑 GJAHR – Fiscal Year | (NUMC 4)
🔑 BELNR – Document Number of an Accounting Document | (CHAR 10)
🔑 BUZEI – Number of Line Item Within Accounting Document | (NUMC 3)

---

Get more content

---

BSIK – Accounting: Secondary Index for Vendors

🔑 BUKRS – Company Code | (CHAR 4)
🔑 LIFNR – Account Number of Supplier | (CHAR 10)
🔑 UMSKS – Special G/L Transaction Type | (CHAR 1)
🔑 UMSKZ – Special G/L Indicator | (CHAR 1)
🔑 AUGDT – Clearing Date | (DATS 8)
🔑 AUGBL – Document Number of the Clearing Document | (CHAR 10)
🔑 ZUONR – Assignment number | (CHAR 18)
🔑 GJAHR – Fiscal Year | (NUMC 4)
🔑 BELNR – Document Number of an Accounting Document | (CHAR 10)
🔑 BUZEI – Number of Line Item Within Accounting Document | (NUMC 3)

---

BSIP – Index for Vendor Validation of Double Documents

🔑 BUKRS – Company Code | (CHAR 4)
🔑 LIFNR – Account Number of Supplier | (CHAR 10)
🔑 WAERS – Currency Key | (CUKY 5)
🔑 BLDAT – Document Date in Document | (DATS 8)
🔑 XBLNR – Reference Document Number | (CHAR 16)
🔑 WRBTR – Amount in document currency | (CURR 13)
🔑 BELNR – Document Number of an Accounting Document | (CHAR 10)
🔑 GJAHR – Fiscal Year | (NUMC 4)
🔑 BUZEI – Number of Line Item Within Accounting Document | (NUMC 3)

---

BSIS – Accounting: Secondary Index for G/L Accounts

🔑 BUKRS – Company Code | (CHAR 4)
🔑 HKONT – General Ledger Account | (CHAR 10)
🔑 AUGDT – Clearing Date | (DATS 8)
🔑 AUGBL – Document Number of the Clearing Document | (CHAR 10)
🔑 ZUONR – Assignment number | (CHAR 18)
🔑 GJAHR – Fiscal Year | (NUMC 4)
🔑 BELNR – Document Number of an Accounting Document | (CHAR 10)
🔑 BUZEI – Number of Line Item Within Accounting Document | (NUMC 3)

BVOR – Intercompany posting procedures

🔑 BVORG – Number of a Cross-Company Code Posting Transaction | (CHAR 16)
🔑 BUKRS – Company Code | (CHAR 4)
🔑 GJAHR – Fiscal Year | (NUMC 4)
🔑 BELNR – Document Number of an Accounting Document | (CHAR 10)

---

CEPC – Profit Center Master Data Table

🔑 PRCTR – Profit Center | (CHAR 10)
🔑 DATBI – Valid To Date | (DATS 8)
🔑 KOKRS – Controlling Area | (CHAR 4)

---

CEPCT – Texts for Profit Center Master Data

🔑 SPRAS – Language Key | (LANG 1)
🔑 PRCTR – Profit Center | (CHAR 10)
🔑 DATBI – Valid To Date | (DATS 8)
🔑 KOKRS – Controlling Area | (CHAR 4)

---

Get more content

---

COBK – CO Object: Document Header

🔑 KOKRS – Controlling Area | (CHAR 4)
🔑 BELNR – Document Number | (CHAR 10)

COEP – CO Object: Line Items (by Period)

🔑 KOKRS – Controlling Area | (CHAR 4)
🔑 BELNR – Document Number | (CHAR 10)
🔑 BUZEI – Posting row | (NUMC 3)

---

COFIO1 – Object Table for Reconciliation Ledger COFIT

🔑 OBJNR – Object number for FI-SL tables | (CHAR 18)

---

COFIO2 – Transaction-dependent fields for reconciliation ledger

🔑 OBJNR – Object number for FI-SL tables | (CHAR 18)

---

COFIT – Totals Records for Reconciliation Ledger

🔑 RLDNR – Ledger | (CHAR 2)
🔑 RRCTY – Record Type | (CHAR 1)
🔑 RVERS – Version | (CHAR 3)
🔑 RYEAR – Fiscal Year | (NUMC 4)
🔑 ROBJNR – Object number for FI-SL tables | (CHAR 18)
🔑 COBJNR – Object number for FI-SL tables | (CHAR 18)
🔑 SOBJNR – Object number for FI-SL tables | (CHAR 18)
🔑 RTCUR – Currency Key for Amounts in Controlling Area Currency | (CUKY 5)
🔑 RUNIT – Base Unit of Measure | (UNIT 3)
🔑 DRCRK – Debit/Credit Indicator | (CHAR 1)
🔑 RPMAX – Period | (NUMC 3)

COSP – CO Object: Cost Totals for External Postings

🔑 LEDNR – Ledger for Controlling objects | (CHAR 2)
🔑 OBJNR – Object number | (CHAR 22)
🔑 GJAHR – Fiscal Year | (NUMC 4)
🔑 WRTTP – Value Type | (CHAR 2)
🔑 VERSN – Version | (CHAR 3)
🔑 KSTAR – Cost Element | (CHAR 10)
🔑 HRKFT – CO key subnumber | (CHAR 14)
🔑 VRGNG – CO Business Transaction | (CHAR 4)
🔑 VBUND – Company ID of Trading Partner | (CHAR 6)
🔑 PARGB – Trading partner’s business area | (CHAR 4)
🔑 BEKNZ – Debit/credit indicator | (CHAR 1)
🔑 TWAER – Transaction Currency | (CUKY 5)
🔑 PERBL – Period block | (NUMC 3)

---

Get more content

---

CSKA – Cost Elements (Data Dependent on Chart of Accounts)

🔑 KTOPL – Chart of Accounts | (CHAR 4)
🔑 KSTAR – Cost Element | (CHAR 10)

---

CSKB – Cost Elements (Data Dependent on Controlling Area)

🔑 KOKRS – Controlling Area | (CHAR 4)
🔑 KSTAR – Cost Element | (CHAR 10)
🔑 DATBI – Valid To Date | (DATS 8)

---

CSKS – Cost Center Master Record

🔑 KOKRS – Controlling Area | (CHAR 4)
🔑 KOSTL – Cost Center | (CHAR 10)
🔑 DATBI – Valid To Date | (DATS 8)

CSKT – Cost Center Texts

🔑 SPRAS – Language Key | (LANG 1)
🔑 KOKRS – Controlling Area | (CHAR 4)
🔑 KOSTL – Cost Center | (CHAR 10)
🔑 DATBI – Valid To Date | (DATS 8)

---

CSKU – Cost Element Texts

🔑 SPRAS – Language Key | (LANG 1)
🔑 KTOPL – Chart of Accounts | (CHAR 4)
🔑 KSTAR – Cost Element | (CHAR 10)

---

GLPCA – EC-PCA: Actual Line Items

🔑 GL_SIRID – Record number of the line item record | (CHAR 18)

---

GLPCC – EC-PCA: Transaction Attributes

🔑 OBJNR – Object number for FI-SL tables | (CHAR 18)

GLPCO – EC-PCA: Object Table for Account Assignment Elements

🔑 OBJNR – Object number for FI-SL tables | (CHAR 18)

---

GLPCT – EC-PCA: Totals Table

🔑 RLDNR – Ledger | (CHAR 2)
🔑 RRCTY – Record Type | (CHAR 1)
🔑 RVERS – Version | (CHAR 3)
🔑 RYEAR – Fiscal Year | (NUMC 4)
🔑 ROBJNR – Object number for FI-SL tables | (CHAR 18)
🔑 COBJNR – Object number for FI-SL tables | (CHAR 18)
🔑 SOBJNR – Object number for FI-SL tables | (CHAR 18)
🔑 RTCUR – Currency Key | (CUKY 5)
🔑 RUNIT – Base Unit of Measure | (UNIT 3)
🔑 DRCRK – Debit/Credit Indicator | (CHAR 1)
🔑 RPMAX – Period | (NUMC 3)

---

KNA1 – General Data in Customer Master

🔑 KUNNR – Customer Number | (CHAR 10)

---

KNB1 – Customer Master (Company Code)

🔑 KUNNR – Customer Number | (CHAR 10)
🔑 BUKRS – Company Code | (CHAR 4)

KNB5 – Customer master (dunning data)

🔑 KUNNR – Customer Number | (CHAR 10)
🔑 BUKRS – Company Code | (CHAR 4)
🔑 MABER – Dunning Area | (CHAR 2)

---

KNC1 – Customer master (transaction figures)

🔑 KUNNR – Customer Number | (CHAR 10)
🔑 BUKRS – Company Code | (CHAR 4)
🔑 GJAHR – Fiscal Year | (NUMC 4)

---

Get more content

---

KNVD – Customer master record sales request form

🔑 KUNNR – Customer Number | (CHAR 10)
🔑 VKORG – Sales Organization | (CHAR 4)
🔑 VTWEG – Distribution Channel | (CHAR 2)
🔑 SPART – Division | (CHAR 2)
🔑 DOCTP – Output Type | (CHAR 4)
🔑 SPRAS – Message language | (LANG 1)

---

KNVP – Customer Master Partner Functions

🔑 KUNNR – Customer Number | (CHAR 10)
🔑 VKORG – Sales Organization | (CHAR 4)
🔑 VTWEG – Distribution Channel | (CHAR 2)
🔑 SPART – Division | (CHAR 2)
🔑 PARVW – Partner Function | (CHAR 2)
🔑 PARZA – Partner counter | (NUMC 3)

KNVV – Customer Master Sales Data

🔑 KUNNR – Customer Number | (CHAR 10)
🔑 VKORG – Sales Organization | (CHAR 4)
🔑 VTWEG – Distribution Channel | (CHAR 2)
🔑 SPART – Division | (CHAR 2)

---

LFA1 – Vendor Master (General Section)

🔑 LIFNR – Account Number of Supplier | (CHAR 10)

---

LFB1 – Vendor Master (Company Code)

🔑 LIFNR – Account Number of Supplier | (CHAR 10)
🔑 BUKRS – Company Code | (CHAR 4)

---

LFB5 – Vendor master (dunning data)

🔑 LIFNR – Account Number of Supplier | (CHAR 10)
🔑 BUKRS – Company Code | (CHAR 4)
🔑 MABER – Dunning Area | (CHAR 2)

LFBK – Vendor Master (Bank Details)

🔑 LIFNR – Account Number of Supplier | (CHAR 10)
🔑 BANKS – Bank Country Key | (CHAR 3)
🔑 BANKL – Bank Keys | (CHAR 15)
🔑 BANKN – Bank account number | (CHAR 18)

---

LFC1 – Vendor master (transaction figures)

🔑 LIFNR – Account Number of Supplier | (CHAR 10)
🔑 BUKRS – Company Code | (CHAR 4)
🔑 GJAHR – Fiscal Year | (NUMC 4)

---

LFM1 – Vendor master record purchasing organization data

🔑 LIFNR – Vendor’s account number | (CHAR 10)
🔑 EKORG – Purchasing Organization | (CHAR 4)

---

Get more content

---

LFM2 – Vendor Master Record: Purchasing Data

🔑 LIFNR – Account Number of Supplier | (CHAR 10)
🔑 EKORG – Purchasing Organization | (CHAR 4)
🔑 LTSNR – Vendor Subrange | (CHAR 6)
🔑 WERKS – Plant | (CHAR 4)

RFBLG – Cluster for accounting document

🔑 BUKRS – Company Code | (CHAR 4)
🔑 BELNR – Document Number of an Accounting Document | (CHAR 10)
🔑 GJAHR – Fiscal Year | (NUMC 4)
🔑 PAGENO – Page | (INT2)

---

PAYR – Payment Medium File

🔑 ZBUKR – Paying Company Code | (CHAR 4)
🔑 HBKID – Short Key for a House Bank | (CHAR 5)
🔑 HKTID – ID for account details | (CHAR 5)
🔑 RZAWE – Payment Method | (CHAR 1)
🔑 CHECT – Check number | (CHAR 13)

---

SKA1 – G/L Account Master (Chart of Accounts)

🔑 KTOPL – Chart of Accounts | (CHAR 4)
🔑 SAKNR – G/L Account Number | (CHAR 10)

---

SKAT – G/L Account Master Record (Chart of Accounts: Description)

🔑 SPRAS – Language Key | (LANG 1)
🔑 KTOPL – Chart of Accounts | (CHAR 4)
🔑 SAKNR – G/L Account Number | (CHAR 10)

SKB1 – G/L account master (company code)

🔑 BUKRS – Company Code | (CHAR 4)
🔑 SAKNR – G/L Account Number | (CHAR 10)

---

---

✅ Conclusion

In this article you saw the tables of the SAP FI / CO (Financial Accounting and Controlling) module. Mainly you got to know how they interact with each other in the system knowing the relationship between the tables. All key fields have also been shown.

Use this article as a guide for the SAP FI/CO module and whenever you have a question, come back here to make your life easier!

Get more content

Keywords: SAP FI tables; sap fi co tables; list of sap fi co tables; SAP FI/CO; SAP ECC FI Relationship between tables SAP FI;sap FI academy; sap sd mm; sap fi sytem; main sap fi tables; sap fi legder tables; how sap FI CO works; SAP FI CO structure architecture;

Did you like the content? Want to get more tips? Subscribe ↗ for free!

---

Follow on social media:

• LinkedIn
• Amazon
• Google
• E-mail
• Imagens
• Twitter
• Facebook

---

• 
  How to Find Deleted VTTK Transport in SAP ECC
  por felipelamounier
  Bem Vindo! | Welcome! By Felipe Lamounier, Minas Gerais, Brasil🇧🇷 – powered by 🙂My Easy B.I. 📑 Table of Contents: Introduction In this post, we will learn how to identify which transports were deleted in SAP ECC. We will also see how this data is removed from the VTTK table over a specific period. InContinuar lendo “How to Find Deleted VTTK Transport in SAP ECC”
• 
  How to identify SAP BW Process Chains with Recurring Errors
  por felipelamounier
  This post by Felipe Lamounier focuses on identifying recurring errors in Process Chains (RSPC) within SAP BW over a 65-day period. It provides a structured approach to filter and analyze execution logs, aimed at improving resource management and system efficiency by addressing improperly executed chains. The analysis concludes with recommendations for maintaining or removing chains based on error frequency.
• 
  How to Retrieve SAP Table Metadata Efficiently
  por felipelamounier
  This post by Felipe Lamounier provides a guide on efficiently retrieving metadata from SAP table fields using transaction SE16 and the DD03M view. Key elements include data element, data type, field length, and descriptions. Additionally, the post lists important SAP system tables, enhancing understanding of SAP metadata extraction.