《sap所有表关系》由会员分享,可在线阅读,更多相关《sap所有表关系(29页珍藏版)》请在金锄头文库上搜索。
1、SAP Table Relations version 1.0.0 compiled by Christopher Solomon with contributions by various SAP Professionals Table Key Link Key One-to-One One-to-Many OneOne OneMany SAP Table Name (Table Description) SAP Field Name (Field Description) Useful Fields SAP Table Information How to use this documen
2、t? SAP Field Name (Field Description) SAP Table Name (Table Description) Transparent TableCluster Table This document displays and describes the relationships and links between the various SAP database tables. These relationships are displayed graphically as described below: Master Data Tables CEPC
3、= 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 Financial Accounting Special Pu
4、rpose Ledger Controlling Accounts Payable General Ledger Accounts Receivable Reconcillation Ledger Custom Ledger Profit Center Accounting Cost Center Accounting Tables: BSAD BSAS BSEG BSES BSIK BSIS FI/CO Table Mapping All FI documents Closed items Open Items Closed items Closed items Open Items Ope
5、n Items Duplicate Invoices VBLNR LFC1 (Vendor master (transaction figures) Vendor (LIFNR) Company Code (BUKRS) Fiscal Year (GJAHR) KNC1 (Customer master (trans figures) Customer (KUNNR) Company Code (BUKRS) Fiscal Year (GJAHR) BSAS (Accounting: Secondary index for G/L accounts (cleared items) Compan
6、y Code (BUKRS) G/L Account (HKONT) Clearing Date (AUGDT) Clearing Doc (AUGBL) Allocation No (ZUONR) Fiscal Year (GJAHR) Document No (BELNR) Line Items (BUZEI) BSIP (Index for vendor validation of double documents) Company Code (BUKRS) Vendor (LIFNR) Currency (WAERS) Document Date (BLDAT) Reference D
7、oc (WRBTR) Amount (WRBTR) Document No (BELNR) Fiscal Year (GJAHR) Line Items (BUZEI) 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 (GJAH
8、R) 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
9、Items (BUZEI) 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) BSAD (Accounting: Secondary
10、 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) BKPF (Accounting document header) Company Code (BUK
11、RS) Document No (BELNR) Fiscal Year (GJAHR) BSEG (Accounting document segment) Company Code (BUKRS) Document No (BELNR) Fiscal Year (GJAHR) Line Item (BUZEI) BSIS Company Code (BUKRS) G/L Account (HKONT) Clearing Date (AUGDT) Clearing Doc (AUGBL) Allocation No (ZUONR) Fiscal Year (GJAHR) Document No
12、 (BELNR) Line Items (BUZEI) 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) All FI docu
13、ments One time accounts Tax documents Financial Accounting Physical Logical BKPF (Accounting document header) Company Code Document No Fiscal Year BSEC BSED BSEG BSES BSET Company Code Document No Fiscal Year Line Item Company Code Document No Fiscal Year Line Item BKPF (Accounting document header)
14、Company Code Document No Fiscal Year Company Code Document No Fiscal Year Line Item BSEG (Accounting document segment) BSEC (One-time account data document segment) BSET (Tax data document segment) RFBLG (Cluster for accounting document) SAP FI/CO Profit Center Accounting ROBJNR COBJNR Cost Center A
15、ccounting Special Purpose Ledger COBJNR ROBJNR _ Example of a Custom Ledger Reconcillation Ledger ROBJNR SAP FI/CO ZZGLO Object (OBJNR) ZZGLT Ledger(RLDNR) Record Type (RRCTY) Version (RVERS) Fiscal Year (GJAHR) Object (ROBJNR) Object (SOBJNR) Currency (RTCUR) UOM (RUNIT) Debit/Credit Ind (DRCRX) Pe
16、riod (RPMAX) ZZGLO Record No (GL_SIRID) COFIT (Totals records - reconciliation ledger) Ledger(RLDNR) Record Type (RRCTY) Version (RVERS) Fiscal Year (GJAHR) Object (ROBJNR) Object (COBJNR) Object (SOBJNR) Currency (RTCUR) UOM (RUNIT) Debit/Credit Ind (DRCRX) Period (RPMAX) COFIO2 (Transaction-dependent fields for reconciliation ledger) Object (OBJNR) COFIO1 (Object Table for Reconciliation Ledger COFIT) Object (OBJNR) COSP (CO Object: C