Saptables

SAP Table Relations
version 1.0.0
compiled by

Christopher Solomon
with contributions by various SAP Professionals

How to use this document?

This document displays and describes the relationships and links between the various SAP database tables. These relationships are displayed graphically as described below:

Table Key
Transparent Table Cluster Table

SAP Table Name (TableDescription) SAP Field Name (Field Description)

SAP Table Information

SAP Table Name (Table Description) SAP Field Name (Field Description)

Useful Fields

Link Key
One-to-One One One-to-Many One Many One

Master Data Tables

CEPC = Profit Center Master Data Table CSKS = Cost Center Master KNA1 = Cutomer Master (General Data) LFA1 = Vendor Master (General Data) MARA = Material Master(General Data) SKB1 = G/L Account Master (Company Code) T001W = Plants/Branches T001 = Company Codes

SAP - FI/CO

Accounts Payable

Reconcillation Ledger

General Ledger

Financial Accounting

Special Purpose Ledger

Custom Ledger Accounts Receivable Controlling

Profit Center Accounting

Cost Center Accounting

Tables: BSAD BSAS BSEG BSES BSIK BSIS

FI/CO
Table MappingBVOR (Intercompany posting procedures) Intercompany No (BVORG) Company Code (BUKRS) Fiscal Year (GJAHR) Document No (BELNR)

PAYR (Payment transfer medium file) Paying Company (ZBUKR) House Bank (HBKID) Account (HKTID) Payment Method (ZLSCH) Check No (CHECKT) VBLNR BKPF (Accounting document header) Company Code (BUKRS) Document No (BELNR) Fiscal Year (GJAHR) All FI documents

BSIP (Indexfor vendor validation of double documents) Company Code (BUKRS) Vendor (LIFNR) Currency (WAERS) Document Date (BLDAT) Duplicate Invoices Reference Doc (WRBTR) Amount (WRBTR) Document No (BELNR) Fiscal Year (GJAHR) Line Items (BUZEI)

BSAD (Accounting: Secondary index for customers (cleared items)) Company Code (BUKRS) Customer (KUNNR) Special G/L Trans (UMSKS) Special G/L Ind (UMSKZ) Clearing Date(AUGDT) Clearing Doc (AUGBL) Allocation No (ZUONR) Fiscal Year (GJAHR) Document No (BELNR) Line Items (BUZEI)

Closed items

Open Items

Open Items BSID (Accounting: Secondary index for customers) Company Code (BUKRS) Customer (KUNNR) Special G/L Trans (UMSKS) Special G/L Ind (UMSKZ) Clearing Date (AUGDT) Clearing Doc (AUGBL) Allocation No (ZUONR) Fiscal Year (GJAHR) Document No (BELNR)Line Items (BUZEI)

BSEG (Accounting document segment) Company Code (BUKRS) Document No (BELNR) Fiscal Year (GJAHR) Line Item (BUZEI)

BSIK (Accounting: Secondary index for vendors) Company Code (BUKRS) Vendor (LIFNR) Special G/L Trans (UMSKS) Special G/L Ind (UMSKZ) Clearing Date (AUGDT) Clearing Doc (AUGBL) Allocation No (ZUONR) Fiscal Year (GJAHR) Document No (BELNR) Line Items (BUZEI)Closed items

Open Items

Closed items

BSAK (Accounting: Secondary index for vendors (cleared items)) Company Code (BUKRS) Vendor (LIFNR) Special G/L Trans (UMSKS) Special G/L Ind (UMSKZ) Clearing Date (AUGDT) Clearing Doc (AUGBL) Allocation No (ZUONR) Fiscal Year (GJAHR) Document No (BELNR) Line Items (BUZEI) KNC1 (Customer master (trans figures)) Customer (KUNNR) Company Code (BUKRS) FiscalYear (GJAHR)

BSIS Company Code (BUKRS) G/L Account (HKONT) Clearing Date (AUGDT) Clearing Doc (AUGBL) Allocation No (ZUONR) Fiscal Year (GJAHR) Document No (BELNR) Line Items (BUZEI)

BSAS (Accounting: Secondary index for G/L accounts (cleared items)) Company Code (BUKRS) G/L Account (HKONT) Clearing Date (AUGDT) Clearing Doc (AUGBL) Allocation No (ZUONR) Fiscal Year (GJAHR) Document No(BELNR) Line Items (BUZEI)

LFC1 (Vendor master (transaction figures)) Vendor (LIFNR) Company Code (BUKRS) Fiscal Year (GJAHR)

SAP FI/CO Financial Accounting

BKPF (Accounting document header) Company Code Document No Fiscal Year BSEC BSED BSEG BSES BSET

RFBLG (Cluster for accounting document)

Physical

BSEG (Accounting document segment)
en ts

A

F ll

I

do

c

um...