Sap基本表关系

version 1.0.0

compiled by

Christopher Solomon

with

contributions by

v

arious SAP Professionals

SAP Table Relations

How to use this document?

This document displays and describes the relationships and links between the various SAP database

displayed graphically as described below:

Table Key

Trans

parent Table

SAP Table Nam

e

(Table Description)

SAP Field Name (Field Description)

SAP Table Information

Useful Fields

SAP

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

General

Ledger< /p>

Financial

Accounting

Special Purp

Ledger

Accounts< /p>

Receivable

Controlling

< br>

Profit Center

Accounting

Cost Cente

Accountin

FI/CO

Table Mapping

BVOR

(Intercom

pany posting procedures)

Intercompany No (BVORG)

Company Code (BUKRS)

Fiscal Year (GJAHR)

Document No (BELNR)

PA YR

(Paym

ent transfer m

edium

file)

Paying Company (ZBUKR)

House Bank (HBKID)

Account (HKTID)

Payment Method (ZLSCH)

Check No (CHECKT)

VBLN R

BKPF

(Accounting docum

ent header)

Company Code (BUKRS)

Document No (BELNR)

Fiscal Year (GJAHR)

Duplicate Invoices

BSIP

(Index for vendor validatio

docum

ents)

Company Code (BUKRS)

Vendor (LIFNR)

Currency (WAERS)

Document Date (BLDAT)

Reference Doc (WRBTR)

Amount (WRBTR)

Document No (BELNR)

Fiscal Year (GJAHR)

Line Items (BUZE

I)

BSAD

(Accounting: Secondary index for

custom

ers (cleared item

s))

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 (BUZE

I)

BSIK

(Accounting: Secondary in

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 (BUZE

I)

Closed items

A

l

l

F

I

d

o

c< /p>

u

m

e

n

t

s

Open Items

Open Items

BSID

(Accounting: Secondary index for

custom

ers)

BSEG

(Accounting docum

ent segm

ent)

Company Code (BUKRS)

Document No (BELNR)

Fiscal Year (GJAHR)

Line Item (BUZEI)

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

Open Items

Closed items

BSAK

(Accounting: Secondary in

vendors (cleared item

s))

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)

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)

A

I

l

l

F

d

u

o

c

m

e