SAP.Tablas MM utiles

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 Table Information

SAP Field Name (Field Description)

SAP Field Name (Field Description)

Useful Fields

Link Key
One-to-One
One

One
One-to-Many

One

SAP Table Name
(Table Description)

Many

Master Data Tables

CEPC = Profit Center Master Data Table
CSKS = Cost Center Master
KNA1 = Cutomer Master (General Data)
LFA1 = Vendor Master (GeneralData)
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

Tables:
BSAD
BSAS
BSEG
BSES
BSIK
BSISCost Center
Accounting

FI/CO
Table Mapping

PAYR
(Payment transfer medium file)
Paying Company (ZBUKR)
House Bank (HBKID)
Account (HKTID)
Payment Method (ZLSCH)
Check No (CHECKT)

BVOR
(Intercompany posting procedures)
Intercompany No (BVORG)
Company Code (BUKRS)
Fiscal Year (GJAHR)
Document No (BELNR)

VBLNR
BKPF
(Accounting document header)
Company Code (BUKRS)
DocumentNo (BELNR)
Fiscal Year (GJAHR)
All FI
documents

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)

BSIP
(Index for vendor validation of doubledocuments)
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)

Closed 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)

Open Items

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

Open Items

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)

Closed items

Closed items

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)

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)

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)

KNC1
(Customer master (trans figures))
Customer (KUNNR)
Company Code (BUKRS)
Fiscal Year (GJAHR)

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

SAP FI/CO
Financial Accounting

RFBLG
(Cluster for accounting
document)

BKPF
(Accounting document...