《SAP 常用表及表关系.docx》由会员分享，可在线阅读，更多相关《SAP 常用表及表关系.docx（13页珍藏版）》请在三一办公上搜索。
1、SAP MM常用表及表关系一、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:采购订单抬头
2、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 - Material Master: General dataM
3、AKT - Material Master: DescriptionMARM - Material Master: Unit of MeasureMAPE - Material master: Export control fileMARC - Material master: Plant dataMARD - Material master: Storage locationMAST - Material link to BOMMBEW - Material valuationMLGN - Material Master: WM InventoryMLGT - Material Master
4、: WM Inventory typeMDIP - Material: MRP profiles (field contents)MKOP - Consignment price segment (old versions of SAP)EBEW - Valuation of sales order stockQBEW - Valuation of project stockMVER - Material Master: Consumption DVER - Material Master: Consumption MVKE - Material Master: Sales MLAN - Ma
5、terial Master: Tax indicatorMARC - Material Master: Plant dataMAPR-MaterialMaster:ForecastMARD-MaterialMaster:Storage LocationMCH1 - Material Master: X Plant BatchesMCHA-MaterialMaster:BatchesMCHB-MaterialMaster:Batch StockMDMA - MRP Area dataDBVM - MRP Planning File Entry: MRP AreaMOFF - Outstandin
6、g Material Master Records (Maintenance status)MARCH - Material Master C Segment: HistoryMARDH - Material Master Storage Location Segment: HistoryMBEWH - Material Valuation: HistoryMCHBH - Batch Stocks: HistoryMKOLH - Special Stocks from Vendor: HistoryMSCAH - Sales Order Stock at Vendor: HistoryMSKA
7、H - Sales Order Stock: HistoryMSKUH - Special Stocks at Customer: HistoryMSLBH - Special Stocks at Vendor: HistoryMSPRH - Project Stock: HistoryMSSAH - Total Sales Order Stocks: HistoryMSSQH - Total Project Stocks: HistoryVendorsLFA1 - Vendor Master: General dataLFB1 - Vendor Master: Company dataLFM
8、1 - Vendor Master: Purchasing Data (Purchasing organization)LFM2 - Vendor Master: Purchasing Data (Plant, Vendor sub-range)PurchasingEBAN - Purchase requisition: itemsEBKN - Purchase Requisition: account assignmentSTXH - SAPScript Text HeaderSTXL - SAPScript Text LinesEKKO - Purchasing document head
9、erEKPO - Purchasing Document: ItemEKET - Purchasing Document: Delivery SchedulesMDBS - Material View of Order Item/Schedule Line (good to find open POs)EKKN - Account assignment in purchasing documentEORD - Purchasing Source ListEIPA - Order price history recordEKAB - Release documentationEKBE - Pur
10、chasing document historyEKBZ - Purchasing document history: delivery costsEKPB - Material to be provided item in purchasing documentESKL - Account assignment specification for service lineESKN - Account assignment in service packageESLH - Service package header dataESLL - Lines in service packageESS
11、R - Service entry sheet header dataESUC - External services management: Unplanned limits for contract itemESUH - External services management: unplanned service limits header dataESUP - External services management: unplanned limits for service packagesESUS - External services management: Unplanned
12、limits for service typesEINA - Purchase Info Record: GeneralEINE - Purchasing info record: purchasing organization dataKONP - Condition ItemKONH - Condition HeaderInventory ManagementISEG - Physical inventory document itemsMKPF - Material document: HeaderMSEG - Material document: itemRKPF - Reservat
13、ion: HeaderRESB - Reservation: ItemInvoice VerificationBSIM - Secondary index: documents for materialMYMFT - FIFO results tableMYML - LIFO material layerMYMLM - LIFO material layer (monthly)MYMP - LIFO period stocks, single materialMYMP1 - Receipt data LIFO/FIFO valuationMYPL - LIFO pool layerMYPLM
14、- LIFO pool layer (monthly)RBCO - Document item, incoming invoice account assignmentRBDIFFKO - Invoice Verification: conditionsRBDIFFME - Invoice Verification: quantity differencesRBDRSEG - Invoice Verification batch: invoice document itemsRBKP - Document header: incoming invoiceRBKPB - Invoice docu
15、ment header (batch invoice verification)RBTX - Taxes:incoming invoiceRBVD - Invoice document: summarization dataRBVDMAT - Invoice Verification: summarization data, materialRBWT - Withholding tax:incoming invoiceRKWA - Consignment withdrawalsRSEG - Document item, incoming invoiceCustomising and other
16、 master dataMDLV - MRP AreasMDLG - MRP Areas - Storage LocationsMDLW - MRP Areas - PlantsMDLL - MRP Areas - SubcontractorT023 - Material GroupsT024 - Purchasing groupsT030 - Standard Accounts Table (Automatic Account Determination)T156 - Movement TypeT156T - Movement Type: TextAUSP - Release Procedu
17、re: Strategy values (cl20n, cl24n)AGR_USERS - Assignment of roles to usersCDHDR & CDPOS - Change history of master data and documentsEDID4 - EDI informationTSTC - SAP Transaction Codes, lock/unlock: sm01, created: se93TSTCT - Transaction codes TEXTNAST - Message statusPurchisiing Info RecordKO MPI C
18、on-diii onske：n|Condrtinn Nd(HNUMH：iEcq Na iKOPOE)KONHI Coriditians (Header |) Candiiicn Na i：KNUMHIEINE fPijrci-QElrfl Inlo Hacord: Purchasing rgni23fbon DztmJ Inia Retold (INFNR) Fuidi占，inQ Drg (EKJRO1 ima id lype (ESOkzj Plant OVER KS) _ _/W17kflatcnnl Inta FI/mE Plsrf.Epccirh二|Application tKAPPL
19、：i can difl on叩巴K5CHLJ UeridrtLiFMR)MateiialNQtMATNR)Purctijslng Drg (EkTIRG)Plant OVEAK Iniaid Cdigorv (E30FVJllditM(DATBI -，SAP MM - PurchasingPurchasing RequisitionSTXH(STXD SAPscript text file I testier)Tb:：-：1s (TDOBJECrjText Name (TDNAIVE)TB)rtldi；TDID) Language (TDSPRAS)EBAH|Purch$e Requisiti
20、on)Purchasing Req (BANFN) Hern (BhFRO)EBKII(Pin clide R敢网汹仆” AcominFlirchasina Req i：BAh.FN：iItem (BNFPO)Preg Account Assignment (ZEBKN)(RELID)TelS (TDOBJECTJ Text Nrre i：TIDN卢,E) Te. Id (TDIDjLarKiuaqe (rDSFASi (SRFF2)Purchase Oirders3D11|PURCH: Purch. Gro-_p StaiitiosjStatist c3d：3SOUR：iVeEionfVRS
21、IO)Monlh (3FMON)Day i SPTAG ：iUi.ieekfSPOi：iPoking Period (SFBUF；iPu toh Eng 0 rg (E KO R &JPum；iasina 0roup fEKORPVendor No (LIFUR)5D12IPURCHIS: Purchasing $taiitics)3tatirfc5(SS0UR：iVersion fVRS IO)Mon1h(3PMON)Day iPTAG：i.H.ieeki：SPWOC：iPoking Period (SPBUF；iPu roh jsi n g 0 rg (E KO R ft)Purchasi
22、ng GroupfEK:=:ud T,pa (ESOKSPlant 啊EKS一(INFMR：iEKKNEKE7Deli very Sch&dul &5 J Purshng Doc(EQELN；i rtemi：EBELF?: eSchedul (ETENR)EKPQPurchawim 口gurnem Item) Purehacirig Dot (EBELN) Hem (EBELF)DMUITiEI-tF (J rc：h 占Si na D OC l：E B E LHj ft?ni(EBELF)Accou n+ Aszig n rria nt(TE kl k加)EKh.0(Purchasing Dd
23、gument hfederlFurchasinp De c (E B EL(：iEORD(Purchasing Source ListMaterial No(NATNR；iPhri+i：WERkS)Source List No fZEORC1)GiBQicIe REceiptMKPF: 妃5= Docuroarri |MSEC(Dacumant Sagmcnl: Matari si)curncnt N? (M 9LNR) Fisoal Year(MJAHR)DcAimEni Nq (MBLNR) F Iwj 1 Y ear (MJ AM R) Lin a tterrifTEILEL -一广-7
24、5031Ids : Mava mints* ior ourrenlSlQDkgJEKSEHiwlory of P_fch=iing Dumant)MVERMaterial mrsj mpcionPuichasing Ddg EBELhO tem(DLP)q函Qun1 3岫n (EP：KN；iTrans T咋w WG柏丘Fiscal YejrrMJAHFCiD电 oum4 nt No H DLNRjLI 陋 IWm (ZEILE) J rMjl4rial NO (MATNR) FlaMEg) Ftscjl YsjrtGJAHFO P：nDdi；PEAkZ)F Dllo-Oh RceDrd(ZAH
25、LR)Slab 册能 DUR)Veision (iRGIO：i UDnlhiEFMarJ)0町货FTA5Wtdi rspuraciPasting Period (EPSUP)Flam (WERK3)WdterifllND(MATNR)Storage LootL,:OAr；i9：H-1I Pll RCHlS: Purchasing &oup Bt就Mi亡SlJllf1lc(SSnUH) Vetsion (VRGI )Mc-niti qs PMONDjy(SFTA&)WeehrSPWOCPjlin- Ptri&d (SPGUPJFmhaslrig DrgEH口 RG；i Fuirhasln。rou
26、p CEK&RFVtnd.：.r No LI FN R)尸ECi I 3(PURCHIS Sialic de Tor Vendor EveJ LiianEtJtidlcrfSSnUR- Veoion IVRSIQ) McntfitGPMON) Pjy l；5FTA&) i：;=pwdc)Fosling Ptiiod iPBUP) Puiohasing Org (EKDRO) FutohJGlng rc-up (EK&RFi Vendor No (UFNR： Mabsrial No (MAIN Rd Phnl(UitRkS) info Ra card G1E目任| In勘 Rr 叫rd (IN
27、FN 的 二、SD常用表1、VBAK:销售凭证：抬头数据2、VBAP:销售凭证：项目数据3、VBEP:销售凭证：计划行数据4、VBKD:销售凭证：业务数据5、VBPA:销售凭证：合作伙伴6、LIKP: SD凭证：交货抬头数据7、LIPS: SD凭证：交货项目数据8、VBRK:出具发票：抬头数据9、VBRP:出具发票：项目数据10、VBFA:销售凭证流11、VBUK:销售凭证：抬头状态和管理数据12、VBUP :销售凭证：项目状态13、T682I:条件：存取顺序（产生格式）14、T681:条件：结构15、T682Z:条件：存取顺序（字段）16、T685:条件:类型三、FICO常用表1、SKA1:
28、总帐科目主记录（科目表）2、SKB1:总帐科目主记录（公司代码）3、SKAT:总帐科目主记录（描述）4、CSKB:成本要素5、BKPF:会计凭证抬头6、BSEG:会计核算凭证项目数据，BSID客户未清会计核算凭证/BSAD客户已清会计 核算凭证/BSIK供应商未清会计核算凭证/BSAK供应商已清会计核算凭证/BSIS总帐未 清会计核算凭证/BSAS总帐已清会计核算凭证7、FAGLFLEXA:总账实际行项目8、FAGLFLEXT :总账汇总9、ANLA:资产主记录段10、ANLC:资产值字段11、CSKS:成本中心主数据12、COEP:成本控制对象：与期间相关的各行项目13、COSS: CO对象
29、：内部过帐成本总计14、COSP: CO对象：外部记帐的成本总计15、CKMLPRKEKO:物料分类帐；价格的成本组件分割（标题）16、CKMLPRKEPH:物料分类帐：价格的成本组件分割（要素0四、PP常用表1、MAST： BOM链接物料2、STKO： BOM 表头3、STAS： BOMs -项选择4、STPO： BOM 项目STKOSTLAN = STAS-STLAN AND STKOSTLAL = STAS-STLALSTASSTLNR = STPO-STLNR AND STASSTLKN = STAS-STLKNBOM类别包括：D-凭证结构、E-设备BOM、K-订单BOM、M-物料BO
30、M、S-标准BOM、T- 功能位置BOM、P-工作分解结构BOM5、PLAF:计划订单6、RKPF:预定/相关需求抬头7、RESB:预定/相关需求行项目8、AUFK:订单主数据9、AFKO:订单表头数据，PP订单10、AFPO: 订单项11、AFVC:订单的工序12、AFVV:工序中数量/日期/值的DB结构13、JEST:订单状态，通过 AUFK-OBJNR二JEST-OBJNR 关联14、AFRU:订单确认15、AUFM:针对订单的货物移动五、PM常用表1、IFLOT:功能位置（表）2、ILOA: PM对象位置和帐户分配六、PS常用表1、PROJ:项目定义2、PRPS: WBS（工作中断结构
31、）元素主数据七、QM常用表八、库存数据1、MBEW:物料评估2、MARD:物料的工厂/库存地点数据3、MSLB:供应商特殊库存（O）4、MKOL:供应商特殊库存（K）5、MSKA:销售订单库存6、MCH1/ MCHB:批次库存九、货物移动数据1、MKPF:物料凭证抬头2、MSEG:物料凭证行项目不是所有的物料移动数据都需要从这物料移动表中进行读取，生产订单相关AUFM，采 购订单相关EKBE，销售相关VBFA。十、WM常用表1、LTBK:转储请求抬头2、LTBP:转储请求项目3、LTAK: WM转储单抬头4、LTAP: WM转储单项目十一、销售价格、采购价格KONV:价格数据销售价格：通过条件记录号KONV-KNUMV=VBAK-KNUMV关联采购价格:通过条件记录号KONV-KNUMV=EKKO-KNUMV关联
