文档介绍:SAP Table Relationsversion byChristopher Solomonwithcontributions byvarious SAP ProfessionalsTable KeyLink KeyOne-to-OneOne-to-ManyOneOneOneManySAP Table Name(Table Description)SAP Field Name (Field Description)Useful FieldsSAP Table InformationHow to use this document?SAP Field Name (Field Description)SAP Table Name(Table Description)Transparent TableCluster TableThis document displays and describes the relationships and links between the various SAP database tables. These relationships aredisplayed graphically as described below:Master Data TablesCEPC = Profit Center Master Data TableCSKS = Cost Center MasterKNA1 = Cutomer Master (General Data)LFA1 = Vendor Master (General Data)MARA = Material Master (General Data)SKB1 = G/L Account Master (Company Code)T001W = Plants/BranchesT001 = Company CodesSAP - FI/ountingSpecial ountsReceivableReconcillation LedgerCustomLedgerProfit ountingCost ountingTables:BSADBSASBSEGBSESBSIKBSISFI/COTable MappingAll FIdocumentsClosed itemsOpen ItemsClosed itemsClosed itemsOpen ItemsOpen ItemsDuplicate InvoicesVBLNRLFC1(Vendor master (transaction figures))Vendor (pany Code (BUKRS)Fiscal Year (GJAHR)KNC1(Customer master (trans figures))Customer (pany Code (BUKRS)Fiscal Year (GJAHR)BSAS(Accounting: Secondary index for G/ounts (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 pany 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 pany 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 forvendors (cleared items))Company Code (BUKRS)Vendor (LIFNR)Special G/L Trans (U