SapTables(sap各模块主表明细及主键关系)

《SapTables(sap各模块主表明细及主键关系)》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、SAPTableRelationsversion1.0.0compiledbyChristopherSolomonwithcontributionsbyvariousSAPProfessionalsHowtousethisdocument?ThisdocumentdisplaysanddescribestherelationshipsandlinksbetweenthevariousSAPdatabasetables.Theserelationshipsaredisplayedgraphicallyasdescribedbelow:TableK

2、eyTransparentTableClusterTableSAPTableNameSAPTableInformationSAPTableName(TableDescription)(TableDescription)SAPFieldName(FieldDescription)SAPFieldName(FieldDescription)UsefulFieldsLinkKeyOne-to-OneOneOneOne-to-ManyOneManyMasterDataTablesCEPC=ProfitCenterMasterDataTableCSKS=

3、CostCenterMasterKNA1=CutomerMaster(GeneralData)LFA1=VendorMaster(GeneralData)MARA=MaterialMaster(GeneralData)SKB1=G/LAccountMaster(CompanyCode)T001W=Plants/BranchesT001=CompanyCodesSAP-FI/COAccountsPayableReconcillationLedgerGeneralFinancialSpecialPurposeLedgerAccountingLedg

4、erCustomLedgerAccountsReceivableControllingProfitCenterCostCenterAccountingAccountingTables:BSADBSASBSEGBSESBSIKBSISFI/COTableMappingBSIPPAYRBVOR(Indexforvendorvalidationofdouble(Paymenttransfermediumfile)(Intercompanypostingprocedures)documents)PayingCompany(ZBUKR)Intercomp

5、anyNo(BVORG)CompanyCode(BUKRS)HouseBank(HBKID)CompanyCode(BUKRS)Vendor(LIFNR)Account(HKTID)FiscalYear(GJAHR)Currency(WAERS)PaymentMethod(ZLSCH)DocumentNo(BELNR)DocumentDate(BLDAT)CheckNo(CHECKT)DuplicateInvoicesReferenceDoc(WRBTR)Amount(WRBTR)VBLNRDocumentNo(BELNR)FiscalYear

6、(GJAHR)LineItems(BUZEI)BKPF(Accountingdocumentheader)BSADCompanyCode(BUKRS)BSIK(Accounting:SecondaryindexforDocumentNo(BELNR)(Accounting:Secondaryindexforcustomers(cleareditems))FiscalYear(GJAHR)vendors)CompanyCode(BUKRS)CompanyCode(BUKRS)Customer(KUNNR)Vendor(LIFNR)SpecialG

7、/LTrans(UMSKS)SpecialG/LInd(UMSKZ)CloseditemsOpenItemsSpecialG/LTrans(UMSKS)ClearingDate(AUGDT)AllFISpecialG/LInd(UMSKZ)ClearingDoc(AUGBL)documentsClearingDate(AUGDT)ClearingDoc(AUGBL)AllocationNo(ZUONR)AllocationNo(ZUONR)FiscalYear(GJAHR)BSEGDocumentNo(BELNR)FiscalYear(GJAH

8、R)(Accountingdocumentsegment)LineItems(BUZEI)DocumentNo(BELNR)CompanyCode(B