1、sap各模块表的关系Customer MasterKNA1Customer Basic DataKNB1Customer Company Level Data客户的公司数据KNVVCustomer Sales Level Data 客户的销售数据KNVPCustomer Partnering Data客户合作伙伴KNKACustomer Credit Data - CentralizedKNKKCustomer Credit Data - Control Area LevelKNBKCustomer Bank DetailsKNVHCustomer HierarchiesKNVLCustome
2、r LicensesKNMTCustomer - Material Info Record,客户-物料信息记录数据表KNMTKCustomer-Material Info Record - HeaderKNVK联系人(供应商,客户)Material MasterMARAMaterial Basic Data(物料类型,)MARCMaterial MRP (Plant) Data(工厂的MRP视图)MARDMaterial Storage Data (查看总库存)(物料的仓储位置数据)MARDHMaterial StoregeData His.查看库存的历史库存(月度的库存)MARM物料计量单位
3、MBEWMaterial ValuationData(查看财务视图-)成本价格)没有工厂字段,但有评估范围字段;MKALMaterial Production Version Data(生产版本)MAKTMaterial Descriptions/Short Texts(物料描述)MARMMaterial Units of Measure(物料主单位的转换数量)MVKEMaterial Sales Level Data (销售视图)MSKUSpecial Stocks with Customer ( ? )MLGNMaterial Warehouse DataMVKEMaterial Sale
4、s 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
5、 - 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 Ty
6、pe 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 Calenda
7、r 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 ItemsLDLBTLine Hierar
8、chy 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 Exte
9、rnal 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 Hea
10、derCRHSHierarchy StructureCRTXWork Center Text(工作中心描述)KAKOCapacity HeaderKAZYIntervals of CapacityCRC逻辑数据库ROUTINGMAPLRouting Link to Material(查到工艺路线的产品描述,物料、组号、组计数器之间的关系)PLPORouting OperationDetails(通过PLPO的ARBID和CRHD的OBJECTID关联获得具体使用哪个工作中心,标准值也在这个表格里保存)PLKORouting Header Details(需要与MAPL关联,PLNTY,PLNN
11、R)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 All
12、ocationPLMKInspection 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到物料BOM使用逻辑数据库的
13、是CMCProductionVersion(生产版本)MKALMaterial Production Version Data (生产版本)Demand ManagementPBEDIndependent Requirements DataPBIMIndependent Requirements by Material(与PBED通过BDZEI关联)PBHIIndependent Requirements History(与PBIM,通过BDZEI关联)PBIDPlannedindependent requirements index: MRP areaRepetitive Manufactu
14、ringSAFKRS Header Master DataS025LIS - Run Schedule QuantitiesS026LIS - Material UsageS028LIS - Reporting Point StatisticsBLPK凭证日志标题(保存了【参考数量】)冲销类型-P,在这里通过【处理类型】来查询相关的报告点的操作,报告点的处理类型为Z。CEZPReporting Point Document Logs(行项目)CPZPReporting Points Periodic Totals(产看某期间的报告点)对象号与AFKO订单号关联;MRP RecordsMDKPM
15、RP 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
16、(保留相关的溯源)Planned OrdersPLAFPlannedOrdersOPIT计划订单调度记录T457P计划订单中订单类型的文本表格T460C计划订单的订单/采购订单类型T460D计划订单的订单/采购订单类型DPM计划订单逻辑数据库Discrete Production(生产订单)从CAUFV找AUFRLAFKOOrderHeader(包含有BOM和ROUTING的组信息)(工序确认,上级订单号)(不要关联该表的物料号,经常会丢失。如果关联则关联AFPO)AFPOOrder ItemDetail(订单类别【DAUTY】5产品收集器,订单类型【DAUAT】RM01,有入库数【WEMNG
17、】)RESBOrderBOM(订单里的实际BOM清单,通过AUFPL与AFVC关联,包含了订单的组件分配)AFFLOrder Sequence DetailsAFFHOrder PRT AssignmentAFBPOrder Batch Print RequestsAFVCOrder Operations Detail(与通过“组”和“计数器”关联AFKO,应该是AUFPL 订单中工序的工艺路线号 与AFKO关联)(订单里的实际工序)ARBID 资源的对象IDAFRUOrder Completion Confirmations(实际值)(生产订单确认量及所有相关的确认的数据(重复制造),对象号
18、与CRCO查找作业类新描述,通过订单号和AFPO关联)得到计划工艺路线号,然后和AFVC关联(订单号,作业编号),再通过AFVC的活动类型到表CSLA获得具体成本要素号;AFRU的订单作业与AFVC相关联AFFWConfirmations - Goods Movementswith Errors(COGI错误库存列表)AFRCConfirmations - Incorrect CostCalculations(COGI) 确认不正确的成本核算AFRDConfirmations - Defaults forCollective ConfirmationAFRHConfirmations - He
19、ader Info forConfirmation PoolAUFM保存订单的货物移动内容(只保存DAUTY-10,也就是保存有生产订单,重复制造的内容不放在该表)AFVVOperationdetails(生产订单的定额标准值/理论值)AFRVConfirmation PoolAFWIConfirmations - SubsequentlyPosted Goods Movements(确认的物料移动)AUFK订单主数据(包含订单的删除标志)(有PP与CO的订单号的对照表,也就是包含了“OR0000.”)CKMLMV001保存了,按照物料版本号,找到生产过程号,然后通过AUFK生产过程号。CKMLMV013保存了订单和生产版本的信息;一般来说,一个订单AUFNR就是一个版本VERID;AUFK-JEST-TJ02TOrderstatus(通过AUFK OBJNR关联)for example:OR4-JSTO
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1