SAP各模塊常用表.doc

SAP各模塊字段與表的對(duì)應(yīng)關(guān)系Customer MasterKNA1Customer Basic DataKNB1Customer Company Level Data客戶的公司數(shù)據(jù)KNVVCustomer Sales Level Data 客戶的銷(xiāo)售數(shù)據(jù)KNVPCustomer Partnering Data客戶合作伙伴KNKACustomer Credit Data - CentralizedKNKK Customer Credit Data - Control Area LevelKNBK Customer Bank DetailsKNVHCustomer HierarchiesKNVLCustomer LicensesKNMTCustomer - Material Info Record，客戶-物料信息記錄數(shù)據(jù)表KNMTKCustomer- Material Info Record - HeaderKNVK 聯(lián)系人(供應(yīng)商，客戶)Material MasterMARAMaterial Basic Data(物料類(lèi)型,)MARCMaterial MRP (Plant) Data(工廠的MRP視圖)MARDMaterial Storage Data (查看總庫(kù)存)（物料的倉(cāng)儲(chǔ)位置數(shù)據(jù)）MARDHMaterial Storege Data His.查看庫(kù)存的歷史庫(kù)存（月度的庫(kù)存）MARM物料計(jì)量單位MBEWMaterial ValuationData(查看財(cái)務(wù)視圖-)成本價(jià)格)沒(méi)有工廠字段，但有評(píng)估范圍字段；MKALMaterial Production Version Data(生產(chǎn)版本)MAKTMaterial Descriptions/Short Texts(物料描述)MARMMaterial Units of Measure(物料主單位的轉(zhuǎn)換數(shù)量)MVKE Material Sales Level Data （銷(xiāo)售視圖）MSKUSpecial Stocks with Customer ( ? )MLGNMaterial Warehouse DataMVKE Material Sales DataMTXHMaterial Long TextMCHABatch management table（批次管理）MCHB批次庫(kù)存MSKASalesOrder Stock（銷(xiāo)售庫(kù)存）MAPL分配任務(wù)清單到物料，物料所建的工藝路線（Q類(lèi)型為檢驗(yàn)計(jì)劃）MAST分配BOM到物料MVKE物料銷(xiāo)售數(shù)據(jù)(查找銷(xiāo)售單位)MLAN物料的稅分類(lèi)MDLV 定制 MRP 運(yùn)行區(qū)域(與MDLG是明細(xì)) MRP范圍MDLGMDMA物料與MRP AREA的關(guān)聯(lián)關(guān)系；T023物料組T023TVendor Master供應(yīng)商LFA1Vendor Master - General DataLFB1Vendor Master - Company Code Data（公司，財(cái)務(wù)視圖）LFM1Vendor Master - Purchasing Org. Data(采購(gòu)組織)LFB5Vendor Master - Dunning DataLFBKVendor Master - Bank Details(銀行信息)-BNKA銀行表LFBWVendor Master - Withholding Tax TypesLBC1Vendor Master - Transaction FiguresLFM2Vendor Master - Purchasing DataLFMCVendor Master - Condition Type Short TextLFMHVendor HierarchyKNVK聯(lián)系人(供應(yīng)商，客戶)WYT3合伙人信息；PP MASTER DATA (cont.)Factory CalendarTFACDFactory Calendar DefinitionTFACSFactory Calendar Display (days/month)TFACTFactory Calendar TextsTFAINFactory Calendar - Special RulesTFAITText for Factory Calendar IntervalsTHOCPublic Holiday Calendar IDsTHOCD Public Holiday Link to Holiday CalendarTHOLPublic Holiday DefinitionTHOLT Public Holiday TextsLine DesignLDLHLine Hierarchy HeaderLDLPLine Hierarchy ItemsLDLTLine Hierarchy Takt TimesLDLBCTakts/No. Individual Capacities per LineLDLBHLine Balance HeaderLDLBPLine Balance ItemsLDLBTLine Hierarchy Entry and Exit TaktsPRTsCRFHPRT Master DataCRVD_ALink of PRT to DocumentCRVD_BLink of Document to PRTCRVE_AAssignment of PRT data to EquipmentCRVE_BAssignment of equipment to PRT dataCRVM_ALink of PRT data to MaterialCRVM_BLink of Material to PRT dataCRVS_ALink of PRT Internal number to PRT External numberCRVS_BLink of PRT External number to PRT Internal numberClass & CharacteristicCABN,CharacteristicRMCLM.Classification(PP) PRODUCTIONPLANNINGWork CenterCRHDWork Center Header DataCRCAWork Center Capacity AllocationCRCOWork Center Cost Center Assignment(通過(guò)對(duì)象號(hào)與CRHD關(guān)聯(lián))包含了作業(yè)類(lèi)型CRHHHierarchy HeaderCRHSHierarchy StructureCRTX Work Center Text(工作中心描述)KAKO Capacity HeaderKAZY Intervals of CapacityCRC邏輯數(shù)據(jù)庫(kù)ROUTINGMAPLRouting Link to Material(查到工藝路線的產(chǎn)品描述，物料、組號(hào)、組計(jì)數(shù)器之間的關(guān)系)PLPORouting OperationDetails（通過(guò)PLPO的ARBID和CRHD的OBJECTID關(guān)聯(lián)獲得具體使用哪個(gè)工作中心，標(biāo)準(zhǔn)值也在這個(gè)表格里保存）PLKORouting Header Details（需要與MAPL關(guān)聯(lián)，PLNTY，PLNNR）PLABRelationships - Standard NetworkPLASTask List - Selection ofOperations（PLPO,PLAS,PLKO三者互相關(guān)聯(lián)才能獲得工作中心描述信息）(plpoplnnr = plasplnnr and plpozaehl = plaszaehl andplpoplnkn = plasplnkn)PLMZComponent Allocation（組件分配）（是記錄分配BOM到ROUTING）PLPHCAPP Sub-operationsPLFHPRT AllocationPLWPMaintenance Package AllocationPLMK Inspection CharacteristicsT435T工藝路線標(biāo)準(zhǔn)文本PNM 邏輯數(shù)據(jù)庫(kù)BOM (物料清單)STPOBOM Item Details(明細(xì)項(xiàng))STKO BOM HeaderDetails(抬頭項(xiàng))（找STAS-再找STOP，這是由于STOP中無(wú)可選項(xiàng)字段）MASTBOM Group to Material（通過(guò)【物料單】字段與STPO、STKO關(guān)聯(lián)）STZUBOM History RecordsSTASBOM Item Selection（有可選項(xiàng)字段）STPFBOM Explosion StructureMAST 分配BOM到物料BOM 使用邏輯數(shù)據(jù)庫(kù)的是CMCProductionVersion(生產(chǎn)版本)MKALMaterial Production Version Data (生產(chǎn)版本)Demand ManagementPBEDIndependent Requirements DataPBIMIndependent Requirements by Material（與PBED通過(guò)BDZEI關(guān)聯(lián)）PBHI Independent Requirements History（與PBIM，通過(guò)BDZEI關(guān)聯(lián)）PBID Plannedindependent requirements index: MRP areaRepetitive ManufacturingSAFKRS Header Master DataS025LIS - Run Schedule QuantitiesS026LIS - Material UsageS028LIS - Reporting Point StatisticsBLPK 憑證日志標(biāo)題（保存了【參考數(shù)量】）沖銷(xiāo)類(lèi)型-P，在這里通過(guò)【處理類(lèi)型】來(lái)查詢相關(guān)的報(bào)告點(diǎn)的操作，報(bào)告點(diǎn)的處理類(lèi)型為Z。CEZPReporting Point Document Logs（行項(xiàng)目）CPZPReporting Points Periodic Totals(產(chǎn)看某期間的報(bào)告點(diǎn))對(duì)象號(hào)與AFKO訂單號(hào)關(guān)聯(lián)；MRP RecordsMDKPMRP Document Header DataMDKPDBPLSCPlanning Scenario (Long-term Planning)MDFDMRP Firming Dates(涉及到長(zhǎng)期計(jì)劃中的計(jì)劃方案)MDVMPlanning File EntriesS094LIS - Stock/Requirements Analysis(動(dòng)態(tài)生成)MDTBMD04/MD05界面的數(shù)據(jù)表DTNUM，只是一份計(jì)劃條目清單；UMD01保存MRP的界面參數(shù)ReservationsRKPFReservations HeaderRESBReservations/Dependent Requirements（保留相關(guān)的溯源）Planned OrdersPLAF PlannedOrdersOPIT計(jì)劃訂單調(diào)度記錄T457P計(jì)劃訂單中訂單類(lèi)型的文本表格T460C計(jì)劃訂單的訂單/采購(gòu)訂單類(lèi)型T460D計(jì)劃訂單的訂單/采購(gòu)訂單類(lèi)型DPM計(jì)劃訂單邏輯數(shù)據(jù)庫(kù)Discrete Production（生產(chǎn)訂單）從CAUFV找AUFRLAFKOOrderHeader（包含有BOM和ROUTING的組信息）(工序確認(rèn),上級(jí)訂單號(hào))(不要關(guān)聯(lián)該表的物料號(hào)，經(jīng)常會(huì)丟失。如果關(guān)聯(lián)則關(guān)聯(lián)AFPO)AFPOOrder ItemDetail(訂單類(lèi)別【DAUTY】5產(chǎn)品收集器，訂單類(lèi)型【DAUAT】RM01，有入庫(kù)數(shù)【W(wǎng)EMNG】)RESBOrderBOM（訂單里的實(shí)際BOM清單，通過(guò)AUFPL與AFVC關(guān)聯(lián)，包含了訂單的組件分配）AFFLOrder Sequence DetailsAFFHOrder PRT AssignmentAFBPOrder Batch Print RequestsAFVCOrder Operations Detail(與通過(guò)“組”和“計(jì)數(shù)器”關(guān)聯(lián)AFKO，應(yīng)該是AUFPL 訂單中工序的工藝路線號(hào) 與AFKO關(guān)聯(lián))（訂單里的實(shí)際工序）ARBID 資源的對(duì)象IDAFRUOrder Completion Confirmations（實(shí)際值）(生產(chǎn)訂單確認(rèn)量及所有相關(guān)的確認(rèn)的數(shù)據(jù)（重復(fù)制造），對(duì)象號(hào)與CRCO查找作業(yè)類(lèi)新描述，通過(guò)訂單號(hào)和AFPO關(guān)聯(lián))得到計(jì)劃工藝路線號(hào)，然后和AFVC關(guān)聯(lián)(訂單號(hào)，作業(yè)編號(hào))，再通過(guò)AFVC的活動(dòng)類(lèi)型到表CSLA獲得具體成本要素號(hào);AFRU的訂單作業(yè)與AFVC相關(guān)聯(lián)AFFW Confirmations - Goods Movementswith Errors（COGI錯(cuò)誤庫(kù)存列表）AFRC Confirmations - Incorrect CostCalculations(COGI) 確認(rèn)不正確的成本核算AFRD Confirmations - Defaults forCollective ConfirmationAFRH Confirmations - Header Info forConfirmation PoolAUFM 保存訂單的貨物移動(dòng)內(nèi)容（只保存DAUTY-10，也就是保存有生產(chǎn)訂單，重復(fù)制造的內(nèi)容不放在該表）AFVV Operationdetails（生產(chǎn)訂單的定額標(biāo)準(zhǔn)值/理論值）AFRV Confirmation PoolAFWI Confirmations - SubsequentlyPosted Goods Movements(確認(rèn)的物料移動(dòng))AUFK訂單主數(shù)據(jù)(包含訂單的刪除標(biāo)志)（有PP與CO的訂單號(hào)的對(duì)照表，也就是包含了“OR0000.”）CKMLMV001保存了，按照物料版本號(hào)，找到生產(chǎn)過(guò)程號(hào)，然后通過(guò)AUFK生產(chǎn)過(guò)程號(hào)。CKMLMV013保存了訂單和生產(chǎn)版本的信息；一般來(lái)說(shuō)，一個(gè)訂單AUFNR就是一個(gè)版本VERID；AUFK-JEST-TJ02TOrderstatus(通過(guò)AUFK OBJNR關(guān)聯(lián)) for example:OR000002014014-JSTO查詢到相應(yīng)的訂單狀態(tài)(具體TJ02T具體描述相應(yīng)的狀態(tài)：系統(tǒng)狀態(tài)語(yǔ)言狀態(tài)狀態(tài)I0001ECRTDCreatedI0002ERELReleasedI0009ECNFConfirmedI0010EPCNFPartially confirmedI0012EDLVDeliveredI0013EDLTDeletion indicatorI0045ETECOTechnically completedI0046ECLSDClosed(取消，清空)TJ02TSYSTEM STATUSJEST,JSTO PO STATUS(TJ30USERSTATUSJCDOChangeDocuments for Status Object (Table)JCDSChangeDocuments for System/User StatusesCOBRB 結(jié)算規(guī)則表ClassificationKLAH Class DetailCABNCharacteristic DetailAUSPCharacteristic ValuesCAWNCharacteristic ValuesCAWNT Characteristic Value TextsKSML Characteristic Allocation to ClassKSSK Material Allocation to Class（QM）Quality Management主數(shù)據(jù)檢驗(yàn)批檢驗(yàn)結(jié)果QADB_SCOPE Scope from ASAP QADBQAES采樣單位表QAKL數(shù)值分類(lèi)的結(jié)果表QALS檢驗(yàn)批記錄（查看檢驗(yàn)批的狀態(tài)：。）QALT部分批量QAMBQM：檢驗(yàn)批和物料憑證的連接(參考類(lèi)型，STAT35代表有結(jié)論；STAT34Q庫(kù)存釋放是否完全釋放QAMR檢驗(yàn)處理中的特性結(jié)果QAMV檢驗(yàn)處理的特性說(shuō)明QAMVRMS 多重說(shuō)明的檢驗(yàn)說(shuō)明/評(píng)估QAOBJMS多個(gè)說(shuō)明 - 對(duì)象QAPP檢驗(yàn)點(diǎn)QASE采樣單元的結(jié)果表QASH控制圖表QASR檢驗(yàn)特性的采樣結(jié)果QASRMS多重說(shuō)明樣品的確認(rèn)數(shù)據(jù)QAST控制圖表跟蹤QASV檢驗(yàn)處理的采樣說(shuō)明QAVE檢驗(yàn)處理：使用決策（取得檢驗(yàn)批的結(jié)果，標(biāo)識(shí)符KZARTL，UD代碼P003）QPMK主檢驗(yàn)特性(MM) MATERIALSMANAGEMENTMaster DataEINAPurchasing Info Record - General Data（采購(gòu)信息記錄）EINEPurchasing Info Record - Purchasing Org. Data(采購(gòu)信息記錄-采購(gòu)視圖)；與EINA是一對(duì)多的；EQUKQuota Arrangement Header(配額)EQUPQuota Arrangement Item DetailEORDSource Lists 貨源清單KOMVHeader Conditions（通訊表）KONPItem Conditions（通訊表），A017是采購(gòu)價(jià)格的數(shù)據(jù)表，然后通過(guò)字段KNUMH；A017不能用于QUERY；T024 采購(gòu)組邏輯數(shù)據(jù)表：IFM-采購(gòu)信息記錄；邏輯數(shù)據(jù)庫(kù)：ILM-可以顯示采購(gòu)價(jià)格等級(jí)數(shù)據(jù)T001L庫(kù)存地點(diǎn)PurchasingPOEKKO Purchasing DocumentHeader詢報(bào)價(jià)(憑證類(lèi)型A)；采購(gòu)合同(憑證類(lèi)型K)EKPOPurchasing Document Item DetailEKBE采購(gòu)訂單歷史EBAN采購(gòu)申請(qǐng)（行項(xiàng)目）EBKN 采購(gòu)申請(qǐng)BAM采購(gòu)申請(qǐng)邏輯數(shù)據(jù)庫(kù)EKET采購(gòu)訂單delivery scheduleEKES 采購(gòu)訂單與內(nèi)向交貨單的關(guān)系；S011LIS - Purchasing GroupsS012LIS - PurchasingS013LIS - Vendor EvaluationS080LIS - Purchasing - MovementsS081LIS - Purchasing - StockS082LIS - Purchasing - Movements & StockEKBZ(發(fā)票校驗(yàn)和采購(gòu)訂單關(guān)聯(lián)的表)審批表CEKKO 采購(gòu)訂單的審批CEBAN 采購(gòu)申請(qǐng)Batch ManagementMCHABatchesS038LIS - Inventory Controlling - BatchesInventory ManagementMSLBSpecial Stocks with Vendor供應(yīng)商特殊庫(kù)存(外協(xié)，委外)MSKUSpecial Stocks with CustomerIKPF Physical Inventory Header(盤(pán)點(diǎn)憑證)ISEG Physical Inventory Document Item DetailS032LIS - Statistics Table - Current StocksS039LIS - Inventory ControllingMSKA Sales Order StockMCHA 批次庫(kù)存MCHB 批次庫(kù)存Material DocumentsMKPFMaterial Document HeaderMSEGMaterial Document Item DetailWarehouse ManagementLTAKTransfer Order HeaderLTAPTransfer Order Item DetailLTBKTransfer Requirement HeaderLTBPTransfer Requirement Item DetailLAGPStorage Bin MasterInvoice verifyBKPFBSEG(SD) SALES AND DISTRIBUTIONSales DocumentsVBAKSales Document - Header DataVBAPSales Document - Detail Data （保存了）VBEP銷(xiāo)售憑證:計(jì)劃行數(shù)據(jù)VBBE 銷(xiāo)售需求（拖延訂單或者斷貨）VBUK銷(xiāo)售憑證：抬頭狀態(tài)和管理數(shù)據(jù)（也可以看到DN單的狀態(tài)）VBFA 銷(xiāo)售憑證流，【先前的銷(xiāo)售和分銷(xiāo)憑證】VBELV字段就是在VA01里看到訂單的最頂層；VBPA售達(dá)方、收貨方再根據(jù)【地址號(hào)碼】ADRNR查找【ADRC】表找到相應(yīng)的地址;VBAK-VBELN 關(guān)聯(lián)VBPA-VBELN；如何查找電子郵件地址？ADR6KONV銷(xiāo)售訂單價(jià)格表：Condition Procedures(含有內(nèi)容比較多)（通過(guò)VBAK的KNUMV和KPOSN兩個(gè)字段)Delivery DocumentsLIKPDelivery Document - Header Datal(包含售達(dá)方，送達(dá)方內(nèi)容)，可以通過(guò)LIKP找到VBPA，然后再找ADRClLIKP- LFART（交貨單類(lèi)型）l也包含了內(nèi)向交貨單LIPSDelivery Document - Detail Data ；Billing DocumentsVBRK Billing Document - Header DataVBRPBilling Document - Detail DataConditionTables（價(jià)格）KONHCondition Header（通訊表）KONPCondition DetailKONVCondition Procedures(是代表銷(xiāo)售訂單的價(jià)格數(shù)據(jù))（通過(guò)VBAK的KNUMV和KPOSN兩個(gè)字段）KOTE* Rebate（回扣） Condition Tables many*966966是條件表，如果不會(huì)則前面加*查找一下；KOTN* 買(mǎi)贈(zèng)（VBN1創(chuàng)建的）A8* 打折表(FI) FINANCIAL ACCOUNTINGAccounting DocumentsBKPFAccounting Document HeaderBSEGAccounting Document Detail(CO) CONTROLLINGCO-PCCOASCOSSCOSP包括所有的數(shù)量COVP保存工序確認(rèn)后的數(shù)值與COBK進(jìn)行關(guān)聯(lián)(通過(guò)對(duì)象號(hào)，憑證編號(hào))，業(yè)務(wù)事務(wù)COIN，一般情況下與AFRU相同。(COVP的參考憑證號(hào)碼,參照組織單位與AFRU 的確認(rèn)號(hào)和計(jì)數(shù)器)，AFKO的定單號(hào)與COBK關(guān)聯(lián)，COBK包含相關(guān)的憑證號(hào)COEPCOVPCOEP與COBK關(guān)聯(lián)VIEWERCO-PACE10010 ABC Operating Concern - DetailsCE20010 ABC Operating Concern - SummaryCE30010 ABC Operating Concern - Summary主數(shù)據(jù)CSKS成本中心CSKA成本要素CSKUCSKBCSLA作業(yè)類(lèi)型（抬頭）CSLT作