发布时间 : 星期三 文章SAP各模块字段与表地对应关系更新完毕开始阅读20d0caeff56527d3240c844769eae009581ba286
实用标准文案
SAP各模块字段与表的对应关系
Customer Master
KNA1 Customer Basic Data
KNB1 Customer Company Level Data客户的公司数据
KNVV Customer Sales Level Data 客户的销售数据
KNVP Customer Partnering Data客户合作伙伴
KNKA Customer Credit Data - Centralized
KNKK Customer Credit Data - Control Area Level
KNBK Customer Bank Details KNVH Customer Hierarchies KNVL Customer Licenses
KNMT Customer - Material Info Record，客户-物料信息记录数据表
KNMTK Customer- Material Info Record - Header
KNVK 联系人(供应商，客户) Material Master
MARA 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 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 Data
文档大全
实用标准文案
MVKE Material Sales Data MTXH Material Long Text
MCHA Batch management table（批次管理）
MCHB 批次库存
MSKA SalesOrder Stock（销售库存） MAPL 分配任务清单到物料，物料所建的工艺路线（Q类型为检验计划）
MAST 分配BOM到物料
MVKE MLAN MDLV MRP范围
MDLG MDMA T023 T023T
Vendor Master 供应商
LFA1 LFB1 Data（公司，财务视图）
LFM1 Data(采购组织)
LFB5 LFBK 行信息)-àBNKA银行表
LFBW Types
LBC1 Figures
LFM2 LFMC Short Text
LFMH KNVK WYT3
PP MASTER DATA (cont.) Factory Calendar
TFACD 文档大全
物料销售数据(查找销售单位) 物料的税分类
定制 MRP 运行区域(与MDLG是明细)
物料与MRP AREA的关联关系； 物料组 Vendor Master -- General Data Vendor Master -- Company Code Vendor Master -- Purchasing Org. Vendor Master -- Dunning Data Vendor Master -- Bank Details((银Vendor Master -- Withholding Tax Vendor Master -- Transaction Vendor Master -- Purchasing Data Vendor Master -- Condition Type Vendor Hierarchy 联系人(供应商，客户) 合伙人信息； Factory Calendar Definition
实用标准文案
TFACS Factory Calendar Display (days/month)
TFACT Factory Calendar Texts
TFAIN Factory Calendar -- Special Rules TFAIT Text for Factory Calendar Intervals
THOC Public Holiday Calendar ID's THOCD Public Holiday Link to Holiday Calendar THOL Public Holiday Definition THOLT
Line Design
LDLH LDLP LDLT LDLBC Line
LDLBH LDLBP LDLBT PRT's
CRFH CRVD_A CRVD_B CRVE_A CRVE_B CRVM_A CRVM_B CRVS_A External number
CRVS_B Internal number
Class & Characteristic
CABN, RMCLM.
(PP) PRODUCTION PLANNING Work Center
CRHD CRCA 文档大全
Public Holiday Texts Line Hierarchy Header Line Hierarchy Items Line Hierarchy Takt Times Takts/No. Individual Capacities per Line Balance Header Line Balance Items
Line Hierarchy Entry and Exit Takts PRT Master Data Link of PRT to Document Link of Document to PRT
Assignment of PRT data to Equipment Assignment of equipment to PRT data Link of PRT data to Material Link of Material to PRT data
Link of PRT Internal number to PRT Link of PRT External number to PRT \ \ Work Center Header Data
Work Center Capacity Allocation
实用标准文案
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 OperationDetails（通过PLPO的ARBID和CRHD的OBJECTID关联获得具体使用哪个工作中心，标准值也在这个表格里保存）
PLKO Routing Header Details（需要与MAPL关联，PLNTY，PLNNR）
PLAB Relationships - Standard Network
PLAS 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-operations PLFH PRT Allocation
PLWP Maintenance Package Allocation PLMK Inspection Characteristics T435T 工艺路线标准文本
PNM 逻辑数据库
BOM (物料清单)
STPO BOM Item Details(明细项) STKO BOM HeaderDetails(抬头项) （找STAS->再找STOP，这是由于STOP中无可选项字段）
MAST BOM Group to Material（通过【物料单】字段与STPO、STKO关联）
STZU BOM History Records
文档大全