Submitted by: Submitted by bhattacharyak
Views: 495
Words: 3265
Pages: 14
Category: Business and Industry
Date Submitted: 02/18/2012 04:25 PM
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...