SAP各模块常用表.doc

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是明细) MRP范围
MDLG                               
MDMA                       物料与MRP AREA的关联关系；
T023                           物料组
T023T                                 
Vendor 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 Types
LBC1                         Vendor Master -- Transaction Figures
LFM2                        Vendor Master -- Purchasing Data
LFMC                        Vendor Master -- Condition Type Short Text
LFMH                       Vendor Hierarchy
KNVK                       联系人(供应商，客户)
WYT3                        合伙人信息；
PP MASTER DATA (cont.)
Factory Calendar
TFACD                      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                      Public Holiday Texts
Line Design
LDLH                        Line Hierarchy Header
LDLP                         Line Hierarchy Items
LDLT                        Line Hierarchy Takt Times
LDLBC                     Takts/No. Individual Capacities per Line
LDLBH                     Line Balance Header
LDLBP                      Line Balance Items
LDLBT                     Line Hierarchy Entry and Exit Takts

PRT's
CRFH                        PRT Master Data
CRVD_A                    Link of PRT to Document
CRVD_B                    Link of Document to PRT
CRVE_A                    Assignment of PRT data to Equipment
CRVE_B                    Assignment of equipment to PRT data
CRVM_A                  Link of PRT data to Material
CRVM_B                  Link of Material to PRT data
CRVS_A                    Link of PRT Internal number to PRT External number
CRVS_B                    Link of PRT External number to PRT Internal number
Class & Characteristic
CABN,                              "Characteristic
RMCLM.                          "Classification

(PP) PRODUCTION PLANNING
Work Center
CRHD                        Work Center Header Data
CRCA                        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
STAS                         BOM Item Selection（有可选项字段）
STPF                          BOM Explosion Structure
MAST                         分配BOM到物料
BOM                          使用逻辑数据库的是CMC
ProductionVersion(生产版本)
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                          Plannedindependent 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界面的数据表   DTNUM，只是一份计划条目清单；
UMD01                      保存MRP的界面参数
Reservations
RKPF                               Reservations Header
RESB                         Reservations/Dependent Requirements（保留相关的溯源）

Planned Orders
PLAF                                PlannedOrders
OPIT                                计划订单调度记录
T457P                              计划订单中订单类型的文本表格
T460C                              计划订单的订单/采购订单类型
T460D                              计划订单的订单/采购订单类型
DPM                                 计划订单逻辑数据库

