SAP Table Relations - ABAP

29 Pages·1999·0.07 MB·English

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 SAP Table Information SAP Table Name
(Table Description) (Table Description)
SAP Field Name (Field Description)
SAP Field Name (Field Description)
Useful Fields
Link Key
One-to-One
One One
One-to-Many
One Many
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 Financial Special Purpose
Ledger Accounting Ledger
Custom
Ledger
Accounts
Receivable
Controlling
Profit Center Cost Center
Accounting Accounting
Tables:
BSAD
BSAS
BSEG
BSES
BSIK
BSIS
FI/CO
Table Mapping
BSIP
BVOR PAYR (Index for vendor validation of double
(Intercompany posting procedures) (Payment transfer medium file) documents)
Intercompany No (BVORG) Paying Company (ZBUKR) Company Code (BUKRS)
Company Code (BUKRS) House Bank (HBKID) Vendor (LIFNR)
Account (HKTID)
Fiscal Year (GJAHR) Currency (WAERS)
Payment Method (ZLSCH)
Document No (BELNR) Document Date (BLDAT)
Check No (CHECKT) Duplicate Invoices Reference Doc (WRBTR)
Amount (WRBTR)
VBLNR Document No (BELNR)
Fiscal Year (GJAHR)
Line Items (BUZEI)
BKPF
(Accounting document header)
BSAD Company Code (BUKRS)
BSIK
(Accounting: Secondary index for Document No (BELNR)
(Accounting: Secondary index for
customers (cleared items)) Fiscal Year (GJAHR)
vendors)
Company Code (BUKRS)
Customer (KUNNR) s Company Code (BUKRS)
SSCppleeeaccriiiaanllg GG D//LLa tITenr d(aA n(UUs GM(UDSMTK)SZK)S) Closed items All FIcument Open Items VSSeppneedccoiiaarll (GGLI//FLLN ITnRrda) n(Us M(USMKSZK)S)
Clearing Doc (AUGBL) do Clearing Date (AUGDT)
Allocation No (ZUONR) Clearing Doc (AUGBL)
Fiscal Year (GJAHR) BSEG Allocation No (ZUONR)
Document No (BELNR) (Accounting document segment) Fiscal Year (GJAHR)
Line Items (BUZEI) Document No (BELNR)
Company Code (BUKRS) Line Items (BUZEI)
Document No (BELNR)
Fiscal Year (GJAHR)
Open ItemsLine Item (BUZEI) Closed items BSAK
(Accounting: Secondary index for
BSID
vendors (cleared items))
(Accounting: Secondary index for
customers) Company Code (BUKRS)
Vendor (LIFNR)
Company Code (BUKRS)
Special G/L Trans (UMSKS)
Customer (KUNNR)
Special G/L Ind (UMSKZ)
Special G/L Trans (UMSKS) Clearing Date (AUGDT)
Special G/L Ind (UMSKZ) Open Items Closed items Clearing Doc (AUGBL)
Clearing Date (AUGDT) Allocation No (ZUONR)
Clearing Doc (AUGBL)
Fiscal Year (GJAHR)
Allocation No (ZUONR)
Document No (BELNR)
Fiscal Year (GJAHR) Line Items (BUZEI)
Document No (BELNR)
Line Items (BUZEI) KNC1
(Customer master (trans figures))
BSAS Customer (KUNNR)
BSIS (Accounting: Secondary index for G/L Company Code (BUKRS)
accounts (cleared items)) Fiscal Year (GJAHR)
Company Code (BUKRS) Company Code (BUKRS)
G/L Account (HKONT) G/L Account (HKONT)
Clearing Date (AUGDT) Clearing Date (AUGDT)
Clearing Doc (AUGBL) Clearing Doc (AUGBL) LFC1
Allocation No (ZUONR) Allocation No (ZUONR) (Vendor master (transaction figures))
Fiscal Year (GJAHR) Fiscal Year (GJAHR) Vendor (LIFNR)
Document No (BELNR) Document No (BELNR) Company Code (BUKRS)
Line Items (BUZEI) Line Items (BUZEI)
Fiscal Year (GJAHR)
SAP FI/CO
Financial Accounting
BKPF RFBLG
(Accounting document header) (Cluster for accounting
document)
Company Code BSEC
Document No BSED
Fiscal Year BSEG Physical
BSES
BSET
BSEG
(Accounting document
segment)
m ents CDoocmupmaennyt CNoode
FI docu FLiinscea Ilt eYmear
All
BSEC
BKPF
One time accounts (One-time account data
(Accounting document header)
document segment)
Company Code
Document No Company Code Logical
Fiscal Year Tax docu DFLiionscceua Imlt eYemenat rNo
ments
BSET
(Tax data document
segment)
Company Code
Document No
Fiscal Year
Line Item
SAP FI/CO
Controlling Special Purpose Ledger
Profit Center GLPCA
Accounting (EC-PCA: Actual Line Items) Example of a Custom
Record No (GL_SIRID) Ledger
GLPCT
(EC-PCA: Totals Table) ZZGLO
Ledger(RLDNR) ROBJNR Object (OBJNR)
Record Type (RRCTY) GLPCO ROBJNR
Plan Version (RVERS)
(EC-PCA: Object Table for Account
Fiscal Year (GJAHR) Assignment Elements) ZZGLT
Object (ROBJNR)
Object (COBJNR) COBJNR Object (OBJNR)
Ledger(RLDNR)
Object (SOBJNR)
Record Type (RRCTY)
Currency (RTCUR) Version (RVERS)
UOM (RUNIT) ZZGLO
Fiscal Year (GJAHR)
Debit/Credit Ind (DRCRX)
Object (ROBJNR)
Period (RPMAX) Record No (GL_SIRID) Object (SOBJNR)
GLPCC Currency (RTCUR)
(EC-PCA: Transaction Attributes) UOM (RUNIT)
Object (OBJNR) Debit/Credit Ind (DRCRX)
Period (RPMAX)
________________________________________________________
Cost Center COEP Reconcillation COFIO2
(CO object: period-related line items) (Transaction-dependent fields for
COSPAccounting CDoocnutrmolelinntg N Aor e(BaE (KLNORK)RS) LCeOdFgITer COBJNR rOebcjoecntc (iOliaBtJioNnR l)edger)
Line Item (BUZEI)
(CO Object: Cost Totals - External (Totals records - reconciliation ledger)
Postings)
Ledger (LEDNR) Ledger(RLDNR)
Object (J_OBJNR) Record Type (RRCTY)
Fiscal Year (GJAHR) Version (RVERS)
Value Type (WRTTP) Fiscal Year (GJAHR) ROBJNR
Version (VERSN) Object (ROBJNR)
Cost Element (KSTAR) Object (COBJNR)
CO Key (HRKFT) Object (SOBJNR)
CO Trans (VRGNG) Currency (RTCUR)
COFIO1
Trading Part ID (VBUND) UOM (RUNIT)
(Object Table for Reconciliation
Trading Part BA (PARGB) COBK Debit/Credit Ind (DRCRX)
Ledger COFIT)
Debit/Credit Ind (BEKNZ) Period (RPMAX)
Currency (TWAER) Object (OBJNR)
Controlling Area (KOKRS)
Period Block (PERBL)
Document No (BELNR)
SAP FI/CO
Accounts Payable
Vendor Master Data
Purchasing Data General Data Company Code Data
LFM1 LFA1 LFB1
(Vendor master record purchasing (Vendor master (general section)) (Vendor master (company code))
organization data)
Vendor No (LIFNR) Vendor No (LIFNR)
Vendor No (LIFNR)
Company Code (BUKRS)
Purch Org (EKORG)
LFM2
(Vendor Master Record: Purchasing LFBK LFB5
Data) (Vendor master (bank details)) (Vendor master (dunning data))
Vendor No (LIFNR) Vendor No (LIFNR) Vendor No (LIFNR)
Purch Org (EKORG) Bank Cntry (BANKS) Company Code (BUKRS)
Sub-range (LTSNR) Bank Key (BANKL) Dunning Area (MABER)
Plant (WERKS) Bank Acc (BANKN)
SAP FI/CO
Accounts Receivable
Customer Master Data
Sales Area Data General Data Company Code Data
KNVP
(Customer Master Partner Functions)
Customer No (KUNNR)
Sales Org (VKORG)
KNA1 KNB1
Distribution Ch (VTWEG)
(General Data in Customer Master) (Customer master (company code))
Division (SPART)
Partner Function (PARVW) Customer No (KUNNR) Customer No (KUNNR)
Partner Counter (PARZA) Company Code (BUKRS)
KNVV
(Customer Master Sales Data)
Customer No (KUNNR)
KNB5
Sales Org (VKORG)
(Customer master (dunning data))
Distribution Ch (VTWEG)
Division (SPART) Customer No (KUNNR)
Company Code (BUKRS)
Dunning Area (MABER)
KNVD
(Customer master record sales
request form)
Customer No (KUNNR)
Sales Org (VKORG)
Distribution Ch (VTWEG)
Division (SPART)
Output Type (NA_KSCHL)
Mess Language (SPRAS)