SAP各模块表关系
(完整版)SAP科目表详解
SAP 会计科目表层次成本控制范围公司代码成本中心组成本中心浪潮信息成本控制范围ιo∞I浪潮北京n∞I浪潮济南1200 II浪潮北京浪渤济南I I I I I销售郡门管理部门制造部门管ITsMl销售祁门则卿处网卿制花中心财夯部J安徽办李处福曲事处人力则0I 人力詡部SB甘舷事处I I ...采购部广东办事处广东加事处■ ■•••SAP 财务系统总账的三套会计科目表并存，为跨国公司属地化核算和集团化管理并行提供了可能在SAP财务系统中存在三大类会计科目表：运营会计科目表、集团会计科目表和国家会计科目表。
其中运营会计科目表是记账必须的会计科目表，集团会计科目表是集团出具合并会计报表使用的会计科目表，国家会计科目表是为了满足某国要求，出具的符合该国会计准则要求的科目表。
三套科目表的设置为一个经营实体按照不同的会计科目系统出具报告提供了可能，换句话说也就是每个公司都可以分别按照三套科目表出具财务报告，这种功能的设置为集团公司，特别是跨国集团公司提供了集团化管理和属地化管理并重的可能性。
SAP财务系统对集团公司的会计科目表设计通常给出两种建议方案：方案1：全集团统一使用一套会计科目表：不论是控股公司还是下级单位都共享一套完整的会计科目表，各家公司在完整的会计科目表里选择自己需要的会计科目，从而生成每个公司代码的个性化的会计科目表。
方案2：用分行业的会计科目表：如一个大型企业，同时经营多种行业，如果共用一套会计科目表，其中的科目数量将是庞大的，且覆盖了各种各样的行业特殊的科目。
所以可以采用相同的行业共用一个会计科目表，这些分行业的会计科目表又能分配给同一个合并会计科目表，这个合并科目表中的科目与分行业科目表中的科目具有对应的关系。
通过这样的管理，既实现了分行业的会计核算，整个集团又有一个统一的核算口径。
多重会计核算原则并行在SAP财务管理系统中可以容纳多重的会计核算原则，即按照不同的核算规则进行核算，并分别记录。
SAP实施PM常见表关系图
KSML 类的特性
CLINT POSNR ADZHL ATINN 内部分类号 项目编号 内部计数器 内部特性
ATINN
CABN 特征
ATINN ADZHL ATNAM
ATINN/LANG
CABNT 特性描述
ATINN SPRAS ADZHL ATBEZ 内部特性 语言代码 内部计数器 特性描述
JSTO 状态对象信息
TJ30 用户状态
STSMA ESTAT INIST HSONR NSONR BERSL OBJNR 状态参数文件 用户状态 初始状态标志 最高状态号 最低状态号 权限码
VIAFKOS PM订单选择(表 AUFK/AFKO/AFIH/ILOA的视图) VIAUFKST 由状态选择的PM订单 (表AUFK/AFKO/AFIH/ILOA的视图)
订单号 订单类型 描述 长文本存在 对象号 主工作中心 订单估算成本 删除标志 工厂
BUKRS GSBER KOKRS KOSTV PRCTR SCOPE FUNC_AREA ABKRS PSPEL
公司代码 业务范围 成本控制域 成本中心 利润中心 对象类 功能范围 分配组 WBS元素
内部特性 内部计数器 特征名称
TIDNR IWERK INGRP SUBMT
GEWRK=OBJID PPSID=OBJID ILOAN
STLTY/STLNR/STLKN STPO BOM项目 STLTY STLNR STLKN STPOZ DATUV LKENZ VGKNT POSNR POSTP IDNRK MENGE MEINS STLKZ UPSKZ BOM类别 物料单 BOM项目节点号 内部计数器 有效起始日期 删除标识 父节点 BOM项目号 项目类别(物料单) BOM组件 组件数量 组件计量单位 标识符:装配 指示符:子项目存在 STLTY/STLNR STKO BOM表头 STLTY STLNR STLAL STKOZ DATUV LKENZ LOEKZ STLST WRKAN BOM类别 物料单 可选的BOM 内部计数器 有效起始日期 删除标识 BOM删除标志 BOM状态 工厂
常用SAP表格
报表开发沟通资料一、SAP常用表列举MM模块主数据：MARA－基础数据；包括物料编号、物料类型、基本计量单位、物料组、重量、等物料基础数据及部分工厂存储/1－2视图内容。
MVKE－销售视图数据；物料的销售组织、分销渠道、行项目类别组、等销售视图1－2数据；销售一般/工厂数据则分别包含在MARA/MARC两个表中。
MARC－物料工厂数据；MRP1－4视图及采购视图及销售视图、工作计划视图、工厂存储/数据1/2。
MAKT－物料描述数据T023T－物料组描述T024—需方联系人、电话号码等MKPF—物料移动凭证MARD－物料的仓储位置数据(可用库存数据)MARM－物料的计量单位数据MBEW－物料财务数据（标准价格、价格单位）MCHA－物料的批次数据MCHB－具有批次管理的物料的库存数据MLAN－物料的税分类数据T001L－物料的负库存数据，也可以用来查看系统的库存地点清单；LFM1－供应商采购数据LFA1—供应商描述CDPOS---采购订单项目更改CDHDR----采购订单项目更改抬头业务数据：MKPF―物料凭证－抬头数据，可根据时间及移动类型查找物料凭证；MSEG－物料凭证数据－行项目数据，物料凭证中详细的数据均在此表中；ISEG－库存盘点凭证数据EBAN－采购申请行项目数据EINA－采购信息记录一般数据EINE－采购信息记录采购组织数据EIPA－采购信息记录价格数据EKBE－采购订单历史记录EKET－交货时间数据EKKO－采购订单抬头数据EKPO－采购订单行项目数据LQUA—查询物料库存及仓位NAST---消息类型MVER—累计消耗量ZPLAN2PR—采购计划与申请对照表（秋碧）ZJHRQ_CG——采购再计划日期备份ZPLAF1——采购计划备份表MKOL—供应商的特殊库存A018——物料订价的有效期A017——采购信息记录的有效期（有条件记录号字段KNUMH）MSLB——库存状态查询PLAF——计划订单TOO1L——库存地点描述KOND——定价条件KONH——定价条件类型T024E——采购组织描述T024W——工厂下的采购组织T320——工厂下的仓储地点RKWA——寄售结算凭证KONP——采购信息记录的条件类型（有条件记录号字段KNUMH）KONV——定价条件明细LFB1——供应商会计数据LFC1——供应商余额1、SD模块主数据：KNA1－客户主数据KNVH－客户层次数据KNVI－客户主数据－税分类数据KNVK－客户主数据合伙人信息KNVP－客户主数据合伙人功能数据KNVV－客户主数据销售组织数据KNKA－信用主数据业务数据：VAKGU－与客户相关的销售订单数据VAKPA－与合伙人相关的销售订单及客户、订单类型、销售范围数据VAPMA－与物料相关的销售订单及销售组织、订单类型、销售范围数据VBAK－销售订单抬头数据VBAP－销售订单行项目数据；包含具体的物料信息及相关信息VBBE－与销售订单个别需求相关的数据；包含物料可用数量及未清数量等数据VBBS－与销售订单总需求相关的数据；包含物料可用数量及未清数量等数据VBEP－销售订单计划行数据VBFA－销售订单凭证流数据VBPA－与客户相关销售订单数据VBRK－发票抬头数据；包含客户信息VBRP－发票行项目数据；包含客户、物料、销售订单等详细数据LIPS－交货订单行项目数据（通过库位来判断是否已经检配）VBUK－销售订单抬头数据：主要是订单管理及状态信息VBUP－销售订单行项目数据：主要是订单管理及状态数据VBUV－销售订单不完整日志VEPVG－与交货相关的数据VLPMA－与交货相关的数据；包含物料、交货单、售达方等数据VRKPA－与交货相关合伙人数据；包含发票、付款方等数据VRPMA－与物料相关的发票行项目数据2、PP模块主数据：CRHD－工作中心主数据（表关键字“对象标识”）CRCO－工作中心与成本中心分配关系CRCA－中作中心能力分配CRTX－工作中心文本描述MAST－物料bom清单（表关键字“BOM”）STKO－BOM抬头数据STPO－物料bom行项目数据ZPSM—导出BOM（开发的报表）MAPL－工艺路线数据PLPO—工艺路线描述RESB—订单预留表批量提取物料BOM：MAST—>STLNR—>STPO—>IDNRK业务数据：AFKO－生产订单抬头数据AFUU－工序数据(工序换算关系中的分子、分母)AFUL－工序号AFPO－生产订单行项目数据PLAF－生产计划项目数据RESB－订单预留（包括相关需求）AFRU－生产订单确认数据KEKO－产品成本估算抬头数据AUFK－生产订单主数据AUFM－基于订单的物料移动数据；包含物料凭证、销售订单、生产订单、交货状态、金额、数量、移动类型、总帐科目等具体字段COAS－生产订单控制数据AFRU—报工单内部表单3、FI/CO模块主数据：ANLA－资产主记录段ANLC－资产值字段ANLP－资产期间价值ANEA－用于比例值的资产行项目CSKA－成本要素(数据与科目表相关)CSKB－成本要素(数据与成本控制范围相关)CSKU－成本要素文本CSKS－成本中心主数据CSKT－成本中心说明文本CSLA－作业类型主数据CSLT－作业类型文本CSSL－成本中心/作业类型CSSK－成本中心/成本要素业务数据：BSID－会计核算：客户的第二次索引（与客户关联的凭证数据）BSAD－会计核算：客户的第二个索引（已结算项目）BSAK－有关应付－供应商会计凭证数据BSAS－有关GR/IR的会计凭证数据BSEG－会计核算凭证段：包括有关发票的数据BSIK－会计核算：可以和供应商关联的凭证数据BSAK－会计核算：供应商的第二个索引（已结算项目）有科目编号、发票号、凭证编号、供应商编号等字段数据BKPF－会计核算凭证标题COSS－CO 对象:内部过帐成本总计COSP－CO 对象：外部记帐的成本总计V_ANEPK－带有行项目标题信息的资产行项目FAGLFLEXT－总帐: 总计SKA1－总帐科目主记录(科目表)SKAT－总帐科目主记录（科目表：说明）二、一般业务逻辑1、物料移动与物料凭证的关系：物料在工厂内及工厂间移动或进行采购收货及销售发货时都会产生物料凭证，该凭证中记录了物料的原存储地点、数量、批次、工厂、收货仓储地点等数据；2、物料移动与会计凭证的关系：一般的采购收货、销售发货、各种消耗都会产生会计凭证；该凭证主要记录了借/贷方的科目、金额、差异等数据；另外：库存地之间的物料转储、寄售收货、供应商库存发货等均不会产生会计凭证，只产生物料凭证。
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。
SAP表对应关系
VBELN POSNR销售索引 ： 按物料的订单项目VBBE销售需求： 单独记录VBLB销售凭证:批准订单数据VEPVG VAKPA销售索引 ： 按合作伙伴功能的订单VBEP销售凭证:计划行数据交货到期索引VKDFSSD索引： 出具发票初始器VBEP-VBELNVAPMAVBAP-VBELN VBAP-POSNR=VBEP-VBELN=VBEP-POSNRVBAK-VBELN=销售订单VBAK-VBELN=VBAP-VBELNVBBE-VBELN=VBAK-VBELNVBLB-VBELN=VBAK-VBELNVBAK销售凭证 ： 抬头数据VBPA销售凭证 ：ETENR VBEH 计划行历史交货单SD凭证:交货抬头数据LIPS-VGBEL VBPA-VBELN=LIPS-VGPOS=VBAP-POSNRLIPS-VGBEL=VBAP-VBELN SD凭证:交货项目数据LIPSVBLK销售凭证：交货抬头LIKP-VBELN=VBLK-VBELN VEPO-VBE LIKP-VBEVTTP-VBE LIKP-VBELIPS-VBELN=LIKP-VBELNLIKPVBAP销售凭证:项目数据VBKD销售凭证 ： 业务数据VBKD-POSNR=VBAP-POSNR VBKD-VBELN VBAP-VBELN=VBAP-VBELN=VBPA-VBELN VBPA-POSNR=VBAP-POSNRVBPA证 ： 合作伙伴VBFA 销售凭证流VBUK销售凭证：抬头状态和管理数据VBUP销售凭证 ： 项目状态VBRK-KNUMV KONV-KNUMVVBRP-VBELN=VBRK-VBELNVBRP-VGBEL LIPS-POSNR=VBRP-VGPOSKONV条件（事务数据）VBRK出具发票:抬头数据VBRP出具发票:项数据货单VTTP 装运项目VTTK 装运抬头VTTP-TKNUM LIPS-VBELN=VEPO包装: 处理单位项目VEKPO-VBELN=P-VBELNVEPO-VENUM=VEKP-VENUMP-VBELN=P-VBELNVTTK-TKNUM=处理单位 - 抬头表出具发票VBSK关于销售凭证抬头的汇总处理VBSS汇总处理： 销售凭证VKDFSSD索引： 出具发票初始器NAST消息状态VRPMA销售索引 ： 每一物料的开票项目VRKPA销售索引 ： 按合作伙伴功能的票据。
SAP 常用表及表关系
SAP MM常用表及表关系一、MM常用表1、MARA: 常规物料数据2、MARC: 物料的工厂数据3、MAKT: 物料描述4、MARD: 物料的工厂/库存地点数据5、MBEW: 物料评估（财务数据），其中MBEW-WERKS指工厂6、MVKE: 物料销售数据7、MLGN: 每一个仓库号物料数据（仓库）8、MLGT: 每一个存储类型的物料数据（仓库/存储类型）8.1、MSTA：物料主记录状态9、LFA1: 供应商主数据（一般数据）10、LFB1: 供应商主数据（公司代码）11、LFM1: 供应商采购组织数据12、EINA: 采购信息记录（一般数据）13、EINE: 采购信息记录（采购组织数据）14、EKKO: 采购订单抬头15、EKPO: 采购订单行项目16、EKET: 计划协议计划行17、EKKN: 采购凭证中的帐户设置18、EKBE: 采购凭证历史19、MKPF: 物料凭证抬头20、MSEG: 物料凭证行项目21、RBKP: 凭证抬头供应商发票数据22、RSEG: 凭证项目供应商发票数据EKKO/EKPO–>MKPF/MSEG–>RBKP/RSEG–>BKPF-BSEG23、KNA1: 客户主数据（一般数据）24、KNB1: 客户主数据（公司代码）25、KNVV: 客户主记录销售数据26、ADRC: 地址27、EBAN: 采购申请MaterialsMARA - Material Master: General dataMAKT - Material Master: DescriptionMARM - Material Master: Unit of MeasureMAPE - Material master: Export control fileMARC - Material master: Plant dataMARD - Material master: Storage locationMAST - Material link to BOMMBEW - Material valuationMLGN – Material Master: WM InventoryMLGT – Material Master: WM Inventory typeMDIP - Material: MRP profiles (field contents)MKOP - Consignment price segment (old versions of SAP)EBEW - Valuation of sales order stockQBEW - Valuation of project stockMVER – Material Master: Consumption <Plant>DVER – Material Master: Consumption <MRP Area>MVKE – Material Master: Sales <Sales Org, Distr Ch>MLAN - Material Master: Tax indicatorMARC - Material Master: Plant dataMAPR – Material Master: ForecastMARD – Material Master: Storage LocationMCH1 – Material Master: X Plant BatchesMCHA – Material Master: BatchesMCHB – Material Master: Batch StockMDMA - MRP Area dataDBVM - MRP Planning File Entry: MRP AreaMOFF - Outstanding Material Master Records (Maintenance status)MARCH - Material Master C Segment: HistoryMARDH - Material Master Storage Location Segment: History MBEWH - Material Valuation: HistoryMCHBH - Batch Stocks: HistoryMKOLH - Special Stocks from Vendor: HistoryMSCAH - Sales Order Stock at Vendor: HistoryMSKAH - Sales Order Stock: HistoryMSKUH - Special Stocks at Customer: HistoryMSLBH - Special Stocks at Vendor: HistoryMSPRH - Project Stock: HistoryMSSAH - Total Sales Order Stocks: HistoryMSSQH - Total Project Stocks: HistoryVendorsLFA1 - Vendor Master: General dataLFB1 - Vendor Master: Company dataLFM1 - Vendor Master: Purchasing Data (Purchasing organization) LFM2 - Vendor Master: Purchasing Data (Plant, Vendor sub-range)PurchasingEBAN - Purchase requisition: itemsEBKN - Purchase Requisition: account assignmentSTXH - SAPScript Text HeaderSTXL - SAPScript Text LinesEKKO - Purchasing document headerEKPO - Purchasing Document: ItemEKET - Purchasing Document: Delivery SchedulesMDBS - Material View of Order Item/Schedule Line (good to find open PO's) EKKN - Account assignment in purchasing documentEORD - Purchasing Source ListEIPA - Order price history recordEKAB - Release documentationEKBE - Purchasing document historyEKBZ - Purchasing document history: delivery costsEKPB - "Material to be provided" item in purchasing documentESKL - Account assignment specification for service lineESKN - Account assignment in service packageESLH - Service package header dataESLL - Lines in service packageESSR - Service entry sheet header dataESUC - External services management: Unplanned limits for contract item ESUH - External services management: unplanned service limits header data ESUP - External services management: unplanned limits for service packagesESUS - External services management: Unplanned limits for service typesEINA - Purchase Info Record: GeneralEINE - Purchasing info record: purchasing organization dataKONP - Condition ItemKONH - Condition HeaderInventory ManagementISEG - Physical inventory document itemsMKPF - Material document: HeaderMSEG - Material document: itemRKPF - Reservation: HeaderRESB - Reservation: ItemInvoice VerificationBSIM - Secondary index: documents for materialMYMFT - FIFO results tableMYML - LIFO material layerMYMLM - LIFO material layer (monthly)MYMP - LIFO period stocks, single materialMYMP1 - Receipt data LIFO/FIFO valuationMYPL - LIFO pool layerMYPLM - LIFO pool layer (monthly)RBCO - Document item, incoming invoice account assignment RBDIFFKO - Invoice Verification: conditionsRBDIFFME - Invoice Verification: quantity differences RBDRSEG - Invoice Verification batch: invoice document items RBKP - Document header: incoming invoiceRBKPB - Invoice document header (batch invoice verification) RBTX - Taxes:incoming invoiceRBVD - Invoice document: summarization dataRBVDMAT - Invoice Verification: summarization data, material RBWT - Withholding tax:incoming invoiceRKWA - Consignment withdrawalsRSEG - Document item, incoming invoiceCustomising and other master dataMDLV - MRP AreasMDLG - MRP Areas - Storage LocationsMDLW - MRP Areas - PlantsMDLL - MRP Areas - SubcontractorT023 - Material GroupsT024 - Purchasing groupsT030 - Standard Accounts Table (Automatic Account Determination) T156 - Movement TypeT156T - Movement Type: TextAUSP - Release Procedure: Strategy values (cl20n, cl24n)AGR_USERS - Assignment of roles to usersCDHDR & CDPOS - Change history of master data and documents EDID4 - EDI informationTSTC - SAP Transaction Codes, lock/unlock: sm01, created: se93 TSTCT - Transaction codes TEXTNAST - Message status二、SD常用表1、VBAK: 销售凭证：抬头数据2、VBAP: 销售凭证：项目数据3、VBEP: 销售凭证：计划行数据4、VBKD: 销售凭证：业务数据5、VBPA: 销售凭证：合作伙伴6、LIKP: SD凭证：交货抬头数据7、LIPS: SD凭证：交货项目数据8、VBRK: 出具发票：抬头数据9、VBRP: 出具发票：项目数据10、VBFA: 销售凭证流11、VBUK: 销售凭证：抬头状态和管理数据12、VBUP: 销售凭证：项目状态13、T682I: 条件：存取顺序( 产生格式 )14、T681: 条件：结构15、T682Z: 条件：存取顺序( 字段 )16、T685: 条件:类型三、FICO常用表1、SKA1: 总帐科目主记录 (科目表)2、SKB1: 总帐科目主记录 (公司代码)3、SKAT: 总帐科目主记录（描述）4、CSKB: 成本要素5、BKPF: 会计凭证抬头6、BSEG: 会计核算凭证项目数据，BSID客户未清会计核算凭证/BSAD客户已清会计核算凭证/BSIK供应商未清会计核算凭证/BSAK供应商已清会计核算凭证/BSIS总帐未清会计核算凭证/BSAS总帐已清会计核算凭证7、FAGLFLEXA: 总账实际行项目8、FAGLFLEXT: 总账汇总9、ANLA: 资产主记录段10、ANLC: 资产值字段11、CSKS: 成本中心主数据12、COEP: 成本控制对象：与期间相关的各行项目13、COSS: CO 对象:内部过帐成本总计14、COSP: CO 对象：外部记帐的成本总计15、 CKMLPRKEKO: 物料分类帐; 价格的成本组件分割 (标题)16、CKMLPRKEPH: 物料分类帐: 价格的成本组件分割 (要素0四、PP常用表1、MAST：BOM链接物料2、STKO：BOM表头3、STAS：BOMs - 项选择4、STPO：BOM项目STKO~STLAN = STAS-STLAN AND STKO~STLAL = STAS-STLALSTAS~STLNR = STPO-STLNR AND STAS~STLKN = STAS-STLKNBOM类别包括：D-凭证结构、E-设备BOM、K-订单BOM、M-物料BOM、S-标准BOM、T-功能位置BOM、P-工作分解结构BOM5、PLAF: 计划订单6、RKPF: 预定/相关需求抬头7、RESB: 预定/相关需求行项目8、AUFK: 订单主数据9、AFKO: 订单表头数据，PP订单10、AFPO: 订单项11、AFVC: 订单的工序12、AFVV: 工序中数量/日期/值的DB结构13、JEST: 订单状态，通过AUFK-OBJNR=JEST-OBJNR关联14、AFRU: 订单确认15、AUFM: 针对订单的货物移动五、PM常用表1、IFLOT: 功能位置(表)2、ILOA: PM 对象位置和帐户分配六、PS常用表1、PROJ: 项目定义2、PRPS: WBS(工作中断结构) 元素主数据七、QM常用表八、库存数据1、MBEW: 物料评估2、MARD: 物料的工厂/库存地点数据3、MSLB: 供应商特殊库存（O）4、MKOL: 供应商特殊库存（K）5、MSKA: 销售订单库存6、MCH1/ MCHB: 批次库存九、货物移动数据1、MKPF: 物料凭证抬头2、MSEG: 物料凭证行项目不是所有的物料移动数据都需要从这物料移动表中进行读取，生产订单相关AUFM，采购订单相关EKBE，销售相关VBFA。
SAP各模块字段与表的对应关系
SAP各模块字段与表的对应关系Customer MasterKNA1Customer Basic DataKNB1Customer 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 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 SalesOrder Stock（销售库存）MAPL分配任务清单到物料，物料所建的工艺路线（Q类型为检验计划）MAST分配BOM到物料MVKE物料销售数据(查找销售单位)MLAN物料的税分类MDLV定制 MRP 运行区域(与MDLG是明细) MRP范围MDLGMDMA物料与MRP AREA的关联关系；T023物料组T023TVendor Master供应商LFA1Vendor Master -- General DataLFB1Vendor Master -- Company Code Data（公司，财务视图）LFM1Vendor Master -- Purchasing Org. Data(采购组织)LFB5Vendor Master -- Dunning DataLFBK Vendor Master -- Bank Details((银行信息)-àBNKA银行表LFBW Vendor Master -- Withholding Tax TypesLBC1Vendor Master -- Transaction FiguresLFM2Vendor 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 RulesTFAIT Text for Factory Calendar IntervalsTHOC Public Holiday Calendar ID'sTHOCD Public Holiday Link to Holiday CalendarTHOL Public Holiday DefinitionTHOLT Public Holiday TextsLine DesignLDLH Line Hierarchy HeaderLDLP Line Hierarchy ItemsLDLT Line Hierarchy Takt TimesLDLBC 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 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 numberClass & 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 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 AllocationPLMK 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 StructureMAST分配BOM到物料BOM使用逻辑数据库的是CMCProductionVersion(生产版本)MKAL Material Production Version Data (生产版本)Demand ManagementPBED Independent Requirements DataPBIM Independent Requirements by Material（与PBED通过BDZEI关联）PBHI Independent Requirements History（与PBIM，通过BDZEI关联）PBID Plannedindependent requirements index: MRP areaRepetitive ManufacturingSAFK RS Header Master DataS025LIS -- Run Schedule QuantitiesS026LIS -- Material UsageS028LIS -- Reporting Point StatisticsBLPK凭证日志标题（保存了【参考数量】）冲销类型----P，在这里通过【处理类型】来查询相关的报告点的操作，报告点的处理类型为Z。
SAP各模块主数据流程结构图
一个成本中心只能对应一个利润中心
FICO主数据相关关系
•
一个公司可以对应多个利润中心
•
一个利润中心可以对应多个公司（柳工仅限一对一）
•
一个利润中心可以对应多个成本中心
•
一个成本中心只能对应一个利润中心
FICO主数据相关关系
控制层面的主数据相互间 几乎没有固定的相关关系， 他们的相关关系主要由费 用归集方式确定。
欢迎
SAP业务模块总揽
SAP相关数据构成
与
即与客户端相关
柳
或无关
工
无
关
数
据
与柳工相关数据
与柳工相关的数据构成
PP-主数据结构图
分类数 据
采用可配置BOM时需 要维护分类数据
MM-采购流程中的主数据
采购信息 供应商主数据
按物料采购的 采购订单必备 条件：基本视 图、采购视图
采购订单
/框架协议
FICO-财务流程中的主数据
成本中心 基金中心 成本要素 作业类型 统计指标
公司代码 利润中心 会计科目 承诺项目
总帐 过帐
会计报表
资产主数据 物料标准价
销售价 供应商采购价
内部订单
•
一个公司可以对应多个利润中心
•
一个利润中心可以对应多个公司（柳工仅限一对一）
•
一个利润中心可以对应多个成本中心
•
1 2
PM订单
维护工作中心
PM主数据相关关系
谢谢大家
基本视图采购视图mm采购流程中的主数据items20采购订单10采购收货采购信息框架协议mm主数据相关关系mm主数据相关关系mm供应商主数据sd销售流程中的主数据总揽sd主开票方开票方送达方送达方付款方付款方sd主数据相关关系成本要素总帐过帐资产主数据销售价供应商采购价公司代码会计报表内部订单基金中心作业类型统计指标fico财务流程中的主数据利润中心会计科目承诺项目成本中心物料标准价fico主数据相关关系一个成本中心只能对应一个利润中心fico主数据相关关系控制层面的主数据相互间几乎没有固定的相关关系他们的相关关系主要由费用归集方式确定
SAP各模块表关系
SAP Principal Tables2007. 09. 28Netweaver TeamContentsMaterial Master Tables SD-MM Tables .……….…………………….................……………………………..2 3PS Tables (6)PP Tables QM Tables CO T bl ........................…………………………….. ......................……………………………..710CO Tables FI Tables…………..…………………………………. ..........................………………………..……1115Dictionary Tables (16)Material Master TablesMaterial Ledger MaterialMaterial Material MaterialMaterial Master ViewMaterial LedgerHeader CKMLHD Material Ledger Total Values Forecast ParameterMPOPPlanning DataMPGD Material Databy Warehouse NumberMPGD Unit of MeasureMARMTax ClassificationMLANMaterial DescriptionGeneral Material MasterMARA CKMLCRMaterial Ledger Total Quantity CKMLPP Material LedgerMaterial Valuation DataMBEWMaterial Data by Plant MAKTPrices CKMLPRMARC Material Data by Storage LocationMARD Material Data by Storage Type M i l A ib Routing Assignmentto Material MAPL BOM Link to MaterialMASTProduction Versionof Material MKALRouting HeaderBOM HeaderProduction Version Bill of Material (BOM)Routing Material Sales Data MVKEby Storage TypeMLGT Material TypeT134Material Group Material Attribute Routing Header PLKO Routing ItemPLPOBOM Header STKO BOM Item STPOMaterialProduction HierarchyT179pT023Material Control RecordMARV 물류자재이동통제MMSD Sales Header StatusVBUK Sales Item StatusSales Doc. FlowVBFAPurchase Doc. HistoryEKBESales Order HeaderVBAK Sales Order ItemVBAPS/O Business DataVBKD VBUP S/O Schedule Line ÆPurchase RequisitionPurchase Requisition ÆPurchase OrderPurchase Order HeaderEKKOPurchase Order ItemEKPOS/O Schedule LineVBEPDelivery HeaderLIKP Shipping HeaderVEKP S/O Schedule Line ÆPurchase OrderEKKNEBKN EBANP/O Schedule LineDelivery ItemLIPSShipping ItemVEPOMaterial Doc. HeaderMKPFG d I (G/I)EKETMaterial Doc. HeaderMKPF Material Doc. ItemMSEGBilling HeaderGoods Issue (G/I)Material Doc. ItemMSEGGoods Receipt (G/R)Invoice Header출하실적VBRKBilling Item VBRPAccounting HeaderBKPF Accounting SegmentS GRBKP Invoice ItemRSEG매출실적매입실적BSEGSD MM ■Organization TablesCategory Table Description Text Master TVKO Sales Organization TVKOT TVTW Distribution Channel TVTWT Category Table Description Text Master T024E Purchasing OrganizationT024Purchasing GroupTSPA Division TSPAT TVBUR Sales Office TVKBT TVKGR Sales Group TVGRTT026Purchasing Area T026T WYT1Vendor Subrange(Vendor + Vendor Subrange)T001W PlantT171Sales Districts T171T Link TVKOS Sales Organization + DivisionTVKOV Sales Organization + ChannelS l O i i Ch l Di i iT001L Storage Location(Plant + Storage Location) Link T024W Plant + Purchasing OrganizationTVTA Sales Organization + Channel + Division TVBVK Sales Office + Sales GroupTVKBZ Sales Organization + Channel + Division + Sales OfficeT026Z Purchasing Organization + PurchasingGroup + Purchasing AreaVendor LFA1Vendor General DataLFB1Vendor + CompanyCustomer KNA1Customer General DataKNB1Customer + CompanyKNVV Customer + Sales Organization +Distribution Channel+Division LFM1Vendor + Purchasing Organization LFM2Vendor + Purchasing Organization + Vendor Subrange + PlantDistribution Channel + Division■MM Purchasing Info RecordSAP Script Text FileLong Text InformationMaterial Info RecordCondition HeaderKONH Condition ItemKONPHeader STXH SAP Script Text FileLines STXLMaterial Info Record Header EINA Material Info RecordItem EINEMaterial Info Recordby Plant A017Purchasing Info Record +Material + VendorPurchasing Doc.Header Purchasing OrderSales Order 재고Table(판매,고객,공급처,창고재고)EKKO Purchasing Doc.Item EKPOS/O Schedule Line ÆPurchase OrderEKKNSales OrderStock MSKA(MSKAH)Special Stocks with Customer MSKU(MSKUH)P/O Schedule LineEKETLogistics Summary TablesS???Special Stocks with Vendor MSLB(MSLBH)Storage Location Datafor Material MARD(MARDH)Project DefinitionWork Center HeaderCRHD Work Center CO Obj. Cost Total Summary ofActual & Plan Data Object Number (OBJNR)Project Definition PROJWork Center TextCRTX Assignment Work Centerto Cost CenterExternal PostingCOSP CO Obj. Cost Total Internal PostingCOSS(O )WBS Element MasterPRPSScheduling Data to Cost Center CRCOProject Hierarchy Scheduling Data for Project ItemPRTEPS Texts (WBS)PRTXPS Texts (Header)Production OrderHeader AFKONetworkj y for WBS ElementPRHI PSTXPS Texts (Description)PSTTProject Hierarchy for WBS ElementPRHISOperation within OrderAFVCOperationActivity Value in Operation AFVVNetwork –RelationshipsAFAB Network 내작업순서선후관계Routing Assignmentto Material BOM Link to MaterialMASTProduction Versionof Material Production Version Bill of Material (BOM)Routing Work Center HeaderCRHD Work Center MAPL MKALRouting HeaderPLKO Routing ItemBOM HeaderSTKOBOM Item Work Center TextCRTX Assignment Work Centerto Cost Center Routing Selection of BOMItem Selection Production Order Master Data CAUFV ViewPlanned OrderPLAF PLPOSTPOto Cost CenterCRCOOperation/ActivatesPLASOrder Operation Data for Work CenterItem SelectionSTASAUFK Production OrderHeader AFKO P d ti O dP d ti O d 생산실적생산계획S022Goods Movements Errors from ConfirmationsAFFWConfirmationProduction Order Item AFPOProduction Order ConfirmationAFRUMaterial Doc.Header MKPF M t i l DSubsequently posted 생산품입고(G/R)BOM 에의한투입원자재예약ReservationItem Reservation Header RKPF Material Doc.Item MSEGSubseque t y posted Goods Movements for ConfirmationsAFWI Goods Movement for Production OrderRESB원자재투입(G/I)AUFM■ConfirmationOperation within OrderÆOrder 내공정작업:Order Routing Table of Planned Changesf C fi tiAFVCActivity Value in Operation AFVV: Order 생성시Routing 정보가복사된다.Production Order ConfirmationAFRU생산실적생산품입고(G/R)Goods Movements Errors from ConfirmationsAFFW Incorrect Cost Calculationfrom Confirmations ErrorsPDCAFRP0for Confirmation Automatic Goods ReceiptSubsequently posted Goods Movements for ConfirmationsAFWIfrom ConfirmationsAFRCAFRP1Backflushing AFRP2만약Confirmation 도중Error 가발생했거나Backlog 가남아있을경우다음의Program 을실행한다.Program :CORUPROC Material Doc.Header MKPF Data Transfer to HRAFRP4Calc. Actual CostsAFRP3Program : CORUPROC,CORUAFFW(T-Code :COGI)Material Doc.Item MSEGCharacteristics ■Production VersionProduction Versionsof MaterialMKALLink between Internal MKAL-MATNR = 자재번호MKAL-WERKS = 플랜트MKAL-PLNTYMKAL-PLNNRMKAL-ALNALINOB-OBJEK=MKAL-PLNTY+MKAL-PLNNR+MKAL-ALNALLink between Internal Number and ObjectINOB INOB OBJEK MKAL PLNTY + MKAL PLNNR + MKAL ALNAL INOB-KLARTINOB-OBTABAllocation Table Object to Class KSSK-OBJEK = INOB-OBTAB KSSK-KLART=INOB-KLARTObject to ClassKSSK KSSK KLART INOB KLART KSSK-CLINTClass Header DataKLAH Characteristics KLAH-CLINT = KSSK-CLINT KLAH-KLART = INOB-KLART KLAH-CLASSCharacteristics of a ClassKSMLInspection Lot Record Inspection CatalogCode Code Texts Quality Message –QALSInspection Processing: Usage DecisionGenerated TableFor View QMFELCharacteristic Specificationsfor Inspection ProcessingQPCDQuality Notification ItemsQMFEQPCT Maintenance Data ExcerptQMIHÆ설비고장시간Inspection MethodQAVE QMFELQAMVCharacteristic Results in Sample Specifications Insp. Specifications/Quality NotificationQMELInspectionCharacteristic MasterQPMKpMaster RecordQMTBInspectionMethod TextsQMTTInspection ProcessingQAMRp pfor Inspection ProcessingQASVp pValuationQAMVRMSInspection CharacteristicI M th d/Results Tablefor the Sample UnitQASEConfirmation Data for Multiple Spec. SampleQASRMSpMaster TextsQPMTLink Inspection Lot Insp. Methods/Insp. CharacteristicQPMZLogistics Summary TablesS???Link Inspection Lotand Material DocumentQAMBMaterial Doc. ItemMSEGMaterial Doc. HeaderMKPFEC-PCA: Actual Line Items CO-PCA Table■Basic TableCost Center MasterCSKS Profit Center MasterCEPCCost Element MasterCSKAMaster DataObject Number Index EC-PCA: Totals TableGLPCTLine Items GLPCA EC-PCA: Object Tablefor AccountAssignment ElementsObject Number Index for Cost CenterONRKSGLPCO EC-PCA: TransactionAttributes GLPCPObject Number(OBJNR):‘KS’+CO Object CO Obj. Cost Total Summary of Actual & Plan DataActual Line ItemCE1????CO Object Document CO-PA TableObject Number(OBJNR) : KS + Controlling Area(KOKRS) + Cost Center(KOSTL)Document LineCOEPCO ObjectDocument HeaderExternal PostingCOSP CO Obj. Cost Total Internal PostingCOSSLine (by Fiscal Year)COEJPlan Line Item CE2????Summary Record Profitability Segment COBKProfitability SegmentCE3????Profitability SegmentDefinition CE4????ll dÆ???? :Controlling Area Code■Material LedgerMaterial Ledger Document 기준Cost Estimate 기준Header Record CKMLHDPeriod Totals d l Cost Component Splitd Product Costing d Document HeaderMLHDDocument C i d lDocument Posting i d d Q i iDocument ItemsMaterial 과Cost Estimate 의Link 정보Records Values CKMLCR Period Totals Records QuantityCKMLPPHeader CKMLKEKO Cost Component SplitElements CKMLKEPHHeader Data KEKO Product Costing Cost ComponentsKEPHCurrencies and Values MLCR Periods and Quantities MLPPDocument Items MLITDocument 와Material, Cost Estimate,Production Process 의Link 정보를담고있다.Prices CKMLPRMaterial Valuation DataCost Component Split Material Costing View Cost Component Split Cost Component GroupsCost Components PP 의원가취합처나생산작업지시와연결된다.MBEW Cost Component Split Header for Prices CKMLPRKEKO Cost Component Split Elements for Prices CKMLPRKEPHMaterial Valuation DataHistory MBEWHCost Component Split (Control Record)CKMLKEV TCKH7Cost Component Groups-Texts TCKH6Cost Components만약CKMLHD 와CKMLPRKEKO 를대사하여CKMLPRKEKO 에존재하지않는Cost Estimate 가있거나Price Update(T-Code:CK24)에서오류발생시별도생성작업을한다.Program : MLCCS_STARTUPMLCCS_RESET ExecuteCost Components-Texts TCKH1Cost Components TCKH3■Product CostsÆProduct Cost by Period(기간별제품원가)에서사용하는Product Cost Collector(제품원가취합처)에취합된Cost DataOrder Master DataAUFK Generated View for COCOASCO Object 기준ÆWRTTP (Val e T pe)Object Number(OBJNR) : ‘OR’ +Order Number (AUFNR:원가취합처or 생산작업지시)Order Header DataAFKOTotal Variances/Results AnalysesCOSB Order Item Cost Totals for External PostingsGenerated View for PPCAUFVWRTTP (Value Type) -‘04’ : 사전원가(Preliminary Cost)-‘05’ : 실적AFPOCOSP Cost Totals for Internal PostingsCOSS Activity Type TotalsÆAUFNR : 원가취합처번호(Order Type:RM01)COSL ÆOBJNR : 오브젝트번호※Product Cost by Order(오더별제품원가)에서는Production Order 단위로Cost Data 가취합된다.※기간별제품원가에서사전원가(Preliminary Cost)는표준원가(Standard Cost)와달리원가취합처별(생산버전: BOM + Routing)로계산하여사용한다.■Activity TypesActivity Master CSLA, CSLTCost Center MasterCSKSCost Center /Activity TypeCSSLControl Data forActivity TypeCOKLObject Number(OBJNR) : ‘KL’ +Controlling Area(KOKRS) +Cost Center(KOSTL) +Activity Type(LSTAR)Activity Type Totals Line Item for ActivityTypes(by Fiscal Year)Line Item for Activity Types(by Period)COSL Types(by Fiscal Year)COEJL Types(by Period)COEPLFI TablesGeneral Ledger TotalVendorG/L AccountCustomerNew G/LClient Level Vendor General DataG/L Account MasterCustomer General DataGeneral Ledger Total FAGLFLEXT G/L Actual Line ItemFAGLFLEXAClient Level Master Data Vendor General Data LFA1G/L Account Master SKA1Customer General Data KNA1Company Level Master Data Vendor Master (Company Code)LFB1G/L Account (Company Code)SKB1Customer Master (Company Code)KNB1Monthly Summary DataVendorTransaction DataLFC1Customer Transaction DataKNC1Accounting for Vendor General Ledger TotalFAGLFLEXT Accounting for G/L AccountAccounting for CustomerÅOpen ItemÅFI SummaryDocuments for Material Secondary IndexBSIK BSIS BSID Accounting for Vendor BSAKAccounting for G/L AccountBSASAccounting for CustomerBSADÅCleared ItemBSIMAccounting DocumentHeader BKPFAccounting Document Header for ParkingVBKPFParking Documentfor Asset Parking Document for Customer Parking Documentfor Vendor Parking Document for G/L Account Accounting DocumentPosting DocumentParked DocumentClustered by RFBLGfor Asset VBSEGAfor Customer VBSEGDfor Vendor VBSEGKfor G/L AccountVBSEGSSegment BSEGTax Data BSETOne-time Accounting DataBSECBill of ExchangingBSEDControl Data(Obsolete)BSESDictionary TablesTable Description Text DD01L DomainsDD01T DD02LSAP TablesDD02T-TRANSP : Transparent table -INTTAB : Structure -CLUSTER : Cluster table DD03L Table Fields DD03T -POOL: Pooled table-VIEW : General view structure -APPEND: Append structureDD04L Data Elements DD04T DD07L Domain Fixed ValueDD07T DD08L Dictionary Relationship Definition (Check Table, Foreign Key)DD08T Table Secondary Indexes DD12L Table Secondary Indexes DD12TDD17S Secondary Index Fields DD20L Match Code Objects DD20T DD30L Search HelpDD30TDD33S Assigned Fields to Search Help ARCH_OCLAS Assign classes to Archive Object ARCH_CLASS Classes of Integrated Objects ARCH DEF Definition of Archive Object ARCH_DEF Definition of Archive Object TFDIR Function Modules TFTIT FUPARAREF Function Parameters TRMAC ABAP Program Macro TFACSFactory Calendar。
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 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 SalesOrder 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 RulesTFAIT Text for Factory Calendar IntervalsTHOC Public Holiday Calendar ID's THOCD 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 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, "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 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 AllocationPLMK 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 StructureMAST 分配BOM到物料BOM 使用逻辑数据库的是CMCProductionVersion(生产版本)MKAL Material Production Version Data (生产版本)Demand ManagementPBED Independent Requirements DataPBIM 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。
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 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 SalesOrder 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 RulesTFAIT Text for Factory Calendar IntervalsTHOC Public Holiday Calendar ID'sTHOCD Public Holiday Link to Holiday CalendarTHOL Public Holiday DefinitionTHOLT Public Holiday TextsLine DesignLDLH Line Hierarchy HeaderLDLP Line Hierarchy ItemsLDLT Line Hierarchy Takt TimesLDLBC 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 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 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 AllocationPLMK 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 StructureMAST分配BOM到物料BOM使用逻辑数据库的是CMCProductionVersion(生产版本)MKAL Material Production Version Data (生产版本)Demand ManagementPBED Independent Requirements DataPBIM 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。
SAP各模块表关系
SAP Principal Tables2007. 09. 28Netweaver TeamContentsMaterial Master Tables SD-MM Tables .……….…………………….................……………………………..2 3PS Tables (6)PP Tables QM Tables CO T bl ........................…………………………….. ......................……………………………..710CO Tables FI Tables…………..…………………………………. ..........................………………………..……1115Dictionary Tables (16)Material Master TablesMaterial Ledger MaterialMaterial Material MaterialMaterial Master ViewMaterial LedgerHeader CKMLHD Material Ledger Total Values Forecast ParameterMPOPPlanning DataMPGD Material Databy Warehouse NumberMPGD Unit of MeasureMARMTax ClassificationMLANMaterial DescriptionGeneral Material MasterMARA CKMLCRMaterial Ledger Total Quantity CKMLPP Material LedgerMaterial Valuation DataMBEWMaterial Data by Plant MAKTPrices CKMLPRMARC Material Data by Storage LocationMARD Material Data by Storage Type M i l A ib Routing Assignmentto Material MAPL BOM Link to MaterialMASTProduction Versionof Material MKALRouting HeaderBOM HeaderProduction Version Bill of Material (BOM)Routing Material Sales Data MVKEby Storage TypeMLGT Material TypeT134Material Group Material Attribute Routing Header PLKO Routing ItemPLPOBOM Header STKO BOM Item STPOMaterialProduction HierarchyT179pT023Material Control RecordMARV 물류자재이동통제MMSD Sales Header StatusVBUK Sales Item StatusSales Doc. FlowVBFAPurchase Doc. HistoryEKBESales Order HeaderVBAK Sales Order ItemVBAPS/O Business DataVBKD VBUP S/O Schedule Line ÆPurchase RequisitionPurchase Requisition ÆPurchase OrderPurchase Order HeaderEKKOPurchase Order ItemEKPOS/O Schedule LineVBEPDelivery HeaderLIKP Shipping HeaderVEKP S/O Schedule Line ÆPurchase OrderEKKNEBKN EBANP/O Schedule LineDelivery ItemLIPSShipping ItemVEPOMaterial Doc. HeaderMKPFG d I (G/I)EKETMaterial Doc. HeaderMKPF Material Doc. ItemMSEGBilling HeaderGoods Issue (G/I)Material Doc. ItemMSEGGoods Receipt (G/R)Invoice Header출하실적VBRKBilling Item VBRPAccounting HeaderBKPF Accounting SegmentS GRBKP Invoice ItemRSEG매출실적매입실적BSEGSD MM ■Organization TablesCategory Table Description Text Master TVKO Sales Organization TVKOT TVTW Distribution Channel TVTWT Category Table Description Text Master T024E Purchasing OrganizationT024Purchasing GroupTSPA Division TSPAT TVBUR Sales Office TVKBT TVKGR Sales Group TVGRTT026Purchasing Area T026T WYT1Vendor Subrange(Vendor + Vendor Subrange)T001W PlantT171Sales Districts T171T Link TVKOS Sales Organization + DivisionTVKOV Sales Organization + ChannelS l O i i Ch l Di i iT001L Storage Location(Plant + Storage Location) Link T024W Plant + Purchasing OrganizationTVTA Sales Organization + Channel + Division TVBVK Sales Office + Sales GroupTVKBZ Sales Organization + Channel + Division + Sales OfficeT026Z Purchasing Organization + PurchasingGroup + Purchasing AreaVendor LFA1Vendor General DataLFB1Vendor + CompanyCustomer KNA1Customer General DataKNB1Customer + CompanyKNVV Customer + Sales Organization +Distribution Channel+Division LFM1Vendor + Purchasing Organization LFM2Vendor + Purchasing Organization + Vendor Subrange + PlantDistribution Channel + Division■MM Purchasing Info RecordSAP Script Text FileLong Text InformationMaterial Info RecordCondition HeaderKONH Condition ItemKONPHeader STXH SAP Script Text FileLines STXLMaterial Info Record Header EINA Material Info RecordItem EINEMaterial Info Recordby Plant A017Purchasing Info Record +Material + VendorPurchasing Doc.Header Purchasing OrderSales Order 재고Table(판매,고객,공급처,창고재고)EKKO Purchasing Doc.Item EKPOS/O Schedule Line ÆPurchase OrderEKKNSales OrderStock MSKA(MSKAH)Special Stocks with Customer MSKU(MSKUH)P/O Schedule LineEKETLogistics Summary TablesS???Special Stocks with Vendor MSLB(MSLBH)Storage Location Datafor Material MARD(MARDH)Project DefinitionWork Center HeaderCRHD Work Center CO Obj. Cost Total Summary ofActual & Plan Data Object Number (OBJNR)Project Definition PROJWork Center TextCRTX Assignment Work Centerto Cost CenterExternal PostingCOSP CO Obj. Cost Total Internal PostingCOSS(O )WBS Element MasterPRPSScheduling Data to Cost Center CRCOProject Hierarchy Scheduling Data for Project ItemPRTEPS Texts (WBS)PRTXPS Texts (Header)Production OrderHeader AFKONetworkj y for WBS ElementPRHI PSTXPS Texts (Description)PSTTProject Hierarchy for WBS ElementPRHISOperation within OrderAFVCOperationActivity Value in Operation AFVVNetwork –RelationshipsAFAB Network 내작업순서선후관계Routing Assignmentto Material BOM Link to MaterialMASTProduction Versionof Material Production Version Bill of Material (BOM)Routing Work Center HeaderCRHD Work Center MAPL MKALRouting HeaderPLKO Routing ItemBOM HeaderSTKOBOM Item Work Center TextCRTX Assignment Work Centerto Cost Center Routing Selection of BOMItem Selection Production Order Master Data CAUFV ViewPlanned OrderPLAF PLPOSTPOto Cost CenterCRCOOperation/ActivatesPLASOrder Operation Data for Work CenterItem SelectionSTASAUFK Production OrderHeader AFKO P d ti O dP d ti O d 생산실적생산계획S022Goods Movements Errors from ConfirmationsAFFWConfirmationProduction Order Item AFPOProduction Order ConfirmationAFRUMaterial Doc.Header MKPF M t i l DSubsequently posted 생산품입고(G/R)BOM 에의한투입원자재예약ReservationItem Reservation Header RKPF Material Doc.Item MSEGSubseque t y posted Goods Movements for ConfirmationsAFWI Goods Movement for Production OrderRESB원자재투입(G/I)AUFM■ConfirmationOperation within OrderÆOrder 내공정작업:Order Routing Table of Planned Changesf C fi tiAFVCActivity Value in Operation AFVV: Order 생성시Routing 정보가복사된다.Production Order ConfirmationAFRU생산실적생산품입고(G/R)Goods Movements Errors from ConfirmationsAFFW Incorrect Cost Calculationfrom Confirmations ErrorsPDCAFRP0for Confirmation Automatic Goods ReceiptSubsequently posted Goods Movements for ConfirmationsAFWIfrom ConfirmationsAFRCAFRP1Backflushing AFRP2만약Confirmation 도중Error 가발생했거나Backlog 가남아있을경우다음의Program 을실행한다.Program :CORUPROC Material Doc.Header MKPF Data Transfer to HRAFRP4Calc. Actual CostsAFRP3Program : CORUPROC,CORUAFFW(T-Code :COGI)Material Doc.Item MSEGCharacteristics ■Production VersionProduction Versionsof MaterialMKALLink between Internal MKAL-MATNR = 자재번호MKAL-WERKS = 플랜트MKAL-PLNTYMKAL-PLNNRMKAL-ALNALINOB-OBJEK=MKAL-PLNTY+MKAL-PLNNR+MKAL-ALNALLink between Internal Number and ObjectINOB INOB OBJEK MKAL PLNTY + MKAL PLNNR + MKAL ALNAL INOB-KLARTINOB-OBTABAllocation Table Object to Class KSSK-OBJEK = INOB-OBTAB KSSK-KLART=INOB-KLARTObject to ClassKSSK KSSK KLART INOB KLART KSSK-CLINTClass Header DataKLAH Characteristics KLAH-CLINT = KSSK-CLINT KLAH-KLART = INOB-KLART KLAH-CLASSCharacteristics of a ClassKSMLInspection Lot Record Inspection CatalogCode Code Texts Quality Message –QALSInspection Processing: Usage DecisionGenerated TableFor View QMFELCharacteristic Specificationsfor Inspection ProcessingQPCDQuality Notification ItemsQMFEQPCT Maintenance Data ExcerptQMIHÆ설비고장시간Inspection MethodQAVE QMFELQAMVCharacteristic Results in Sample Specifications Insp. Specifications/Quality NotificationQMELInspectionCharacteristic MasterQPMKpMaster RecordQMTBInspectionMethod TextsQMTTInspection ProcessingQAMRp pfor Inspection ProcessingQASVp pValuationQAMVRMSInspection CharacteristicI M th d/Results Tablefor the Sample UnitQASEConfirmation Data for Multiple Spec. SampleQASRMSpMaster TextsQPMTLink Inspection Lot Insp. Methods/Insp. CharacteristicQPMZLogistics Summary TablesS???Link Inspection Lotand Material DocumentQAMBMaterial Doc. ItemMSEGMaterial Doc. HeaderMKPFEC-PCA: Actual Line Items CO-PCA Table■Basic TableCost Center MasterCSKS Profit Center MasterCEPCCost Element MasterCSKAMaster DataObject Number Index EC-PCA: Totals TableGLPCTLine Items GLPCA EC-PCA: Object Tablefor AccountAssignment ElementsObject Number Index for Cost CenterONRKSGLPCO EC-PCA: TransactionAttributes GLPCPObject Number(OBJNR):‘KS’+CO Object CO Obj. Cost Total Summary of Actual & Plan DataActual Line ItemCE1????CO Object Document CO-PA TableObject Number(OBJNR) : KS + Controlling Area(KOKRS) + Cost Center(KOSTL)Document LineCOEPCO ObjectDocument HeaderExternal PostingCOSP CO Obj. Cost Total Internal PostingCOSSLine (by Fiscal Year)COEJPlan Line Item CE2????Summary Record Profitability Segment COBKProfitability SegmentCE3????Profitability SegmentDefinition CE4????ll dÆ???? :Controlling Area Code■Material LedgerMaterial Ledger Document 기준Cost Estimate 기준Header Record CKMLHDPeriod Totals d l Cost Component Splitd Product Costing d Document HeaderMLHDDocument C i d lDocument Posting i d d Q i iDocument ItemsMaterial 과Cost Estimate 의Link 정보Records Values CKMLCR Period Totals Records QuantityCKMLPPHeader CKMLKEKO Cost Component SplitElements CKMLKEPHHeader Data KEKO Product Costing Cost ComponentsKEPHCurrencies and Values MLCR Periods and Quantities MLPPDocument Items MLITDocument 와Material, Cost Estimate,Production Process 의Link 정보를담고있다.Prices CKMLPRMaterial Valuation DataCost Component Split Material Costing View Cost Component Split Cost Component GroupsCost Components PP 의원가취합처나생산작업지시와연결된다.MBEW Cost Component Split Header for Prices CKMLPRKEKO Cost Component Split Elements for Prices CKMLPRKEPHMaterial Valuation DataHistory MBEWHCost Component Split (Control Record)CKMLKEV TCKH7Cost Component Groups-Texts TCKH6Cost Components만약CKMLHD 와CKMLPRKEKO 를대사하여CKMLPRKEKO 에존재하지않는Cost Estimate 가있거나Price Update(T-Code:CK24)에서오류발생시별도생성작업을한다.Program : MLCCS_STARTUPMLCCS_RESET ExecuteCost Components-Texts TCKH1Cost Components TCKH3■Product CostsÆProduct Cost by Period(기간별제품원가)에서사용하는Product Cost Collector(제품원가취합처)에취합된Cost DataOrder Master DataAUFK Generated View for COCOASCO Object 기준ÆWRTTP (Val e T pe)Object Number(OBJNR) : ‘OR’ +Order Number (AUFNR:원가취합처or 생산작업지시)Order Header DataAFKOTotal Variances/Results AnalysesCOSB Order Item Cost Totals for External PostingsGenerated View for PPCAUFVWRTTP (Value Type) -‘04’ : 사전원가(Preliminary Cost)-‘05’ : 실적AFPOCOSP Cost Totals for Internal PostingsCOSS Activity Type TotalsÆAUFNR : 원가취합처번호(Order Type:RM01)COSL ÆOBJNR : 오브젝트번호※Product Cost by Order(오더별제품원가)에서는Production Order 단위로Cost Data 가취합된다.※기간별제품원가에서사전원가(Preliminary Cost)는표준원가(Standard Cost)와달리원가취합처별(생산버전: BOM + Routing)로계산하여사용한다.■Activity TypesActivity Master CSLA, CSLTCost Center MasterCSKSCost Center /Activity TypeCSSLControl Data forActivity TypeCOKLObject Number(OBJNR) : ‘KL’ +Controlling Area(KOKRS) +Cost Center(KOSTL) +Activity Type(LSTAR)Activity Type Totals Line Item for ActivityTypes(by Fiscal Year)Line Item for Activity Types(by Period)COSL Types(by Fiscal Year)COEJL Types(by Period)COEPLFI TablesGeneral Ledger TotalVendorG/L AccountCustomerNew G/LClient Level Vendor General DataG/L Account MasterCustomer General DataGeneral Ledger Total FAGLFLEXT G/L Actual Line ItemFAGLFLEXAClient Level Master Data Vendor General Data LFA1G/L Account Master SKA1Customer General Data KNA1Company Level Master Data Vendor Master (Company Code)LFB1G/L Account (Company Code)SKB1Customer Master (Company Code)KNB1Monthly Summary DataVendorTransaction DataLFC1Customer Transaction DataKNC1Accounting for Vendor General Ledger TotalFAGLFLEXT Accounting for G/L AccountAccounting for CustomerÅOpen ItemÅFI SummaryDocuments for Material Secondary IndexBSIK BSIS BSID Accounting for Vendor BSAKAccounting for G/L AccountBSASAccounting for CustomerBSADÅCleared ItemBSIMAccounting DocumentHeader BKPFAccounting Document Header for ParkingVBKPFParking Documentfor Asset Parking Document for Customer Parking Documentfor Vendor Parking Document for G/L Account Accounting DocumentPosting DocumentParked DocumentClustered by RFBLGfor Asset VBSEGAfor Customer VBSEGDfor Vendor VBSEGKfor G/L AccountVBSEGSSegment BSEGTax Data BSETOne-time Accounting DataBSECBill of ExchangingBSEDControl Data(Obsolete)BSESDictionary TablesTable Description Text DD01L DomainsDD01T DD02LSAP TablesDD02T-TRANSP : Transparent table -INTTAB : Structure -CLUSTER : Cluster table DD03L Table Fields DD03T -POOL: Pooled table-VIEW : General view structure -APPEND: Append structureDD04L Data Elements DD04T DD07L Domain Fixed ValueDD07T DD08L Dictionary Relationship Definition (Check Table, Foreign Key)DD08T Table Secondary Indexes DD12L Table Secondary Indexes DD12TDD17S Secondary Index Fields DD20L Match Code Objects DD20T DD30L Search HelpDD30TDD33S Assigned Fields to Search Help ARCH_OCLAS Assign classes to Archive Object ARCH_CLASS Classes of Integrated Objects ARCH DEF Definition of Archive Object ARCH_DEF Definition of Archive Object TFDIR Function Modules TFTIT FUPARAREF Function Parameters TRMAC ABAP Program Macro TFACSFactory Calendar。
SAP各模块的简单介绍
SAP各模块的简略介绍1.FICO模块：FICO是SAP中的财务模块,一块是FI(Finance)模块,CO （Controlling）模块.FI模块即外部管帐,存眷的是按照必定的管帐准则,组织账务,并出具知足财税等外部实体及人员请求的法定财务报表,平日比较尺度.而CO模块包含利润及成本中间.产品成本.项目管帐.获利剖析等功效,不但可以控制成本,还可控制公司目的,别的还供给信息以帮忙高等治理人员作出决议计划或制订例划.不但可以控制成本,还可以控制公司的目的.2.HR模块：HR（Human Resource）模块,中文名称为人力资本模块.HR模块属于SAP中的一个重要模块,包含人力资本筹划.时光治理.雇用治理.员工薪资核算.培训筹划.差旅治理等,并同SAP R/3的财务.物流等体系构成了高效的.具有高度集成性的企业资本体系.经由过程ERP中的人力资本治理体系树立尺度化的人力资本治理体系,进步人力资本治理工作效力,有用整合人力资本,合理设置装备摆设人力资本,进步员工工作技巧和工作知足度,增强公司凝集力.3.ABAP模块：ABAP（高等商务运用编程）是一种高等编程说话,由德国软件公司SAP开辟.今朝,和比来引入的Java一路,ABAP重要用作SAP的编程.这个办事器软件是SAP NetWeaver平台的一部分,这个平台重要用来开辟商务运用.ABAP支撑有面向进程和面向对象.4.BW模块：SAP BW 全称Business Information Warehouse ,SAP BW是mySAP 商务智能（BI）的集成化组件之一,为SAP数据和非SAP数据的收集.存储.剖析和治理供给一个集成的,面向商务的平台.它可以智能化地治理全部企业治理信息体系的海量数据信息并从中挖掘出最有价值的信息,以向企业治理者供给强有力的决议计划支撑,从而使企业对市场反响更敏锐快捷,全部企业也更具有性命力和竞争力 .5.SD模块：SD(Sales and Distribution)模块,中文名称为发卖与分销模块.SD模块处理有关发卖.装运.单据开具的义务.它供给的发卖支撑有：对有关发卖线索和竞争者运动的信息进行治理的对象,发卖信息体系还能提出关于市场趋向的早期警告.假如顾客发出一份订单,SD模块可以或许从数据库中抽取顾客地址.发卖运动和信誉限额等信息.6.MM模块：MM(Materials Management)模块,中文名称为物料治理模块, MM 模块重要义务是处理物料流入.流经以及流出公司的运动.MM处理倾销营业.仓库治理和库存清单,还进行发票的核查以及供给一套庞杂的信息体系.MM物料治理模块笼罩了一个集成的供给链中（物料需求筹划,倾销,库存和库房治理）所有的有关物料治理的义务.7.PP模块：PP(Production Planning)模块,中文名称为临盆筹划模块.PP模块属于后勤模块之一,它和MM模块.SD模块一同构成了临盆型企业最根本的产供销体系.PP模块协助公司高低从临盆司理到操纵工的全部员工来筹划临盆进程.比方,它对原材料的运输与存储.生产装备.副产品以及废品都可以或许作出筹划.临盆进程用图形的情势暗示,展现出临盆各个阶段间的关系,供给了筹划.控制以及临盆文档所需的信息.PP 模块生成一份临盆订单,上面汇总了成本.材料.工艺.数目和进度各项信息.PP模块可以知足营业流程在不竭转变且成长的制作商们的运营请求.对临盆筹划.生产履行和临盆控制三个范畴,它均能供给幻想的解决筹划.在PP模块中,需求治理.物料需求筹划.临盆控制和结算是企业运用比较多的功效.8.CRM模块：SAP客户关系治理为企业营业流程治理供给最佳客户办事解决筹划.其重要由SAP市场治理,SAP发卖治理和SAP办事治理筹划三部分构成.SAP CRM的特色是笼罩全部客户关系性命周期,同时在全部筹划中贯串了面向客户的脚色治理功效.SAP 客户关系治理不但使得企业可以或许实现以客户为目的的计谋成长,还能经由过程供给不凡的用户体验对其进行市场划分.9.BASIS模块：sap basis是从事sap体系治理的一个脚色.重要负责sap体系的筹划,装配,设置装备摆设,治理,监控,保护,调优等. sap basis从具体工作内容的倾向角度,可以分为实行和运维.实行倾向筹划,装配,设置装备摆设等;运维倾向治理,监控,保护等;调优是须要分解考量的,往往更倾向于实行,但其实不是绝对. 一般而言,对于sap basis实行的参谋请求应该高于运维.实行筹划装配设置装备摆设了体系,理论上还应当交付大量文档,也就是说定了大局,运维主如果在这个大局已定的前提下做好日常工作.但是其实不代表实在行就必定在所有倾向上都比运维专业,因为各自的范畴有所误差.同时,有一点很重要,就是数据的安然,所以,数据库备份和还原是须要卖力控制的.。
SAP表对应关系
VBELN POSNRETENR VBEH 计划行历史销售订单VBAK-VBELN=VBAP-VBELNVBBE-VBELN=VBAK-VBELNVBLB-VBELN=VBAK-VBELNVBAK销售凭证 ： 抬头数VBPA销售凭证 ：VBBE销售需求： 单独记录VBLB销售凭证:批准订单数VAKPA销售索引 ： 按合作伙伴功VBEP销售凭证:计划行数交货到期索引VKDFSSD索引： 出具发票初始器VBEP-VBELNVAPMAVBAP-VBELN VBAP-POSNR=VBEP-VBELN=VBEP-POSNRVBAK-VBELN=销售索引 ： 按物料的订单VEPVGVBFA 销售凭证流VBUK销售凭证：抬头状态和管理VBUP销售凭证 ： 项目状态VBAP-VBELN=VBPA-VBELN VBPA-POSNR=VBAP-POSNRVBPA证 ： 合作伙VBAP销售凭证:项目数据VBKD销售凭证 ： 业务数VBKD-POSNR=VBAP-POSNR VBKD-VBELN VBAP-VBELN=LIKP-VBELN=VBLK-VBELN VEPO-VBE LIKP-VBEVTTP-VBE LIKP-VBELIPS-VBELN=LIKP-VBELNLIKPVBAP-VBELN SD凭证:交货项目数据LIPSVBLK销售凭证：交货抬头交货单SD凭证:交货抬头数据LIPS-VGBEL VBPA-VBELN=LIPS-VGPOS=VBAP-POSNRLIPS-VGBEL=O-VBELN=P-VBELNP-VBELN=P-VBELNVTTK 装运抬头VTTP-TKNUM LIPS-VBELN=VEPO包装: 处理单位项VEKPVEPO-VENUM=VEKP-VENUMVTTK-TKNUM=处理单位 - 抬头表VBRP-VGBEL LIPS-POSNR=VBRP-VGPOSKONV条件（事务数据）VBRK出具发票:抬头数据VBRP出具发票:项数据货单VTTP 装运项目VBRK-KNUMV KONV-KNUMVVBRP-VBELN=VBRK-VBELN出具发票VBSK关于销售凭证抬头的汇总处理VBSS汇总处理： 销售凭证VKDFSSD索引： 出具发票初始器NAST消息状态VRPMA销售索引 ： 每一物料的开票项VRKPA销售索引 ： 按合作伙伴功能的。
SAP所有表及关系
表名英文短文本A000Condition Table for Pricing $A002Domestic TaxesA003Tax IndicatorA008Plant/Additional selling plantA011Export TaxesA013Overhead TypeA014Overhead Type/Overhead KeyA020Division/Price GroupA027Controlling AreaA029Material Pricing GroupA031Price Group/Material Pricing GroupA033IncotermsA034Incoterms Part 1 + 2A035Overhead Type/PlantA036Overhead Type/Order TypeA037Overhead Type/Order Catg.A038Overhead Type/Company CodeA039Overhead Type/Business AreaA040Country/State/Customer Classif.1/Material C A041Country/State/County/Customer Classif.2/Mat A042Country/State/City/Customer Classif.3/Mater A043Purchasing Organization/Material TypeA048Sales conditions sample structure for prici A050Sales conditions sample structure for prici A055Sales conditions sample structure for prici A056Sales conditions sample structure for prici A057VariantsA064Customer HierarchyA065Customer Hierarchy/MaterialA066Info record per order unitA067Plant Info Record per Order UnitA068Outline Agreement Item: Plant-DependentA069Vendor Sub-RangeA070EAN per PlantA071Material per PlantA072EAN per SOrg/DstChA073Material per SOrg/DstChA074Plant/Preference Zone/MaterialA075Master Conditions for SRV with Material Gro A076Master Conditions for Activities in Contrac A077Cost Split for Activities in ContractA078Departure Country / Destination CountryA079Sales Organization/Distribution Channel/Mat A080Taxes: MaterialA081Contract Conditions at Plant LevelA082Contract Conditions without PlantA083Vendor Conditions with PlantA084Vendor Conditions without PlantA085Metal PricesA086Taxes: Material, Plant and OriginA087Taxes: Plant, Account Assignment and Origin A088Taxes: Material, Plant, Account Assignment A089SD Document/MaterialA090SD Document/Item/MaterialA091Wage Type Surcharge at Plant LevelA092Wage Type Surcharge without PlantA093Wage Type Surcharge - GeneralA094Taxes: Material, Plant, Origin and Region A095Activities + Purchasing OrganizationA096Activities for VendorA097Activities for Vendor with PlantA098SD Document/Item/Material Pricing GroupA099SD Document/ItemA100SOrg/DstCh/Material_MainItem/MaterialA101SOrg/DstCh/Material-Main Item/Material Pric A102SOrg/DstCh/Material Pricing Group-Main Item A103SOrg/DstCh/MaterialPricingGroup-MainItem/Ma A104Service Conditions (Own Estimate)A105Controlling Area/Company Code/Business Area A106Price List/Material GroupA107Vendor HierarchyA108Vendor Hierarchy / MaterialA109Vendor hierarchy: vendor sub-rangeA110Sales Organization/Destination CountryA112Service agentA113Service agent/try/Dep.post.code/Dest. A114Tax Exemption: CustomerA115Ser.agnt/Dep.ctry/Dep.PC /Ship-to partyA116Tax Exemption - Customer/Tax Classification A117Tax Exemption - Customer/MaterialA118Empties Prices (Material-Dependent)A119Service agent/Dep.ctry/Dep.post.code /Dest. A120Overhead Type/VersionA121Legal Control: Values for Calculating Forei A122Surch. type /Profit CenterA123Discount Type/Resp. Cost CenterA124Service agent/try/Dep. PostCode/Tarif A125Service agent/Tariff zone dep./Tariff zone A126Service Agent/TariffZoneDep/TariffZoneDest/ A127Service Agent/TariffZoneDep/TariffZoneDest/ A128Service Agent/TariffZoneDep/TariffZoneDest/ A129Service Agent/TariffZDep/TariffZDest/ShipMa A130Service agent/tariff zone dep./tariff zone A131Service Agent/TariffZnDp/TariffZnDest/Packa A132Price per Cost CenterA133Mixed Taxes, DomesticA134VendorA135Transp. service agent/shipping type/bulk gr A136Price per Controlling AreaA137Price per Country/RegionA138Price per Company Code/Business AreaA139Price per Profit CenterA140Sales Area / Accounting IndicatorA141Dependent on material and receiver profit c A142Dependent on materialA143Dependent on material groupA144Sales Deal Basic DataA145Sales Deal - Customer/MaterialA146Customer HierarchyA147Customer Hierarchy (Sales Deal)A148Product HierarchyA152Sales Org./Dist. Channel/Plant/Material/SalA153Sales Org./Distribution Channel/Plant/SalesA154SalesOrg./Dist.Channel/PriceList/Material/SA155Sales Org./Dist. Channel/Price List/MateriaA156Country of Departure/Destination Country/DeA160Plant Info Record: VariantsA161Info Record: VariantsA162Trading Contract: Invoice RecipientA180Country/Preference Zone/Cross-Plant GroupinA185Order no./Item/Configuration no./Material/PA190Condition Table for Pricing A190A191Condition Table for Pricing A191A192Country/Goods Rec./Tax Class - MaterialA193Condition Table for Pricing A193A215Contract header conditions at outline levelA273Sales org./Distr. chl/Division/Material/Customer/ItemA274Sales org./Distr. chl/Division/Material/ItemA275Material/Agreement Data for ATO/MTS ComponentsA276Agreement Data and status with agreement searchA300Statistical Value of Subcontracting ComponeA301Info Record Type and IncotermsA302SD doc./Item/CustomerA303SD doc./Item/Material/CompMat/CompSup/CompTypeA304Material with release statusA305Customer/material with release statusA306Price list category/currency/material withA307Customer with Release StatusA310Duty Rate Customs Exemption: Importing CtryA315Cust.Duty Anti-dumping: Import/Code/Orig.ctA316Anti-dumping Duty Rate: Imp.Ctry/Code/Orig.A317Anti-dumping Duty Rate: try/Code NumbA320Third country Duties: Import ctry/Code/OrigA321Third Country Duty Rate: Import Country/CodA325Duties Pharma. Products: Import country/CodA326Pharm. Products Duty Rate: Import Country/CA330Preferential Cust.Duties: Imp.ctry/Orig.ctrA331Preference Duty Rate: Import Ctry/Code/OrigA335Quota Duty Rate: Imp.ctry/Code/Orig.ctry/PrA336Quota Duty Rate: Import Country/Code/Orig.CA340Foreign Trade: CAP: Restitution ratesA345Ceiling Duty Rate: Import Country/Orig.CounA364Trading Contract/Vendor/MaterialA365Trading Contract/Vendor/MaterialA366Trading Contract NumberA370Customer/ServiceA390Brazil: 100% reversalsA395Arg.: Country/Fisc.TypeA396Arg.: Country/Fisc.Type/MaterialA397Arg.: Tax relevant classificationA399Withholding tax code - country-specificA435Sales org./Distr. chl/Customer/Material/DRM Agr No/DRM Itm A436Agreement data in combination with Agreement searchA437Material/Customer/Agreement dataA439Material/Agreement dataA467Customer or Ship-To Party/Equipment/MaterialA468Customer/Relevant to (Un)Loading CostsA469Customer/Catalog Group 2/MaterialA470Transaction Type/Recipient TypeA472Transaction Type/Sender Type/Recipient TypeA473Transaction Type/Sender Type/Recipient Type/Diff. Co. Codes A479Customer or Ship-To Party/Document CategoryA482Std dummy customer/doc. cat./material group/materialA485Standard dummy customer/material group/material numberA486Customer or Ship-To Party/Equipment Type/MaterialA488Owner/AdministratorA490Equipment type/document categoryA491Equipment/document categoryA492Document CategoryA495Equipment type/standard dummy customer/document categoryA496Equipment/standard dummy customer/document categoryA497Standard Dummy Customer/Document Category/Material GroupA498CEM Material / Activity TypeA499CEM Ship-To Party/Material/Activity TypeABAPHTML System Table ABAPHTML for Buffering ABAP DoABAPTREE ABAP Demonstration HierarchyABAPTREET Demonstration Hierarchy: TextsABC_F4TAB CO-ABC: Table for Subdividing F4 Data ElemeABC_FTREE CO-OM-ABC: Function TreeABC_FTREET CO-ABC: Text Tree StructureABDOCMODE Window Setting for ABAP Keyword DocumentatiABTREE ABAP Workbench Tree ObjectsACCTCR Compressed Data from FI/CO Document - CurreACCTHD Compressed Data from FI/CO Document - HeadeACCTIT Compressed Data from FI/CO DocumentACDIAGSHOW AC Diagnosis Tool: Displayed Fields in AC DACLPERMIS Access Control List for Package Use AccessACRELATION Relationships in AccountingACT_ASPECT AC Diagnosis Tool: Definition of Views forACTFLI ABAP/4 book: FlightsAD00PMCL Class TableAD00PMCLT Text Table for ClassAD00PMEV Class event tableAD00PMEVT Text Table for EventsAD01C_ATTR DIP profile: CharacteristicsAD01C_CHK DIP profile: Check functionAD01C_CHKT DIP profile: Check function textsAD01C_CT Apportionment reasonAD01C_CTT Apportionment reason textAD01C_MAT DIP profile: Material determinationAD01C_MATA DIP profile: Material determination criteriAD01C_PROF DIP profile: UsageAD01C_PRTX DIP profile: TextsAD01C_SEL DIP profile: SourcesAD01C_SELA DIP profile: Selection criteriaAD01DLI Dynamic items (DI)AD01DLIEF DI flow: Individual flowAD01DLISF DI Flow: Totals FlowAD01DLISFR Resource-related billing: DLI flow totals revenue by rev elAD01SETTCH DIP: Saved settings for user 1AD01SETTMO DIP: Saved settings for user 2AD01SRC DIP: SourcesAD01SRCTAB DIP: Source <-> TableAD01SRCTXT DIP: Source TextsAD01T000Settings for A&D billingAD03OBJTV Plan data handling WBS objects, type and versionAD03PHP Plan data handling profileAD03PHPT Plan data handling profile textAD03PHV WBS version typeAD03PHVT version type textAD04KALSM Additional properties of costing sheetAD04KSUA Assessment preprocessor: assign CostElem to StKeyFigures AD04NMC Number CategoryAD04NMCT Text element for number categoryAD04RELCON Relation between conditionsADAA SAP DB: Directory of Valid DBA ActionsADACACHE Information About SAP DB Cache AccessADCNTRYQU Countries with active quarterly adjustmentADCOMP PM/PS Reference ElementADCOMPT PM/PS Text Table for ADCOMPADCP Person/Address assignment (central addressADCPS Shadow table: Assignment person/address (CA ADIRACCESS Table to store keys for TADIR objectsADLZSN Leading Zeroes in Serial NumbersADMI_APPLI Application archive file information tableADMI_BUFFC Buffer tableADMI_BUFFI Buffer tableADMI_CRIT Manage critical archiving objects (databaseADMI_EXAMP Archiving object EXAMPLE archive file infoADMI_FIDOC Archive Management for FI_DOCUMNT ObjectADMI_FIDOQ Enhancement to Archive Mgt. for FI_DOCUMNTADMI_FILES Archive Files of Archive SessionsADMI_JOBS Archive JobsADMI_RJOBS Read program jobsADMI_RUN Archive Runs Header DataADMI_SBOOK Archive file - info table for archiving objADMI_SKIP Address of data objects to be skippedADMI_VARIA Contents of Variant of Archive ProgramADOWNERREF Temporary reference address storage - MasteADQUINDX INDX-type table for quarterly adjustment adADR10Printer (central address management)ADR10S Shadow table: Printer (central address manaADR10S2Shadow Table 2: Printer (Central Address MaADR11SSF (Central address management)ADR11S Shadow table: SSF (central address managemeADR11S2Shadow Table 2: SSF (Central Address ManageADR12FTP and URL (central address management)ADR12S Shadow table: FTP and URL (central addressADR12S2Shadow Table 2: FTP and URL (Central AddresADR13Pager (central address management)ADR13S Shadow table: Pager (central address manageADR13S2Shadow Table 2: Pager (Central Address ManaADR14Reserve communication type (central addressADR15Reserve communication type (central addressADR16Reserve communication type (central address ADR2Telephone numbers (central address admin.) ADR2S Shadow table: Telephone numbers (CAM)ADR2S2Shadow Table 2: Telephone Nos (Central Addr ADR3Fax numbers (central address admin.)ADR3S Shadow table: Fax numbers (CAM)ADR3S2Shadow Table 2: Fax Numbers (Central Addres ADR4Teletex numbers (central address admin.) ADR4S Shadow table: Teletex numbers (CAM)ADR4S2Shadow Table 2: Teletex Numbers (Central Ad ADR5Telex numbers (central address administrati ADR5S Shadow table: Fax numbers (CAM)ADR5S2Shadow Table 2: Telex Numbers (Central Addr ADR6SMTP numbers (central address admin.)ADR6S Shadow table: SMTP numbers (CAM)ADR6S2Shadow Table 2: SMTP Numbers (Central Addre ADR7Remote Mail Addresses (R/3 - R/3; Central a ADR7S Shadow table: RML addresses (Central Addres ADR7S2Shadow Table 2: RML addresses (Central Addr ADR8X.400 numbers (central address admin.)ADR8S Shadow table: X.400 numbers (CAM)ADR8S2Shadow Table 2: X.400 Numbers (Central Addr TOAFO SAP ArchiveLink form managementTOAFV SAP ArchiveLink form managementTOAHR Container table for HR administration level TOAID Doc. ID / file name generationTOAIN SAP ArchiveLink - Interface tableTOAKT SAP ArchiveLink - Communication types value TOAMS SAP ArchiveLink API: Length definition of p TOAO2SAP ArchiveLink extended meta table TOAOM SAP ArchiveLink: Meta table for links TOAOS Logical mapping to implementation method TOAP2SAP ArchiveLink: PresettingsTOAPA Table for parameter maintenance for storing TOAPI SAP ArchiveLink interfaceTOAPR SAP ArchiveLink: Presettings for storage sc TOAPRE SAP ArchiveLink: Presettings for storage sc TOAPRS SAP ArchiveLink: Long text presettings for TOAR7SAP ArchiveLink: Request table (asynchronou TOAS1Number of stored archive filesTOASA SAP ArchiveLink: Language table for methods TOASB Language Table fFor TOABATOASD Language-Dependent Table For TOADDTOASK SAP ArchiveLink: Language table communicati TOASM Language-Dependent Table For TOACMTOASO Language-Dependent Table For TOACOTOASP SAP ArchiveLink: Language table for archive TOASR Language-Dependent Table For TOAARTOASV SAP ArchiveLink: Language table for form ma TOAV1VIEW basis table structure analogous to TOA TOAV2VIEW table 2 structure for link table TOAVK Definition of function calls for object lin TOAVK_S Language table for TOAVKTOBAE Transfer Times: Control Station Communicati TOBJ ObjectsTOBJ_CD Objects that were disabledTOBJ_CONTROL Objects that were disabledTOBJ_OFF Objects that were disabledTOBJ_SAV Objects that were disabledTOBJ_TPL Authorization objects for a global templateTOBJ_TPO Definition table for global templatesTOBJ_TPT Text table for global templatesTOBJECTP Objects assigned to a projectTOBJECTT Objects assigned to a templateTOBJT Texts for Objects in Table TOBJTOBJVOR SAP_NEW Release-Dependent Data for Authoriz TOBJVORDAT Field Values for SAP_NEW Authorization Obje TOBJVORFLG Flags for Authorization ObjectsTODIR Object List for SwitchTODOS TODO: Exclude programs from individual SLINTOGCF GG: Configuration ViewsTOGM1Software Maintenance Process: Collective Processing TOGM2Maintenance sets for profilesTOGM3PLM definition of 'push' materialTOGM4Maintenance ProfileTOGM5Software Maintenance Process: Rejection Codes TOGMT PLM profile descriptionTOJMB Objects in the SAP System: methodsTOJMT Objects in the SAP System: method descriptiTOJRB SAP objects: return values for methodsTOJRT Objects in the SAP System: return value texTOJTB Business object repository: Basic dataTOJTD Customizing Object TypesTOJTL Objects in the SAP System: object types witTOJTT Texts Basic DataTOKOM Technical Parameters for Communications ModTOLE OLE ApplicationsTOLET Workflow Object Types: Texts OLE ApplicatioTONR Number status: general object numberTOOL_COST Costs for Prod.Resource/ToolTOPDEVV Process Order - Selection VariantsTOPRK Log MessagesTORB1Incoming Orders: Cost Element AssignmentTORB2Incoming Orders: Settings for KeyTORS0Customizing Time-Dependent Status: ActivateTORS1Statuses Relevant for Key-Date Based ManageTP01Business Partner: Form of AddressTP01T Business Partner: Form of Address TextTP02Business Partner: SalutationTP02T Business Partner: Salutation TextTP03Business Partner: Marital StatusTP03T Business Partner: Description of Marital StTP04Business Partner: Marital Property RegimeTP04T Business Partner: Description of Marital PrTP05Business Partner: Employee GroupTP05T Business Partner: Name of Employee GroupTP06Business Partner: RatingTP06T Business Partner: Rating DescriptionTP07Business Partner: Credit Rating InstituteTP07T Business Partner: Name of Credit Rating InsTP08Business Partner: Legal FormTP08T Business Partner: Description of Legal Form TP09Business Partner: Legal EntityTP09T Business Partner: Name of Legal EntityTP10Business partner: Loan to Manager Indicator TP103BP: Field Modification via BP Role Category TP105BP: Field Modification via Activity Categor TP10T Business Partner: Name of Loan to Manager TP11Business Partner: Employment StatusTP11T Business Partner: Description of Employment TP12Business Partner: Credit Standing Acc. to G TP12T Business Partner: Description of Credit Sta TP13Business Partner: Partner Grouping (Target TP13T Business Partner: Name of Partner Grouping TP14Business Partner: Address IDTP14T Business Partner: Name of Address IDTP15Business Partner: FunctionTP15T Business partner: Name of FunctionTP16Business Partner: DepartmentTP16T Business Partner: Name of DepartmentTP17U Business Partner: Convert Industries TPACHECK Checking Table Directory for Check Modules TPACHECKASSIGN Checking Module Assignments in SD Partner P TPACHECKRELATION Dependency Graph for Check Modules in SD Pa TPAER_PM Partner Functions in Partner Schema (PM) wi TPAFILTER Filter Table for Displaying Partner Subscri TPAKL Assignment of Partner Function to Account G TPALOG DB Buffer for ALOG FileTPALOGHDR Header Table for TPALOGTPAMA Search Strings for Pattern Matching TPAMAT Text Table for Search String TPAMATPAR Business Partner: FunctionsTPARA Directory of Memory IDsTPARAAPPL Application Table for TPARATPARAT Memory ID Short TextsTPART Business Partner Functions: TextsTPARU Control parallelized confirmation processes TPATT Pattern type in VarChartTPCA_ALE Company Code/Field Transfer PCA (ALE) TPCRTYPE Document Types for Posting Correction Reque TPDB2DB2/390: Pagesize <-> table storage paramet TPEXT Profile for external procurementTPEXT_T Text tables for profiles (external procurem TPF02Profile Table Parameter Names from sapparam TPFBA SAP System operation modeTPFES Prototype: Table for profile parameters TPFET Table of profile parametersTPFHS Prototype: Profile header, administration d TPFHT Profile header, administration data for pro TPFID Description of SAP instanceTPFK Contact Persons: FunctionsTPFKT Contact Partner Functions: TextsTPFST Startup: List of programs to be started TPFVA Profiles: Parameter valid flagsTPFVD Profiles: Parameter values table D (DB, tabTPFVE Profile Parameters for Environment / ValiTPFVI Profiles: Parameter values, table I (IPC...TPFVP Profile Parameters for Processes (Disp, AppTPFVQ Profiles Parameters for Processes (Disp,...TPFVR Profile Parameter Roll, Paging, StatisticsTPFVX Profile Parameter Values Table X (other...)TPFWE Profile Parameters for EnvironmentTPFYDOC Parameter documentationTPFYPROPTY Parameter attributesTPGAC GG enhancement: Material types representing Product Groups TPGPRF Profile for static pegging and data distribTPGPRFT Text table for pegging profileTPHASEP Project phasesTPHASETP Project phases text tableTPHCNV Data for Product Hierarchy ConversionTPHVP Header: Planning ProfileTPI01Interest Calculation ProfileTPI01T Interest Calculation ProfileTPI02Interest Calculation Profile and Interest ITPI03CO Objects: Date of Last Interest RunTPI04Interest Relevance of Cost Element/CommitmeTPICK Analysis of Function Code PICKTPIF2Commitment items: value categoryTPIF3Assignments: Commitment Item -> Value CategTPIK2Cost elements: value categoriesTPIK3Assignment Table: Cost Elements -> Value CaTPIR1Value CategoriesTPIR1T Texts for Value CategoriesTPIR2Value CategoriesTPIR2T Texts for Value CategoriesTPIRX Control RPSCO updateTPIS3Assignment Table:Statistical Key Figures ->TPK01Key for Controlling the Control Cycle; In-HTPK02Key for Controlling Control Cycle: ExternalTPK03Key for Controlling Control Cycle; Stock TrTPK1T Control Cycle Profile for In-House ProductiTPK2T Control Cycle Profile (External ProcurementTPK3T Control Cycle Profile (Stock Transfer) - TeTPKAK Actions in KANBAN ProcessingTPKBP Kanban calculation profileTPKBU Adjusting a Control Cycle in Kanban CalculaTPKER Alternative Error Handling in the Kanban PrTPKLEK Delete Event-Driven KanbansTPKPT Kanban Authorization TextTPKSF Kanban Status SequencesTPKTX Kanban Container Status Short TextTPLMK GG enhancement: Document types proposed for MLMTPLOG Logging of tp CallsTPLOGNAMES tp: Names of Log Files and Times UsedTPLVP Planning ProfileTPMA_DERIV_ASSGN Assignment of Derivation CategoriesTPMB_DERIV_AMORT Assign Amortization Method to Derivation CaTPMB_DERIV_CAT Define Derivation MethodsTPMCKF PMIS: customer-specific value and quantityTPMCKFT PMIS: texts for cust.-specific value and quTPMIM IM allocation keyTPMK Cost key figures of the maintenance order TPMKT Texts for cost key figures of the maintenan TPMP Maintenance profileTPMPO Maintenance order processing profileTPMT_DEDOC_HDR Derivatives Document: Document Header TPMT_DEDOC_LOTPO Derivatives Document: Document Item Per Lot TPMT_DEDOC_POS Derivatives Document: Document ItemTPMT_DEPAL_FLOWS Listed Futures: Price Gain RecordsTPMT_LOT_HEADER Single Position Master Data for TR Position TPMT_POS_IND_DE Allocation of Acct Assignment Reference to TPMTAUSWDEF Definition Table: Evaluation Area Customizi TPMTAUSWTEXT Text Table: Evaluation Area for Customizing TPMTCUSTCHECK Table for Function Modules of Customizing C TPMTVMFL Position management variation margin flows TPMUS PM/SM - User default valuesTPNNR Customizing prima notaTPNNT Prima nota customizing textsTPOOL Master Record, LIFO PoolsTPR_INDEX List of nodes sorted by projectTPR_PREF User's settingsTPR_VINDX List of IMG Activities in a Project View TPR_XREF_D Index for Where-Used ListTPR_XREF_P Projects: Constraint on Where-Used List TPR1Patner-Object Relationship: Assignment Cate TPR1_U Patner-Object Relationship: Assignment Cate TPR1T Partner-Object Relationship: Assignment Cat TPR2Partner-Obj. Relationship: Assignment Cat. TPR4Partner-Object Relationship: Event Modules TPR5Partner Object Relationship: Application Ca TPR6Partner Object Relationship: Application Ca TPRBO Business Objects with ALE Change Authorizat TPRC Business Process in Expiring Currency TPRCD Date for Subsequent Process for Expiring Cu TPRCLASS Project Management Project Classes TPRCLASST Project Class Table Text TableTPRCT Business Process in Expiring Currency (Text TPRF International Article Number (EAN) Prefixes TPRFL Field Groups per Change Authorization Profi TPRFT EAN Prefix DescriptionsTPRI_PAR ABAP print parameter storageTPRIO Customers: Delivery PrioritiesTPRIOCL Project Class Priority Assignment TPRIOEPR Project Management PrioritiesTPRIOP Project PrioritiesTPRIOTPR Project Management: Priorities TextTPRIT Customers: Delivery Priority: TextsTPRO Profile Names for ALE Change Authorizations TPROCESSES Profile Names for ALE Change Authorizations TPROF_CEP Profile for CEPTPROFT_CEP Text table for CEP profileTPROJ_GEN Project Additional Data TableTPROJECT SPROJECT: Project TableTPROJECTF Project Management Favorites List TPROJECTT Project Table Text TableTPROO Sequence of Change Authorization Profiles TPROT Table contains all DD tables to be logged TPROX Profile Names for ALE Change Authorizations TPRPROF Profile name for roleTPRQPB Payment Block when using Payment Requests TPRRU Control table for process chain for confirm TPRRUT Text table for process control of confirmat TPRVOR Templates Profile Generator: Entity Table TPRVORDAT Templates: Relation Transaction > Auth. Obj TPRVORT Templates Profile Generator: Entity Table TPRZ1Partner-Object RelationshipTPS01Business Transaction Events: Process Interf TPS01T Process Interface TextsTPS02Process Interfaces: Allocation to applicati TPS31Application function modules per process in TPS32Partner function modules per process interf TPS34Customer function modules per process inter TPST Functional Location - BOM LinkTPSTAT Status of tp CallsTPSVP Planning profile linesTPT_ABQT_OBJECTS TMW: Assignment of Quota Type and Object ID TPT_DISP_OBJ_CT TMW: Display Objects Column Short Texts TPT_DISP_OBJ_T TMW: Display Objects Column Short Texts TPT_EVENTATTR Pair Formation: Characteristics of Time Eve TPT_FIELD_CAT Field CatalogTPT_FIELD_CAT_T Field Catalog TextTPT_FIELD_SEL Field selectionTPT_FIELD_SEL_C Field Selection: CustomizingTPT_FIELD_SEL_T Field Selection TextTPT_GUI_CLNT_FRM Function Modules for GUI Objects: Client-De TPT_GUI_CLNT_LAY GUI Layout: Definition for Client-Dependent TPT_GUI_CLNT_LYS GUI Layout: Structure, Client-Dependent Obj TPT_GUI_CLNT_LYT GUI Layout TextTPT_GUI_CLNT_OBJ GUI Object Types According to ID (Client-De TPT_GUI_CLNT_OBT GUI Objects: TextTPT_GUI_CLNTSSCR Assignment of Object ID to SubscreenTPT_GUI_LAYOUT GUI Layout: Structure and Assignment of Obj TPT_GUI_LAYOUT_T GUI Layout TextTPT_GUI_LAYOUTS GUI Layout: DefinitionTPT_GUI_OBJECT_T GUI Objects textTPT_GUI_OBJECTS GUI Object Types According to IDTPT_GUI_SAP_FRM Assignment of GUI Object Types to Function TPT_GUI_SAP_SSCR Assignment of Object ID to Subscreen TMCRT Texts for RMCS0F00 (LIS Standard Analyses) TMCSA LIS EvaluationsTMCSC LIS LibrariesTMCSD LIS Readings for Internal Number Assignment TMCSE LIS Default Sets and Format ClassesTMCSF LIS Standard Reports/Layouts for Evaluation TMCSG LIS Standard Reports/Layouts for Evaluation TMCTC LIS Transaction Code ControlTMCTX LIS: Characteristic Texts (external data an TMCUS Parameters for Standard Analyses in LIS TMCW RIS EnhancementTMCW1Table for Counter Readings of Info StructurTMCW2Administrative Data for SIS Re-Setup TMCW3Table for Counter Readings of Info Structur TMCWB Do not use!TMCWBT Do not use!TMCWW Check table: Time of day classTMCWWT Texts for descriptions of time of day class TMCZ Special Categories of Info Structures TMDIR Table for administering methods in a class TMED Purchasing Various Control Parameters TMEDS SAPfind structure and text for IMG menu ent TMEMO User-specific memoryTMENU01Node Table for General Structure Storage TMENU01R General Structure Storage References TMENU01T General Structure Storage Node Names TMENUBK01Node Table for General Structure Storage TMENUBK01R General Structure Storage References TMENUBK01T Node Names for General Storage Structure TMENUTAB Table and field assignments for transaction TMET Unit of measure categoriesTMETADIM_02HR Forms: MetaDimensionsTMETADIM_T_02HR Forms: Short Texts for MetaDimensions TMETADIMFLD_02HR Forms: MetaFieldsTMETADIMFLD_T_02HR Forms: Short Texts for MetaFields TMETAFIGURE_02HR Forms: MetaFiguresTMETAFIGURE_T_02HR Forms: Short Texts for MetaFigures TMETANET_02HR Forms: MetaNetsTMETANET_T_02HR Forms: Short Texts for MetaNets TMETANETSTAR_02HR Forms: Assignment of MetaStars to MetaNe TMETANETSTAR_03HR Forms: Assignment of MetaStars to MetaNe TMETANETSTARI_02HR Forms: MetaStars in MetaNets (Internatio TMETASTAR_02HR Forms: MetaStarsTMETASTAR_I02HR Forms: Read Data for Infotypes TMETASTAR_O02HR Forms: Read Data for Other MetaStars TMETASTAR_P02HR Forms: Read Data for Payroll Results TMETASTAR_T_02HR Forms: MetaStarsTMETASTARDIM_02HR Forms: Assignment of Dimensions to MetaS TMETASTARDIM_03HR Forms: Assignment of Dimensions to MetaS TMETASTARDIM_I02HR Forms: Read Data for Infotype MetaDimens TMETASTARDIM_I03HR Forms: Read Data for Infotype MetaDimens TMETASTARDIM_O02HR Forms: Read Data for Other MetaDimension TMETASTARDIM_O03HR Forms: Read Data for Other MetaDimension TMETASTARDIM_P02HR Forms: Read Data for Payroll Dimensions TMETASTARDIM_P03HR Forms: Read Data for Payroll Dimensions TMETASTARDIMI_02HR Forms: Dimensions in MetaStars (Internat TMETASTARDIMII02HR Forms: Read Data for Infotype Dim. (Inte TMETASTARDIMIO02HR Forms: Read Data for Other Dim. (Interna TMETASTARDIMIP02HR Forms: Read Data for Payroll Dim. (Inter TMETASTARFIG_02HR Forms: Figures in MetaStars TMETASTARFIG_I02HR Forms: Read Data for Infotype Figures TMETASTARFIG_O02HR Forms: Read Data for Other Figures TMETASTARFIG_P02HR Forms: Read Data for Payroll Figures TMETT Description for unit of measure categories TMEX Quantity Overview: ExceptionsTMEXT PIC: Interchability Codes' TextTMFA Markdown Planning - Markdown type。
SAP所有模块简介
SAP在管理功能上，它共有12个系统模块,下面为你一一介绍, 希望对你了解SAP 有所帮助。
（1）SAP MM模块（物料管理模块），主要有采购、库房与库存管理、MRP、供应商评价等管理功能。
（2）SAP SD模块（销售与分销模块)，其中包括销售计划、询价报价、订单管理、运输发货、发票等的管理，同时可对分销网络进行有效的管理。
（3）SAP AM 模块（资产管理模块)，具有固定资产、技术资产、投资控制等管理功能。
（4）SAP CO模块(管理会计模块)，它包括利润及成本中心、产品成本、项目会计、获利分析等功能，它不仅可以控制成本，还可以控制公司的目标，另外还提供信息以帮助高级管理人员作出决策或制定规划。
（5）SAP FI模块（财务会计模块），它可提供应收、应付、总账、合并、投资、基金、现金管理等功能，这些功能可以根据各分支机构的需要来进行调整，并且往往是多语种的。
同时，科目的设置会遵循任何一个特定国家中的有关规定。
（6）SAP PS模块（项目管理模块），具有项目计划、项目预算、能力计划、资源管理、结果分析等功能。
（7）SAP HR模块（人力资源模块），其中包括：薪资、差旅、工时、招聘、发展计划、人事成本等功能。
（8）SAP WF模块（工作流管理模块），可提供工作定义、流程管理、电子邮件、信息传送自动化等功能。
（9）SAP QM模块（质量管理模块)，可提供质量计划、质量检测、质量控制、质量文档等功能。
(10) SAP PP模块（生产计划模块)，可实现对工厂数据、生产计划、MRP、能力计划、成本核算等的管理，使得企业能够有效的降低库存，提高效率。
同时各个原本分散的生产流程的自动连接，也使得生产流程能够前后连贯的进行，而不会出现生产脱节，耽误生产交货时间。
(11) SAP PM模块（工厂维修模块），可提供维护及检测计划、交易所处理、历史数据、报告分析。
(12) SAP IS模块(行业解决方案），可针对不同的行业提供特殊的应用和方案。
SAP表的对应关系003
VBELN POSNRETENR VBEH 计划行历史SDVBAK-VBELN=VBAP-VBELNVBBE-VBELN=VBAK-VBELNVBLB-VBELN=VBAK-VBELNVBAK销售凭证 ： 抬头数据VBPA销售凭证 ：VAKPA销售索引 ： 按合作伙伴功能的订单VBEP销售凭证:计划行数据交货到期索引VKDFSSD索引： 出具发票初始器VBEP-VBELNVAPMAVBAP-VBELN VBAP-POSNR=VBEP-VBELN=VBEP-POSNRVBAK-VBELN=销售索引 ： 按物料的订单项目VBBE销售需求： 单独记录VBLB销售凭证:批准订单数据VEPVGVBFA 销售凭证流VBUK销售凭证：抬头状态和管理数据VBUP销售凭证 ： 项目状态VBAP-VBELN=VBPA-VBELN VBPA-POSNR=VBAP-POSNRVBPA证 ： 合作伙伴VBAP销售凭证:项目数据VBKD销售凭证 ： 业务数据VBKD-POSNR=VBAP-POSNR VBKD-VBELN VBAP-VBELN=LIKP-VBELN=VBLK-VBELN VEPO-VBE LIKP-VBEVTTP-VBE LIKP-VBELIPS-VBELN=LIKP-VBELNLIKPVBAP-VBELN SD凭证:交货项目数据LIPSVBLK销售凭证：交货抬头交货单SD凭证:交货抬头数据LIPS-VGBEL VBPA-VBELN=LIPS-VGPOS=VBAP-POSNRLIPS-VGBEL=O-VBELN=KP-VBELNP-VBELN=KP-VBELNVTTK 装运抬头VTTP-TKNUM LIPS-VBELN=VEPO包装: 处理单位项目VEKPVEPO-VENUM=VEKP-VENUMVTTK-TKNUM=处理单位 - 抬头表VBRP-VGBEL LIPS-POSNR=VBRP-VGPOSKONV条件（事务数据）VBRK出具发票:抬头数据VBRP出具发票:项数据货单VTTP 装运项目VBRK-KNUMV KONV-KNUMVVBRP-VBELN=VBRK-VBELN出具发票VBSK关于销售凭证抬头的汇总处理VBSS汇总处理： 销售凭证VKDFSSD索引： 出具发票初始器NAST消息状态VRPMA销售索引 ： 每一物料的开票项目VRKPA销售索引 ： 按合作伙伴功能的票据。
SAP 常用表及表关系
SAP MM常用表及表关系一、MM常用表1、MARA: 常规物料数据2、MARC: 物料的工厂数据3、MAKT: 物料描述4、MARD: 物料的工厂/库存地点数据5、MBEW: 物料评估（财务数据），其中MBEW-WERKS指工厂6、MVKE: 物料销售数据7、MLGN: 每一个仓库号物料数据（仓库）8、MLGT: 每一个存储类型的物料数据（仓库/存储类型）8.1、MSTA：物料主记录状态9、LFA1: 供应商主数据（一般数据）10、LFB1: 供应商主数据（公司代码）11、LFM1: 供应商采购组织数据12、EINA: 采购信息记录（一般数据）13、EINE: 采购信息记录（采购组织数据）14、EKKO: 采购订单抬头15、EKPO: 采购订单行项目16、EKET: 计划协议计划行17、EKKN: 采购凭证中的帐户设置18、EKBE: 采购凭证历史19、MKPF: 物料凭证抬头20、MSEG: 物料凭证行项目21、RBKP: 凭证抬头供应商发票数据22、RSEG: 凭证项目供应商发票数据EKKO/EKPO–>MKPF/MSEG–>RBKP/RSEG–>BKPF-BSEG23、KNA1: 客户主数据（一般数据）24、KNB1: 客户主数据（公司代码）25、KNVV: 客户主记录销售数据26、ADRC: 地址27、EBAN: 采购申请MaterialsMARA - Material Master: General dataMAKT - Material Master: DescriptionMARM - Material Master: Unit of MeasureMAPE - Material master: Export control fileMARC - Material master: Plant dataMARD - Material master: Storage locationMAST - Material link to BOMMBEW - Material valuationMLGN – Material Master: WM InventoryMLGT – Material Master: WM Inventory typeMDIP - Material: MRP profiles (field contents)MKOP - Consignment price segment (old versions of SAP)EBEW - Valuation of sales order stockQBEW - Valuation of project stockMVER – Material Master: Consumption <Plant>DVER – Material Master: Consumption <MRP Area>MVKE – Material Master: Sales <Sales Org, Distr Ch>MLAN - Material Master: Tax indicatorMARC - Material Master: Plant dataMAPR – Material Master: ForecastMARD – Material Master: Storage LocationMCH1 – Material Master: X Plant BatchesMCHA – Material Master: BatchesMCHB – Material Master: Batch StockMDMA - MRP Area dataDBVM - MRP Planning File Entry: MRP AreaMOFF - Outstanding Material Master Records (Maintenance status)MARCH - Material Master C Segment: HistoryMARDH - Material Master Storage Location Segment: History MBEWH - Material Valuation: HistoryMCHBH - Batch Stocks: HistoryMKOLH - Special Stocks from Vendor: HistoryMSCAH - Sales Order Stock at Vendor: HistoryMSKAH - Sales Order Stock: HistoryMSKUH - Special Stocks at Customer: HistoryMSLBH - Special Stocks at Vendor: HistoryMSPRH - Project Stock: HistoryMSSAH - Total Sales Order Stocks: HistoryMSSQH - Total Project Stocks: HistoryVendorsLFA1 - Vendor Master: General dataLFB1 - Vendor Master: Company dataLFM1 - Vendor Master: Purchasing Data (Purchasing organization) LFM2 - Vendor Master: Purchasing Data (Plant, Vendor sub-range)PurchasingEBAN - Purchase requisition: itemsEBKN - Purchase Requisition: account assignmentSTXH - SAPScript Text HeaderSTXL - SAPScript Text LinesEKKO - Purchasing document headerEKPO - Purchasing Document: ItemEKET - Purchasing Document: Delivery SchedulesMDBS - Material View of Order Item/Schedule Line (good to find open PO's) EKKN - Account assignment in purchasing documentEORD - Purchasing Source ListEIPA - Order price history recordEKAB - Release documentationEKBE - Purchasing document historyEKBZ - Purchasing document history: delivery costsEKPB - "Material to be provided" item in purchasing documentESKL - Account assignment specification for service lineESKN - Account assignment in service packageESLH - Service package header dataESLL - Lines in service packageESSR - Service entry sheet header dataESUC - External services management: Unplanned limits for contract item ESUH - External services management: unplanned service limits header data ESUP - External services management: unplanned limits for service packagesESUS - External services management: Unplanned limits for service typesEINA - Purchase Info Record: GeneralEINE - Purchasing info record: purchasing organization dataKONP - Condition ItemKONH - Condition HeaderInventory ManagementISEG - Physical inventory document itemsMKPF - Material document: HeaderMSEG - Material document: itemRKPF - Reservation: HeaderRESB - Reservation: ItemInvoice VerificationBSIM - Secondary index: documents for materialMYMFT - FIFO results tableMYML - LIFO material layerMYMLM - LIFO material layer (monthly)MYMP - LIFO period stocks, single materialMYMP1 - Receipt data LIFO/FIFO valuationMYPL - LIFO pool layerMYPLM - LIFO pool layer (monthly)RBCO - Document item, incoming invoice account assignment RBDIFFKO - Invoice Verification: conditionsRBDIFFME - Invoice Verification: quantity differences RBDRSEG - Invoice Verification batch: invoice document items RBKP - Document header: incoming invoiceRBKPB - Invoice document header (batch invoice verification) RBTX - Taxes:incoming invoiceRBVD - Invoice document: summarization dataRBVDMAT - Invoice Verification: summarization data, material RBWT - Withholding tax:incoming invoiceRKWA - Consignment withdrawalsRSEG - Document item, incoming invoiceCustomising and other master dataMDLV - MRP AreasMDLG - MRP Areas - Storage LocationsMDLW - MRP Areas - PlantsMDLL - MRP Areas - SubcontractorT023 - Material GroupsT024 - Purchasing groupsT030 - Standard Accounts Table (Automatic Account Determination) T156 - Movement TypeT156T - Movement Type: TextAUSP - Release Procedure: Strategy values (cl20n, cl24n)AGR_USERS - Assignment of roles to usersCDHDR & CDPOS - Change history of master data and documents EDID4 - EDI informationTSTC - SAP Transaction Codes, lock/unlock: sm01, created: se93 TSTCT - Transaction codes TEXTNAST - Message status二、SD常用表1、VBAK: 销售凭证：抬头数据2、VBAP: 销售凭证：项目数据3、VBEP: 销售凭证：计划行数据4、VBKD: 销售凭证：业务数据5、VBPA: 销售凭证：合作伙伴6、LIKP: SD凭证：交货抬头数据7、LIPS: SD凭证：交货项目数据8、VBRK: 出具发票：抬头数据9、VBRP: 出具发票：项目数据10、VBFA: 销售凭证流11、VBUK: 销售凭证：抬头状态和管理数据12、VBUP: 销售凭证：项目状态13、T682I: 条件：存取顺序( 产生格式 )14、T681: 条件：结构15、T682Z: 条件：存取顺序( 字段 )16、T685: 条件:类型三、FICO常用表1、SKA1: 总帐科目主记录 (科目表)2、SKB1: 总帐科目主记录 (公司代码)3、SKAT: 总帐科目主记录（描述）4、CSKB: 成本要素5、BKPF: 会计凭证抬头6、BSEG: 会计核算凭证项目数据，BSID客户未清会计核算凭证/BSAD客户已清会计核算凭证/BSIK供应商未清会计核算凭证/BSAK供应商已清会计核算凭证/BSIS总帐未清会计核算凭证/BSAS总帐已清会计核算凭证7、FAGLFLEXA: 总账实际行项目8、FAGLFLEXT: 总账汇总9、ANLA: 资产主记录段10、ANLC: 资产值字段11、CSKS: 成本中心主数据12、COEP: 成本控制对象：与期间相关的各行项目13、COSS: CO 对象:内部过帐成本总计14、COSP: CO 对象：外部记帐的成本总计15、 CKMLPRKEKO: 物料分类帐; 价格的成本组件分割 (标题)16、CKMLPRKEPH: 物料分类帐: 价格的成本组件分割 (要素0四、PP常用表1、MAST：BOM链接物料2、STKO：BOM表头3、STAS：BOMs - 项选择4、STPO：BOM项目STKO~STLAN = STAS-STLAN AND STKO~STLAL = STAS-STLALSTAS~STLNR = STPO-STLNR AND STAS~STLKN = STAS-STLKNBOM类别包括：D-凭证结构、E-设备BOM、K-订单BOM、M-物料BOM、S-标准BOM、T-功能位置BOM、P-工作分解结构BOM5、PLAF: 计划订单6、RKPF: 预定/相关需求抬头7、RESB: 预定/相关需求行项目8、AUFK: 订单主数据9、AFKO: 订单表头数据，PP订单10、AFPO: 订单项11、AFVC: 订单的工序12、AFVV: 工序中数量/日期/值的DB结构13、JEST: 订单状态，通过AUFK-OBJNR=JEST-OBJNR关联14、AFRU: 订单确认15、AUFM: 针对订单的货物移动五、PM常用表1、IFLOT: 功能位置(表)2、ILOA: PM 对象位置和帐户分配六、PS常用表1、PROJ: 项目定义2、PRPS: WBS(工作中断结构) 元素主数据七、QM常用表八、库存数据1、MBEW: 物料评估2、MARD: 物料的工厂/库存地点数据3、MSLB: 供应商特殊库存（O）4、MKOL: 供应商特殊库存（K）5、MSKA: 销售订单库存6、MCH1/ MCHB: 批次库存九、货物移动数据1、MKPF: 物料凭证抬头2、MSEG: 物料凭证行项目不是所有的物料移动数据都需要从这物料移动表中进行读取，生产订单相关AUFM，采购订单相关EKBE，销售相关VBFA。
SAP CRM 表关系图
IBASE
CRM_JEST OBJNR(FK) STAT INACT CHGNR
COMM_PRPRDCATR PRODUCT_GUID(FK) CATEGORY_GUID CATEGORY_ID
FM2[GUID_Convert] Product_GUID OBJNR IBINVALUES IN_RECNO(FK) SYMBOL_ID IBINOWN(Owner) INSTANCE OBJKEY(FK) INTTYP(1001)
COMM_PR_TAX PRODUCT_GUID(FK) TEXT_TYPE TEXT_GROUP COMM_PR_FRG_REL PRODUCT_GUID(FK) FRAGMENT_GUID(FK) COMM_PR_UNIT PRODUCT_GUID(FK) UNIT VOLUMN COMM_PR_FRG_ROD PRODUCT_GUID(FK) SALES_ORG FRAGMENT_GUID(FK) STATUS_OBJECT COMM_PRSHTEXT PRODUCT_GUID(FK) SHORT_TEXT
IBIN(componoent) IBASE OBJNR IN_RECNO INSTANCE IN_OBJNR IN_GUID
CRM_JSTO OBJNR OBTYP
COMM_PRODUCT PRODUCT_GUID PRODUCT_ID PRODUCT_Type Object_Family
FM1[GUID_Convert] SEGMENT_RECNO IN_OBJNR/IB_GUID
BUT100(role) PARTNER(FK) RLTYP BUT0IS(industry) PARTNER(FK) IND_SECTOR BUT0BK(bank) PARTNER(FK) BKVID BANKN BUT050(relationship) PARTNER1(FK) PARTNER2 RELNR
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
SAP Principal Tables2007. 09. 28Netweaver TeamContentsMaterial Master Tables SD-MM Tables .……….…………………….................……………………………..2 3PS Tables (6)PP Tables QM Tables CO T bl ........................…………………………….. ......................……………………………..710CO Tables FI Tables…………..…………………………………. ..........................………………………..……1115Dictionary Tables (16)Material Master TablesMaterial Ledger MaterialMaterial Material MaterialMaterial Master ViewMaterial LedgerHeader CKMLHD Material Ledger Total Values Forecast ParameterMPOPPlanning DataMPGD Material Databy Warehouse NumberMPGD Unit of MeasureMARMTax ClassificationMLANMaterial DescriptionGeneral Material MasterMARA CKMLCRMaterial Ledger Total Quantity CKMLPP Material LedgerMaterial Valuation DataMBEWMaterial Data by Plant MAKTPrices CKMLPRMARC Material Data by Storage LocationMARD Material Data by Storage Type M i l A ib Routing Assignmentto Material MAPL BOM Link to MaterialMASTProduction Versionof Material MKALRouting HeaderBOM HeaderProduction Version Bill of Material (BOM)Routing Material Sales Data MVKEby Storage TypeMLGT Material TypeT134Material Group Material Attribute Routing Header PLKO Routing ItemPLPOBOM Header STKO BOM Item STPOMaterialProduction HierarchyT179pT023Material Control RecordMARV 물류자재이동통제MMSD Sales Header StatusVBUK Sales Item StatusSales Doc. FlowVBFAPurchase Doc. HistoryEKBESales Order HeaderVBAK Sales Order ItemVBAPS/O Business DataVBKD VBUP S/O Schedule Line ÆPurchase RequisitionPurchase Requisition ÆPurchase OrderPurchase Order HeaderEKKOPurchase Order ItemEKPOS/O Schedule LineVBEPDelivery HeaderLIKP Shipping HeaderVEKP S/O Schedule Line ÆPurchase OrderEKKNEBKN EBANP/O Schedule LineDelivery ItemLIPSShipping ItemVEPOMaterial Doc. HeaderMKPFG d I (G/I)EKETMaterial Doc. HeaderMKPF Material Doc. ItemMSEGBilling HeaderGoods Issue (G/I)Material Doc. ItemMSEGGoods Receipt (G/R)Invoice Header출하실적VBRKBilling Item VBRPAccounting HeaderBKPF Accounting SegmentS GRBKP Invoice ItemRSEG매출실적매입실적BSEGSD MM ■Organization TablesCategory Table Description Text Master TVKO Sales Organization TVKOT TVTW Distribution Channel TVTWT Category Table Description Text Master T024E Purchasing OrganizationT024Purchasing GroupTSPA Division TSPAT TVBUR Sales Office TVKBT TVKGR Sales Group TVGRTT026Purchasing Area T026T WYT1Vendor Subrange(Vendor + Vendor Subrange)T001W PlantT171Sales Districts T171T Link TVKOS Sales Organization + DivisionTVKOV Sales Organization + ChannelS l O i i Ch l Di i iT001L Storage Location(Plant + Storage Location) Link T024W Plant + Purchasing OrganizationTVTA Sales Organization + Channel + Division TVBVK Sales Office + Sales GroupTVKBZ Sales Organization + Channel + Division + Sales OfficeT026Z Purchasing Organization + PurchasingGroup + Purchasing AreaVendor LFA1Vendor General DataLFB1Vendor + CompanyCustomer KNA1Customer General DataKNB1Customer + CompanyKNVV Customer + Sales Organization +Distribution Channel+Division LFM1Vendor + Purchasing Organization LFM2Vendor + Purchasing Organization + Vendor Subrange + PlantDistribution Channel + Division■MM Purchasing Info RecordSAP Script Text FileLong Text InformationMaterial Info RecordCondition HeaderKONH Condition ItemKONPHeader STXH SAP Script Text FileLines STXLMaterial Info Record Header EINA Material Info RecordItem EINEMaterial Info Recordby Plant A017Purchasing Info Record +Material + VendorPurchasing Doc.Header Purchasing OrderSales Order 재고Table(판매,고객,공급처,창고재고)EKKO Purchasing Doc.Item EKPOS/O Schedule Line ÆPurchase OrderEKKNSales OrderStock MSKA(MSKAH)Special Stocks with Customer MSKU(MSKUH)P/O Schedule LineEKETLogistics Summary TablesS???Special Stocks with Vendor MSLB(MSLBH)Storage Location Datafor Material MARD(MARDH)Project DefinitionWork Center HeaderCRHD Work Center CO Obj. Cost Total Summary ofActual & Plan Data Object Number (OBJNR)Project Definition PROJWork Center TextCRTX Assignment Work Centerto Cost CenterExternal PostingCOSP CO Obj. Cost Total Internal PostingCOSS(O )WBS Element MasterPRPSScheduling Data to Cost Center CRCOProject Hierarchy Scheduling Data for Project ItemPRTEPS Texts (WBS)PRTXPS Texts (Header)Production OrderHeader AFKONetworkj y for WBS ElementPRHI PSTXPS Texts (Description)PSTTProject Hierarchy for WBS ElementPRHISOperation within OrderAFVCOperationActivity Value in Operation AFVVNetwork –RelationshipsAFAB Network 내작업순서선후관계Routing Assignmentto Material BOM Link to MaterialMASTProduction Versionof Material Production Version Bill of Material (BOM)Routing Work Center HeaderCRHD Work Center MAPL MKALRouting HeaderPLKO Routing ItemBOM HeaderSTKOBOM Item Work Center TextCRTX Assignment Work Centerto Cost Center Routing Selection of BOMItem Selection Production Order Master Data CAUFV ViewPlanned OrderPLAF PLPOSTPOto Cost CenterCRCOOperation/ActivatesPLASOrder Operation Data for Work CenterItem SelectionSTASAUFK Production OrderHeader AFKO P d ti O dP d ti O d 생산실적생산계획S022Goods Movements Errors from ConfirmationsAFFWConfirmationProduction Order Item AFPOProduction Order ConfirmationAFRUMaterial Doc.Header MKPF M t i l DSubsequently posted 생산품입고(G/R)BOM 에의한투입원자재예약ReservationItem Reservation Header RKPF Material Doc.Item MSEGSubseque t y posted Goods Movements for ConfirmationsAFWI Goods Movement for Production OrderRESB원자재투입(G/I)AUFM■ConfirmationOperation within OrderÆOrder 내공정작업:Order Routing Table of Planned Changesf C fi tiAFVCActivity Value in Operation AFVV: Order 생성시Routing 정보가복사된다.Production Order ConfirmationAFRU생산실적생산품입고(G/R)Goods Movements Errors from ConfirmationsAFFW Incorrect Cost Calculationfrom Confirmations ErrorsPDCAFRP0for Confirmation Automatic Goods ReceiptSubsequently posted Goods Movements for ConfirmationsAFWIfrom ConfirmationsAFRCAFRP1Backflushing AFRP2만약Confirmation 도중Error 가발생했거나Backlog 가남아있을경우다음의Program 을실행한다.Program :CORUPROC Material Doc.Header MKPF Data Transfer to HRAFRP4Calc. Actual CostsAFRP3Program : CORUPROC,CORUAFFW(T-Code :COGI)Material Doc.Item MSEGCharacteristics ■Production VersionProduction Versionsof MaterialMKALLink between Internal MKAL-MATNR = 자재번호MKAL-WERKS = 플랜트MKAL-PLNTYMKAL-PLNNRMKAL-ALNALINOB-OBJEK=MKAL-PLNTY+MKAL-PLNNR+MKAL-ALNALLink between Internal Number and ObjectINOB INOB OBJEK MKAL PLNTY + MKAL PLNNR + MKAL ALNAL INOB-KLARTINOB-OBTABAllocation Table Object to Class KSSK-OBJEK = INOB-OBTAB KSSK-KLART=INOB-KLARTObject to ClassKSSK KSSK KLART INOB KLART KSSK-CLINTClass Header DataKLAH Characteristics KLAH-CLINT = KSSK-CLINT KLAH-KLART = INOB-KLART KLAH-CLASSCharacteristics of a ClassKSMLInspection Lot Record Inspection CatalogCode Code Texts Quality Message –QALSInspection Processing: Usage DecisionGenerated TableFor View QMFELCharacteristic Specificationsfor Inspection ProcessingQPCDQuality Notification ItemsQMFEQPCT Maintenance Data ExcerptQMIHÆ설비고장시간Inspection MethodQAVE QMFELQAMVCharacteristic Results in Sample Specifications Insp. Specifications/Quality NotificationQMELInspectionCharacteristic MasterQPMKpMaster RecordQMTBInspectionMethod TextsQMTTInspection ProcessingQAMRp pfor Inspection ProcessingQASVp pValuationQAMVRMSInspection CharacteristicI M th d/Results Tablefor the Sample UnitQASEConfirmation Data for Multiple Spec. SampleQASRMSpMaster TextsQPMTLink Inspection Lot Insp. Methods/Insp. CharacteristicQPMZLogistics Summary TablesS???Link Inspection Lotand Material DocumentQAMBMaterial Doc. ItemMSEGMaterial Doc. HeaderMKPFEC-PCA: Actual Line Items CO-PCA Table■Basic TableCost Center MasterCSKS Profit Center MasterCEPCCost Element MasterCSKAMaster DataObject Number Index EC-PCA: Totals TableGLPCTLine Items GLPCA EC-PCA: Object Tablefor AccountAssignment ElementsObject Number Index for Cost CenterONRKSGLPCO EC-PCA: TransactionAttributes GLPCPObject Number(OBJNR):‘KS’+CO Object CO Obj. Cost Total Summary of Actual & Plan DataActual Line ItemCE1????CO Object Document CO-PA TableObject Number(OBJNR) : KS + Controlling Area(KOKRS) + Cost Center(KOSTL)Document LineCOEPCO ObjectDocument HeaderExternal PostingCOSP CO Obj. Cost Total Internal PostingCOSSLine (by Fiscal Year)COEJPlan Line Item CE2????Summary Record Profitability Segment COBKProfitability SegmentCE3????Profitability SegmentDefinition CE4????ll dÆ???? :Controlling Area Code■Material LedgerMaterial Ledger Document 기준Cost Estimate 기준Header Record CKMLHDPeriod Totals d l Cost Component Splitd Product Costing d Document HeaderMLHDDocument C i d lDocument Posting i d d Q i iDocument ItemsMaterial 과Cost Estimate 의Link 정보Records Values CKMLCR Period Totals Records QuantityCKMLPPHeader CKMLKEKO Cost Component SplitElements CKMLKEPHHeader Data KEKO Product Costing Cost ComponentsKEPHCurrencies and Values MLCR Periods and Quantities MLPPDocument Items MLITDocument 와Material, Cost Estimate,Production Process 의Link 정보를담고있다.Prices CKMLPRMaterial Valuation DataCost Component Split Material Costing View Cost Component Split Cost Component GroupsCost Components PP 의원가취합처나생산작업지시와연결된다.MBEW Cost Component Split Header for Prices CKMLPRKEKO Cost Component Split Elements for Prices CKMLPRKEPHMaterial Valuation DataHistory MBEWHCost Component Split (Control Record)CKMLKEV TCKH7Cost Component Groups-Texts TCKH6Cost Components만약CKMLHD 와CKMLPRKEKO 를대사하여CKMLPRKEKO 에존재하지않는Cost Estimate 가있거나Price Update(T-Code:CK24)에서오류발생시별도생성작업을한다.Program : MLCCS_STARTUPMLCCS_RESET ExecuteCost Components-Texts TCKH1Cost Components TCKH3■Product CostsÆProduct Cost by Period(기간별제품원가)에서사용하는Product Cost Collector(제품원가취합처)에취합된Cost DataOrder Master DataAUFK Generated View for COCOASCO Object 기준ÆWRTTP (Val e T pe)Object Number(OBJNR) : ‘OR’ +Order Number (AUFNR:원가취합처or 생산작업지시)Order Header DataAFKOTotal Variances/Results AnalysesCOSB Order Item Cost Totals for External PostingsGenerated View for PPCAUFVWRTTP (Value Type) -‘04’ : 사전원가(Preliminary Cost)-‘05’ : 실적AFPOCOSP Cost Totals for Internal PostingsCOSS Activity Type TotalsÆAUFNR : 원가취합처번호(Order Type:RM01)COSL ÆOBJNR : 오브젝트번호※Product Cost by Order(오더별제품원가)에서는Production Order 단위로Cost Data 가취합된다.※기간별제품원가에서사전원가(Preliminary Cost)는표준원가(Standard Cost)와달리원가취합처별(생산버전: BOM + Routing)로계산하여사용한다.■Activity TypesActivity Master CSLA, CSLTCost Center MasterCSKSCost Center /Activity TypeCSSLControl Data forActivity TypeCOKLObject Number(OBJNR) : ‘KL’ +Controlling Area(KOKRS) +Cost Center(KOSTL) +Activity Type(LSTAR)Activity Type Totals Line Item for ActivityTypes(by Fiscal Year)Line Item for Activity Types(by Period)COSL Types(by Fiscal Year)COEJL Types(by Period)COEPLFI TablesGeneral Ledger TotalVendorG/L AccountCustomerNew G/LClient Level Vendor General DataG/L Account MasterCustomer General DataGeneral Ledger Total FAGLFLEXT G/L Actual Line ItemFAGLFLEXAClient Level Master Data Vendor General Data LFA1G/L Account Master SKA1Customer General Data KNA1Company Level Master Data Vendor Master (Company Code)LFB1G/L Account (Company Code)SKB1Customer Master (Company Code)KNB1Monthly Summary DataVendorTransaction DataLFC1Customer Transaction DataKNC1Accounting for Vendor General Ledger TotalFAGLFLEXT Accounting for G/L AccountAccounting for CustomerÅOpen ItemÅFI SummaryDocuments for Material Secondary IndexBSIK BSIS BSID Accounting for Vendor BSAKAccounting for G/L AccountBSASAccounting for CustomerBSADÅCleared ItemBSIMAccounting DocumentHeader BKPFAccounting Document Header for ParkingVBKPFParking Documentfor Asset Parking Document for Customer Parking Documentfor Vendor Parking Document for G/L Account Accounting DocumentPosting DocumentParked DocumentClustered by RFBLGfor Asset VBSEGAfor Customer VBSEGDfor Vendor VBSEGKfor G/L AccountVBSEGSSegment BSEGTax Data BSETOne-time Accounting DataBSECBill of ExchangingBSEDControl Data(Obsolete)BSESDictionary TablesTable Description Text DD01L DomainsDD01T DD02LSAP TablesDD02T-TRANSP : Transparent table -INTTAB : Structure -CLUSTER : Cluster table DD03L Table Fields DD03T -POOL: Pooled table-VIEW : General view structure -APPEND: Append structureDD04L Data Elements DD04T DD07L Domain Fixed ValueDD07T DD08L Dictionary Relationship Definition (Check Table, Foreign Key)DD08T Table Secondary Indexes DD12L Table Secondary Indexes DD12TDD17S Secondary Index Fields DD20L Match Code Objects DD20T DD30L Search HelpDD30TDD33S Assigned Fields to Search Help ARCH_OCLAS Assign classes to Archive Object ARCH_CLASS Classes of Integrated Objects ARCH DEF Definition of Archive Object ARCH_DEF Definition of Archive Object TFDIR Function Modules TFTIT FUPARAREF Function Parameters TRMAC ABAP Program Macro TFACSFactory Calendar。