SAP各模块字段及表的对应关系.docx

1、SAP各模块字段及表的对应关系SAP各模块字段与表的对应关系 Customer MasterKNA1Customer Basic DataKNB1Customer pany Level Data客户的公司数据KNVVCustomer Sales Level Data 客户的销售数据KNVPCustomer Partnering Data客户合作伙伴KNKACustomer Credit Data - CentralizedKNKKCustomer Credit Data - Control Area LevelKNBKCustomer Bank DetailsKNVHCustomer Hier

2、archiesKNVLCustomer LicensesKNMTCustomer - Material Info Record，客户-物料信息记录数据表KNMTKCustomer-Material Info Record - HeaderKNVK联系人(供应商，客户)Material MasterMARAMaterial Basic Data(物料类型,)MARCMaterial MRP (Plant) Data(工厂的MRP视图)MARDMaterial Storage Data (查看总库存)（物料的仓储位置数据）MARDHMaterial StoregeData His.查看库存的历史库

3、存（月度的库存）MARM物料计量单位MBEWMaterial ValuationData(查看财务视图-)成本价格)没有工厂字段，但有评估围字段；MKALMaterial Production Version Data(生产版本)MAKTMaterial Descriptions/Short Texts(物料描述)MARMMaterial Units of Measure(物料主单位的转换数量)MVKEMaterial Sales Level Data （销售视图）MSKUSpecial Stocks with Customer ( ? )MLGNMaterial Warehouse Data

4、MVKEMaterial 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 DataL

5、FB1Vendor Master - pany 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 -

6、 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 Ho

7、liday Calendar IDsTHOCDPublic Holiday Link to Holiday CalendarTHOLPublic Holiday DefinitionTHOLTPublic Holiday TextsLine DesignLDLHLine Hierarchy HeaderLDLPLine Hierarchy ItemsLDLTLine Hierarchy Takt TimesLDLBCTakts/No. Individual Capacities per LineLDLBHLine Balance HeaderLDLBPLine Balance ItemsLDL

8、BTLine 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 numbe

9、r 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关联)包含了作业类型CRHH

10、Hierarchy HeaderCRHSHierarchy StructureCRTXWork Center Text(工作中心描述)KAKOCapacity HeaderKAZYIntervals of CapacityCRC逻辑数据库ROUTINGMAPLRouting Link to Material(查到工艺路线的产品描述，物料、组号、组计数器之间的关系)PLPORouting OperationDetails（通过PLPO的ARBID和CRHD的OBJECTID关联获得具体使用哪个工作中心，标准值也在这个表格里保存）PLKORouting Header Details（需要与MAPL

11、关联，PLNTY，PLNNR）PLABRelationships - Standard NetworkPLASTask List - Selection ofOperations（PLPO,PLAS,PLKO三者互相关联才能获得工作中心描述信息）(plpoplnnr = plasplnnr and plpozaehl = plaszaehl andplpoplnkn = plasplnkn)PLMZponent Allocation（组件分配）（是记录分配BOM到ROUTING）PLPHCAPP Sub-operationsPLFHPRT AllocationPLWPMaintenance P

12、ackage AllocationPLMKInspection CharacteristicsT435T工艺路线标准文本PNM逻辑数据库BOM (物料清单)STPOBOM Item Details(明细项)STKOBOM HeaderDetails(抬头项)（找STAS-再找STOP，这是由于STOP中无可选项字段）MASTBOM Group to Material（通过【物料单】字段与STPO、STKO关联）STZUBOM History RecordsSTASBOM Item Selection（有可选项字段）STPFBOM Explosion StructureMAST分配BOM到物料B

13、OM使用逻辑数据库的是CMCProductionVersion(生产版本)MKALMaterial Production Version Data (生产版本)Demand ManagementPBEDIndependent Requirements DataPBIMIndependent Requirements by Material（与PBED通过BDZEI关联）PBHIIndependent Requirements History（与PBIM，通过BDZEI关联）PBIDPlannedindependent requirements index: MRP areaRepetitive

14、 ManufacturingSAFKRS Header Master DataS025LIS - Run Schedule QuantitiesS026LIS - Material UsageS028LIS - Reporting Point StatisticsBLPK凭证日志标题（保存了【参考数量】）冲销类型-P，在这里通过【处理类型】来查询相关的报告点的操作，报告点的处理类型为Z。CEZPReporting Point Document Logs（行项目）CPZPReporting Points Periodic Totals(产看某期间的报告点)对象号与AFKO订单号关联；MRP Re

15、cordsMDKPMRP Document Header DataMDKPDBPLSCPlanning Scenario (Long-term Planning)MDFDMRP Firming Dates(涉及到长期计划中的计划方案)MDVMPlanning File EntriesS094LIS - Stock/Requirements Analysis(动态生成)MDTBMD04/MD05界面的数据表DTNUM，只是一份计划条目清单；UMD01保存MRP的界面参数ReservationsRKPFReservations HeaderRESBReservations/Dependent Re

16、quirements（保留相关的溯源）Planned OrdersPLAFPlannedOrdersOPIT计划订单调度记录T457P计划订单中订单类型的文本表格T460C计划订单的订单/采购订单类型T460D计划订单的订单/采购订单类型DPM计划订单逻辑数据库Discrete Production（生产订单）从CAUFV找AUFRLAFKOOrderHeader（包含有BOM和ROUTING的组信息）(工序确认,上级订单号)(不要关联该表的物料号，经常会丢失。如果关联则关联AFPO)AFPOOrder ItemDetail(订单类别【DAUTY】5产品收集器，订单类型【DAUAT】RM01，

17、有入库数【WEMNG】)RESBOrderBOM（订单里的实际BOM清单，通过AUFPL与AFVC关联，包含了订单的组件分配）AFFLOrder Sequence DetailsAFFHOrder PRT AssignmentAFBPOrder Batch Print RequestsAFVCOrder Operations Detail(与通过“组”和“计数器”关联AFKO，应该是AUFPL 订单中工序的工艺路线号 与AFKO关联)（订单里的实际工序）ARBID 资源的对象IDAFRUOrder pletion Confirmations（实际值）(生产订单确认量及所有相关的确认的数据（重复

18、制造），对象号与CRCO查找作业类新描述，通过订单号和AFPO关联)得到计划工艺路线号，然后和AFVC关联(订单号，作业编号)，再通过AFVC的活动类型到表CSLA获得具体成本要素号;AFRU的订单作业与AFVC相关联AFFWConfirmations - Goods Movementswith Errors（COGI错误库存列表）AFRCConfirmations - Incorrect CostCalculations(COGI) 确认不正确的成本核算AFRDConfirmations - Defaults forCollective ConfirmationAFRHConfirmatio

19、ns - Header Info forConfirmation PoolAUFM 保存订单的货物移动容（只保存DAUTY-10，也就是保存有生产订单，重复制造的容不放在该表）AFVV Operationdetails（生产订单的定额标准值/理论值）AFRVConfirmation PoolAFWIConfirmations - SubsequentlyPosted Goods Movements(确认的物料移动)AUFK订单主数据(包含订单的删除标志)（有PP与CO的订单号的对照表，也就是包含了“OR0000.”）CKMLMV001保存了，按照物料版本号，找到生产过程号，然后通过AUFK生产过程号。CKMLMV013保存了订单和生产版本的信息；一般来说，一个订单AUFNR就是一个版本VERID；AUFK-JEST-TJ02TOrderstatus(通过AUFK OBJNR关联)