《Sap基本表关系.docx》由会员分享，可在线阅读，更多相关《Sap基本表关系.docx（34页珍藏版）》请在三一文库上搜索。
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)Material No (MATNR)Plant (WERKS)Source List No (ZEORD)SAP MM - Purchasing.专业整理 .Goods ReceiptS011(PURCHIS: Purchasing G