SAP 常用表及表关系

SAPMM常用表及表关系一、MM常用表1、MARA:常规物料数据2、MARC:物料的工厂数据3、MAKT:物料描述4、MARD:物料的工厂/库存地点数据5、MBEW:物料评估（财务数据），其中MBEW-WERKS指工厂6、MVKE:物料销售数据7、MLGN:每一个仓库号物料数据（仓库）8、MLGT:每一个存储类型的物料数据（仓库/存储类型）8.1、MSTA：物料主记录状态9、LFA1:供应商主数据（一般数据）10、LFB1:供应商主数据（公司代码）11、LFM1:供应商采购组织数据12、EINA:采购信息记录（一般数据）13、EINE:采购信息记录（采购组织数据）14、EKKO:采购订单抬头15、EKPO:采购订单行项目16、EKET:计划协议计划行17、EKKN:采购凭证中的帐户设置18、EKBE:采购凭证历史19、MKPF:物料凭证抬头20、MSEG:物料凭证行项目21、RBKP:凭证抬头供应商发票数据22、RSEG:凭证项目供应商发票数据EKKO/EKPO–MKPF/MSEG–RBKP/RSEG–BKPF-BSEG23、KNA1:客户主数据（一般数据）24、KNB1:客户主数据（公司代码）25、KNVV:客户主记录销售数据26、ADRC:地址27、EBAN:采购申请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:ConsumptionPlantDVER–MaterialMaster:ConsumptionMRPAreaMVKE–MaterialMaster:SalesSalesOrg,DistrChMLAN-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:deliverycostsEKPB-MaterialtobeprovidediteminpurchasingdocumentESKL-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-MessagestatusSAPMM-MasterDataPiiiichHsirgDalaUasicLJataMARCMastenC£电^01e1在卜MAKI帆才6同No(MAINR)PEH的BRK帮\Msieriairu。(.MATNR)Longusge(SPRAS'I-—」■.------■勾厂—-fAaRAilMiiteriiilMd^ter:Gcntral口融讦｝.■■M司如同MDCMATHR]L______---T_J—JAfR『11「■'■../HARMqUlnlt生MTMe*医■■e)MLAGax£1编辱函tMMion:lhl.vt#ri；il|iMoicrialND(MRJMR]UOM(阳NH)MHmidM〔MAIN斡CDi.rtryi；W-ANDjL__-—L_AEEaurttingDalai.jMBEWi川VMMion|iMarterlalNotMRTT咐VaLstiariArea(BVWEV)15间记口Type〔WAR)SAPMM-Purchasing度PiirEhasmgInfaR怎瞄nrdSAPMM-Purchasing,PurchasingRequisiti