sap所有表及关系

SAPTableRelationsversion1.0.0compiledbyChristopherSolomonwithcontributionsbyvariousSAPProfessionalsTableKeyLinkKeyOne-to-OneOne-to-ManyOneOneOneManySAPTableName(TableDescription)SAPFieldName(FieldDescription)UsefulFieldsSAPTableInformationHowtousethisdocument?SAPFieldName(FieldDescription)SAPTableName(TableDescription)TransparentTableClusterTableThisdocumentdisplaysanddescribestherelationshipsandlinksbetweenthevariousSAPdatabasetables.Theserelationshipsaredisplayedgraphicallyasdescribedbelow:MasterDataTablesCEPC=ProfitCenterMasterDataTableCSKS=CostCenterMasterKNA1=CutomerMaster(GeneralData)LFA1=VendorMaster(GeneralData)MARA=MaterialMaster(GeneralData)SKB1=G/LAccountMaster(CompanyCode)T001W=Plants/BranchesT001=CompanyCodesSAP-FI/COFinancialAccountingSpecialPurposeLedgerControllingAccountsPayableGeneralLedgerAccountsReceivableReconcillationLedgerCustomLedgerProfitCenterAccountingCostCenterAccountingTables:BSADBSASBSEGBSESBSIKBSISFI/COTableMappingAllFIdocumentsCloseditemsOpenItemsCloseditemsCloseditemsOpenItemsOpenItemsDuplicateInvoicesVBLNRLFC1(Vendormaster(transactionfigures))Vendor(LIFNR)CompanyCode(BUKRS)FiscalYear(GJAHR)KNC1(Customermaster(transfigures))Customer(KUNNR)CompanyCode(BUKRS)FiscalYear(GJAHR)BSAS(Accounting:SecondaryindexforG/Laccounts(cleareditems))CompanyCode(BUKRS)G/LAccount(HKONT)ClearingDate(AUGDT)ClearingDoc(AUGBL)AllocationNo(ZUONR)FiscalYear(GJAHR)DocumentNo(BELNR)LineItems(BUZEI)BSIP(Indexforvendorvalidationofdoubledocuments)CompanyCode(BUKRS)Vendor(LIFNR)Currency(WAERS)DocumentDate(BLDAT)ReferenceDoc(WRBTR)Amount(WRBTR)DocumentNo(BELNR)FiscalYear(GJAHR)LineItems(BUZEI)BSIK(Accounting:Secondaryindexforvendors)CompanyCode(BUKRS)Vendor(LIFNR)SpecialG/LTrans(UMSKS)SpecialG/LInd(UMSKZ)ClearingDate(AUGDT)ClearingDoc(AUGBL)AllocationNo(ZUONR)FiscalYear(GJAHR)DocumentNo(BELNR)LineItems(BUZEI)BSAK(Accounting:Secondaryindexforvendors(cleareditems))CompanyCode(BUKRS)Vendor(LIFNR)SpecialG/LTrans(UMSKS)SpecialG/LInd(UMSKZ)ClearingDate(AUGDT)ClearingDoc(AUGBL)AllocationNo(ZUONR)FiscalYear(GJAHR)DocumentNo(BELNR)LineItems(BUZEI)BVOR(Intercompanypostingprocedures)IntercompanyNo(BVORG)CompanyCode(BUKRS)FiscalYear(GJAHR)DocumentNo(BELNR)PAYR(Paymenttransfermediumfile)PayingCompany(ZBUKR)HouseBank(HBKID)Account(HKTID)PaymentMethod(ZLSCH)CheckNo(CHECKT)BSAD(Accounting:Secondaryindexforcustomers(cleareditems))CompanyCode(BUKRS)Customer(KUNNR)SpecialG/LTrans(UMSKS)SpecialG/LInd(UMSKZ)ClearingDate(AUGDT)ClearingDoc(AUGBL)AllocationNo(ZUONR)FiscalYear(GJAHR)DocumentNo(BELNR)LineItems(BUZEI)BKPF(Accountingdocumentheader)CompanyCode(BUKRS)DocumentNo(BELNR)FiscalYear(GJAHR)BSEG(Accountingdocumentsegment)CompanyCode(BUKRS)DocumentNo(BELNR)FiscalYear(GJAHR)LineItem(BUZEI)BSISCompanyCode(BUKRS)G/LAccount(HKONT)ClearingDate(AUGDT)ClearingDoc(AUGBL)AllocationNo(ZUONR)FiscalYear(GJAHR)DocumentNo(BELNR)LineItems(BUZEI)BSID(Accounting:Secondaryindexforcustomers)CompanyCode(BUKRS)Customer(KUNNR)SpecialG/LTrans(UMSKS)SpecialG/LInd(UMSKZ)ClearingDate(AUGDT)ClearingDoc(AUGBL)AllocationNo(ZUONR)FiscalYear(GJAHR)DocumentNo(BELNR)LineItems(BUZEI)AllFIdocumentsOnetimeaccountsTaxdocumentsFinancialAccountingPhysicalLogicalBKPF(Accountingdocumentheader)CompanyCodeDocumentNoFiscalYearBSECBSEDBSEGBSESBSETCompanyCodeDocumentNoFiscalYearLineItemCompanyCodeDocumentNoFiscalYearLineItemBKPF(Accountingdocumentheader)CompanyCodeDocumentNoFiscalYearCompanyCodeDocumentNoFiscalYearLineItemBSEG(Accountingdocumentsegment)BSEC(One-timeaccountdatadocumentsegment)BSET(Taxdatadocumentsegment)RFBLG(Clusterforaccountingdocument)SAPFI/COProfitCenterAccountingROBJNRCOBJNRCostCenterAccountingSpecialPurposeLedgerCOBJNRROBJNR________________________________________________________ExampleofaCustomLedgerReconcillationLedgerROBJNRSAPFI/COZZGLOObject(OBJNR)ZZGLTLedger(RLDNR)RecordType(RRCTY)Version(RVERS)FiscalYear(GJAHR)Object(ROBJNR)Object(SOBJNR)Currency(RTCUR)UOM(RUNIT)Debit/CreditInd(DRCRX)Period(RPMAX)ZZGLORecordNo(GL_SIRID)COFIT(Totalsrecords-reconciliationledger)Ledger(RLDNR)RecordType(RRCTY)Version(RVERS)FiscalYear(GJAHR)Object(ROBJNR)Object(COBJNR)Object(SOBJNR)Currency(RTCUR)UOM(RUNIT)Debit/CreditInd(DRCRX)Period(RPMAX)COFIO2(Transaction-dependentfieldsforreconciliationledger)Object(OBJNR)COFIO1(ObjectTableforReconciliationLedgerCOFIT)Object(OBJNR)COSP(COObject:CostTotals-ExternalPostings)Ledger(LEDNR)Object(J_OBJNR)FiscalYear(GJAHR)ValueType(WRTTP)Version(VERSN)CostElement(KSTAR)COKey(HRKFT)COTrans(VRGNG)TradingPartID(VBUND)TradingPartBA(PARGB)Debit/CreditInd(BEKNZ)Currency(TWAER)PeriodBlock(PERBL)COEP(COobject:period-relatedlineitems)ControllingArea(KOKRS)DocumentNo(BELNR)LineItem(BUZEI)COBKControllingArea(KOKRS)DocumentNo(BELNR)GLPCA(EC-PCA:ActualLineItems)RecordNo(GL_SIRID)GLPCO(EC-PCA:ObjectTableforAccountAssignmentElements)Object(OBJNR)GLPCT(EC-PCA:TotalsTable)Ledger(RLDNR)RecordType(RRCTY)PlanVersion(RVERS)FiscalYear(GJAHR)Object(ROBJNR)Object(COBJNR)Object(SOBJNR)Currency(RTCUR)UOM(RUNIT)Debit/CreditInd(DRCRX)Period(RPMAX)GLPCC(EC-PCA:Tran