SAP各模块字段与表的对应关系(2011-12-09 07:54:21)转载▼Customer MasterKNA1 Customer Basic DataKNB1 Customer Company Level Data客户的公司数据KNVV Customer Sales Level Data 客户的销售数据KNVP Customer Partnering Data客户合作伙伴KNKA Customer Credit Data - CentralizedKNKK Customer Credit Data - Control Area LevelKNBK Customer Bank DetailsKNVH Customer HierarchiesKNVL Customer LicensesKNMT Customer - Material Info Record，客户-物料信息记录数据表KNMTK Customer - Material Info Record - HeaderKNVK联系人(供应商，客户)Material MasterMARA Material Basic Data(物料类型,,,,,)MARC Material MRP (Plant) Data(工厂的MRP视图)MARD Material Storage Data (查看总库存)（物料的仓储位置数据）MARDH Material Storege Data His. 查看库存的历史库存（月度的库存）MARM物料计量单位MBEW Material Valuation Data(查看财务视图-)成本价格) 没有工厂字段，但有评估范围字段；MKAL Material Production Version Data(生产版本)MAKT Material Descriptions/Short Texts(物料描述)MARM Material Units of Measure(物料主单位的转换数量)MVKE Material Sales Level Data （销售视图）MSKU Special Stocks with Customer ( ? )MLGN Material Warehouse DataMVKE Material Sales DataMTXH Material Long TextMCHA Batch management table（批次管理）MCHB批次库存MSKA Sales Order Stock（销售库存）MAPL分配任务清单到物料，物料所建的工艺路线（Q类型为检验计划）MAST分配BOM到物料MVKE物料销售数据(查找销售单位)MLAN物料的税分类MDLV定制MRP 运行区域(与MDLG是明细) MRP范围MDLGMDMA物料与MRP AREA的关联关系；T023 物料组T023TVendor Master 供应商LFA1 Vendor Master -- General DataLFB1 Vendor Master -- Company Code Data（公司，财务视图）LFM1 Vendor Master -- Purchasing Org. Data(采购组织)LFB5 Vendor Master -- Dunning DataLFBK Vendor Master -- Bank Details((银行信息)-à BNKA银行表LFBW Vendor Master -- Withholding Tax TypesLBC1 Vendor Master -- Transaction FiguresLFM2 Vendor Master -- Purchasing DataLFMC Vendor Master -- Condition Type Short TextLFMH Vendor HierarchyKNVK联系人(供应商，客户)WYT3 合伙人信息PP MASTER DATA (cont.)Factory CalendarTFACD Factory Calendar DefinitionTFACS Factory Calendar Display (days/month) TFACT Factory Calendar TextsTFAIN Factory Calendar -- Special Rules TFAIT Text for Factory Calendar Intervals THOC Public Holiday Calendar ID'sTHOCD Public Holiday Link to Holiday Calendar THOL Public Holiday DefinitionTHOLT Public Holiday TextsLine DesignLDLH Line Hierarchy HeaderLDLP Line Hierarchy ItemsLDLT Line Hierarchy Takt TimesLDLBC Takts/No. Individual Capacities per Line LDLBH Line Balance HeaderLDLBP Line Balance ItemsLDLBT Line Hierarchy Entry and Exit TaktsPRT'sCRFH PRT Master DataCRVD_A Link of PRT to DocumentCRVD_B Link of Document to PRTCRVE_A Assignment of PRT data to EquipmentCRVE_B Assignment of equipment to PRT dataCRVM_A Link of PRT data to MaterialCRVM_B Link of Material to PRT dataCRVS_A Link of PRT Internal number to PRT External number CRVS_B Link of PRT External number to PRT Internal number Class & CharacteristicCABN, "CharacteristicRMCLM. "Classification(PP) PRODUCTION PLANNINGWork CenterCRHD Work Center Header DataCRCA Work Center Capacity AllocationCRCO Work Center Cost Center Assignment(通过对象号与CRHD关联)包含了作业类型CRHH Hierarchy HeaderCRHS Hierarchy StructureCRTX Work Center Text(工作中心描述)KAKO Capacity HeaderKAZY Intervals of CapacityCRC 逻辑数据库ROUTINGMAPL Routing Link to Material(查到工艺路线的产品描述，物料、组号、组计数器之间的关系)PLPO Routing Operation Details（通过PLPO的ARBID和CRHD的OBJECTID关联获得具体使用哪个工作中心，标准值也在这个表格里保存）PLKO Routing Header Details（需要与MAPL关联，PLNTY，PLNNR）PLAB Relationships - Standard NetworkPLAS Task List - Selection of Operations（PLPO,PLAS,PLKO 三者互相关联才能获得工作中心描述信息）(plpo~plnnr = plas~plnnr and plpo~zaehl = plas~zaehl and plpo~plnkn =plas~plnkn)PLMZ Component Allocation（组件分配）（是记录分配BOM到ROUTING）PLPH CAPP Sub-operationsPLFH PRT AllocationPLWP Maintenance Package AllocationPLMK Inspection CharacteristicsT435T 工艺路线标准文本PNM 逻辑数据库BOM (物料清单)STPO BOM Item Details(明细项)STKO BOM Header Details(抬头项) （找STAS->再找STOP，这是由于STOP中无可选项字段）MAST BOM Group to Material（通过【物料单】字段与STPO、STKO关联）STZU BOM History RecordsSTAS BOM Item Selection（有可选项字段）STPF BOM Explosion StructureMAST分配BOM到物料BOM使用逻辑数据库的是CMCProduction Version(生产版本)MKAL Material Production Version Data (生产版本)Demand ManagementPBED Independent Requirements DataPBIM Independent Requirements by Material（与PBED通过BDZEI关联）PBHI Independent Requirements History（与PBIM，通过BDZEI关联）PBID Planned independent requirements index: MRP areaRepetitive ManufacturingSAFK RS Header Master DataS025 LIS -- Run Schedule QuantitiesS026 LIS -- Material UsageS028 LIS -- Reporting Point StatisticsBLPK 凭证日志标题（保存了【参考数量】）冲销类型----P，在这里通过【处理类型】来查询相关的报告点的操作，报告点的处理类型为Z。

CEZP Reporting Point Document Logs（行项目）CPZP Reporting Points – Periodic Totals(产看某期间的报告点)对象号与AFKO订单号关联；MRP RecordsMDKP MRP Document Header DataMDKPDBPLSC Planning Scenario (Long-term Planning)MDFD MRP Firming Dates(涉及到长期计划中的计划方案) MDVM Planning File EntriesS094 LIS -- Stock/Requirements Analysis(动态生成)MDTB MD04/MD05界面的数据表 DTNUM，只是一份计划条目清单；UMD01 保存MRP的界面参数ReservationsRKPF Reservations HeaderRESB Reservations/Dependent Requirements（保留相关的溯源）Planned OrdersPLAF Planned OrdersOPIT 计划订单调度记录T457P 计划订单中订单类型的文本表格T460C 计划订单的订单/采购订单类型T460D 计划订单的订单/采购订单类型DPM 计划订单逻辑数据库Discrete Production（生产订单）从CAUFV找AUFRLAFKO Order Header（包含有BOM和ROUTING的组信息）(工序确认,上级订单号)(不要关联该表的物料号，经常会丢失。