Sap基本表关系

1、.专业整理 .SAP Table Relationsversion 1.0.0compiled byChristopher Solomonwithcontributions byvarious SAP Professionals.学习帮手 .专业整理 .How to use this document?This document displays and describes the relationships and links between the various SAP database tables. These relationships aredisplayed graphical

2、ly as described below:Trans parent TableSAP Table Name(Table Description)SAP Field Name (Field Description)Link Key.学习帮手 .One-to-OneOneOneOne-to-ManyOneManyTable KeyClus ter TableSAP Table InformationSAP Table Nam e(Table Description)Useful FieldsSAP Field Name (Field Description).专业整理 .Master Data

3、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 Codes.学习帮手 .SAP - FI/CO.专业整理 .AccountsPayable

4、ReconcillatioGeneralLedgerFinancialAccountingSpecial PurposeLedgerCustomLedgeAccountsReceivableControllingProfit CenterAccountingCost CenterAccountingTables :.学习帮手 .BSADBSASBSEGBSESBSIKBSIS.专业整理 .FI/COTable Mapping.学习帮手 .BVOR(Intercompany posting procedures)Intercompany No (BVORG)Company Code (BUKRS

5、)Fiscal Year (GJAHR)Document No (BELNR)BSAD(Accounting: Secondary index forcustomers (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 (BUZE

6、I)BSID(Accounting: Secondary index for custom ers)PAYR(Paym ent transfer medium file)Paying Company (ZBUKR)House Bank (HBKID).专业整理 .Account (HKTID)Payment Method (ZLSCH)Check No (CHECKT)Duplicate InvoicesVBLNRBKPF(Accounting document header)Company Code (BUKRS)Document No (BELNR)Fiscal Year (GJAHR)s

7、ItnClosed itemsFelmOpen ItemsluAcodBSEG(Accounting document segm ent)Company Code (BUKRS)Document No (BELNR)Fiscal Year (GJAHR)Line Item (BUZEI)Closed itemsOpen ItemsBSIP(Index for vendor validation of doubledocuments)Company Code (BUKRS)Vendor (LIFNR)Currency (WAERS)Document Date (BLDAT)Reference D

8、oc (WRBTR)Amount (WRBTR)Document No (BELNR)Fiscal Year (GJAHR)Line Items (BUZEI)BSIK(Accounting: Secondary index forvendors)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 (

9、BELNR)Line Items (BUZEI)BSAK(Accounting: Secondary index forvendors (cleared items)Company Code (BUKRS)Vendor (LIFNR)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

10、)Line Items (BUZEI)Open ItemsClosed itemsSpecial 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)KNC1.学习帮手 .BSISBSAS(Accounting: Secondary index for G/Laccounts (cleared items)Company Code (

11、BUKRS)Company Code (BUKRS)G/L Account (HKONT)G/L Account (HKONT)Clearing Date (AUGDT)Clearing Date (AUGDT)Clearing Doc (AUGBL)Clearing Doc (AUGBL)(Customer master (trans figCustomer (KUNNR)Company Code (BUKRS)Fiscal Year (GJAHR)LFC1BKPF(Accounting document header)Company CodeDocument NoFiscal YearBK

12、PF(Accounting document header)Company CodeDocument NoFiscal Year.学习帮手 .专业整理 .SAP FI/COFinancial AccountingRFBLG(Cluster for accountingdocument)BSECBSEDBSEGBSESBSETBSEG(Accounting documentsegment)Company CodetsDocument NoFiscal YearencumLine ItemI dol FlAOne time accountsBSEC(One-time account datadoc

13、ument segment)TCompany CodeDocument NoaxdocumFiscal YearLine ItementsBSET(Tax data documentsegment)Company CodeDocument NoFiscal YearLine ItemPhysicalLogicalSAP FI/COControllingProfit CenterAccountingGLPCT(EC-PCA: Totals Table)Ledger(RLDNR)Record Type (RRCTY)Plan Version (RVERS)Fiscal Year (GJAHR)Ob

14、ject (ROBJNR)Object (COBJNR)Object (SOBJNR)Currency (RTCUR)UOM (RUNIT)Debit/Credit Ind (DRCRX)Period (RPMAX)ROBJNRCOBJNRGLPCA(EC-PCA: Actual Line Items)Record No (GL_SIRID)GLPCO(EC-PCA: Object Table for AccountAssignment Elements)Object (OBJNR)GLPCC(EC-PCA: Transaction Attributes)Object (OBJNR).专业整理

15、 .Special Purpose LedgerExample of a CustomLedgerZZGLOObject (OBJNR)ROBJNRZZGLORecord No (GL_SIRID)ZZGLTLedger(RLDNR)Record Type (RRCTY)Version (RVERS)Fiscal Year (GJAHR)Object (ROBJNR)Object (SOBJNR)Currency (RTCUR)UOM (RUNIT)Debit/Credit Ind (DRCRX)Period (RPMAX)Cost CenterAccountingCOSP(CO Obj ec

16、t: Cost Totals - External Postings)Ledger (LEDNR)Object (J_OBJNR)Fiscal Year (GJAHR)Value Type (WRTTP)Version (VERSN).学习帮手 .Cost Element (KSTAR)CO Key (HRKFT)CO Trans (VRGNG)Trading Part ID (VBUND)Trading Part BA (PARGB)Debit/Credit Ind (BEKNZ)Currency (TWAER)COEP(CO object: period-related line item

17、s)Controlling Area (KOKRS)Document No (BELNR)Line Item (BUZEI)COBKControlling Area (KOKRS)_ReconcillationCOFIO2(Transaction-dependent fields forLedgerBJNRreconciliation ledger)COFITObject (OBJNR)CO(Totals records - reconciliation ledger)Ledger(RLDNR)Record Type (RRCTY)Version (RVERS)Fiscal Year (GJA

18、HR)ROBJNRObject (ROBJNR)Object (COBJNR)Object (SOBJNR)Currency (RTCUR)COFIO1UOM (RUNIT)(Object Table for ReconciliationDebit/Credit Ind (DRCRX)Ledger COFIT)Period (RPMAX)Object (OBJNR)Purchasing DataLFM1(Vendor master record purchasingorganization data)Vendor No (LIFNR)Purch Org (EKORG)LFM2(Vendor M

19、aster Record: PurchasingData)Vendor No (LIFNR)Purch Org (EKORG)Sub-range (LTSNR)Plant (WERKS).专业整理 .SAP FI/COAccounts PayableVendor M aster DataGeneral DataLFA1(Vendor master (general section)Vendor No (LIFNR)LFBK(Vendor master (bank details)Vendor No (LIFNR)Bank Cntry(BANKS)Bank Key(BANKL)Bank Acc

20、(BANKN)Company Code DataLFB1(Vendor master (company code)Vendor No (LIFNR)CompanyCode (BUKRS)LFB5(Vendor master (dunning data)Vendor No (LIFNR)CompanyCode (BUKRS)Dunning Area (MABER).学习帮手 .Sales Area DataKNVP(Customer Master Partner Functions)Customer No (KUNNR)Sales Org (VKORG)Distribution Ch (VTWE

21、G)Division (SPART)Partner Function (PARVW)Partner Counter (PARZA)KNVV(Customer Master Sales Data)Customer No (KUNNR)Sales Org (VKORG)Distribution Ch (VTWEG)Division (SPART).学习帮手 .KNVD(Custom er master record salesrequest form)Customer No (KUNNR)Sales Org (VKORG)Distribution Ch (VTWEG)Division (SPART

22、)Output Type (NA_KSCHL)SAP FI/CO.专业整理 .Accounts ReceivableCustomer Master DataGeneral DataCompany Code DataKNA1KNB1(General Data in Customer Master)(Customer master (company code)Customer No (KUNNR)Customer No (KUNNR)Company Code (BUKRS)KNB5(Customer master (dunning data)Customer No (KUNNR)Company C

23、ode (BUKRS)Dunning Area (MABER)Profit CenterCEPC(Profit center master data table)Profit Center (PRCTR)Valid to Date (DATBI)Controlling Area (KOKRS)CEPCT(Texts for Profit Center Master Data)Language (SPRAS)Profit Center (PRCTR)Valid to Date (DATBI)Controlling Area (KOKRS)SAP FI/CO.专业整理 .Master DataCo

24、st CenterCSKS(Cost center master)Controlling Area (KOKRS)Cost Center (KOSTL)Valid to Date (DATBI)CSKT(Cost Center Texts)Language (SPRAS)Controlling Area (KOKRS)Cost Center (KOSTL)Valid to Date (DATBI)Cost ElemetCSKA(Cost elements (data dependent onchart of accounts)COA (KTOPL)Cost Element (KSTAR)CSK

25、B(Cost elements (data dependent ocontrolling area)Controlling Area (KOKRS)COA (KTOPL)Cost Element (KSTAR)Valid to Date (DATBI)CSKU(Cost Element Texts)Language (SPRAS)COA (KTOPL)Cost Element (KSTAR)General Ledger.学习帮手 .SKB1(G/L account master (company code)Company Code (BUKRS)G/L Account (SAKNR)SKA1(

26、G/L accounts master (chart ofaccounts)COA (KTOPL)G/L Account (SAKNR)SKAT(G/L account master record (chart ofaccounts: description)Language (SPRAS)COA (KTOPL)G/L Account (SAKNR)SAP - Materials Management.专业整理 .PurchasingMaterials ManagementMaterials ManagementFinancial AccountingAccounts PayableInvoi

27、ceVerification.学习帮手 .Tables :EKKOEKPOKNMTMAKTKNMT(Customer-MaterialInfo Record DataTable).专业整理 .makt-matnr = knmt-matnrandmakt-spras = sy-languMAKT(MaterialDescription)MDKP(MRP Header)EKKO(Purchasing DocHeader)MDKP-DTNUM =MDTB-DTNUMEKPO-EBELN =EKKO-EBELNMDTB(MRP Detail)EKPO(Purchasing DocItem).学习帮手

28、.专业整理 .SAP MM - PurchasingPurchasing RequisitionSTXHEBAN(STXD SAPscript text file header)(Purchase Requisition)Texts (TDOBJECT)Purchasing Req (BANFN)Text Name (TDNAME)Item (BNFPO)Text Id (TDID)Language (TDSPRAS)STXL(STXD SAPscript text file lines)(RELID)Texts (TDOBJECT)Text Name (TDNAME)Text Id (TDI

29、D)Language (TDSPRAS)(SRTF2)EBKN(Purchase Requisition AccountAssignment)Purchasing Req (BANFN)Item (BNFPO)Preg Account Assignment (ZEBKN).学习帮手 .SAP MM - Purchasing.专业整理 .Purchase OrdersS011S012(PURCH: Purch. Group Statistics)(PURCHIS: Purchasing Statistics)Statistics (SSOUR)Statistics (SSOUR)Version

30、(VRSIO)Version (VRSIO)Month (SPMON)Month (SPMON)Day (SPTAG)Day (SPTAG)Week (SPWOC)Week (SPWOC)Posting Period (SPBUP)Posting Period (SPBUP)Purchasing Org (EKORG)Purchasing Org (EKORG)Purchasing Group (EKGRP)Purchasing Group (EKGRP)Vendor No (LIFNR)Material No (MATNR)Plant (WERKS)Info Record Category

31、(ESOKZ)Material Group (MATKL)Info Record (INFNR)Country (LAND1)EKET(Delivery Schedules)Purchasing Doc (EBELN)Item (EBELP)Delivery Schedule (ETENR)EKPO(Purchasing Document Item)Purchasing Doc (EBELN)Item (EBELP)EKKN(Account Assignment in PurchasingDocument)Purchasing Doc (EBELN)Item (EBELP)Account As

32、signment (ZEKKN).学习帮手 .EKKO(Purchasing Document Header)Purchasing Doc (EBELN)EINE(Purchasing Info Record: PurchasingOrganization Data)Info Record (INFNR)Purchasing Org (EKORG)Info Record Type (ESOKZ)Plant (WEKS)EINA(Purch Info Record: General Data)Info Record (INFNR)EORD(Purchasing Source List)Mater

33、ial No (MATNR)Plant (WERKS)Source List No (ZEORD)SAP MM - Purchasing.专业整理 .Goods ReceiptS011(PURCHIS: Purchasing GroupStatistics)Statistics (SSOUR)MKPFMSEGVersion (VRSIO)Month (SPMON)(Header: Material Document)(Docum ent Segm ent: Material)Day (SPTAG)Document No (MBLNR)Document No (MBLNR)Week (SPWOC

34、)Fiscal Year (MJAHR)Fiscal Year (MJAHR)Posting Period (SPBUP)Line Item (ZEILE)Purchasing Org (EKORG)Purchasing Group (EKGRP)Vendor No (LIFNR)S013(PURCHIS: Statistics for VendorEvaluation)S031Statistics (SSOUR)EKBEVersion (VRSIO)MVER(Statistics: Movements for currentMonth (SPMON)(History of Purchasin

35、g Document)(Material consumption)stocks)Day (SPTAG)Purchasing Doc (EBELN)Material NO (MATNR)Statistics (SSOUR)Week (SPWOC)Item (EBELP)Version (VRSIO)Posting Period (SPBUP)Plant (WERKS)Account Assign (ZEKKN)Month (SPMON)Purchasing Org (EKORG)Fiscal Year (GJAHR)Purchasing Group (EKGRP)Trans Type (VGAB

36、E)Period (P ERKZ)Day (SPTAG).学习帮手 .Follow -on Records (ZAHLR)Week (SPWOC)Vendor No (LIFNR)Fiscal Year (MJAHR)Document No (MBLNR)Posting Period (SPBUP)Material No (MATNR)Line Item (ZEILE)Plant (WERKS)Plant (WERKS)Material No (MATNR)Info Record Cat (ESOKZ)Storage Loc (LGORT)Info Record (INFNR)Purchasi

37、ng DataMARC(Material Master: C Segment)Material No (MATNR)Plant (WERKS)MLAN(Tax Classification: Material).学习帮手 .Material No (MATNR)Country (ALAND).专业整理 .SAP MM - Master DataBasic DataMAKT(Material Descriptions)Material No (MATNR)Language (SPRAS)MARA(Material Master: General Data)Material No (MATNR)M

38、ARM(Units of Measure)Material No (MATNR)UOM (MEINH)Accounting DataMBEW(Material Valuation)Material No (MATNR)Valuation Area (BWKEY)Valuation Type (BWTAR)SAP MM - Purchasing.专业整理 .Purchasing Info RecordKONP(Conditions (Item)KONH(Conditions (Header)Condition No (KNUMH)Seq No (KOPOS)Condition No (KNUMH)EINA(Purchasing Info Record: GeneralData)Info Record (INFNR)EINE(Purchasing Info Record: Purc