SAP各模块常用表.doc

SAP各模块字段与表的对应关系Customer MasterKNA1Customer Basic DataKNB1Customer Company Level Data客户的公司数据KNVVCustomer Sales Level Data 客户的销售数据KNVPCustomer Partnering Data客户合作伙伴KNKACustomer Credit Data - CentralizedKNKK Customer Credit Data - Control Area LevelKNBK Customer Bank DetailsKNVHCustomer HierarchiesKNVLCustomer LicensesKNMTCustomer - Material Info Record，客户-物料信息记录数据表KNMTKCustomer- Material Info Record - HeaderKNVK 联系人(供应商，客户)Material MasterMARAMaterial Basic Data(物料类型,)MARCMaterial MRP (Plant) Data(工厂的MRP视图)MARDMaterial Storage Data (查看总库存)（物料的仓储位置数据）MARDHMaterial Storege Data His.查看库存的历史库存（月度的库存）MARM物料计量单位MBEWMaterial ValuationData(查看财务视图-)成本价格)没有工厂字段，但有评估范围字段；MKALMaterial Production Version Data(生产版本)MAKTMaterial Descriptions/Short Texts(物料描述)MARMMaterial Units of Measure(物料主单位的转换数量)MVKE Material Sales Level Data （销售视图）MSKUSpecial Stocks with Customer ( ? )MLGNMaterial Warehouse DataMVKE Material Sales DataMTXHMaterial Long TextMCHABatch management table（批次管理）MCHB批次库存MSKASalesOrder Stock（销售库存）MAPL分配任务清单到物料，物料所建的工艺路线（Q类型为检验计划）MAST分配BOM到物料MVKE物料销售数据(查找销售单位)MLAN物料的税分类MDLV 定制 MRP 运行区域(与MDLG是明细) MRP范围MDLGMDMA物料与MRP AREA的关联关系；T023物料组T023TVendor Master供应商LFA1Vendor Master - General DataLFB1Vendor Master - Company Code Data（公司，财务视图）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联系人(供应商，客户)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关联)包含了作业类型CRHHHierarchy HeaderCRHSHierarchy StructureCRTX Work Center Text(工作中心描述)KAKO Capacity HeaderKAZY Intervals of CapacityCRC逻辑数据库ROUTINGMAPLRouting Link to Material(查到工艺路线的产品描述，物料、组号、组计数器之间的关系)PLPORouting OperationDetails（通过PLPO的ARBID和CRHD的OBJECTID关联获得具体使用哪个工作中心，标准值也在这个表格里保存）PLKORouting Header Details（需要与MAPL关联，PLNTY，PLNNR）PLABRelationships - Standard NetworkPLASTask List - Selection ofOperations（PLPO,PLAS,PLKO三者互相关联才能获得工作中心描述信息）(plpoplnnr = plasplnnr and plpozaehl = plaszaehl andplpoplnkn = plasplnkn)PLMZComponent Allocation（组件分配）（是记录分配BOM到ROUTING）PLPHCAPP Sub-operationsPLFHPRT AllocationPLWPMaintenance Package AllocationPLMK Inspection CharacteristicsT435T工艺路线标准文本PNM 逻辑数据库BOM (物料清单)STPOBOM Item Details(明细项)STKO BOM HeaderDetails(抬头项)（找STAS-再找STOP，这是由于STOP中无可选项字段）MASTBOM Group to Material（通过【物料单】字段与STPO、STKO关联）STZUBOM History RecordsSTASBOM Item Selection（有可选项字段）STPFBOM Explosion StructureMAST 分配BOM到物料BOM 使用逻辑数据库的是CMCProductionVersion(生产版本)MKALMaterial Production Version Data (生产版本)Demand ManagementPBEDIndependent Requirements DataPBIMIndependent Requirements by Material（与PBED通过BDZEI关联）PBHI Independent Requirements History（与PBIM，通过BDZEI关联）PBID Plannedindependent requirements index: MRP areaRepetitive ManufacturingSAFKRS Header Master DataS025LIS - Run Schedule QuantitiesS026LIS - Material UsageS028LIS - Reporting Point StatisticsBLPK 凭证日志标题（保存了【参考数量】）冲销类型-P，在这里通过【处理类型】来查询相关的报告点的操作，报告点的处理类型为Z。CEZPReporting Point Document Logs（行项目）CPZPReporting Points Periodic Totals(产看某期间的报告点)对象号与AFKO订单号关联；MRP RecordsMDKPMRP Document Header DataMDKPDBPLSCPlanning Scenario (Long-term Planning)MDFDMRP Firming Dates(涉及到长期计划中的计划方案)MDVMPlanning File EntriesS094LIS - Stock/Requirements Analysis(动态生成)MDTBMD04/MD05界面的数据表DTNUM，只是一份计划条目清单；UMD01保存MRP的界面参数ReservationsRKPFReservations HeaderRESBReservations/Dependent Requirements（保留相关的溯源）Planned OrdersPLAF PlannedOrdersOPIT计划订单调度记录T457P计划订单中订单类型的文本表格T460C计划订单的订单/采购订单类型T460D计划订单的订单/采购订单类型DPM计划订单逻辑数据库Discrete Production（生产订单）从CAUFV找AUFRLAFKOOrderHeader（包含有BOM和ROUTING的组信息）(工序确认,上级订单号)(不要关联该表的物料号，经常会丢失。如果关联则关联AFPO)AFPOOrder ItemDetail(订单类别【DAUTY】5产品收集器，订单类型【DAUAT】RM01，有入库数【WEMNG】)RESBOrderBOM（订单里的实际BOM清单，通过AUFPL与AFVC关联，包含了订单的组件分配）AFFLOrder Sequence DetailsAFFHOrder PRT AssignmentAFBPOrder Batch Print RequestsAFVCOrder Operations Detail(与通过“组”和“计数器”关联AFKO，应该是AUFPL 订单中工序的工艺路线号 与AFKO关联)（订单里的实际工序）ARBID 资源的对象IDAFRUOrder Completion Confirmations（实际值）(生产订单确认量及所有相关的确认的数据（重复制造），对象号与CRCO查找作业类新描述，通过订单号和AFPO关联)得到计划工艺路线号，然后和AFVC关联(订单号，作业编号)，再通过AFVC的活动类型到表CSLA获得具体成本要素号;AFRU的订单作业与AFVC相关联AFFW Confirmations - Goods Movementswith Errors（COGI错误库存列表）AFRC Confirmations - Incorrect CostCalculations(COGI) 确认不正确的成本核算AFRD Confirmations - Defaults forCollective ConfirmationAFRH Confirmations - Header Info forConfirmation PoolAUFM 保存订单的货物移动内容（只保存DAUTY-10，也就是保存有生产订单，重复制造的内容不放在该表）AFVV Operationdetails（生产订单的定额标准值/理论值）AFRV Confirmation PoolAFWI Confirmations - SubsequentlyPosted Goods Movements(确认的物料移动)AUFK订单主数据(包含订单的删除标志)（有PP与CO的订单号的对照表，也就是包含了“OR0000.”）CKMLMV001保存了，按照物料版本号，找到生产过程号，然后通过AUFK生产过程号。CKMLMV013保存了订单和生产版本的信息；一般来说，一个订单AUFNR就是一个版本VERID；AUFK-JEST-TJ02TOrderstatus(通过AUFK OBJNR关联) for example:OR000002014014-JSTO查询到相应的订单状态(具体TJ02T具体描述相应的状态：系统状态语言状态状态I0001ECRTDCreatedI0002ERELReleasedI0009ECNFConfirmedI0010EPCNFPartially confirmedI0012EDLVDeliveredI0013EDLTDeletion indicatorI0045ETECOTechnically completedI0046ECLSDClosed(取消，清空)TJ02TSYSTEM STATUSJEST,JSTO PO STATUS(TJ30USERSTATUSJCDOChangeDocuments for Status Object (Table)JCDSChangeDocuments for System/User StatusesCOBRB 结算规则表ClassificationKLAH Class DetailCABNCharacteristic DetailAUSPCharacteristic ValuesCAWNCharacteristic ValuesCAWNT Characteristic Value TextsKSML Characteristic Allocation to ClassKSSK Material Allocation to Class（QM）Quality Management主数据检验批检验结果QADB_SCOPE Scope from ASAP QADBQAES采样单位表QAKL数值分类的结果表QALS检验批记录（查看检验批的状态：。）QALT部分批量QAMBQM：检验批和物料凭证的连接(参考类型，STAT35代表有结论；STAT34Q库存释放是否完全释放QAMR检验处理中的特性结果QAMV检验处理的特性说明QAMVRMS 多重说明的检验说明/评估QAOBJMS多个说明 - 对象QAPP检验点QASE采样单元的结果表QASH控制图表QASR检验特性的采样结果QASRMS多重说明样品的确认数据QAST控制图表跟踪QASV检验处理的采样说明QAVE检验处理：使用决策（取得检验批的结果，标识符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是采购价格的数据表，然后通过字段KNUMH；A017不能用于QUERY；T024 采购组逻辑数据表：IFM-采购信息记录；逻辑数据库：ILM-可以显示采购价格等级数据T001L库存地点PurchasingPOEKKO Purchasing DocumentHeader询报价(凭证类型A)；采购合同(凭证类型K)EKPOPurchasing Document Item DetailEKBE采购订单历史EBAN采购申请（行项目）EBKN 采购申请BAM采购申请逻辑数据库EKET采购订单delivery scheduleEKES 采购订单与内向交货单的关系；S011LIS - Purchasing GroupsS012LIS - PurchasingS013LIS - Vendor EvaluationS080LIS - Purchasing - MovementsS081LIS - Purchasing - StockS082LIS - Purchasing - Movements & StockEKBZ(发票校验和采购订单关联的表)审批表CEKKO 采购订单的审批CEBAN 采购申请Batch ManagementMCHABatchesS038LIS - Inventory Controlling - BatchesInventory ManagementMSLBSpecial Stocks with Vendor供应商特殊库存(外协，委外)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销售凭证:计划行数据VBBE 销售需求（拖延订单或者断货）VBUK销售凭证：抬头状态和管理数据（也可以看到DN单的状态）VBFA 销售凭证流，【先前的销售和分销凭证】VBELV字段就是在VA01里看到订单的最顶层；VBPA售达方、收货方再根据【地址号码】ADRNR查找【ADRC】表找到相应的地址;VBAK-VBELN 关联VBPA-VBELN；如何查找电子邮件地址？ADR6KONV销售订单价格表：Condition Procedures(含有内容比较多)（通过VBAK的KNUMV和KPOSN两个字段)Delivery DocumentsLIKPDelivery Document - Header Datal(包含售达方，送达方内容)，可以通过LIKP找到VBPA，然后再找ADRClLIKP- LFART（交货单类型）l也包含了内向交货单LIPSDelivery Document - Detail Data ；Billing DocumentsVBRK Billing Document - Header DataVBRPBilling Document - Detail DataConditionTables（价格）KONHCondition Header（通讯表）KONPCondition DetailKONVCondition Procedures(是代表销售订单的价格数据)（通过VBAK的KNUMV和KPOSN两个字段）KOTE* Rebate（回扣） Condition Tables many*966966是条件表，如果不会则前面加*查找一下；KOTN* 买赠（VBN1创建的）A8* 打折表(FI) FINANCIAL ACCOUNTINGAccounting DocumentsBKPFAccounting Document HeaderBSEGAccounting Document Detail(CO) CONTROLLINGCO-PCCOASCOSSCOSP包括所有的数量COVP保存工序确认后的数值与COBK进行关联(通过对象号，凭证编号)，业务事务COIN，一般情况下与AFRU相同。(COVP的参考凭证号码,参照组织单位与AFRU 的确认号和计数器)，AFKO的定单号与COBK关联，COBK包含相关的凭证号COEPCOVPCOEP与COBK关联VIEWERCO-PACE10010 ABC Operating Concern - DetailsCE20010 ABC Operating Concern - SummaryCE30010 ABC Operating Concern - Summary主数据CSKS成本中心CSKA成本要素CSKUCSKBCSLA作业类型（抬头）CSLT作