《资料_tables(表关联)》由会员分享,可在线阅读,更多相关《资料_tables(表关联)(27页珍藏版)》请在金锄头文库上搜索。
1、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 Acount Master (Company Code)T01W = Plants/BranchesT01 = Company CodesCEPC CSKS KNA1 LFA1 MARA SKB1 T
2、001W T001SAP Table Relationsversion 1.0.0compiled byChristopher Solomonwithcontributions byvarious SAP ProfesionalsTable KeyLink KeyOne-to-OneOne-to-ManyOne OneOne ManySAP Table Name(Table Description)SAP Field Name (Field Description) Useful FieldsSAP Table InformationHow to use this document?SAP F
3、ield Name (Field Description)SAP Table Name(Table Description)Transparent Table Cluster TableThis document displays and describes the relationships and links betwen the various SAP database tables. These relationships aredisplayed graphicaly as described below:BSAD BSAS BSEG BSES BSIK BSIS SAP - FI/
4、COFinancialAcounting Special PurposeLedgerControlingAcountsPayableGeneralLedgerAcountsReceivableReconcilation LedgerCustomLedgerProfit CenterAcounting Cost CenterAcountingTables:BSADBSASBSEGBSESBSIKBSI BVOR PAYR BSIP BSAD BKPF BSIK BSID BSEG BSAK BSIS BSAS KNC1 LFC1 FI/COTable MapingAl FIdocumentsCl
5、osed itemsOpen ItemsClosed itemsClosed itemsOpen ItemsOpen ItemsDuplicate InvoicesVBLNRLFC1(Vendor master (transaction figures)Vendor (LIFNR)Company Code (BUKRS)Fiscal Year (GJAHR)KNC1(Customer master (trans figures)Customer (KUNR)Company Code (BUKRS)Fiscal Year (GJAHR)BSAS(Acounting: Secondary inde
6、x for G/Lacounts (cleared items)Company Code (BUKRS)G/L Acount (HKONT)Clearing Date (AUGDT)Clearing Doc (AUBL)Alocation No (ZUONR)Fiscal Year (GJAHR)Document No (BELNR)Line Ites (BUZEI)BSIP(Index for vendor validation of doubledocuments)Copany Code (BUKRS)Vendor (LIFNR)Curency (WAERS)Document Date (
7、BLDAT)Refrence Doc (WRBTR)Amount (WRBTR)Document No (BELNR)Fiscal Year (GJAHR)Line Items (BUZEI)BSIK(Acounting: Secondary index forvendors)Company Code (BUKRS)Vendor (LIFNR)Special G/L Trans (UMSKS)Special /L Ind (USKZ)Clearing Date (AUGDT)Clearing Doc (AUBL)Alocation No (ZUONR)Fiscal Year (GJAHR)Do
8、cument No (BELNR)Line Ites (BUZEI)BSAK(Acounting: Secondary index forvendors (cleared items)Company Code (BUKRS)Vendor (LIFNR)Special G/L Trans (UMSKS)Special /L Ind (USKZ)Clearing Date (AUGDT)Clearing Doc (AUBL)Alocation No (ZUONR)Fiscal Year (GJAHR)Document No (BELNR)Line Ites (BUZEI)BVOR(Intercom
9、pany 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)Acount (HKTID)Payment Method (ZLSCH)Check No (CHECKT)BSAD(Acounting: Secondary index forcustomers (cleared items)Company
10、Code (BUKRS)Customer (KUNR)Special G/L Trans (UMSKS)Special /L Ind (USKZ)Clearing Date (AUGDT)Clearing Doc (AUBL)Alocation No (ZUONR)Fiscal Year (GJAHR)Document No (BELNR)Line Ites (BUZEI)BKPF(Acounting document header)Company Code (BUKRS)Docuent No (BELNR)Fiscal Year (GJAHR)BSEG(Acounting document
11、segment)Company Code (BUKRS)Docuent No (BELNR)Fiscal Year (GJAHR)Line Item (BUZEI)BSICompany Code (BUKRS)G/L Acount (HKONT)Clearing Date (AUGDT)Clearing Doc (AUBL)Alocation No (ZUONR)Fiscal Year (GJAHR)Document No (BELNR)Line Ites (BUZEI)BSID(Acounting: Secondary index forcustomers)Company Code (BUK
12、RS)Customer (KUNR)Special G/L Trans (UMSKS)Special /L Ind (USKZ)Clearing Date (AUGDT)Clearing Doc (AUBL)Alocation No (ZUONR)Fiscal Year (GJAHR)Document No (BELNR)Line Ites (BUZEI)GLPCT GLPCA GLPCO GLPCC COSP COEP COBK / ZZGLO ZZGLT COFIO 1 COFIO2 COFIT Profit CenterAcountingROBJNRCOBJNRCost CenterAc
13、ountingSpecial Purpose LedgerCOBJNRROBJNR_Example of a CustomLedgerReconcilationLedgerROBJNRSAP FI/COZGLOObject (OBJNR)ZGLTLedger(RLDNR)Record Type (RCTY)Version (RVERS)Fiscal Year (GJAHR)Object (ROBJNR)Object (SOBJNR)Curency (RTCUR)UOM (RUNIT)Debit/Credit Ind (DRCRX)Period (RPMAX)ZGLORecord No (GL_
14、SIRID)COFIT(Totals records - reconciliation ledger)Ledger(RLDNR)Record Type (RCTY)Version (RVERS)Fiscal Year (GJAHR)Object (ROBJNR)Object (COBJNR)Object (SOBJNR)Curency (RTCUR)UOM (RUNIT)Debit/Credit Ind (DRCRX)Period (RPMAX)COFIO2(Transaction-dependent fields forreconciliation ledger)Object (OBJNR)
15、COFIO1(Object Table for ReconciliationLedger COFIT)Object (OBJNR)COSP(CO bject: Cost Totals - ExternalPostings)Ledger (LEDNR)Object (J_OBJNR)Fiscal Year (GJAHR)Value Type (WRTP)Version (VERSN)Cost Element (KSTAR)CO Key (HRKFT)CO Trans (VRGNG)Trading Part ID (VBUND)Trading Part BA (PARGB)Debit/Credit
16、 Ind (BEKNZ)Curency (TWAER)Period Block (PERBL)COEP(CO object: period-related line items)Controling Area (KOKRS)Document No (BELNR)Line Ite (BUZEI)COBKControling Area (KOKRS)Document No (BELNR)GLPCA(EC-PCA: Actual Line Items)Record No (GL_SIRID)GLPCO(EC-PCA: Object Table for AcountAsignment Elements)Object (OBJNR)GLPCT(EC-PCA: Totals Table)Ledger(RLDNR)Record Type (RCTY)Plan Ver