SAP 常用表及表關(guān)系

SAPMM常用表及表關(guān)系一、MM常用表1、MARA:常規(guī)物料數(shù)據(jù)2、MARC:物料的工廠數(shù)據(jù)3、MAKT:物料描述4、MARD:物料的工廠/庫(kù)存地點(diǎn)數(shù)據(jù)5、MBEW:物料評(píng)估（財(cái)務(wù)數(shù)據(jù)），其中MBEW-WERKS指工廠6、MVKE:物料銷(xiāo)售數(shù)據(jù)7、MLGN:每一個(gè)倉(cāng)庫(kù)號(hào)物料數(shù)據(jù)（倉(cāng)庫(kù)）8、MLGT:每一個(gè)存儲(chǔ)類(lèi)型的物料數(shù)據(jù)（倉(cāng)庫(kù)/存儲(chǔ)類(lèi)型）8.1、MSTA:物料主記錄狀態(tài)9、LFA1:供應(yīng)商主數(shù)據(jù)（一般數(shù)據(jù)）10、LFB1:供應(yīng)商主數(shù)據(jù)（公司代碼）11、LFM1:供應(yīng)商采購(gòu)組織數(shù)據(jù)12、EINA:采購(gòu)信息記錄（一般數(shù)據(jù)）13、EINE:采購(gòu)信息記錄（采購(gòu)組織數(shù)據(jù)）14、EKKO:采購(gòu)訂單抬頭15、EKPO:采購(gòu)訂單行項(xiàng)目16、EKET:計(jì)劃協(xié)議計(jì)劃行17、EKKN:采購(gòu)憑證中的帳戶設(shè)置18、EKBE:采購(gòu)憑證歷史19、MKPF:物料憑證抬頭20、MSEG:物料憑證行項(xiàng)目21、RBKP:憑證抬頭供應(yīng)商發(fā)票數(shù)據(jù)22、RSEG:憑證項(xiàng)目供應(yīng)商發(fā)票數(shù)據(jù)EKKO/EKPO->MKPF/MSEG->RBKP/RSEG->BKPF-BSEG23、KNA1:客戶主數(shù)據(jù)（一般數(shù)據(jù)）24、KNB1:客戶主數(shù)據(jù)（公司代碼）25、KNVV:客戶主記錄銷(xiāo)售數(shù)據(jù)26、ADRC:地址27、EBAN:采購(gòu)申請(qǐng)MaterialsMARA-MaterialMaster:GeneraldataMAKT-MaterialMaster:DescriptionMARM-MaterialMaster:UnitofMeasureMAPE-Materialmaster:ExportcontrolfileMARC-Materialmaster:PlantdataMARD-Materialmaster:StoragelocationMAST-MateriallinktoBOMMBEW-MaterialvaluationMLGN-MaterialMaster:WMInventoryMLGT-MaterialMaster:WMInventorytypeMDIP-Material:MRPprofiles(fieldcontents)MKOP-Consignmentpricesegment(oldversionsofSAP)EBEW-ValuationofsalesorderstockQBEW-ValuationofprojectstockMVER-MaterialMaster:Consumption<Plant>DVER-MaterialMaster:Consumption<MRPArea>MVKE-MaterialMaster:Sales〈SalesOrg,DistrCh>MLAN-MaterialMaster:TaxindicatorMARC-MaterialMaster:PlantdataMAPR-MaterialMaster:ForecastMARD-MaterialMaster:StorageLocationMCH1-MaterialMaster:XPlantBatchesMCHA-MaterialMaster:BatchesMCHB-MaterialMaster:BatchStockMDMA-MRPAreadataDBVM-MRPPlanningFileEntry:MRPAreaMOFF-OutstandingMaterialMasterRecords(Maintenancestatus)MARCH-MaterialMasterCSegment:HistoryMARDH-MaterialMasterStorageLocationSegment:HistoryMBEWH-MaterialValuation:HistoryMCHBH-BatchStocks:HistoryMKOLH-SpecialStocksfromVendor:HistoryMSCAH-SalesOrderStockatVendor:HistoryMSKAH-SalesOrderStock:HistoryMSKUH-SpecialStocksatCustomer:HistoryMSLBH-SpecialStocksatVendor:HistoryMSPRH-ProjectStock:HistoryMSSAH-TotalSalesOrderStocks:HistoryMSSQH-TotalProjectStocks:HistoryVendorsLFA1-VendorMaster:GeneraldataLFB1-VendorMaster:CompanydataLFM1-VendorMaster:PurchasingData(Purchasingorganization)LFM2-VendorMaster:PurchasingData(Plant,Vendorsub-range)PurchasingEBAN-Purchaserequisition:itemsEBKN-PurchaseRequisition:accountassignmentSTXH-SAPScriptTextHeaderSTXL-SAPScriptTextLinesEKKO-PurchasingdocumentheaderEKPO-PurchasingDocument:ItemEKET-PurchasingDocument:DeliverySchedulesMDBS-MaterialViewofOrderItem/ScheduleLine(goodtofindopenPO's)EKKN-AccountassignmentinpurchasingdocumentEORD-PurchasingSourceListEIPA-OrderpricehistoryrecordEKAB-ReleasedocumentationEKBE-PurchasingdocumenthistoryEKBZ-Purchasingdocumenthistory:deliverycostsESKL-AccountassignmentspecificationforservicelineESKN-AccountassignmentinservicepackageESLH-ServicepackageheaderdataESLL-LinesinservicepackageESSR-ServiceentrysheetheaderdataESUC-Externalservicesmanagement:UnplannedlimitsforcontractitemESUH-Externalservicesmanagement:unplannedservicelimitsheaderdataESUP-Externalservicesmanagement:unplannedlimitsforservicepackagesESUS-Externalservicesmanagement:UnplannedlimitsforservicetypesEINA-PurchaseInfoRecord:GeneralEINE-Purchasinginforecord:purchasingorganizationdataKONP-ConditionItemKONH-ConditionHeaderInventoryManagementISEG-PhysicalinventorydocumentitemsMKPF-Materialdocument:HeaderMSEG-Materialdocument:itemRKPF-Reservation:HeaderRESB-Reservation:ItemInvoiceVerificationBSIM-Secondaryindex:documentsformaterialMYMFT-FIFOresultstableMYML-LIFOmateriallayerMYMLM-LIFOmateriallayer(monthly)MYMP-LIFOperiodstocks,singlematerialMYMP1-ReceiptdataLIFO/FIFOvaluationMYPL-LIFOpoollayerMYPLM-LIFOpoollayer(monthly)RBCO-Documentitem,incominginvoiceaccountassignmentRBDIFFKO-InvoiceVerification:conditionsRBDIFFME-InvoiceVerification:quantitydifferencesRBDRSEG-InvoiceVerificationbatch:invoicedocumentitemsRBKP-Documentheader:incominginvoiceRBKPB-Invoicedocumentheader(batchinvoiceverification)RBTX-Taxes:incominginvoiceRBVD-Invoicedocument:summarizationdataRBVDMAT-InvoiceVerification:summarizationdata,materialRBWT-Withholdingtax:incominginvoiceRKWA-ConsignmentwithdrawalsRSEG-Documentitem,incominginvoiceCustomisingandothermasterdataMDLV-MRPAreasMDLG-MRPAreas-StorageLocationsMDLW-MRPAreas-PlantsMDLL-MRPAreas-SubcontractorT023-MaterialGroupsT024-PurchasinggroupsT030-StandardAccountsTable(AutomaticAccountDetermination)T156-MovementTypeT156T-MovementType:TextAUSP-ReleaseProcedure:Strategyvalues(cl20n,cl24n)AGR_USERS-AssignmentofrolestousersCDHDR&CDPOS-ChangehistoryofmasterdataanddocumentsEDID4-EDIinformationTSTC-SAPTransactionCodes,lock/unlock:sm01,created:se93TSTCT-TransactioncodesTEXTNAST-Messagestatus

SAPMM-MasterDatagPu「亡nasingUBtsMA1P.Cif^krt-erialiMii3t?r:Pu「亡nasingUBtsMA1P.Cif^krt-erialiMii3t?r:CSygnwnrt、論it匕ridNa]MW「NF?IPlsntpAERKS)MLAIJ門(mén)農(nóng)fl■令兮Ifk■址皿n;M址自idull}論it匕ridNa]MW「NF?ICourtry〔凸LAhD)SAPMM-PurchasingRPurchasiriigInfoReiEordEINA^FurEl-QCIrqEINA^FurEl-QCIrqIniaRacord:□anorsibats)EINE[RltcJ-q匚IngInloHacord:PurchafflrigClrg^ni;imbo「iEteiaJIrdaHetE-id(INFNR)IniaRtDDid(INFNR)Fuichaain口DratE曲RD)——--1rdofiecdidl|pECESnkZ)Phrd如￡RK￡；i_____KONPI'CondiiionsfItsm|]KOMH[Corditians(l-teader|].-■'DondrtianNuENUhlH)CandilionNa(KHUMH^呂oqNdi^KOFOE)AQ17[IiWminIIntaRacariJ[Flsnl:?弓psciric：]|Applicationi：KAPPL：i匚andiflonr^pe(K5CHU'■.'■arid^r(lUFhlR)MdhiialNQtMATNR)FurcTiJilnqDrg(EKEIRG)Plant(\V￡R'IniaFlccoidCdkgory[ESOKEiValldilyCDATBrj_..——SAPMM?Purchasing謁PurchasingR皂qui號(hào)itionebkiiSTXHEBAN(PiijclidseRe(|iiisitionAccouiw(STXDSAP^criptfikIwM專(zhuān)門(mén)T--^sslgnmerrt)Te:：ds(TDOBJECT]PurehasngReq(E^NFN)RjrchasrgReq(BAhFN)TextName(TDNAIVE)Hem(BhFRO)Item(BNFPO)1B.：aId1.1L.'IL.'J—————_一一」FYegAccountAssignment(ZEBKN)Language(TDSFRAS.L__-7-JSTXL(STKDSAPscripttertliklilies}^(RELID)Te>ls(TDOBJECT]TextNamei：T匚悴沁TextId(TDID)Lariiiuaae[TDSFRASi(SRFF2jSAPMM-PurchasingPurchaseOrdersEKKNEKE7[Deliverj.rSchedulesjPurshjangDoci：；EQELN；EKKNEKE7[Deliverj.rSchedulesjPurshjangDoci：；EQELN；i~rtemrEBELF?[:,eliiiery5cheduk(ETENR)EINE(PurchasingInf-:-Rstc-rd:Purohasing0「口anDmta]InioRauid(1NFNR)Furthaslng口叩(EKuF；??)Iri1oRflc?:>idT>,ipS!(EG0K5PlantOlUEkS)___'EKPQ(PurchasingOdcumentItem)Pur^hjacinpDot(EQELhl)Hem(EEiELP)EIMA(PurchInfoPecord:GeneralOafaJInioRaMid(1NFNR)[!皿|_1「泥廠tFurGhdSinadogcebelh：!ftcmfEBELF)Accaun+Aacignman+i；ZEkk^J)3D11|PURCH:F'.jrcb.Groi.p盤(pán)詁呂ios〕Statist]c5i：SS0UR：i'./eEionCVRSIO)Monlh(3FMON)Dayi'SPTAG：iUi.ieeki：SP\J￥OC1PostingPeriod(SFBUF；iPuiohdfing0rgi：EKDR&)PuichasingroupfEKGRP)lenderNo(LIFNR)8D12|PUR匚HIE:Pur口hmsin日Statistics(33OUR：i'■/erionCVRSIO)Mon1h(3FMON)Dayi'SPTAG：!i.ri.ieek(SPWOCjPostingFeriod(SPBUF；iPurohdsingUrg(EKORft)F'urcnasing$roupfEKGRP)MaterialNo(MATNR)PlantfWERkS)inTaRecordCategoryi；E5OKZ^Materialtioup(MATKL：iInfaRecord(INFNR)C-:-ijntry(LAND1)Eh.h.0(PurchasingDdcumenthfeader'lFurchasinpDae(EBELH)EORD(尸urcha耳inpSourceList]MdierialNo(NATNR；iPlaritfWERkS)SourceLibNo(ZEClRD』SAPMM■PurchasingGiqqcIeREceipt￡011IPHRCHIS:PurchasiriegGroupMKPP(Hnctef:MNANOccun-Anl|C*qcurncntNa(MBLNR]FifoalYejr(MJAl-IRJMStG(DDCumanfcSagmcnl:Matariai)Dpc^mEntNo(MBLNR)Fi?uI■i,，ear(btJAhR)Linattom17EILEJ51a1ldlc￡(SSDUH)Vteion(VRGICOklonttiqSFMON]bjy(SPTA&)Weehi：5PW0C：iP^5lingPeriDd(GPBUP]FuiohitdngOrg(EP：nRG；iFuichaslnq^raup(EK&RF^Vtnd.：.rNo(UFNR)”一[HiHaryoTPurchazirig口DCLimant)PuichasingDdc[EBELhTirtemfEDCiJ3)Ae^ounlfl￡=hgn(^EP：KN；iTr^nsIjxpe""日鬲FisoalYearrMJAMR)EDurn4ntMe-(MBLNRjLlh￡>ItAm(ZEILE)”[MaterialMnsumpciori]Mdi4rij|NO|MATNR)PlantfWEHKS)FecalPftnDd(PEAI<Z)Fallo^-ohR?card￡(ZAHLR)&J31|兮Ipiisrtic-s:MavamortzIcrourrsnl￡lOCk￡]SLstijijcstSSOUH^Veision(^'RSiO；iUDn1hi^E.FMaN；iEyCSFTa腳Wtdii：spurac：iPastingPeriod(EPDUPJPljn!(WERKS)MdtEridlND(MATHR)StorageLo^fL'^OAT：iE-n-i?(FLIRCHISSialiccsTorV^rdcirEveJLaiian]EtJtldlci(ESnUH)-VedinnCVRSID)McnifiCSPMON)DjriSFTAS)畑曲i：SPWOC：iFoxingPtiiod三FBUF)PuiohasingOrg(EK口FK町PuiohJidrig^rc-up(Ek&RF^iVendorNO(UFNRf]'Ma^ridlNo(HATHR)Phn1(VltRk￡；ilrii*oRdcordCj1i；EEaKriInfoRecord(INFH卸SD常用表1、VBAK:銷(xiāo)售憑證：抬頭數(shù)據(jù)2、VBAP:銷(xiāo)售憑證：項(xiàng)目數(shù)據(jù)3、VBEP:銷(xiāo)售憑證：計(jì)劃行數(shù)據(jù)4、VBKD:銷(xiāo)售憑證：業(yè)務(wù)數(shù)據(jù)5、VBPA:銷(xiāo)售憑證：合作伙伴6、LIKP:SD憑證：交貨抬頭數(shù)據(jù)7、LIPS:SD憑證：交貨項(xiàng)目數(shù)據(jù)8、VBRK:出具發(fā)票：抬頭數(shù)據(jù)9、VBRP:出具發(fā)票：項(xiàng)目數(shù)據(jù)10、VBFA:銷(xiāo)售憑證流11、VBUK:銷(xiāo)售憑證：抬頭狀態(tài)和管理數(shù)據(jù)12、VBUP:銷(xiāo)售憑證：項(xiàng)目狀態(tài)13、T682I:條件：存取順序（產(chǎn)生格式）14、T681:條件：結(jié)構(gòu)15、T682Z:條件：存取順序（字段）16、T685:條件:類(lèi)型三、FICO常用表1、SKA1:總帳科目主記錄（科目表）2、SKB1:總帳科目主記錄（公司代碼）3、SKAT:總帳科目主記錄（描述）4、CSKB:成本要素5、BKPF:會(huì)計(jì)憑證抬頭6、BSEG:會(huì)計(jì)核算憑證項(xiàng)目數(shù)據(jù)，BSID客戶未清會(huì)計(jì)核算憑證/BSAD客戶已清會(huì)計(jì)核算憑證/BSIK供應(yīng)商未清會(huì)計(jì)核算憑證/BSAK供應(yīng)商已清會(huì)計(jì)核算憑證/BSIS總帳未清會(huì)計(jì)核算憑證/BSAS總帳已清會(huì)計(jì)核算憑證7、FAGLFLEXA:總賬實(shí)際行項(xiàng)目8、FAGLFLEXT:總賬匯總9、ANLA:資產(chǎn)主記錄段10、ANLC:資產(chǎn)值字段11、CSKS:成本中心主數(shù)據(jù)12、COEP:成本控制對(duì)象：與期間相關(guān)的各行項(xiàng)目13、COSS:CO對(duì)象:內(nèi)部過(guò)帳成本總計(jì)14、CO