SAP各模塊常用表.doc

SAP各模塊字段與表的對應(yīng)關(guān)系Customer MasterKNA1Customer Basic DataKNB1Customer Company Level Data客戶的公司數(shù)據(jù)KNVVCustomer Sales Level Data 客戶的銷售數(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(物料類型,)MARCMaterial MRP (Plant) Data(工廠的MRP視圖)MARDMaterial Storage Data (查看總庫存)（物料的倉儲位置數(shù)據(jù)）MARDHMaterial Storege Data His.查看庫存的歷史庫存（月度的庫存）MARM物料計量單位MBEWMaterial ValuationData(查看財務(wù)視圖-)成本價格)沒有工廠字段，但有評估范圍字段；MKALMaterial Production Version Data(生產(chǎn)版本)MAKTMaterial Descriptions/Short Texts(物料描述)MARMMaterial Units of Measure(物料主單位的轉(zhuǎn)換數(shù)量)MVKE Material Sales Level Data （銷售視圖）MSKUSpecial Stocks with Customer ( ? )MLGNMaterial Warehouse DataMVKE Material Sales DataMTXHMaterial Long TextMCHABatch management table（批次管理）MCHB批次庫存MSKASalesOrder Stock（銷售庫存）MAPL分配任務(wù)清單到物料，物料所建的工藝路線（Q類型為檢驗計劃）MAST分配BOM到物料MVKE物料銷售數(shù)據(jù)(查找銷售單位)MLAN物料的稅分類MDLV 定制 MRP 運行區(qū)域(與MDLG是明細) MRP范圍MDLGMDMA物料與MRP AREA的關(guān)聯(lián)關(guān)系；T023物料組T023TVendor Master供應(yīng)商LFA1Vendor Master - General DataLFB1Vendor Master - Company Code Data（公司，財務(wù)視圖）LFM1Vendor Master - Purchasing Org. Data(采購組織)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(通過對象號與CRHD關(guān)聯(lián))包含了作業(yè)類型CRHHHierarchy HeaderCRHSHierarchy StructureCRTX Work Center Text(工作中心描述)KAKO Capacity HeaderKAZY Intervals of CapacityCRC邏輯數(shù)據(jù)庫ROUTINGMAPLRouting Link to Material(查到工藝路線的產(chǎn)品描述，物料、組號、組計數(shù)器之間的關(guān)系)PLPORouting OperationDetails（通過PLPO的ARBID和CRHD的OBJECTID關(guān)聯(lián)獲得具體使用哪個工作中心，標準值也在這個表格里保存）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工藝路線標準文本PNM 邏輯數(shù)據(jù)庫BOM (物料清單)STPOBOM Item Details(明細項)STKO BOM HeaderDetails(抬頭項)（找STAS-再找STOP，這是由于STOP中無可選項字段）MASTBOM Group to Material（通過【物料單】字段與STPO、STKO關(guān)聯(lián)）STZUBOM History RecordsSTASBOM Item Selection（有可選項字段）STPFBOM Explosion StructureMAST 分配BOM到物料BOM 使用邏輯數(shù)據(jù)庫的是CMCProductionVersion(生產(chǎn)版本)MKALMaterial Production Version Data (生產(chǎn)版本)Demand ManagementPBEDIndependent Requirements DataPBIMIndependent Requirements by Material（與PBED通過BDZEI關(guān)聯(lián)）PBHI Independent Requirements History（與PBIM，通過BDZEI關(guān)聯(lián)）PBID Plannedindependent requirements index: MRP areaRepetitive ManufacturingSAFKRS Header Master DataS025LIS - Run Schedule QuantitiesS026LIS - Material UsageS028LIS - Reporting Point StatisticsBLPK 憑證日志標題（保存了【參考數(shù)量】）沖銷類型-P，在這里通過【處理類型】來查詢相關(guān)的報告點的操作，報告點的處理類型為Z。CEZPReporting Point Document Logs（行項目）CPZPReporting Points Periodic Totals(產(chǎn)看某期間的報告點)對象號與AFKO訂單號關(guān)聯(lián)；MRP RecordsMDKPMRP Document Header DataMDKPDBPLSCPlanning Scenario (Long-term Planning)MDFDMRP Firming Dates(涉及到長期計劃中的計劃方案)MDVMPlanning File EntriesS094LIS - Stock/Requirements Analysis(動態(tài)生成)MDTBMD04/MD05界面的數(shù)據(jù)表DTNUM，只是一份計劃條目清單；UMD01保存MRP的界面參數(shù)ReservationsRKPFReservations HeaderRESBReservations/Dependent Requirements（保留相關(guān)的溯源）Planned OrdersPLAF PlannedOrdersOPIT計劃訂單調(diào)度記錄T457P計劃訂單中訂單類型的文本表格T460C計劃訂單的訂單/采購訂單類型T460D計劃訂單的訂單/采購訂單類型DPM計劃訂單邏輯數(shù)據(jù)庫Discrete Production（生產(chǎn)訂單）從CAUFV找AUFRLAFKOOrderHeader（包含有BOM和ROUTING的組信息）(工序確認,上級訂單號)(不要關(guān)聯(lián)該表的物料號，經(jīng)常會丟失。如果關(guān)聯(lián)則關(guān)聯(lián)AFPO)AFPOOrder ItemDetail(訂單類別【DAUTY】5產(chǎn)品收集器，訂單類型【DAUAT】RM01，有入庫數(shù)【W(wǎng)EMNG】)RESBOrderBOM（訂單里的實際BOM清單，通過AUFPL與AFVC關(guān)聯(lián)，包含了訂單的組件分配）AFFLOrder Sequence DetailsAFFHOrder PRT AssignmentAFBPOrder Batch Print RequestsAFVCOrder Operations Detail(與通過“組”和“計數(shù)器”關(guān)聯(lián)AFKO，應(yīng)該是AUFPL 訂單中工序的工藝路線號 與AFKO關(guān)聯(lián))（訂單里的實際工序）ARBID 資源的對象IDAFRUOrder Completion Confirmations（實際值）(生產(chǎn)訂單確認量及所有相關(guān)的確認的數(shù)據(jù)（重復(fù)制造），對象號與CRCO查找作業(yè)類新描述，通過訂單號和AFPO關(guān)聯(lián))得到計劃工藝路線號，然后和AFVC關(guān)聯(lián)(訂單號，作業(yè)編號)，再通過AFVC的活動類型到表CSLA獲得具體成本要素號;AFRU的訂單作業(yè)與AFVC相關(guān)聯(lián)AFFW Confirmations - Goods Movementswith Errors（COGI錯誤庫存列表）AFRC Confirmations - Incorrect CostCalculations(COGI) 確認不正確的成本核算AFRD Confirmations - Defaults forCollective ConfirmationAFRH Confirmations - Header Info forConfirmation PoolAUFM 保存訂單的貨物移動內(nèi)容（只保存DAUTY-10，也就是保存有生產(chǎn)訂單，重復(fù)制造的內(nèi)容不放在該表）AFVV Operationdetails（生產(chǎn)訂單的定額標準值/理論值）AFRV Confirmation PoolAFWI Confirmations - SubsequentlyPosted Goods Movements(確認的物料移動)AUFK訂單主數(shù)據(jù)(包含訂單的刪除標志)（有PP與CO的訂單號的對照表，也就是包含了“OR0000.”）CKMLMV001保存了，按照物料版本號，找到生產(chǎn)過程號，然后通過AUFK生產(chǎn)過程號。CKMLMV013保存了訂單和生產(chǎn)版本的信息；一般來說，一個訂單AUFNR就是一個版本VERID；AUFK-JEST-TJ02TOrderstatus(通過AUFK OBJNR關(guān)聯(lián)) for example:OR000002014014-JSTO查詢到相應(yīng)的訂單狀態(tài)(具體TJ02T具體描述相應(yīng)的狀態(tài)：系統(tǒng)狀態(tài)語言狀態(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ù)檢驗批檢驗結(jié)果QADB_SCOPE Scope from ASAP QADBQAES采樣單位表QAKL數(shù)值分類的結(jié)果表QALS檢驗批記錄（查看檢驗批的狀態(tài)：。）QALT部分批量QAMBQM：檢驗批和物料憑證的連接(參考類型，STAT35代表有結(jié)論；STAT34Q庫存釋放是否完全釋放QAMR檢驗處理中的特性結(jié)果QAMV檢驗處理的特性說明QAMVRMS 多重說明的檢驗說明/評估QAOBJMS多個說明 - 對象QAPP檢驗點QASE采樣單元的結(jié)果表QASH控制圖表QASR檢驗特性的采樣結(jié)果QASRMS多重說明樣品的確認數(shù)據(jù)QAST控制圖表跟蹤QASV檢驗處理的采樣說明QAVE檢驗處理：使用決策（取得檢驗批的結(jié)果，標識符KZARTL，UD代碼P003）QPMK主檢驗特性(MM) MATERIALSMANAGEMENTMaster DataEINAPurchasing Info Record - General Data（采購信息記錄）EINEPurchasing Info Record - Purchasing Org. Data(采購信息記錄-采購視圖)；與EINA是一對多的；EQUKQuota Arrangement Header(配額)EQUPQuota Arrangement Item DetailEORDSource Lists 貨源清單KOMVHeader Conditions（通訊表）KONPItem Conditions（通訊表），A017是采購價格的數(shù)據(jù)表，然后通過字段KNUMH；A017不能用于QUERY；T024 采購組邏輯數(shù)據(jù)表：IFM-采購信息記錄；邏輯數(shù)據(jù)庫：ILM-可以顯示采購價格等級數(shù)據(jù)T001L庫存地點PurchasingPOEKKO Purchasing DocumentHeader詢報價(憑證類型A)；采購合同(憑證類型K)EKPOPurchasing Document Item DetailEKBE采購訂單歷史EBAN采購申請（行項目）EBKN 采購申請BAM采購申請邏輯數(shù)據(jù)庫EKET采購訂單delivery scheduleEKES 采購訂單與內(nèi)向交貨單的關(guān)系；S011LIS - Purchasing GroupsS012LIS - PurchasingS013LIS - Vendor EvaluationS080LIS - Purchasing - MovementsS081LIS - Purchasing - StockS082LIS - Purchasing - Movements & StockEKBZ(發(fā)票校驗和采購訂單關(guān)聯(lián)的表)審批表CEKKO 采購訂單的審批CEBAN 采購申請Batch ManagementMCHABatchesS038LIS - Inventory Controlling - BatchesInventory ManagementMSLBSpecial Stocks with Vendor供應(yīng)商特殊庫存(外協(xié)，委外)MSKUSpecial Stocks with CustomerIKPF Physical Inventory Header(盤點憑證)ISEG Physical Inventory Document Item DetailS032LIS - Statistics Table - Current StocksS039LIS - Inventory ControllingMSKA Sales Order StockMCHA 批次庫存MCHB 批次庫存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銷售憑證:計劃行數(shù)據(jù)VBBE 銷售需求（拖延訂單或者斷貨）VBUK銷售憑證：抬頭狀態(tài)和管理數(shù)據(jù)（也可以看到DN單的狀態(tài)）VBFA 銷售憑證流，【先前的銷售和分銷憑證】VBELV字段就是在VA01里看到訂單的最頂層；VBPA售達方、收貨方再根據(jù)【地址號碼】ADRNR查找【ADRC】表找到相應(yīng)的地址;VBAK-VBELN 關(guān)聯(lián)VBPA-VBELN；如何查找電子郵件地址？ADR6KONV銷售訂單價格表：Condition Procedures(含有內(nèi)容比較多)（通過VBAK的KNUMV和KPOSN兩個字段)Delivery DocumentsLIKPDelivery Document - Header Datal(包含售達方，送達方內(nèi)容)，可以通過LIKP找到VBPA，然后再找ADRClLIKP- LFART（交貨單類型）l也包含了內(nèi)向交貨單LIPSDelivery Document - Detail Data ；Billing DocumentsVBRK Billing Document - Header DataVBRPBilling Document - Detail DataConditionTables（價格）KONHCondition Header（通訊表）KONPCondition DetailKONVCondition Procedures(是代表銷售訂單的價格數(shù)據(jù))（通過VBAK的KNUMV和KPOSN兩個字段）KOTE* Rebate（回扣） Condition Tables many*966966是條件表，如果不會則前面加*查找一下；KOTN* 買贈（VBN1創(chuàng)建的）A8* 打折表(FI) FINANCIAL ACCOUNTINGAccounting DocumentsBKPFAccounting Document HeaderBSEGAccounting Document Detail(CO) CONTROLLINGCO-PCCOASCOSSCOSP包括所有的數(shù)量COVP保存工序確認后的數(shù)值與COBK進行關(guān)聯(lián)(通過對象號，憑證編號)，業(yè)務(wù)事務(wù)COIN，一般情況下與AFRU相同。(COVP的參考憑證號碼,參照組織單位與AFRU 的確認號和計數(shù)器)，AFKO的定單號與COBK關(guān)聯(lián)，COBK包含相關(guān)的憑證號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è)類型（抬頭）CSLT作