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

SAP各模块字段与表的对应关系(2011-12-09 07:54:21)转载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 HierarchiesKNVLCustomer 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物料计量单位MBEWMaterial Valuation Data(查看财务视图-)成本价格)没有工厂字段，但有评估范围字段；MKALMaterial Production Version Data(生产版本)MAKTMaterial Descriptions/Short Texts(物料描述)MARMMaterial Units of Measure(物料主单位的转换数量)MVKEMaterial Sales Level Data （销售视图）MSKUSpecial Stocks with Customer ( ? )MLGNMaterial Warehouse DataMVKEMaterial Sales DataMTXHMaterial Long TextMCHABatch management table（批次管理）MCHB批次库存MSKASales Order 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 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 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) PRODUCTION PLANNINGWorkCenterCRHDWork Center Header DataCRCAWork Center Capacity AllocationCRCOWork Center Cost Center Assignment(通过对象号与CRHD关联)包含了作业类型CRHHHierarchy HeaderCRHSHierarchy StructureCRTXWork Center Text(工作中心描述)KAKOCapacity HeaderKAZYIntervals of CapacityCRC逻辑数据库ROUTINGMAPLRouting Link to Material(查到工艺路线的产品描述，物料、组号、组计数器之间的关系)PLPORouting Operation Details（通过PLPO的ARBID和CRHD的OBJECTID关联获得具体使用哪个工作中心，标准值也在这个表格里保存）PLKORouting Header Details（需要与MAPL关联，PLNTY，PLNNR）PLABRelationships - Standard NetworkPLASTask List - Selection of Operations（PLPO,PLAS,PLKO三者互相关联才能获得工作中心描述信息）(plpoplnnr = plasplnnr and plpozaehl = plaszaehl and plpoplnkn = plasplnkn)PLMZComponent Allocation（组件分配）（是记录分配BOM到ROUTING）PLPHCAPP Sub-operationsPLFHPRT AllocationPLWPMaintenance Package AllocationPLMKInspection CharacteristicsT435T工艺路线标准文本PNM逻辑数据库BOM (物料清单)STPOBOM Item Details(明细项)STKOBOM Header Details(抬头项)（找STAS-再找STOP，这是由于STOP中无可选项字段）MASTBOM Group to Material（通过【物料单】字段与STPO、STKO关联）STZUBOM History RecordsSTASBOM Item Selection（有可选项字段）STPFBOM Explosion StructureMAST分配BOM到物料BOM使用逻辑数据库的是CMCProduction Version(生产版本)MKALMaterial Production Version Data (生产版本)Demand ManagementPBEDIndependent Requirements DataPBIMIndependent Requirements by Material（与PBED通过BDZEI关联）PBHIIndependent Requirements History（与PBIM，通过BDZEI关联）PBIDPlanned independent 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 OrdersPLAFPlanned OrdersOPIT计划订单调度记录T457P计划订单中订单类型的文本表格T460C计划订单的订单/采购订单类型T460D计划订单的订单/采购订单类型DPM计划订单逻辑数据库Discrete Production（生产订单）从CAUFV找AUFRLAFKOOrder Header（包含有BOM和ROUTING的组信息）(工序确认,上级订单号)(不要关联该表的物料号，经常会丢失。如果关联则关联AFPO)AFPOOrder Item Detail(订单类别【DAUTY】5产品收集器，订单类型【DAUAT】RM01，有入库数【WEMNG】)RESBOrder BOM（订单里的实际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相关联AFFWConfirmations - Goods Movements with Errors（COGI错误库存列表）AFRCConfirmations - Incorrect Cost Calculations(COGI) 确认不正确的成本核算AFRDConfirmations - Defaults for Collective ConfirmationAFRHConfirmations - Header Info for Confirmation PoolAUFM保存订单的货物移动内容（只保存DAUTY-10，也就是保存有生产订单，重复制造的内容不放在该表）AFVVOperation details（生产订单的定额标准值/理论值）AFRVConfirmation PoolAFWIConfirmations - Subsequently Posted Goods Movements(确认的物料移动)AUFK订单主数据(包含订单的删除标志)（有PP与CO的订单号的对照表，也就是包含了“OR0000.”）CKMLMV001保存了，按照物料版本号，找到生产过程号，然后通过AUFK生产过程号。CKMLMV013保存了订单和生产版本的信息；一般来说，一个订单AUFNR就是一个版本VERID；AUFK-JEST -TJ02TOrder status(通过AUFK OBJNR关联)for example: OR000002014014-JSTO查询到相应的订单状态(具体TJ02T具体描述相应的状态：系统状态语言状态状态I0001ECRTDCreatedI0002ERELReleasedI0009ECNFConfirmedI0010EPCNFPartially confirmedI0012EDLVDeliveredI0013EDLTDeletion indicatorI0045ETECOTechnically completedI0046ECLSDClosed(取消，清空)TJ02TSYSTEM STATUSJEST,JSTOPO STATUS(TJ30USER STATUSJCDOChange Documents for Status Object (Table)JCDSChange Documents for System/User StatusesCOBRB结算规则表ClassificationKLAHClass DetailCABNCharacteristic DetailAUSPCharacteristic ValuesCAWNCharacteristic ValuesCAWNTCharacteristic Value TextsKSMLCharacteristic Allocation to ClassKSSKMaterial Allocation to Class（QM）Quality Management主数据检验批检验结果QADB_SCOPEScope 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) MATERIALS MANAGEMENTMasterDataEINAPurchasing 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库存地点PurchasingPOEKKOPurchasing Document Header询报价(凭证类型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采购申请CEBANBatch ManagementMCHABatchesS038LIS - Inventory Controlling - BatchesInventory ManagementMSLBSpecial Stocks with Vendor供应商特殊库存(外协，委外)MSKUSpecial Stocks with CustomerIKPFPhysical Inventory Header(盘点凭证)ISEGPhysical Inventory Document Item DetailS032LIS - Statistics Table - Current StocksS039LIS - Inventory ControllingMSKASales 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 DocumentsVBRKBilling Document - Header DataVBRPBilling Document - Detail DataCondition Tables（价格）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-PACE10010ABC Operating Concern - DetailsCE20010ABC Operating Concern - SummaryCE30010ABC Operating Concern - Summary主数据CSKS成本中心CSKA成本要素CSKUCSKBCSLA作业类型（抬头）CSLT作业类型文本批次