当前位置:文档之家› SAP各模块字段与表地对应关系

SAP各模块字段与表地对应关系

SAP各模块字段与表的对应关系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 ValuationData(查看财务视图-)成本价格) 没有工厂字段,但有评估范围字段;MKAL Material Production VersionData(生产版本)MAKT Material Descriptions/ShortTexts(物料描述)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 SalesOrder Stock(销售库存)MAPL 分配任务清单到物料,物料所建的工艺路线(Q类型为检验计划)MAST 分配BOM到物料MVKE 物料销售数据(查找销售单位) MLAN 物料的税分类MDLV 定制 MRP 运行区域(与MDLG是明细) MRP范围MDLGMDMA 物料与MRP AREA的关联关系;T023 物料组T023TVendor Master 供应商LFA1 Vendor Master -- General Data LFB1 Vendor Master -- Company Code Data(公司,财务视图)LFM1 Vendor Master -- Purchasing Org. Data(采购组织)LFB5 Vendor Master -- Dunning Data LFBK Vendor Master -- Bank Details((银行信息)-àBNKA银行表LFBW Vendor Master -- Withholding Tax TypesLBC1 Vendor Master -- Transaction FiguresLFM2 Vendor Master -- Purchasing Data LFMC 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 IntervalsTHOC Public Holiday Calendar ID's THOCD Public Holiday Link to Holiday Calendar THOL Public Holiday Definition THOLT Public Holiday TextsLine DesignLDLH Line Hierarchy HeaderLDLP Line Hierarchy ItemsLDLT Line Hierarchy Takt Times LDLBC Takts/No. Individual Capacities per LineLDLBH 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 Equipment CRVE_B Assignment of equipment to PRT data CRVM_A Link of PRT data to MaterialCRVM_B Link of Material to PRT dataCRVS_A Link of PRT Internal number to PRT External numberCRVS_B Link of PRT External number to PRT Internal numberClass & CharacteristicCABN, "Characteristic RMCLM. "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 OperationDetails(通过PLPO的ARBID和CRHD的OBJECTID关联获得具体使用哪个工作中心,标准值也在这个表格里保存)PLKO Routing Header Details(需要与MAPL关联,PLNTY,PLNNR)PLAB Relationships - Standard NetworkPLAS Task List - Selection ofOperations(PLPO,PLAS,PLKO三者互相关联才能获得工作中心描述信息)(plpo~plnnr = plas~plnnr and plpo~zaehl = plas~zaehl andplpo~plnkn = plas~plnkn) PLMZ Component Allocation(组件分配)(是记录分配BOM到ROUTING)PLPH CAPP Sub-operationsPLFH PRT AllocationPLWP Maintenance Package Allocation PLMK Inspection CharacteristicsT435T 工艺路线标准文本PNM 逻辑数据库BOM (物料清单)STPO BOM Item Details(明细项) STKO BOM HeaderDetails(抬头项) (找STAS->再找STOP,这是由于STOP中无可选项字段)MAST BOM Group to Material(通过【物料单】字段与STPO、STKO关联)STZU BOM History RecordsSTAS BOM Item Selection(有可选项字段)STPF BOM Explosion Structure MAST 分配BOM到物料BOM 使用逻辑数据库的是CMCProductionVersion(生产版本)MKAL Material Production Version Data (生产版本)Demand ManagementPBED Independent Requirements Data PBIM Independent Requirements by Material(与PBED通过BDZEI关联)PBHI Independent Requirements History(与PBIM,通过BDZEI关联)PBID Plannedindependent 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 Data MDKPDBPLSC 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 PlannedOrders OPIT 计划订单调度记录T457P 计划订单中订单类型的文本表格T460C 计划订单的订单/采购订单类型T460D 计划订单的订单/采购订单类型DPM 计划订单逻辑数据库Discrete Production(生产订单)从CAUFV找AUFRLAFKO OrderHeader(包含有BOM和ROUTING 的组信息)(工序确认,上级订单号)(不要关联该表的物料号,经常会丢失。

相关主题