sap所有表关系.pdf

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 document? 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 = 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 Purpose 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 Open 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)) 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) BSIP (Index for vendor validation of double documents) Company Code (BUKRS) Vendor (LIFNR) Currency (WAERS) Document Date (BLDAT) Reference Doc (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 (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) 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 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 (BUKRS) 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 (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 documents 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) 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 Accounting 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) Period (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。