Sap基本表关系.docx

.专业整理 .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 graphically 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 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.专业整理 .AccountsPayableReconcillatioGeneralLedgerFinancialAccountingSpecial PurposeLedgerCustomLedgeAccountsReceivableControllingProfit CenterAccountingCost CenterAccountingTables :.学习帮手 .BSADBSASBSEGBSESBSIKBSIS.专业整理 .FI/COTable Mapping.学习帮手 .BVOR(Intercompany posting procedures)Intercompany No (BVORG)Company Code (BUKRS)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 (BUZEI)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)sItnClosed 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 Doc (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 (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)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 (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 YearBKPF(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 datadocument 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)Object (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).专业整理 .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 ect: 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 items)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 (GJAHR)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 Master 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 (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 (VTWEG)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)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 Code (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 DataCost 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)CSKB(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(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 PayableInvoiceVerification.学习帮手 .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).学习帮手 .专业整理 .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 (TDID)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 (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 (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 Assignment (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