Discrete Production（生产订单）
从CAUFV找AUFRL
AFKO                        OrderHeader（包含有BOM和ROUTING的组信息）(工序确认,上级订单号)(不要关联该表的物料号，经常会丢失。如果关联则关联AFPO)
AFPO                        Order ItemDetail(订单类别【DAUTY】－5产品收集器，订单类型【DAUAT】－RM01，有入库数【WEMNG】)
RESB                         OrderBOM（订单里的实际BOM清单，通过AUFPL与AFVC关联，包含了订单的组件分配）
AFFL                         Order Sequence Details
AFFH                        Order PRT Assignment
AFBP                        Order Batch Print Requests
AFVC                         Order Operations Detail (与通过“组”和“计数器”关联AFKO，应该是AUFPL [订单中工序的工艺路线号] 与AFKO关联)（订单里的实际工序）
ARBID                       资源的对象ID
AFRU                         Order Completion Confirmations（实际值）
(生产订单确认量及所有相关的确认的数据（重复制造），对象号与CRCO查找作业类新描述，通过订单号和AFPO关联)得到计划工艺路线号，然后和AFVC关联(订单号，作业编号)，再通过AFVC的活动类型到表CSLA获得具体成本要素号;[AFRU的订单＆作业与AFVC相关联]
AFFW                          Confirmations -- Goods Movementswith Errors（COGI错误库存列表）
AFRC                           Confirmations -- Incorrect CostCalculations(COGI) 确认不正确的成本核算
AFRD                           Confirmations -- Defaults forCollective Confirmation
AFRH                          Confirmations -- Header Info forConfirmation Pool
AUFM                          保存订单的货物移动内容（只保存DAUTY-10，也就是保存有生产订单，重复制造的内容不放在该表）
AFVV                           Operationdetails（生产订单的定额－标准值/理论值）
AFRV                           Confirmation Pool
AFWI                           Confirmations -- SubsequentlyPosted Goods Movements(确认的物料移动)
AUFK                           订单主数据(包含订单的删除标志)（有PP与CO的订单号的对照表，也就是包含了“OR0000….”）
CKMLMV001                   保存了，按照物料＋版本号，找到生产过程号，然后通过AUFK生产过程号。
CKMLMV013                   保存了订单和生产版本的信息；一般来说，一个订单AUFNR就是一个版本VERID；
AUFK->JEST->TJ02T     Orderstatus(通过AUFK OBJNR关联)  for example:OR000002014014
->JSTO                               查询到相应的订单状态(具体
TJ02T                                  具体描述相应的状态：
系统状态

语言
状态

状态

I0001

E
CRTD

Created
I0002

E
REL

Released
I0009

E
CNF

Confirmed
I0010

E
PCNF

Partially confirmed
I0012

E
DLV

Delivered
I0013

E
DLT

Deletion indicator
I0045

E
TECO

Technically completed
I0046

E
CLSD

Closed(取消，清空)

TJ02T                                SYSTEM STATUS
JEST,JSTO                         PO STATUS(
TJ30                                   USERSTATUS
JCDO                                  ChangeDocuments for Status Object (Table)
JCDS                                   ChangeDocuments for System/User Statuses
COBRB                                结算规则表

Classification
KLAH                         Class Detail
CABN                        Characteristic Detail
AUSP                         Characteristic Values
CAWN                       Characteristic Values
CAWNT                     Characteristic Value Texts
KSML                         Characteristic Allocation to Class
KSSK                          Material Allocation to Class

（QM）Quality Management
主数据
检验批
检验结果

QADB_SCOPE             Scope from ASAP QADB
QAES                          采样单位表
QAKL                          数值分类的结果表
QALS                          检验批记录（查看检验批的状态：。。。。）
QALT                          部分批量
QAMB                         QM：检验批和物料凭证的连接(参考类型－，STAT35－代表有结论；STAT34－Q库存释放是否完全释放
QAMR                         检验处理中的特性结果
QAMV                         检验处理的特性说明
QAMVRMS                 多重说明的检验说明/评估
QAOBJMS                  多个说明 - 对象
QAPP                          检验点
QASE                          采样单元的结果表
QASH                          控制图表
QASR                          检验特性的采样结果
QASRMS                     多重说明样品的确认数据
QAST                          控制图表跟踪
QASV                          检验处理的采样说明
QAVE                          检验处理：使用决策（取得检验批的结果，标识符KZART＝L，UD代码＝P003）
QPMK                        主检验特性
(MM) MATERIALS  MANAGEMENT
Master  Data
EINA                         Purchasing Info Record -- General Data（采购信息记录）
EINE                          Purchasing Info Record -- Purchasing Org. Data(采购信息记录-采购视图)；与EINA是一对多的；
EQUK                        Quota Arrangement Header(配额)
EQUP                        Quota Arrangement Item Detail
EORD                        Source Lists 货源清单
KOMV                       Header Conditions（通讯表）
KONP                        Item Conditions（通讯表）， A017是采购价格的数据表，然后通过字段KNUMH；A017不能用于QUERY；
T024                          采购组
逻辑数据表：IFM-采购信息记录；
逻辑数据库：ILM----可以显示采购价格等级数据
T001L                          库存地点
Purchasing
PO
EKKO                        Purchasing DocumentHeader询报价(凭证类型＝A)；采购合同(凭证类型＝K)
EKPO                        Purchasing Document Item Detail
EKBE                         采购订单历史
EBAN                        采购申请（行项目）
EBKN                        采购申请
BAM                         采购申请逻辑数据库
EKET                           采购订单delivery schedule
EKES                           采购订单与内向交货单的关系；
S011                           LIS -- Purchasing Groups
S012                           LIS -- Purchasing
S013                           LIS -- Vendor Evaluation
S080                           LIS -- Purchasing - Movements
S081                           LIS -- Purchasing - Stock
S082                           LIS -- Purchasing - Movements & Stock
EKBZ                                 (发票校验和采购订单关联的表)

审批表
CEKKO                         采购订单的审批              
CEBAN                         采购申请                         
Batch Management
MCHA                       Batches
S038                          LIS -- Inventory Controlling - Batches
Inventory Management
MSLB                        Special Stocks with Vendor供应商特殊库存(外协，委外)
MSKU                        Special Stocks with Customer
IKPF                           Physical Inventory Header(盘点凭证)
ISEG                           Physical Inventory Document Item Detail
S032                           LIS -- Statistics Table - Current Stocks
S039                           LIS -- Inventory Controlling
MSKA                         Sales Order Stock
MCHA                         批次库存
MCHB                          批次库存
Material Documents
MKPF                        Material Document Header
MSEG                       Material Document Item Detail
Warehouse Management
LTAK                        Transfer Order Header
LTAP                         Transfer Order Item Detail
LTBK                        Transfer Requirement Header
LTBP                         Transfer Requirement Item Detail
LAGP                        Storage Bin Master
Invoice verify
BKPF
BSEG
(SD) SALES AND DISTRIBUTION

Sales Documents
VBAK                       Sales Document - Header Data
VBAP                        Sales Document - Detail Data （保存了）
VBEP