Sap Tables

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 (Table Description) 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 (Index for 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...