SAP各模块字段与表的对应关系 下载本文

CRCO Work Center Cost Center Assignment(通过对象号与CRHD关联)包含了作业类型

CRHH Hierarchy Header CRHS Hierarchy Structure

CRTX Work Center Text(工作中心描述) KAKO Capacity Header KAZY Intervals of Capacity

CRC 逻辑数据库

ROUTING

MAPL Routing Link to Material(查到工艺路线的产品描述,物料、组号、组计数器之间的关系)

PLPO Routing Operation Details(通过PLPO的ARBID和CRHD的OBJECTID关联获得具体使用哪个工作中心,标准值也在这个表格里保存)

PLKO Routing Header Details(需要与MAPL关联,PLNTY,PLNNR)

PLAB Relationships - Standard Network

PLAS 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-operations PLFH PRT Allocation

PLWP Maintenance Package Allocation PLMK Inspection Characteristics T435T 工艺路线标准文本

PNM 逻辑数据库

BOM (物料清单)

STPO BOM Item Details(明细项)

STKO BOM Header Details(抬头项) (找STAS->再找STOP,这是由于STOP中无可选项字段)

MAST BOM Group to Material(通过【物料单】字段与STPO、STKO关联)

STZU BOM History Records

STAS BOM Item Selection(有可选项字段) STPF BOM Explosion Structure MAST 分配BOM到物料 BOM 使用逻辑数据库的是CMC

Production Version(生产版本)

MKAL Material Production Version Data (生产版本)

Demand Management

PBED Independent Requirements Data

PBIM Independent Requirements by Material(与PBED通过BDZEI关联)

PBHI Independent Requirements History(与PBIM,通过BDZEI关联)

PBID Planned independent requirements index: MRP area

Repetitive Manufacturing

SAFK RS Header Master Data S025 LIS -- Run Schedule Quantities S026 LIS -- Material Usage

S028 LIS -- Reporting Point Statistics

BLPK 凭证日志标题(保存了【参考数量】)冲销类型----P,在这里通过【处理类型】来查询相关的报告点的操作,报告点的处理类型为Z。 CEZP Reporting Point Document Logs(行项目)

CPZP Reporting Points – Periodic Totals(产看某期间的报告点)对象号与AFKO订单号关联;

MRP Records

MDKP MRP Document Header Data MDKPDB

PLSC Planning Scenario (Long-term Planning)

MDFD MRP Firming Dates(MDVM Planning File Entries

S094 LIS -- Stock/Requirements Analysis(MDTB MD04/MD05划条目清单;

UMD01

Reservations

RKPF Reservations Header

RESB Reservations/Dependent Requirements源)

Planned Orders

PLAF Planned Orders

涉及到长期计划中的计划方案) 动态生成) 界面的数据表 DTNUM,只是一份计保存MRP的界面参数 (保留相关的溯 OPIT 计划订单调度记录

T457P 计划订单中订单类型的文本表格 T460C 计划订单的订单/采购订单类型 T460D 计划订单的订单/采购订单类型 DPM 计划订单逻辑数据库

Discrete Production(生产订单)

从CAUFV找AUFRL

AFKO Order Header(包含有BOM和ROUTING的组信息)(工序确认,上级订单号)(不要关联该表的物料号,经常会丢失。如果关联则关联AFPO)

AFPO Order Item Detail(订单类别【DAUTY】-5产品收集器,订单类型【DAUAT】-RM01,有入库数【WEMNG】)

RESB Order BOM(订单里的实际BOM清单,通过AUFPL与AFVC关联,包含了订单的组件分配) AFFL Order Sequence Details AFFH Order PRT Assignment AFBP Order Batch Print Requests