sap各模块表的关系
SAP各模块字段与表地对应关系
SAP各模块字段与表的对应关系Customer MasterKNA1 Customer Basic DataKNB1 Customer Company Level Data客户的公司数据KNVV Customer Sales Level Data 客户的销售数据KNVP Customer Partnering Data客户合作伙伴KNKA Customer Credit Data - CentralizedKNKK Customer Credit Data - Control Area LevelKNBK Customer Bank DetailsKNVH Customer HierarchiesKNVL Customer LicensesKNMT Customer - Material Info Record，客户-物料信息记录数据表KNMTK Customer- Material Info Record - HeaderKNVK 联系人(供应商，客户)Material MasterMARA Material Basic Data(物料类型,,,,,) MARC Material MRP (Plant) Data(工厂的MRP视图)MARD Material Storage Data (查看总库存)（物料的仓储位置数据）MARDH Material Storege Data His.查看库存的历史库存（月度的库存）MARM 物料计量单位MBEW Material ValuationData(查看财务视图-)成本价格) 没有工厂字段，但有评估范围字段；MKAL Material Production VersionData(生产版本)MAKT Material Descriptions/ShortTexts(物料描述)MARM Material Units of Measure(物料主单位的转换数量)MVKE Material Sales Level Data （销售视图）MSKU Special Stocks with Customer ( ? ) MLGN Material Warehouse DataMVKE Material Sales DataMTXH Material Long TextMCHA Batch management table（批次管理）MCHB 批次库存MSKA SalesOrder Stock（销售库存）MAPL 分配任务清单到物料，物料所建的工艺路线（Q类型为检验计划）MAST 分配BOM到物料MVKE 物料销售数据(查找销售单位) MLAN 物料的税分类MDLV 定制 MRP 运行区域(与MDLG是明细) MRP范围MDLGMDMA 物料与MRP AREA的关联关系；T023 物料组T023TVendor Master 供应商LFA1 Vendor Master -- General Data LFB1 Vendor Master -- Company Code Data（公司，财务视图）LFM1 Vendor Master -- Purchasing Org. Data(采购组织)LFB5 Vendor Master -- Dunning Data LFBK Vendor Master -- Bank Details((银行信息)-àBNKA银行表LFBW Vendor Master -- Withholding Tax TypesLBC1 Vendor Master -- Transaction FiguresLFM2 Vendor Master -- Purchasing Data LFMC Vendor Master -- Condition Type Short TextLFMH Vendor HierarchyKNVK 联系人(供应商，客户)WYT3 合伙人信息；PP MASTER DATA (cont.)Factory CalendarTFACD Factory Calendar DefinitionTFACS Factory Calendar Display(days/month)TFACT Factory Calendar TextsTFAIN Factory Calendar -- Special Rules TFAIT Text for Factory Calendar IntervalsTHOC Public Holiday Calendar ID's THOCD Public Holiday Link to Holiday Calendar THOL Public Holiday Definition THOLT Public Holiday TextsLine DesignLDLH Line Hierarchy HeaderLDLP Line Hierarchy ItemsLDLT Line Hierarchy Takt Times LDLBC Takts/No. Individual Capacities per LineLDLBH Line Balance HeaderLDLBP Line Balance ItemsLDLBT Line Hierarchy Entry and Exit TaktsPRT'sCRFH PRT Master DataCRVD_A Link of PRT to DocumentCRVD_B Link of Document to PRTCRVE_A Assignment of PRT data to Equipment CRVE_B Assignment of equipment to PRT data CRVM_A Link of PRT data to MaterialCRVM_B Link of Material to PRT dataCRVS_A Link of PRT Internal number to PRT External numberCRVS_B Link of PRT External number to PRT Internal numberClass & CharacteristicCABN, "Characteristic RMCLM. "Classification(PP) PRODUCTION PLANNINGWork CenterCRHD Work Center Header DataCRCA Work Center Capacity AllocationCRCO Work Center Cost Center Assignment(通过对象号与CRHD关联)包含了作业类型CRHH Hierarchy HeaderCRHS Hierarchy StructureCRTX Work Center Text(工作中心描述) KAKO Capacity HeaderKAZY Intervals of CapacityCRC 逻辑数据库ROUTINGMAPL Routing Link to Material(查到工艺路线的产品描述，物料、组号、组计数器之间的关系)PLPO Routing OperationDetails（通过PLPO的ARBID和CRHD的OBJECTID关联获得具体使用哪个工作中心，标准值也在这个表格里保存）PLKO Routing Header Details（需要与MAPL关联，PLNTY，PLNNR）PLAB Relationships - Standard NetworkPLAS Task List - Selection ofOperations（PLPO,PLAS,PLKO三者互相关联才能获得工作中心描述信息）(plpo~plnnr = plas~plnnr and plpo~zaehl = plas~zaehl andplpo~plnkn = plas~plnkn) PLMZ Component Allocation（组件分配）（是记录分配BOM到ROUTING）PLPH CAPP Sub-operationsPLFH PRT AllocationPLWP Maintenance Package Allocation PLMK Inspection CharacteristicsT435T 工艺路线标准文本PNM 逻辑数据库BOM (物料清单)STPO BOM Item Details(明细项) STKO BOM HeaderDetails(抬头项) （找STAS->再找STOP，这是由于STOP中无可选项字段）MAST BOM Group to Material（通过【物料单】字段与STPO、STKO关联）STZU BOM History RecordsSTAS BOM Item Selection（有可选项字段）STPF BOM Explosion Structure MAST 分配BOM到物料BOM 使用逻辑数据库的是CMCProductionVersion(生产版本)MKAL Material Production Version Data (生产版本)Demand ManagementPBED Independent Requirements Data PBIM Independent Requirements by Material（与PBED通过BDZEI关联）PBHI Independent Requirements History（与PBIM，通过BDZEI关联）PBID Plannedindependent requirements index: MRP areaRepetitive ManufacturingSAFK RS Header Master DataS025 LIS -- Run Schedule QuantitiesS026 LIS -- Material UsageS028 LIS -- Reporting Point StatisticsBLPK 凭证日志标题（保存了【参考数量】）冲销类型----P，在这里通过【处理类型】来查询相关的报告点的操作，报告点的处理类型为Z。
SAP模块介绍及功能模块关联图
采购委托
采购订单
入出库登记
发票校验
仓库管理
库存评价
计划成本核算
实绩成本核算
差异分析
CO-PCA 利润中心会计
CO-CCA成本中心会计
利润中心别预算
实绩
分配
成本中心别预算
成本中心移动 类型别比率计 算
实绩
分配
分配
差异分析 （比率分析異）
ＦＩ财务会计
FI-GL一般会计
总帐
凭证输入
月度结帐处理
年度结帐处理
手工
录入 记帐凭证
损 法定 报表 事业部报表
Plant报表
内部管理报表
14
总帐管理应用－严密的权限管理
15
总帐管理应用－灵活的会计数据查询
报表
余额
113100 银行存款
一月 二月 三月 四月l
45,000,000 670,000,000 45,560,000 784,000
记帐凭证/交易凭证
行项目
113100 银行存款
13,000,000
70,197,000 7,000
347,000
15,230,000 23,000
原始文档
16
总帐管理应用－日常能自动产生的帐目报表
总帐科目余额
S_ALR_87012277
收货
在库部件
采购
（输入发票）
生产管理系统 在库零部件 在库半成品 在库产成品
（生产）
标准会计系统
接口程序
手动凭证 债权管理
★
债务管理 资产管理
人事管理
EXECL成本计算
一般会計
账本凭证以及
数据合作 ★
管理会計
SAP模块及功能模块关联图
1
会议大纲
１．SAP简介 ２．标准会计系统的对应范围与周边系统接口处理 ３．标准会计对应范围标准应用方案 4、 SAP系统的数据安全 5、项目推动方法与预定成果物
22
SAP R/3 业务模块组成图
综合解决方案 开放式系统
CLIENT/SERVER结构
SD 销售管理
MM 在库/ 采购管理 PP 生产管理/ 计划管理
・数据中心有关的系统统一管理以及运用管理 ・提供SAP形态的安全、 规章性的的高级的处理服务。
10
会议大纲
１．SAP简介 ２．标准会计系统的对应范围与周边系统接口处理 ３．标准会计对应范围标准应用方案 4、 SAP系统的数据安全 5、项目推动方法与预定成果物
1111
标准会计对应方案的内容
• 总帐管理应用 • 应付管理应用 • 应收管理应用 • 固定资产管理 • 管理会计的应用 • 统括管理信息的对应
销售（采购） 系统
接口程序
SAP系统
数 据 库
调用
SAP
RFC
应
接口
用
程序
层
SAP 数 据 库
返回
(BAPI)
结果
说明：
1.接口程序只从销售（采购）系统数据库中获取会计已确认的采购入库和销售出库的数据，并调用SAP RFC在 SAP中创建对应的应付和应收发票凭证
2.接口程序将安装在本地，按设定时间间隔执行，同时把每次执行的结果日志保存在本地供查询
准备
CO
费用控制 基于活动的成本 产品成本 盈利分析
预算释放 执行
6
会议大纲
１．SAP简介 ２．标准会计系统的对应范围与周边系统接口处理 ３．标准会计对应范围标准应用方案 4、 SAP系统的数据安全 5、项目推动方法与预定成果物
SAP FICO表关系图解 BSEG与BSIS+BSAS+BSID+BSAD+BSIK+BSAK之间的关系
SAP FICO表关系图解 BSEG与BSIS、BSAS、BSID、BSAD、BSIK、BSAK
之间的关系
BSEG和BSIS、BSAS、BSID、BSAD、BSIK、BSAK六个表的关系
BSAS+BSIS+BSAK+BSIK+BSAD+BSID = BSEG
cleared │ opened
——————————–
BSAS │ BSIS ==>all GL documents
BSAK │ BSIK ==>all AP documents
BSAD │ BSID ==>all AR documents
BKPF 是财务凭证抬头，BSEG 是财务凭证行项目。
在财务凭证记账的时候，数据被插入 BKPF 和 BSEG，如果有必要，数据同时插入以上六张表中的一个未清表。
做清帐的时候，数据从六张表中的一个未清表删除，同时插入对应的已清表。
BSAD：应收明细（已清帐）客户
BSID：应收明细（未清帐）客户
BSAS：总帐明细（已清帐）总账
BSIS：总帐明细（未清帐）总账
BSAK：应付明细（已清帐）供应商
BSIK：应付明细（未清帐）供应商
BSEG主要通过“凭证号”“会计年度”“行号”和这六张表关联。
SAP所有表及关系
表名英文短文本中文短文本A000Condition Table for Pricing $定价$的销售条件A002Domestic Taxes国内税A003Tax Indicator税标识A008Plant/Additional selling plant地点/附加销售地点A011Export Taxes出口税A013Overhead Type管理费用类型A014Overhead Type/Overhead Key间接费用类型/间接费用键A020Division/Price Group产品组/价格组A027Controlling Area控制范围A029Material Pricing Group商品定价组A031Price Group/Material Pricing Group价格组/商品定价组A033Incoterms国际贸易条件A034Incoterms Part 1 + 2国际贸易条件部分1 + 2A035Overhead Type/Plant间接费用类型/地点A036Overhead Type/Order Type间接费用类型/订单类型A037Overhead Type/Order Catg.间接费用类型/订单类别A038Overhead Type/Company Code间接费用类型/公司代码A039Overhead Type/Business Area间接费用类型/业务范围A040Country/State/Customer Classif.1/Material C国家/州/客户分类1/物料分类1A041Country/State/County/Customer Classif.2/Mat国家/州/县/客户分类2/物料分类A042Country/State/City/Customer Classif.3/Mater国家/州/城市/客户分类3/物料分A043Purchasing Organization/Material Type采购组织/商品类型A048Sales conditions sample structure for prici为定价的销售条件样本结构A050Sales conditions sample structure for prici为定价的销售条件样本结构A055Sales conditions sample structure for prici为定价的销售条件样本结构A056Sales conditions sample structure for prici为定价的销售条件样本结构A057Variants变式A064Customer Hierarchy客户层次A065Customer Hierarchy/Material客户层次/商品A066Info record per order unit按订单单位的信息记录A067Plant Info Record per Order Unit每一订单单位的工厂信息记录A068Outline Agreement Item: Plant-Dependent框架协议项目:与工厂相关的A069Vendor Sub-Range供应商子区域A070EAN per Plant每一工厂的 EANA071Material per Plant每一地点的商品A072EAN per SOrg/DstCh每个销售机构/分销渠道的 EANA073Material per SOrg/DstCh每一销售机构/分销渠道的商品A074Plant/Preference Zone/Material地点/优惠区/商品A075Master Conditions for SRV with Material Gro带商品组的SRV的主记录条件A076Master Conditions for Activities in Contrac合同中活动的主记录条件A077Cost Split for Activities in Contract合同活动的成本拆分A078Departure Country / Destination Country启程国家/目的地国A079Sales Organization/Distribution Channel/Mat销售机构/分销渠道/商品类目A080Taxes: Material税款:商品A081Contract Conditions at Plant Level工厂级的合同条件A082Contract Conditions without Plant不带地点的合同条件A083Vendor Conditions with Plant带地点的供应商条件A084Vendor Conditions without Plant不带地点的供应商条件A085Metal Prices金属价格A086Taxes: Material, Plant and Origin税金：物料，工厂和原产地A087Taxes: Plant, Account Assignment and Origin税金：工厂，帐户分配和原产地A088Taxes: Material, Plant, Account Assignment 税金：物料，工厂，帐户分配和原A089SD Document/Material SD凭证/商品A090SD Document/Item/Material SD凭证/项目/商品A091Wage Type Surcharge at Plant Level工厂级工资类型附加费A092Wage Type Surcharge without Plant无工厂的工资类型附加费A093Wage Type Surcharge - General工资类型附加费 - 一般A094Taxes: Material, Plant, Origin and Region税金：物料、工厂、源和地区A095Activities + Purchasing Organization活动＋采购组织A096Activities for Vendor供应商的活动A097Activities for Vendor with Plant有工厂的供应商活动A098SD Document/Item/Material Pricing Group SD凭证/项目/商品定价组A099SD Document/Item SD凭证/项目A100SOrg/DstCh/Material_MainItem/Material销售机构/分销渠道/商品_维护项目/商品A101SOrg/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 Group价格清单/商品类目A107Vendor Hierarchy供应商层次A108Vendor Hierarchy / Material供应商层次/商品A109Vendor hierarchy: vendor sub-range供应商层次：供应商子范围A110Sales Organization/Destination Country销售机构/目的地国家A112Service agent Service agentA113Service agent/try/Dep.post.code/Dest.Service agent/try/Dep.pA114Tax Exemption: Customer免税:客户A115Ser.agnt/Dep.ctry/Dep.PC /Ship-to party Ser.agnt/Dep.ctry/Dep.PC /Ship-to party A116Tax Exemption - Customer/Tax Classification免税－客户/税收分类2－商品A117Tax Exemption - Customer/Material免税－客户/商品A118Empties Prices (Material-Dependent)空价格(商品相关的)A119Service agent/Dep.ctry/Dep.post.code /Dest.Service agent/Dep.ctry/Dep.poA120Overhead Type/Version间接费用类型/版本A121Legal Control: Values for Calculating Forei合法控制:计算国外百分比值A122Surch. type /Profit Center Surch. type /Profit CenterA123Discount Type/Resp. Cost Center Discount Type/Resp. Cost CenterA124Service agent/try/Dep. PostCode/Tarif Service agent/try/Dep.A125Service agent/Tariff zone dep./Tariff zone Service agent/Tariff zone depA126Service Agent/TariffZoneDep/TariffZoneDest/服务代理/出发地的关税区/目的地A127Service Agent/TariffZoneDep/TariffZoneDest/Service Agent/TariffZoneDep/TA128Service Agent/TariffZoneDep/TariffZoneDest/服务代理/出发地的关税区/目的地A129Service Agent/TariffZDep/TariffZDest/ShipMa Service Agent/TariffZDep/TariA130Service agent/tariff zone dep./tariff zone 服务代理/关税区域部门/关税区域A131Service Agent/TariffZnDp/TariffZnDest/Packa服务代理/tariffZnDp/TariffZnDA132Price per Cost Center成本中心的价格A133Mixed Taxes, Domestic混合税, 国内A134Vendor供应商A135Transp. service agent/shipping type/bulk gr运输服务代理/装运类型/散装组A136Price per Controlling Area每个控制范围的价格A137Price per Country/Region每个国家/区域的价格A138Price per Company Code/Business Area每个代码/业务范围的价格A139Price per Profit Center利润中心的价格A140Sales Area / Accounting Indicator销售范围/会计指示符A141Dependent on material and receiver profit c依赖于物料和接收利润中心A142Dependent on material依赖于物料A143Dependent on material group依赖于物料组A144Sales Deal Basic Data销售贸易基本数据A145Sales Deal - Customer/Material销售贸易 - 客户/商品A146Customer Hierarchy客户层次A147Customer Hierarchy (Sales Deal)客户层次（销售贸易）A148Product Hierarchy产品层次A152Sales Org./Dist. Channel/Plant/Material/Sal销售组织/分销渠道/工厂/物料/销A153Sales Org./Distribution Channel/Plant/Sales销售组织/分销渠道/工厂/销售单A154SalesOrg./Dist.Channel/PriceList/Material/S销售组织/分销渠道/价格清单/物A155Sales Org./Dist. Channel/Price List/Materia销售组织/分销渠道/价格清单/物A156Country of Departure/Destination Country/De启运国/目的国/交货国A160Plant Info Record: Variants工厂信息记录: 变体A161Info Record: Variants信息记录: 变体A162Trading Contract: Invoice Recipient贸易合同: 发票接受人A180Country/Preference Zone/Cross-Plant Groupin国家/优惠区/交叉工厂分组A185Order no./Item/Configuration no./Material/P订单编号/项目/配置编号/物料/参A190Condition Table for Pricing A190A191Condition Table for Pricing A191A192Country/Goods Rec./Tax Class - MaterialA193Condition Table for Pricing A193A215Contract header conditions at outline level无工厂的框架级别的合同抬头条件A273Sales 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 Compone转包合同组件的统计值A301Info Record Type and Incoterms信息记录类型和国际贸易术语A302SD doc./Item/CustomerA303SD doc./Item/Material/CompMat/CompSup/CompTypeA304Material with release status具有审批状态的商品A305Customer/material with release status具有审批状态的客户/商品A306Price list category/currency/material with 具有审批状态的价格清单类别/货A307Customer with Release Status具有审批状态的客户A310Duty Rate Customs Exemption: Importing Ctry关税免除: 进口国家/代码/物料A315Cust.Duty Anti-dumping: Import/Code/Orig.ct关税反倾销: 进口/代码/源产国/ A316Anti-dumping Duty Rate: Imp.Ctry/Code/Orig.反倾销关税: 进口国家/代码/源国A317Anti-dumping Duty Rate: try/Code Numb反倾销关税: 进口国/代码编号/原A320Third country Duties: Import ctry/Code/Orig第三国海关税: 进口国/代码/原产A321Third Country Duty Rate: Import Country/Cod第三国关税: 进口国/代码A325Duties Pharma. Products: Import country/Cod药品税: 进口国/代码/CAS/物料A326Pharm. Products Duty Rate: Import Country/C药品税: 进口国/代码/药品A330Preferential Cust.Duties: Imp.ctry/Orig.ctr优惠关税: 进口国/原产国/装运国A331Preference Duty Rate: Import Ctry/Code/Orig优惠关税: 进口国家/代码/源产国A335Quota Duty Rate: Imp.ctry/Code/Orig.ctry/Pr关税配额: 进口国/代码/原产国/ A336Quota Duty Rate: Import Country/Code/Orig.C关税限额: 进口国/代码/原产国/ A340Foreign Trade: CAP: Restitution rates外贸：CAP：返还率A345Ceiling Duty Rate: Import Country/Orig.Coun关税最高限额: 进口国/原产国/最A364Trading Contract/Vendor/Material贸易合同/供应商/商品A365Trading Contract/Vendor/Material贸易合同/供应商/商品A366Trading Contract Number贸易合同编号A370Customer/ServiceA390Brazil: 100% reversals巴西：100% 回转A395Arg.: Country/Fisc.Type Arg.: 国家/财政类型A396Arg.: Country/Fisc.Type/Material Arg.: 国家/财政类型/商品A397Arg.: Tax relevant classification Arg.: 税相关分类A399Withholding tax code - country-specific预提税代码-指定国家A435Sales org./Distr. chl/Customer/Material/DRM Agr No/DRM ItmA436Agreement 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. CodesA479Customer 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 Do System Table ABAPHTML for Buf ABAPTREE ABAP Demonstration Hierarchy ABAP 验证层次ABAPTREET Demonstration Hierarchy: Texts验证层次: 文本ABC_F4TAB CO-ABC: Table for Subdividing F4 Data Eleme CO-ABC：F4 数据元素分类表ABC_FTREE CO-OM-ABC: Function Tree CO-OM-ABC: 功能树ABC_FTREET CO-ABC: Text Tree Structure CO-ABC: 文本树结构ABDOCMODE Window Setting for ABAP Keyword Documentati Window Setting for ABAP Keywo ABTREE ABAP Workbench Tree Objects ABAP 工作台树结构对象ACCTCR Compressed Data from FI/CO Document - Curre FI/CO 凭证的压缩数据 - 货币ACCTHD Compressed Data from FI/CO Document - Heade FI/CO 凭证的压缩数据 - 标题ACCTIT Compressed Data from FI/CO Document FI/CO 凭证的压缩数据ACDIAGSHOW AC Diagnosis Tool: Displayed Fields in AC D AC诊断工具: 在AC文本中显示的字ACLPERMIS Access Control List for Package Use Access Access Control List for Packa ACRELATION Relationships in Accounting会计中的关系ACT_ASPECT AC Diagnosis Tool: Definition of Views for AC诊断工具: AC界面的视图定义ACTFLI ABAP/4 book: Flights ABAP/4 预定： 航班AD00PMCL Class TableAD00PMCLT Text Table for ClassAD00PMEV Class event tableAD00PMEVT Text Table for EventsAD01C_ATTR DIP profile: Characteristics DIP 参数文件：特性AD01C_CHK DIP profile: Check function DIP 参数文件：检查功能AD01C_CHKT DIP profile: Check function texts DIP 参数文件：检查功能文本AD01C_CT Apportionment reason分摊原因AD01C_CTT Apportionment reason text分摊原因文本AD01C_MAT DIP profile: Material determination DIP 参数文件：商品确认AD01C_MATA DIP profile: Material determination criteri DIP 参数文件：商品确认准则AD01C_PROF DIP profile: Usage DIP 参数文件：用法AD01C_PRTX DIP profile: Texts DIP 参数文件：文本AD01C_SEL DIP profile: Sources DIP 参数文件：资源AD01C_SELA DIP profile: Selection criteria DIP 参数文件：选择准则AD01DLI Dynamic items (DI)动态项目（DI）AD01DLIEF DI flow: Individual flow动态项目流：单独流AD01DLISF DI Flow: Totals Flow动态项目流：总计流AD01DLISFR Resource-related billing: DLI flow totals revenue by rev elAD01SETTCH DIP: Saved settings for user 1DIP：用户 1 的保存设置AD01SETTMO DIP: Saved settings for user 2DIP：用户 2 的保存设置AD01SRC DIP: Sources DIP：源AD01SRCTAB DIP: Source <-> Table DIP：源 <-> 表格AD01SRCTXT DIP: Source Texts DIP: 源文本AD01T000Settings 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 StKeyFiguresAD04NMC Number CategoryAD04NMCT Text element for number categoryAD04RELCON Relation between conditionsADAA SAP DB: Directory of Valid DBA Actions SAP DB: 有效 DBA 操作的目录ADACACHE Information About SAP DB Cache Access Information About SAP DB Cache Access ADCNTRYQU Countries with active quarterly adjustment有活动季度调整的国家ADCOMP PM/PS Reference ElementADCOMPT PM/PS Text Table for ADCOMPADCP Person/Address assignment (central address 个人/地址分配（中心地址管理）ADCPS Shadow table: Assignment person/address (CA阴影表:分配 人员/地址 (CAM) ADIRACCESS Table to store keys for TADIR objects要存储 TADIR 对象关键字的表ADLZSN Leading Zeroes in Serial NumbersADMI_APPLI Application archive file information table应用程序存档文件信息表ADMI_BUFFC Buffer table缓冲表格ADMI_BUFFI Buffer table缓冲表格ADMI_CRIT Manage critical archiving objects (database管理严格存档的对象（数据库转换ADMI_EXAMP Archiving object EXAMPLE archive file info 存档对象 EXAMPLE 存档文件信息ADMI_FIDOC Archive Management for FI_DOCUMNT Object FI_DOCUMNT对象归档管理ADMI_FIDOQ Enhancement to Archive Mgt. for FI_DOCUMNT FI_DOCUMNT 对象归档管理的增强ADMI_FILES Archive Files of Archive Sessions归档进程的归档文件ADMI_JOBS Archive Jobs档案工作ADMI_RJOBS Read program jobs读程序作业ADMI_RUN Archive Runs Header Data档案运行标题数据ADMI_SBOOK Archive file - info table for archiving obj存档文件－用于存档对象 BC_SBOADMI_SKIP Address of data objects to be skipped忽略数据对象的地址ADMI_VARIA Contents of Variant of Archive Program档案程序变体的目录ADOWNERREF Temporary reference address storage - Maste临时参考地址存储 - 主对象 (AL ADQUINDX INDX-type table for quarterly adjustment ad季度调整地址的 INDX-类型表ADR10Printer (central address management)打印机（中心地址管理）ADR10S Shadow table: Printer (central address mana影像表：打印机（中心地址管理）ADR10S2Shadow Table 2: Printer (Central Address Ma阴影表 2：打印机（中心地址管理ADR11SSF (Central address management)SSF （中心地址管理）ADR11S Shadow table: SSF (central address manageme影像表： SSF （中心地址管理）ADR11S2Shadow Table 2: SSF (Central Address Manage阴影表 2：SSF（中心地址管理）ADR12FTP and URL (central address management)FTP 和 URL （中心地址管理）ADR12S Shadow table: FTP and URL (central address 影像表：FTP 和 URL （中心地址ADR12S2Shadow Table 2: FTP and URL (Central Addres阴影表 2：FTP 和 URL（中心地址ADR13Pager (central address management)寻呼机（中心地址管理）ADR13S Shadow table: Pager (central address manage影像表：寻呼机（中心地址管理）ADR13S2Shadow Table 2: Pager (Central Address Mana阴影表 2：呼机（中心地址管理）ADR14Reserve communication type (central address预留的通讯类型（中心地址管理）ADR15Reserve communication type (central address预留的通讯类型（中心地址管理）ADR16Reserve communication type (central address预留的通讯类型（中心地址管理）ADR2Telephone numbers (central address admin.)电话号码（中央地址管理）ADR2S Shadow table: Telephone numbers (CAM)阴影标题:电话号码 (CAM)ADR2S2Shadow Table 2: Telephone Nos (Central Addr阴影表 2：电话号码 (中心地址管ADR3Fax numbers (central address admin.)传真号（中央地址管理）ADR3S Shadow table: Fax numbers (CAM)阴影标题:传真号码 (CAM)ADR3S2Shadow Table 2: Fax Numbers (Central Addres阴影表 2：传真号码 (中心地址管ADR4Teletex numbers (central address admin.)电话号码（中央地址管理）ADR4S Shadow table: Teletex numbers (CAM)阴影标题:电传号码 (CAM)ADR4S2Shadow Table 2: Teletex Numbers (Central Ad阴影表 2: 电传号码 (中心地址管ADR5Telex numbers (central address administrati电话号码（中央地址管理）ADR5S Shadow table: Fax numbers (CAM)阴影标题:传真号码 (CAM)ADR5S2Shadow Table 2: Telex Numbers (Central Addr阴影表 2: 电传号码 (中心地址管ADR6SMTP numbers (central address admin.)SMTP 数值(集中地址管理)ADR6S Shadow table: SMTP numbers (CAM)阴影标题: SMTP 号码 (CAM)ADR6S2Shadow Table 2: SMTP Numbers (Central Addre阴影表 2: SMTP 号码 (中心地址ADR7Remote Mail Addresses (R/3 - R/3; Central a远程邮件地址 (R/3 - R/3; 中心ADR7S Shadow table: RML addresses (Central Addres阴影表: RML 地址 (中心地址管理ADR7S2Shadow Table 2: RML addresses (Central Addr阴影表 2: RML 地址 (中心地址管ADR8X.400 numbers (central address admin.)X.400 数目(中心地址管理)ADR8S Shadow table: X.400 numbers (CAM)阴影标题:X.400 号码 (CAM)ADR8S2Shadow Table 2: X.400 Numbers (Central Addr阴影表 2: X.400 号码 (中心地址TOAFO SAP ArchiveLink form management SAP 归档链接表格管理TOAFV SAP ArchiveLink form management SAP 归档链接表格管理TOAHR Container table for HR administration level HR管理级的容器表TOAID Doc. ID / file name generation Doc. ID / 文件名生成TOAIN SAP ArchiveLink - Interface table SAP 归档链接 - 接口表TOAKT SAP ArchiveLink - Communication types value SAP 归档链接- 通讯类型值表TOAMS SAP ArchiveLink API: Length definition of p SAP 归档链接 API: 参数的长度定TOAO2SAP ArchiveLink extended meta table SAP 归档链接扩展的元表TOAOM SAP ArchiveLink: Meta table for links SAP 归档链接：链接的元表TOAOS Logical mapping to implementation method逻辑映射到执行方法TOAP2SAP ArchiveLink: Presettings SAP 归档链接：预置TOAPA Table for parameter maintenance for storing用于存储早期条目的参数维护表TOAPI SAP ArchiveLink interface SAP 归档连接界面TOAPR SAP ArchiveLink: Presettings for storage sc SAP 归档链接：存储方案的预置TOAPRE SAP ArchiveLink: Presettings for storage sc SAP 归档链接：存储方案的预置TOAPRS SAP ArchiveLink: Long text presettings for SAP 归档链接：用于存储方案的长TOAR7SAP ArchiveLink: Request table (asynchronou SAP 存档连接：请求表（异步存档TOAS1Number of stored archive files存储的归档文件数TOASA SAP ArchiveLink: Language table for methods SAP 归档链接： 方式的语言表TOASB Language Table fFor TOABA用于 TOABA 的语言表TOASD Language-Dependent Table For TOADD TOADD 的语言相关表TOASK SAP ArchiveLink: Language table communicati SAP 归档链接： 语言表通讯类型TOASM Language-Dependent Table For TOACM用于 TOACM 的语言相关表TOASO Language-Dependent Table For TOACO用于 TOACO 的语言相关表TOASP SAP ArchiveLink: Language table for archive SAP 归档链接：用于归档对象的语TOASR Language-Dependent Table For TOAAR用于 TOAAR 的语言相关表TOASV SAP ArchiveLink: Language table for form ma SAP 归档链接：表单管理的语言表TOAV1VIEW basis table structure analogous to TOA视图基本表结构模拟TOAV2VIEW table 2 structure for link table视图表 2 链表结构TOAVK Definition of function calls for object lin对象链接功能调用的定义TOAVK_S Language table for TOAVK TOAVK 的语言表TOBAE Transfer Times: Control Station Communicati传送次数: 控制站通讯TOBJ Objects对象TOBJ_CD Objects that were disabled禁用对象TOBJ_CONTROL Objects that were disabledTOBJ_OFF Objects that were disabled禁用对象TOBJ_SAV Objects that were disabled禁用对象TOBJ_TPL Authorization objects for a global template用于全局模板的授权对象TOBJ_TPO Definition table for global templates用于全局模板的定义表TOBJ_TPT Text table for global templates用于全局模板的文本表TOBJECTP Objects assigned to a project Objects assigned to a project TOBJECTT Objects assigned to a template Objects assigned to a template TOBJT Texts for Objects in Table TOBJ在表 TOBJ 中的对象的文本TOBJVOR SAP_NEW Release-Dependent Data for Authoriz SAP_NEW Release-Dependent Dat TOBJVORDAT Field Values for SAP_NEW Authorization Obje Field Values for SAP_NEW Auth TOBJVORFLG Flags for Authorization Objects Flags for Authorization Objects TODIR Object List for Switch切换的对象列表TODOS TODO: Exclude programs from individual SLIN TODO: 单个 SLIN 检查的包含程序TOGCF GG: Configuration ViewsTOGM1Software Maintenance Process: Collective ProcessingTOGM2Maintenance sets for profilesTOGM3PLM definition of 'push' materialTOGM4Maintenance ProfileTOGM5Software Maintenance Process: Rejection CodesTOGMT PLM profile descriptionTOJMB Objects in the SAP System: methods在SAP系统对象中:方法TOJMT Objects in the SAP System: method descripti在SAP系统中的对象:方法描述TOJRB SAP objects: return values for methods SAP目标:为方法返回值TOJRT Objects in the SAP System: return value tex在SAP系统中对象:返回值文本TOJTB Business object repository: Basic data事务对象储存处: 基础数据TOJTD Customizing Object Types自定义 对象类型TOJTL Objects in the SAP System: object types wit在SAP系统中的对象:具有定义的对TOJTT Texts Basic Data基础文本数据TOKOM Technical Parameters for Communications Mod用于通讯模式的技术参数TOLE OLE Applications OLE 应用程序TOLET Workflow Object Types: Texts OLE Applicatio工作流对象类型: 文本 OLE 应用TONR Number status: general object number编号状态：一般对象号TOOL_COST Costs for Prod.Resource/Tool生产资源/工具的成本TOPDEVV Process Order - Selection Variants流程订单 - 选择变式TOPRK Log Messages日志信息TORB1Incoming Orders: Cost Element Assignment收入订单：成本要素分配TORB2Incoming Orders: Settings for Key收入订单：关键字设置TORS0Customizing Time-Dependent Status: Activate定制时间相关状态：有效功能TORS1Statuses Relevant for Key-Date Based Manage基于关键日期管理的相关状态TP01Business Partner: Form of Address业务伙伴：地址表格TP01T Business Partner: Form of Address Text业务伙伴：地址文本表格TP02Business Partner: Salutation业务伙伴人：问候TP02T Business Partner: Salutation Text业务伙伴：问候文本TP03Business Partner: Marital Status业务伙伴：婚姻状况TP03T Business Partner: Description of Marital St业务伙伴：婚姻状况描述TP04Business Partner: Marital Property Regime业务伙伴：婚姻财产权TP04T Business Partner: Description of Marital Pr业务伙伴：婚姻财产权描述TP05Business Partner: Employee Group业务伙伴：雇员组TP05T Business Partner: Name of Employee Group业务伙伴：雇员组名称TP06Business Partner: Rating业务伙伴：评估TP06T Business Partner: Rating Description业务伙伴：评估描述TP07Business Partner: Credit Rating Institute业务伙伴：信用评估机构TP07T Business Partner: Name of Credit Rating Ins业务伙伴：信用评估机构名称TP08Business Partner: Legal Form业务伙伴：法律表格TP08T Business Partner: Description of Legal Form业务伙伴：法律表格描述TP09Business Partner: Legal Entity业务伙伴：法律实体TP09T Business Partner: Name of Legal Entity业务伙伴：法律实体名称TP10Business partner: Loan to Manager Indicator业务伙伴：经理贷款标识符TP103BP: Field Modification via BP Role Category BP：通过BP 职责类别修改字段TP105BP: Field Modification via Activity Categor BP：通过活动类别修改字段TP10T Business Partner: Name of Loan to Manager业务伙伴：经理贷款名称TP11Business Partner: Employment Status业务伙伴：雇佣状况TP11T 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 ID业务伙伴：地址标识TP14T Business Partner: Name of Address ID业务伙伴：地址标识名称TP15Business Partner: Function业务伙伴人：功能TP15T Business partner: Name of Function业务伙伴人：功能名称TP16Business Partner: Department业务伙伴人：部门TP16T Business Partner: Name of Department业务伙伴人：部门名称TP17U Business Partner: Convert Industries业务合伙人: 转换工业TPACHECK Checking Table Directory for Check Modules 检查表格目录用于 SD 合伙人的检TPACHECKASSIGN Checking Module Assignments in SD Partner P在 SD 合伙人处理中检查模块分配TPACHECKRELATION Dependency Graph for Check Modules in SD Pa SD 合伙人处理中检查模块的相关TPAER_PM Partner Functions in Partner Schema (PM) wi在有复制标志的合伙人概要(PM)中TPAFILTER Filter Table for Displaying Partner Subscri显示合伙人订阅 1000 的过滤器表TPAKL Assignment of Partner Function to Account G把业务往来功能分配给供应商帐户TPALOG DB Buffer for ALOG File DB Buffer for ALOG File TPALOGHDR Header Table for TPALOG Header Table for TPALOG TPAMA Search Strings for Pattern Matching模式匹配的搜索字符串TPAMAT Text Table for Search String TPAMA搜索字符串 TPAMA 的文本表格TPAR Business Partner: Functions业务合作伙伴: 功能TPARA Directory of Memory IDs IDS内存表TPARAAPPL Application Table for TPARA Application Table for TPARA TPARAT Memory ID Short Texts内存ID短文本TPART Business Partner Functions: Texts业务合作伙伴功能: 文本TPARU Control parallelized confirmation processes控制并行的确认处理TPATT Pattern type in VarChart VarChart图形类型TPCA_ALE Company Code/Field Transfer PCA (ALE)公司代码/字段传输 PCA (ALE) TPCRTYPE Document Types for Posting Correction Reque记帐修正请求的凭证类型TPDB2DB2/390: Pagesize <-> table storage paramet DB2/390: 页面大小 <-> 表存储参TPEXT Profile for external procurement外协采购的概况TPEXT_T Text tables for profiles (external procurem(外部采购) 参数文件文本表TPF02Profile Table Parameter Names from sapparam描述文件表格参数名称从TPFBA SAP System operation mode SAP 系统操作模式TPFES Prototype: Table for profile parameters范例:表格为描述文件参数TPFET Table of profile parameters描述参数的表TPFHS Prototype: Profile header, administration d范例:描述文件标题:管理数据描述TPFHT Profile header, administration data for pro描述文件标题,管理数据DBTPFID Description of SAP instance SAP 距离描述TPFK Contact Persons: Functions联系人: 功能TPFKT Contact Partner Functions: Texts与合伙人联系功能: 文本TPFST Startup: List of programs to be started启动:程序列表被开始TPFVA Profiles: Parameter valid flags描述文件,参数合法的标志TPFVD Profiles: Parameter values table D (DB, tab描述文件:参数值表格DIDB,表格缓TPFVE Profile Parameters for Environment / Vali描述文件参数环境/合法标志TPFVI Profiles: Parameter values, table I (IPC...描述文件:参数值,表格I(IPC...)TPFVP Profile Parameters for Processes (Disp, App描述文件参数处理TPFVQ Profiles Parameters for Processes (Disp,...描述文件参数处理(显示)TPFVR Profile Parameter Roll, Paging, Statistics 描述文件参数卷轴,版,统计资料/TPFVX Profile Parameter Values Table X (other...)描述文件参数值表格X(other...)TPFWE Profile Parameters for Environment描述文件参数环境TPFYDOC Parameter documentation参数文档TPFYPROPTY Parameter attributes参数属性TPGAC GG enhancement: Material types representing Product GroupsTPGPRF Profile for static pegging and data distrib静态限制和数据分配的参数文件TPGPRFT Text table for pegging profile限制参数文件的文本表格TPHASEP Project phases Project phasesTPHASETP Project phases text table Project phases text tableTPHCNV Data for Product Hierarchy Conversion用于产品层次转换的数据TPHVP Header: Planning Profile标题：计划参数文件TPI01Interest Calculation Profile利息计算参数TPI01T Interest Calculation Profile利息计算参数TPI02Interest Calculation Profile and Interest I利息计算概况和利息标记TPI03CO Objects: Date of Last Interest Run CO 对象: 上一次计息日TPI04Interest Relevance of Cost Element/Commitme成本要素/承诺项目组的利息相关TPICK Analysis of Function Code PICK功能编码 PICK 的分析TPIF2Commitment items: value category承诺项目: 数值类型TPIF3Assignments: Commitment Item -> Value Categ分配：委托项目 -> 价值类别TPIK2Cost elements: value categories成本要素: 数值类型TPIK3Assignment Table: Cost Elements -> Value Ca分配表格：成本要素 -> 价值类别TPIR1Value Categories价值种类TPIR1T Texts for Value Categories值类别文本TPIR2Value Categories价值种类TPIR2T Texts for Value Categories值类别文本TPIRX Control RPSCO update控制 RPSCO 更新TPIS3Assignment Table:Statistical Key Figures ->分配表：统计关键指标 -> 价值类TPK01Key for Controlling the Control Cycle; In-H用来控制控制周期的代码;自制生TPK02Key for Controlling Control Cycle: External用来控制控制周期的代码;外部补TPK03Key for Controlling Control Cycle; Stock Tr用来控制控制周期的代码;库存转TPK1T Control Cycle Profile for In-House Producti控制自制生产控制周期参数文件-TPK2T Control Cycle Profile (External Procurement控制周期参数文件(外部采购)-文TPK3T Control Cycle Profile (Stock Transfer) - Te控制周期参数文件(库存转移)-文TPKAK Actions in KANBAN Processing在看板处理中的活动TPKBP Kanban calculation profile看板计算参数文件TPKBU Adjusting a Control Cycle in Kanban Calcula在看板计算中调整控制周期TPKER Alternative Error Handling in the Kanban Pr看板处理中的可选错误处理TPKLEK Delete Event-Driven KanbansTPKPT Kanban Authorization Text看板权限文本TPKSF Kanban Status Sequences看板状态顺序TPKTX Kanban Container Status Short Text看板容器状态短文本TPLMK GG enhancement: Document types proposed for MLMTPLOG Logging of tp Calls tp 调用的记录TPLOGNAMES tp: Names of Log Files and Times Used tp: Names of Log Files and Times Used TPLVP Planning Profile计划参数文件TPMA_DERIV_ASSGN Assignment of Derivation Categories派生类别的分配TPMB_DERIV_AMORT Assign Amortization Method to Derivation Ca将分摊方法分配到派生类型TPMB_DERIV_CAT Define Derivation Methods定义派生方法TPMCKF PMIS: customer-specific value and quantity PMIS：客户特定值和数量关键指标TPMCKFT PMIS: texts for cust.-specific value and qu PMIS：客户特定值和数量关键指标TPMIM IM allocation key IM 分配码TPMK Cost key figures of the maintenance order维护订单的成本关键数TPMKT Texts for cost key figures of the maintenan维护订单的成本关键数的文本TPMP Maintenance profile维护概况TPMPO Maintenance order processing profile维护订单处理概况TPMT_DEDOC_HDR Derivatives Document: Document Header派生凭证：凭证标题TPMT_DEDOC_LOTPO Derivatives Document: Document Item Per Lot派生凭证：每批量的凭证项目TPMT_DEDOC_POS Derivatives Document: Document Item派生凭证：凭证项目TPMT_DEPAL_FLOWS Listed Futures: Price Gain Records列出的期货：价格收益记录TPMT_LOT_HEADER Single Position Master Data for TR Position TR 位置管理的单个位置主数据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 values PM/SM - 用户缺省值TPNNR Customizing prima nota定制第一通知TPNNT Prima nota customizing texts第一通知定制文本TPOOL Master Record, LIFO Pools主记录,先进先出池TPR_INDEX List of nodes sorted by project List of nodes sorted by projectTPR_PREF User's settings用户设置TPR_VINDX List of IMG Activities in a Project View List of IMG Activities in a Project View TPR_XREF_D Index for Where-Used List Index for Where-Used ListTPR_XREF_P Projects: Constraint on Where-Used List 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带有ALE修改权限的商业对象TPRC Business Process in Expiring Currency以期满货币业务处理TPRCD Date for Subsequent Process for Expiring Cu期满货币的后续处理日期TPRCLASS Project Management Project Classes Project Management Project Classes TPRCLASST Project Class Table Text Table Project Class Table Text TableTPRCT Business Process in Expiring Currency (Text期满货币的业务处理(文本表)TPRF International Article Number (EAN) Prefixes内部商品号(EAN)前缀TPRFL Field Groups per Change Authorization Profi每个权限参数文件的字段组TPRFT EAN Prefix Descriptions EAN前缀描述TPRI_PAR ABAP print parameter storage ABAP 打印参数存储TPRIO Customers: Delivery Priorities客户：交货优先级TPRIOCL Project Class Priority Assignment Project Class Priority Assignment TPRIOEPR Project Management Priorities Project Management PrioritiesTPRIOP Project Priorities Project PrioritiesTPRIOTPR Project Management: Priorities Text Project Management: Priorities Text TPRIT Customers: Delivery Priority: Texts客户: 交货优先: 文本TPRO Profile Names for ALE Change Authorizations ALE修改权限的参数文件名称TPROCESSES Profile Names for ALE Change AuthorizationsTPROF_CEP Profile for CEP Profile for CEPTPROFT_CEP Text table for CEP profile Text table for CEP profileTPROJ_GEN Project Additional Data Table Project Additional Data Table TPROJECT SPROJECT: Project Table SPROJECT: Project TableTPROJECTF Project Management Favorites List Project Management Favorites List TPROJECTT Project Table Text Table Project Table Text Table。
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常用表及表关系
20、MSEG: 物料凭证行项目
21、RBKP: 凭证抬头供应商发票数据
22、RSEG: 凭证项目供应商发票数据
EKKO/EKPO–>MKPF/MSEG–>RBKP/RSEG–>BKPF-BSEG
23、KNA1: 客户主数据（一般数据）
24、B1: 客户主数据（公司代码）
RKPF - Reservation: Header
RESB - Reservation: Item
Invoice Verification
BSIM - Secondary index: documents for material
MYMFT - FIFO results table
MYML - LIFO material layer
RKWA - Consignment withdrawals
RSEG - Document item, incoming invoice
Customising and other master data
MDLV - MRP Areas
MDLG - MRP Areas - Storage Locations
MYMLM - LIFO material layer (monthly)
MYMP - LIFO period stocks, single material
MYMP1 - Receipt data LIFO/FIFO valuation
MYPL - LIFO pool layer
MYPLM - LIFO pool layer (monthly)
MLAN - Material Master: Tax indicator
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 area Repetitive 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模块介绍及功能模块关联图
FI-AR应收款管理
销售客户总帐
付款通知
到帐管理
FI-AP应付款管理
采购客户总帐
付款通知
支付管理
資资資金資金予预金予測测予測測
5
SAP财务系统总览
EC
企业管理
EIS 报表合并
预算
盈利中心
TR
现金管理 金库管理 市场风险管理 基金管理
IM
资本预算
FI
总帐 法人报表合并 应收帐 应付帐 资产管理 预算
R/3 ®
CO 成本控制
AM 资产管理
CLIENT/SERVER结构
QM 质量管理
PM 工厂设备管理
HR 人事管理
PS 项目管理
WF 工作流程 IS 行业解决方案
完备齐全功能
企业模式
跨国企业多国业务对应
3
R/3 CLIENT / SERVER 构造
DATABASE SERVER
APPLICATION LOGIC SERVER
手工
录入 记帐凭证
损 法定 报表 事业部报表
Plant报表
内部管理报表
14
总帐管理应用－严密的权限管理
15
总帐管理应用－灵活的会计数据查询
报表
余额
113100 银行存款
一月 二月 三月 四月l
45,000,000 670,000,000 45,560,000 784,000
记帐凭证/交易凭证
行项目
销售（采购） 系统
接口程序
SAP系统
数 据 库
调用
SAP
RFC
应
接口
用
程序
层
SAP 数 据 库
返回
Sapblessap各模块主表明细及主键关系
Company Code (BUKRS)
Company Code (BUKRS)
G/L Account (HKONT) Clearing Date (AUGDT)
G/L Account (HKONT) Clearing Date (AUGDT)
Clearing Doc (AUGBL) Allocation No (ZUONR) Fiscal Year (GJAHR) Document No (BELNR) Line Items (BUZEI)
Open Items
BSIK (Accounting: Secondary index for vendors)
Company Code (BUKRS) Vendor (LIFNR) Special G/L Trans (UMSKS) Special G/L Ind (UMSKZ) Clearing Date (AUGDT) Clearing Doc (AUGBL) Allocation No (ZUONR) Fiscal Year (GJAHR) Document No (BELNR) Line Items (BUZEI)
Accounts Payable
General Ledger
Accounts Receivable
Tables: BSAD BSAS BSEG BSES BSIK BSIS
SAP - FI/CO
Financial Accounting
Special Purpose Ledger
Controlling
Line Item (BUZEI) Open Items
Open Items
Closed items
Closed items
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各模块表关系
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表对应关系
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 Taxes国内税A003Tax Indicator税标识A008Plant/Additional selling plant地点/附加销售地点A011Export Taxes出口税A013Overhead Type管理费用类型A014Overhead Type/Overhead Key间接费用类型/间接费用键A020Division/Price Group产品组/价格组A027Controlling Area控制范围A029Material Pricing Group商品定价组A031Price Group/Material Pricing Group价格组/商品定价组A033Incoterms国际贸易条件A034Incoterms Part 1 + 2国际贸易条件部分1 + 2A035Overhead Type/Plant间接费用类型/地点A036Overhead Type/Order Type间接费用类型/订单类型A037Overhead Type/Order Catg.间接费用类型/订单类别A038Overhead Type/Company Code间接费用类型/公司代码A039Overhead Type/Business Area间接费用类型/业务范围A040Country/State/Customer Classif.1/Material C国家/州/客户分类1/物料分类1A041Country/State/County/Customer Classif.2/Mat国家/州/县/客户分类2/物料分类A042Country/State/City/Customer Classif.3/Mater国家/州/城市/客户分类3/物料分A043Purchasing Organization/Material Type采购组织/商品类型A048Sales conditions sample structure for prici为定价的销售条件样本结构A050Sales conditions sample structure for prici为定价的销售条件样本结构A055Sales conditions sample structure for prici为定价的销售条件样本结构A056Sales conditions sample structure for prici为定价的销售条件样本结构A057Variants变式A064Customer Hierarchy客户层次A065Customer Hierarchy/Material客户层次/商品A066Info record per order unit按订单单位的信息记录A067Plant Info Record per Order Unit每一订单单位的工厂信息记录A068Outline Agreement Item: Plant-Dependent框架协议项目:与工厂相关的A069Vendor Sub-Range供应商子区域A070EAN per Plant每一工厂的 EANA071Material per Plant每一地点的商品A072EAN per SOrg/DstCh每个销售机构/分销渠道的 EANA073Material per SOrg/DstCh每一销售机构/分销渠道的商品A074Plant/Preference Zone/Material地点/优惠区/商品A075Master Conditions for SRV with Material Gro带商品组的SRV的主记录条件A076Master Conditions for Activities in Contrac合同中活动的主记录条件A077Cost Split for Activities in Contract合同活动的成本拆分A078Departure Country / Destination Country启程国家/目的地国A079Sales Organization/Distribution Channel/Mat销售机构/分销渠道/商品类目A080Taxes: Material税款:商品A081Contract Conditions at Plant Level工厂级的合同条件A082Contract Conditions without Plant不带地点的合同条件A083Vendor Conditions with Plant带地点的供应商条件A084Vendor Conditions without Plant不带地点的供应商条件A085Metal Prices金属价格A086Taxes: Material, Plant and Origin税金：物料，工厂和原产地A087Taxes: Plant, Account Assignment and Origin税金：工厂，帐户分配和原产地A088Taxes: Material, Plant, Account Assignment 税金：物料，工厂，帐户分配和原A089SD Document/Material SD凭证/商品A090SD Document/Item/Material SD凭证/项目/商品A091Wage Type Surcharge at Plant Level工厂级工资类型附加费A092Wage Type Surcharge without Plant无工厂的工资类型附加费A093Wage Type Surcharge - General工资类型附加费 - 一般A094Taxes: Material, Plant, Origin and Region税金：物料、工厂、源和地区A095Activities + Purchasing Organization活动＋采购组织A096Activities for Vendor供应商的活动A097Activities for Vendor with Plant有工厂的供应商活动A098SD Document/Item/Material Pricing Group SD凭证/项目/商品定价组A099SD Document/Item SD凭证/项目A100SOrg/DstCh/Material_MainItem/Material销售机构/分销渠道/商品_维护项目/商品A101SOrg/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 Group价格清单/商品类目A107Vendor Hierarchy供应商层次A108Vendor Hierarchy / Material供应商层次/商品A109Vendor hierarchy: vendor sub-range供应商层次：供应商子范围A110Sales Organization/Destination Country销售机构/目的地国家A112Service agent Service agentA113Service agent/try/Dep.post.code/Dest.Service agent/try/Dep.pA114Tax Exemption: Customer免税:客户A115Ser.agnt/Dep.ctry/Dep.PC /Ship-to party Ser.agnt/Dep.ctry/Dep.PC /Ship-to party A116Tax Exemption - Customer/Tax Classification免税－客户/税收分类2－商品A117Tax Exemption - Customer/Material免税－客户/商品A118Empties Prices (Material-Dependent)空价格(商品相关的)A119Service agent/Dep.ctry/Dep.post.code /Dest.Service agent/Dep.ctry/Dep.poA120Overhead Type/Version间接费用类型/版本A121Legal Control: Values for Calculating Forei合法控制:计算国外百分比值A122Surch. type /Profit Center Surch. type /Profit CenterA123Discount Type/Resp. Cost Center Discount Type/Resp. Cost CenterA124Service agent/try/Dep. PostCode/Tarif Service agent/try/Dep.A125Service agent/Tariff zone dep./Tariff zone Service agent/Tariff zone depA126Service Agent/TariffZoneDep/TariffZoneDest/服务代理/出发地的关税区/目的地A127Service Agent/TariffZoneDep/TariffZoneDest/Service Agent/TariffZoneDep/TA128Service Agent/TariffZoneDep/TariffZoneDest/服务代理/出发地的关税区/目的地A129Service Agent/TariffZDep/TariffZDest/ShipMa Service Agent/TariffZDep/TariA130Service agent/tariff zone dep./tariff zone 服务代理/关税区域部门/关税区域A131Service Agent/TariffZnDp/TariffZnDest/Packa服务代理/tariffZnDp/TariffZnDA132Price per Cost Center成本中心的价格A133Mixed Taxes, Domestic混合税, 国内A134Vendor供应商A135Transp. service agent/shipping type/bulk gr运输服务代理/装运类型/散装组A136Price per Controlling Area每个控制范围的价格A137Price per Country/Region每个国家/区域的价格A138Price per Company Code/Business Area每个代码/业务范围的价格A139Price per Profit Center利润中心的价格A140Sales Area / Accounting Indicator销售范围/会计指示符A141Dependent on material and receiver profit c依赖于物料和接收利润中心A142Dependent on material依赖于物料A143Dependent on material group依赖于物料组A144Sales Deal Basic Data销售贸易基本数据A145Sales Deal - Customer/Material销售贸易 - 客户/商品A146Customer Hierarchy客户层次A147Customer Hierarchy (Sales Deal)客户层次（销售贸易）A148Product Hierarchy产品层次A152Sales Org./Dist. Channel/Plant/Material/Sal销售组织/分销渠道/工厂/物料/销A153Sales Org./Distribution Channel/Plant/Sales销售组织/分销渠道/工厂/销售单A154SalesOrg./Dist.Channel/PriceList/Material/S销售组织/分销渠道/价格清单/物A155Sales Org./Dist. Channel/Price List/Materia销售组织/分销渠道/价格清单/物A156Country of Departure/Destination Country/De启运国/目的国/交货国A160Plant Info Record: Variants工厂信息记录: 变体A161Info Record: Variants信息记录: 变体A162Trading Contract: Invoice Recipient贸易合同: 发票接受人A180Country/Preference Zone/Cross-Plant Groupin国家/优惠区/交叉工厂分组A185Order no./Item/Configuration no./Material/P订单编号/项目/配置编号/物料/参A190Condition Table for Pricing A190A191Condition Table for Pricing A191A192Country/Goods Rec./Tax Class - MaterialA193Condition Table for Pricing A193A215Contract header conditions at outline level无工厂的框架级别的合同抬头条件A273Sales 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 Compone转包合同组件的统计值A301Info Record Type and Incoterms信息记录类型和国际贸易术语A302SD doc./Item/CustomerA303SD doc./Item/Material/CompMat/CompSup/CompTypeA304Material with release status具有审批状态的商品A305Customer/material with release status具有审批状态的客户/商品A306Price list category/currency/material with 具有审批状态的价格清单类别/货A307Customer with Release Status具有审批状态的客户A310Duty Rate Customs Exemption: Importing Ctry关税免除: 进口国家/代码/物料A315Cust.Duty Anti-dumping: Import/Code/Orig.ct关税反倾销: 进口/代码/源产国/ A316Anti-dumping Duty Rate: Imp.Ctry/Code/Orig.反倾销关税: 进口国家/代码/源国A317Anti-dumping Duty Rate: try/Code Numb反倾销关税: 进口国/代码编号/原A320Third country Duties: Import ctry/Code/Orig第三国海关税: 进口国/代码/原产A321Third Country Duty Rate: Import Country/Cod第三国关税: 进口国/代码A325Duties Pharma. Products: Import country/Cod药品税: 进口国/代码/CAS/物料A326Pharm. Products Duty Rate: Import Country/C药品税: 进口国/代码/药品A330Preferential Cust.Duties: Imp.ctry/Orig.ctr优惠关税: 进口国/原产国/装运国A331Preference Duty Rate: Import Ctry/Code/Orig优惠关税: 进口国家/代码/源产国A335Quota Duty Rate: Imp.ctry/Code/Orig.ctry/Pr关税配额: 进口国/代码/原产国/ A336Quota Duty Rate: Import Country/Code/Orig.C关税限额: 进口国/代码/原产国/ A340Foreign Trade: CAP: Restitution rates外贸：CAP：返还率A345Ceiling Duty Rate: Import Country/Orig.Coun关税最高限额: 进口国/原产国/最A364Trading Contract/Vendor/Material贸易合同/供应商/商品A365Trading Contract/Vendor/Material贸易合同/供应商/商品A366Trading Contract Number贸易合同编号A370Customer/ServiceA390Brazil: 100% reversals巴西：100% 回转A395Arg.: Country/Fisc.Type Arg.: 国家/财政类型A396Arg.: Country/Fisc.Type/Material Arg.: 国家/财政类型/商品A397Arg.: Tax relevant classification Arg.: 税相关分类A399Withholding tax code - country-specific预提税代码-指定国家A435Sales org./Distr. chl/Customer/Material/DRM Agr No/DRM ItmA436Agreement 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. CodesA479Customer 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 Do System Table ABAPHTML for Buf ABAPTREE ABAP Demonstration Hierarchy ABAP 验证层次ABAPTREET Demonstration Hierarchy: Texts验证层次: 文本ABC_F4TAB CO-ABC: Table for Subdividing F4 Data Eleme CO-ABC：F4 数据元素分类表ABC_FTREE CO-OM-ABC: Function Tree CO-OM-ABC: 功能树ABC_FTREET CO-ABC: Text Tree Structure CO-ABC: 文本树结构ABDOCMODE Window Setting for ABAP Keyword Documentati Window Setting for ABAP Keywo ABTREE ABAP Workbench Tree Objects ABAP 工作台树结构对象ACCTCR Compressed Data from FI/CO Document - Curre FI/CO 凭证的压缩数据 - 货币ACCTHD Compressed Data from FI/CO Document - Heade FI/CO 凭证的压缩数据 - 标题ACCTIT Compressed Data from FI/CO Document FI/CO 凭证的压缩数据ACDIAGSHOW AC Diagnosis Tool: Displayed Fields in AC D AC诊断工具: 在AC文本中显示的字ACLPERMIS Access Control List for Package Use Access Access Control List for Packa ACRELATION Relationships in Accounting会计中的关系ACT_ASPECT AC Diagnosis Tool: Definition of Views for AC诊断工具: AC界面的视图定义ACTFLI ABAP/4 book: Flights ABAP/4 预定： 航班AD00PMCL Class TableAD00PMCLT Text Table for ClassAD00PMEV Class event tableAD00PMEVT Text Table for EventsAD01C_ATTR DIP profile: Characteristics DIP 参数文件：特性AD01C_CHK DIP profile: Check function DIP 参数文件：检查功能AD01C_CHKT DIP profile: Check function texts DIP 参数文件：检查功能文本AD01C_CT Apportionment reason分摊原因AD01C_CTT Apportionment reason text分摊原因文本AD01C_MAT DIP profile: Material determination DIP 参数文件：商品确认AD01C_MATA DIP profile: Material determination criteri DIP 参数文件：商品确认准则AD01C_PROF DIP profile: Usage DIP 参数文件：用法AD01C_PRTX DIP profile: Texts DIP 参数文件：文本AD01C_SEL DIP profile: Sources DIP 参数文件：资源AD01C_SELA DIP profile: Selection criteria DIP 参数文件：选择准则AD01DLI Dynamic items (DI)动态项目（DI）AD01DLIEF DI flow: Individual flow动态项目流：单独流AD01DLISF DI Flow: Totals Flow动态项目流：总计流AD01DLISFR Resource-related billing: DLI flow totals revenue by rev elAD01SETTCH DIP: Saved settings for user 1DIP：用户 1 的保存设置AD01SETTMO DIP: Saved settings for user 2DIP：用户 2 的保存设置AD01SRC DIP: Sources DIP：源AD01SRCTAB DIP: Source <-> Table DIP：源 <-> 表格AD01SRCTXT DIP: Source Texts DIP: 源文本AD01T000Settings 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 StKeyFiguresAD04NMC Number CategoryAD04NMCT Text element for number categoryAD04RELCON Relation between conditionsADAA SAP DB: Directory of Valid DBA Actions SAP DB: 有效 DBA 操作的目录ADACACHE Information About SAP DB Cache Access Information About SAP DB Cache Access ADCNTRYQU Countries with active quarterly adjustment有活动季度调整的国家ADCOMP PM/PS Reference ElementADCOMPT PM/PS Text Table for ADCOMPADCP Person/Address assignment (central address 个人/地址分配（中心地址管理）ADCPS Shadow table: Assignment person/address (CA阴影表:分配 人员/地址 (CAM) ADIRACCESS Table to store keys for TADIR objects要存储 TADIR 对象关键字的表ADLZSN Leading Zeroes in Serial NumbersADMI_APPLI Application archive file information table应用程序存档文件信息表ADMI_BUFFC Buffer table缓冲表格ADMI_BUFFI Buffer table缓冲表格ADMI_CRIT Manage critical archiving objects (database管理严格存档的对象（数据库转换ADMI_EXAMP Archiving object EXAMPLE archive file info 存档对象 EXAMPLE 存档文件信息ADMI_FIDOC Archive Management for FI_DOCUMNT Object FI_DOCUMNT对象归档管理ADMI_FIDOQ Enhancement to Archive Mgt. for FI_DOCUMNT FI_DOCUMNT 对象归档管理的增强ADMI_FILES Archive Files of Archive Sessions归档进程的归档文件ADMI_JOBS Archive Jobs档案工作ADMI_RJOBS Read program jobs读程序作业ADMI_RUN Archive Runs Header Data档案运行标题数据ADMI_SBOOK Archive file - info table for archiving obj存档文件－用于存档对象 BC_SBOADMI_SKIP Address of data objects to be skipped忽略数据对象的地址ADMI_VARIA Contents of Variant of Archive Program档案程序变体的目录ADOWNERREF Temporary reference address storage - Maste临时参考地址存储 - 主对象 (AL ADQUINDX INDX-type table for quarterly adjustment ad季度调整地址的 INDX-类型表ADR10Printer (central address management)打印机（中心地址管理）ADR10S Shadow table: Printer (central address mana影像表：打印机（中心地址管理）ADR10S2Shadow Table 2: Printer (Central Address Ma阴影表 2：打印机（中心地址管理ADR11SSF (Central address management)SSF （中心地址管理）ADR11S Shadow table: SSF (central address manageme影像表： SSF （中心地址管理）ADR11S2Shadow Table 2: SSF (Central Address Manage阴影表 2：SSF（中心地址管理）ADR12FTP and URL (central address management)FTP 和 URL （中心地址管理）ADR12S Shadow table: FTP and URL (central address 影像表：FTP 和 URL （中心地址ADR12S2Shadow Table 2: FTP and URL (Central Addres阴影表 2：FTP 和 URL（中心地址ADR13Pager (central address management)寻呼机（中心地址管理）ADR13S Shadow table: Pager (central address manage影像表：寻呼机（中心地址管理）ADR13S2Shadow Table 2: Pager (Central Address Mana阴影表 2：呼机（中心地址管理）ADR14Reserve communication type (central address预留的通讯类型（中心地址管理）ADR15Reserve communication type (central address预留的通讯类型（中心地址管理）ADR16Reserve communication type (central address预留的通讯类型（中心地址管理）ADR2Telephone numbers (central address admin.)电话号码（中央地址管理）ADR2S Shadow table: Telephone numbers (CAM)阴影标题:电话号码 (CAM)ADR2S2Shadow Table 2: Telephone Nos (Central Addr阴影表 2：电话号码 (中心地址管ADR3Fax numbers (central address admin.)传真号（中央地址管理）ADR3S Shadow table: Fax numbers (CAM)阴影标题:传真号码 (CAM)ADR3S2Shadow Table 2: Fax Numbers (Central Addres阴影表 2：传真号码 (中心地址管ADR4Teletex numbers (central address admin.)电话号码（中央地址管理）ADR4S Shadow table: Teletex numbers (CAM)阴影标题:电传号码 (CAM)ADR4S2Shadow Table 2: Teletex Numbers (Central Ad阴影表 2: 电传号码 (中心地址管ADR5Telex numbers (central address administrati电话号码（中央地址管理）ADR5S Shadow table: Fax numbers (CAM)阴影标题:传真号码 (CAM)ADR5S2Shadow Table 2: Telex Numbers (Central Addr阴影表 2: 电传号码 (中心地址管ADR6SMTP numbers (central address admin.)SMTP 数值(集中地址管理)ADR6S Shadow table: SMTP numbers (CAM)阴影标题: SMTP 号码 (CAM)ADR6S2Shadow Table 2: SMTP Numbers (Central Addre阴影表 2: SMTP 号码 (中心地址ADR7Remote Mail Addresses (R/3 - R/3; Central a远程邮件地址 (R/3 - R/3; 中心ADR7S Shadow table: RML addresses (Central Addres阴影表: RML 地址 (中心地址管理ADR7S2Shadow Table 2: RML addresses (Central Addr阴影表 2: RML 地址 (中心地址管ADR8X.400 numbers (central address admin.)X.400 数目(中心地址管理)ADR8S Shadow table: X.400 numbers (CAM)阴影标题:X.400 号码 (CAM)ADR8S2Shadow Table 2: X.400 Numbers (Central Addr阴影表 2: X.400 号码 (中心地址TOAFO SAP ArchiveLink form management SAP 归档链接表格管理TOAFV SAP ArchiveLink form management SAP 归档链接表格管理TOAHR Container table for HR administration level HR管理级的容器表TOAID Doc. ID / file name generation Doc. ID / 文件名生成TOAIN SAP ArchiveLink - Interface table SAP 归档链接 - 接口表TOAKT SAP ArchiveLink - Communication types value SAP 归档链接- 通讯类型值表TOAMS SAP ArchiveLink API: Length definition of p SAP 归档链接 API: 参数的长度定TOAO2SAP ArchiveLink extended meta table SAP 归档链接扩展的元表TOAOM SAP ArchiveLink: Meta table for links SAP 归档链接：链接的元表TOAOS Logical mapping to implementation method逻辑映射到执行方法TOAP2SAP ArchiveLink: Presettings SAP 归档链接：预置TOAPA Table for parameter maintenance for storing用于存储早期条目的参数维护表TOAPI SAP ArchiveLink interface SAP 归档连接界面TOAPR SAP ArchiveLink: Presettings for storage sc SAP 归档链接：存储方案的预置TOAPRE SAP ArchiveLink: Presettings for storage sc SAP 归档链接：存储方案的预置TOAPRS SAP ArchiveLink: Long text presettings for SAP 归档链接：用于存储方案的长TOAR7SAP ArchiveLink: Request table (asynchronou SAP 存档连接：请求表（异步存档TOAS1Number of stored archive files存储的归档文件数TOASA SAP ArchiveLink: Language table for methods SAP 归档链接： 方式的语言表TOASB Language Table fFor TOABA用于 TOABA 的语言表TOASD Language-Dependent Table For TOADD TOADD 的语言相关表TOASK SAP ArchiveLink: Language table communicati SAP 归档链接： 语言表通讯类型TOASM Language-Dependent Table For TOACM用于 TOACM 的语言相关表TOASO Language-Dependent Table For TOACO用于 TOACO 的语言相关表TOASP SAP ArchiveLink: Language table for archive SAP 归档链接：用于归档对象的语TOASR Language-Dependent Table For TOAAR用于 TOAAR 的语言相关表TOASV SAP ArchiveLink: Language table for form ma SAP 归档链接：表单管理的语言表TOAV1VIEW basis table structure analogous to TOA视图基本表结构模拟TOAV2VIEW table 2 structure for link table视图表 2 链表结构TOAVK Definition of function calls for object lin对象链接功能调用的定义TOAVK_S Language table for TOAVK TOAVK 的语言表TOBAE Transfer Times: Control Station Communicati传送次数: 控制站通讯TOBJ Objects对象TOBJ_CD Objects that were disabled禁用对象TOBJ_CONTROL Objects that were disabledTOBJ_OFF Objects that were disabled禁用对象TOBJ_SAV Objects that were disabled禁用对象TOBJ_TPL Authorization objects for a global template用于全局模板的授权对象TOBJ_TPO Definition table for global templates用于全局模板的定义表TOBJ_TPT Text table for global templates用于全局模板的文本表TOBJECTP Objects assigned to a project Objects assigned to a project TOBJECTT Objects assigned to a template Objects assigned to a template TOBJT Texts for Objects in Table TOBJ在表 TOBJ 中的对象的文本TOBJVOR SAP_NEW Release-Dependent Data for Authoriz SAP_NEW Release-Dependent Dat TOBJVORDAT Field Values for SAP_NEW Authorization Obje Field Values for SAP_NEW Auth TOBJVORFLG Flags for Authorization Objects Flags for Authorization Objects TODIR Object List for Switch切换的对象列表TODOS TODO: Exclude programs from individual SLIN TODO: 单个 SLIN 检查的包含程序TOGCF GG: Configuration ViewsTOGM1Software Maintenance Process: Collective ProcessingTOGM2Maintenance sets for profilesTOGM3PLM definition of 'push' materialTOGM4Maintenance ProfileTOGM5Software Maintenance Process: Rejection CodesTOGMT PLM profile descriptionTOJMB Objects in the SAP System: methods在SAP系统对象中:方法TOJMT Objects in the SAP System: method descripti在SAP系统中的对象:方法描述TOJRB SAP objects: return values for methods SAP目标:为方法返回值TOJRT Objects in the SAP System: return value tex在SAP系统中对象:返回值文本TOJTB Business object repository: Basic data事务对象储存处: 基础数据TOJTD Customizing Object Types自定义 对象类型TOJTL Objects in the SAP System: object types wit在SAP系统中的对象:具有定义的对TOJTT Texts Basic Data基础文本数据TOKOM Technical Parameters for Communications Mod用于通讯模式的技术参数TOLE OLE Applications OLE 应用程序TOLET Workflow Object Types: Texts OLE Applicatio工作流对象类型: 文本 OLE 应用TONR Number status: general object number编号状态：一般对象号TOOL_COST Costs for Prod.Resource/Tool生产资源/工具的成本TOPDEVV Process Order - Selection Variants流程订单 - 选择变式TOPRK Log Messages日志信息TORB1Incoming Orders: Cost Element Assignment收入订单：成本要素分配TORB2Incoming Orders: Settings for Key收入订单：关键字设置TORS0Customizing Time-Dependent Status: Activate定制时间相关状态：有效功能TORS1Statuses Relevant for Key-Date Based Manage基于关键日期管理的相关状态TP01Business Partner: Form of Address业务伙伴：地址表格TP01T Business Partner: Form of Address Text业务伙伴：地址文本表格TP02Business Partner: Salutation业务伙伴人：问候TP02T Business Partner: Salutation Text业务伙伴：问候文本TP03Business Partner: Marital Status业务伙伴：婚姻状况TP03T Business Partner: Description of Marital St业务伙伴：婚姻状况描述TP04Business Partner: Marital Property Regime业务伙伴：婚姻财产权TP04T Business Partner: Description of Marital Pr业务伙伴：婚姻财产权描述TP05Business Partner: Employee Group业务伙伴：雇员组TP05T Business Partner: Name of Employee Group业务伙伴：雇员组名称TP06Business Partner: Rating业务伙伴：评估TP06T Business Partner: Rating Description业务伙伴：评估描述TP07Business Partner: Credit Rating Institute业务伙伴：信用评估机构TP07T Business Partner: Name of Credit Rating Ins业务伙伴：信用评估机构名称TP08Business Partner: Legal Form业务伙伴：法律表格TP08T Business Partner: Description of Legal Form业务伙伴：法律表格描述TP09Business Partner: Legal Entity业务伙伴：法律实体TP09T Business Partner: Name of Legal Entity业务伙伴：法律实体名称TP10Business partner: Loan to Manager Indicator业务伙伴：经理贷款标识符TP103BP: Field Modification via BP Role Category BP：通过BP 职责类别修改字段TP105BP: Field Modification via Activity Categor BP：通过活动类别修改字段TP10T Business Partner: Name of Loan to Manager业务伙伴：经理贷款名称TP11Business Partner: Employment Status业务伙伴：雇佣状况TP11T 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 ID业务伙伴：地址标识TP14T Business Partner: Name of Address ID业务伙伴：地址标识名称TP15Business Partner: Function业务伙伴人：功能TP15T Business partner: Name of Function业务伙伴人：功能名称TP16Business Partner: Department业务伙伴人：部门TP16T Business Partner: Name of Department业务伙伴人：部门名称TP17U Business Partner: Convert Industries业务合伙人: 转换工业TPACHECK Checking Table Directory for Check Modules 检查表格目录用于 SD 合伙人的检TPACHECKASSIGN Checking Module Assignments in SD Partner P在 SD 合伙人处理中检查模块分配TPACHECKRELATION Dependency Graph for Check Modules in SD Pa SD 合伙人处理中检查模块的相关TPAER_PM Partner Functions in Partner Schema (PM) wi在有复制标志的合伙人概要(PM)中TPAFILTER Filter Table for Displaying Partner Subscri显示合伙人订阅 1000 的过滤器表TPAKL Assignment of Partner Function to Account G把业务往来功能分配给供应商帐户TPALOG DB Buffer for ALOG File DB Buffer for ALOG File TPALOGHDR Header Table for TPALOG Header Table for TPALOG TPAMA Search Strings for Pattern Matching模式匹配的搜索字符串TPAMAT Text Table for Search String TPAMA搜索字符串 TPAMA 的文本表格TPAR Business Partner: Functions业务合作伙伴: 功能TPARA Directory of Memory IDs IDS内存表TPARAAPPL Application Table for TPARA Application Table for TPARA TPARAT Memory ID Short Texts内存ID短文本TPART Business Partner Functions: Texts业务合作伙伴功能: 文本TPARU Control parallelized confirmation processes控制并行的确认处理TPATT Pattern type in VarChart VarChart图形类型TPCA_ALE Company Code/Field Transfer PCA (ALE)公司代码/字段传输 PCA (ALE) TPCRTYPE Document Types for Posting Correction Reque记帐修正请求的凭证类型TPDB2DB2/390: Pagesize <-> table storage paramet DB2/390: 页面大小 <-> 表存储参TPEXT Profile for external procurement外协采购的概况TPEXT_T Text tables for profiles (external procurem(外部采购) 参数文件文本表TPF02Profile Table Parameter Names from sapparam描述文件表格参数名称从TPFBA SAP System operation mode SAP 系统操作模式TPFES Prototype: Table for profile parameters范例:表格为描述文件参数TPFET Table of profile parameters描述参数的表TPFHS Prototype: Profile header, administration d范例:描述文件标题:管理数据描述TPFHT Profile header, administration data for pro描述文件标题,管理数据DBTPFID Description of SAP instance SAP 距离描述TPFK Contact Persons: Functions联系人: 功能TPFKT Contact Partner Functions: Texts与合伙人联系功能: 文本TPFST Startup: List of programs to be started启动:程序列表被开始TPFVA Profiles: Parameter valid flags描述文件,参数合法的标志TPFVD Profiles: Parameter values table D (DB, tab描述文件:参数值表格DIDB,表格缓TPFVE Profile Parameters for Environment / Vali描述文件参数环境/合法标志TPFVI Profiles: Parameter values, table I (IPC...描述文件:参数值,表格I(IPC...)TPFVP Profile Parameters for Processes (Disp, App描述文件参数处理TPFVQ Profiles Parameters for Processes (Disp,...描述文件参数处理(显示)TPFVR Profile Parameter Roll, Paging, Statistics 描述文件参数卷轴,版,统计资料/TPFVX Profile Parameter Values Table X (other...)描述文件参数值表格X(other...)TPFWE Profile Parameters for Environment描述文件参数环境TPFYDOC Parameter documentation参数文档TPFYPROPTY Parameter attributes参数属性TPGAC GG enhancement: Material types representing Product GroupsTPGPRF Profile for static pegging and data distrib静态限制和数据分配的参数文件TPGPRFT Text table for pegging profile限制参数文件的文本表格TPHASEP Project phases Project phasesTPHASETP Project phases text table Project phases text tableTPHCNV Data for Product Hierarchy Conversion用于产品层次转换的数据TPHVP Header: Planning Profile标题：计划参数文件TPI01Interest Calculation Profile利息计算参数TPI01T Interest Calculation Profile利息计算参数TPI02Interest Calculation Profile and Interest I利息计算概况和利息标记TPI03CO Objects: Date of Last Interest Run CO 对象: 上一次计息日TPI04Interest Relevance of Cost Element/Commitme成本要素/承诺项目组的利息相关TPICK Analysis of Function Code PICK功能编码 PICK 的分析TPIF2Commitment items: value category承诺项目: 数值类型TPIF3Assignments: Commitment Item -> Value Categ分配：委托项目 -> 价值类别TPIK2Cost elements: value categories成本要素: 数值类型TPIK3Assignment Table: Cost Elements -> Value Ca分配表格：成本要素 -> 价值类别TPIR1Value Categories价值种类TPIR1T Texts for Value Categories值类别文本TPIR2Value Categories价值种类TPIR2T Texts for Value Categories值类别文本TPIRX Control RPSCO update控制 RPSCO 更新TPIS3Assignment Table:Statistical Key Figures ->分配表：统计关键指标 -> 价值类TPK01Key for Controlling the Control Cycle; In-H用来控制控制周期的代码;自制生TPK02Key for Controlling Control Cycle: External用来控制控制周期的代码;外部补TPK03Key for Controlling Control Cycle; Stock Tr用来控制控制周期的代码;库存转TPK1T Control Cycle Profile for In-House Producti控制自制生产控制周期参数文件-TPK2T Control Cycle Profile (External Procurement控制周期参数文件(外部采购)-文TPK3T Control Cycle Profile (Stock Transfer) - Te控制周期参数文件(库存转移)-文TPKAK Actions in KANBAN Processing在看板处理中的活动TPKBP Kanban calculation profile看板计算参数文件TPKBU Adjusting a Control Cycle in Kanban Calcula在看板计算中调整控制周期TPKER Alternative Error Handling in the Kanban Pr看板处理中的可选错误处理TPKLEK Delete Event-Driven KanbansTPKPT Kanban Authorization Text看板权限文本TPKSF Kanban Status Sequences看板状态顺序TPKTX Kanban Container Status Short Text看板容器状态短文本TPLMK GG enhancement: Document types proposed for MLMTPLOG Logging of tp Calls tp 调用的记录TPLOGNAMES tp: Names of Log Files and Times Used tp: Names of Log Files and Times Used TPLVP Planning Profile计划参数文件TPMA_DERIV_ASSGN Assignment of Derivation Categories派生类别的分配TPMB_DERIV_AMORT Assign Amortization Method to Derivation Ca将分摊方法分配到派生类型TPMB_DERIV_CAT Define Derivation Methods定义派生方法TPMCKF PMIS: customer-specific value and quantity PMIS：客户特定值和数量关键指标TPMCKFT PMIS: texts for cust.-specific value and qu PMIS：客户特定值和数量关键指标TPMIM IM allocation key IM 分配码TPMK Cost key figures of the maintenance order维护订单的成本关键数TPMKT Texts for cost key figures of the maintenan维护订单的成本关键数的文本TPMP Maintenance profile维护概况TPMPO Maintenance order processing profile维护订单处理概况TPMT_DEDOC_HDR Derivatives Document: Document Header派生凭证：凭证标题TPMT_DEDOC_LOTPO Derivatives Document: Document Item Per Lot派生凭证：每批量的凭证项目TPMT_DEDOC_POS Derivatives Document: Document Item派生凭证：凭证项目TPMT_DEPAL_FLOWS Listed Futures: Price Gain Records列出的期货：价格收益记录TPMT_LOT_HEADER Single Position Master Data for TR Position TR 位置管理的单个位置主数据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 values PM/SM - 用户缺省值TPNNR Customizing prima nota定制第一通知TPNNT Prima nota customizing texts第一通知定制文本TPOOL Master Record, LIFO Pools主记录,先进先出池TPR_INDEX List of nodes sorted by project List of nodes sorted by projectTPR_PREF User's settings用户设置TPR_VINDX List of IMG Activities in a Project View List of IMG Activities in a Project View TPR_XREF_D Index for Where-Used List Index for Where-Used ListTPR_XREF_P Projects: Constraint on Where-Used List 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带有ALE修改权限的商业对象TPRC Business Process in Expiring Currency以期满货币业务处理TPRCD Date for Subsequent Process for Expiring Cu期满货币的后续处理日期TPRCLASS Project Management Project Classes Project Management Project Classes TPRCLASST Project Class Table Text Table Project Class Table Text TableTPRCT Business Process in Expiring Currency (Text期满货币的业务处理(文本表)TPRF International Article Number (EAN) Prefixes内部商品号(EAN)前缀TPRFL Field Groups per Change Authorization Profi每个权限参数文件的字段组TPRFT EAN Prefix Descriptions EAN前缀描述TPRI_PAR ABAP print parameter storage ABAP 打印参数存储TPRIO Customers: Delivery Priorities客户：交货优先级TPRIOCL Project Class Priority Assignment Project Class Priority Assignment TPRIOEPR Project Management Priorities Project Management PrioritiesTPRIOP Project Priorities Project PrioritiesTPRIOTPR Project Management: Priorities Text Project Management: Priorities Text TPRIT Customers: Delivery Priority: Texts客户: 交货优先: 文本TPRO Profile Names for ALE Change Authorizations ALE修改权限的参数文件名称TPROCESSES Profile Names for ALE Change AuthorizationsTPROF_CEP Profile for CEP Profile for CEPTPROFT_CEP Text table for CEP profile Text table for CEP profileTPROJ_GEN Project Additional Data Table Project Additional Data Table TPROJECT SPROJECT: Project Table SPROJECT: Project TableTPROJECTF Project Management Favorites List Project Management Favorites List TPROJECTT Project Table Text Table Project Table Text Table。
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基本表关系
Sap基本表关系SAP Table Relationsversion 1.0.0compiled byChristopher Solomonwithcontributions byvarious SAP ProfessionalsTable KeyLink KeyOne-to-OneOne-to-Many OneOneOneMany SAP Table Nam e (Table Description)SAP Field Name (Field Description)Useful FieldsSAP Table InformationHow to use this document?SAP Field Name (Field Description)SAP Table Nam e (Table Description)Trans parent TableClus ter TableThis document displays and describes the relationships and links between the v arious SAP database tables. These relationships aredisplayed graphically as described below:SAP - FI/COCustomLedgeFI/CO Table MappingFinancial AccountingPhysicalBKPF(Accounting document header)Company Code Document No Fiscal YearBSEC BSED BSEG BSES BSETRFBLG(Cluster for accounting document)SAP FI/COSpecial Purpose LedgerSAP FI/COControllingSA P FI/CO Accounts PayableSAP FI/CO Accounts ReceivableMaster DataCost CenterProfit CenterSAP FI/COCEPC(Profit center m aster data table)Profit Center (P RCTR)Valid to Date (DATBI)Controlling Area (KOKRS)CEPCT(Texts for Profit Center Master Data)Language (SPRAS)Profit Center (P RCTR)Valid to Date (DATBI)Controlling Area (KOKRS)CSKS(Cost center m aster)Controlling Area (KOKRS)Cost Center (KOSTL)Valid to Date (DATBI)CSKT(Cost Center Texts)Language (SPRAS)Controlling Area (KOKRS)Cost Center (KOSTL)Valid to Date (DATBI)SAP - Materials ManagementMAKT (Material Description)KNMT(Customer-MaterialInfo Record DataTable)makt-matnr = knmt-matnrandmakt-spras = sy-languEKKO(Purchasing DocHeader)EKPO(Purchasing DocItem)EKPO-EBELN =EKKO-EBELNMDKP(MRP Header)MDTB(MRP Detail)MDKP-DTNUM =MDTB-DTNUMPurchasing Requisition SAP MM - PurchasingSTXH(STXD SAPscript text file header) Texts (TDOBJECT)Text Name (TDNAME)Text Id (TDID)Language (TDSPRAS)EBAN(Purchase Requisition)Purchasing Req (BANFN)Item (BNFPO)EBKN(Purchase Requisition AccountAssignm ent)Purchasing Req (BANFN)Item (BNFPO)Preg Account Assignment (ZEBKN)STXL(STXD SAPscript text file lines)) (RELID)Texts (TDOBJECT)Text Name (TDNAME)Text Id (TDID)Language (TDSPRAS)(SRTF2)SAP MM - Purchasing Purchase OrdersSAP MM - Purchasing Goods ReceiptSAP MM - Master DataSAP MM - PurchasingSAP - Project PlanningProject PlanningPROJ(Project Definition)PRPS(WBS Elements)PRPS-PSPHI =PROJ-PSPNRPRTE(Schedule Data forProj. Item)PRPS-PSPNR =PRTE-POSNRand PRPS-PSPHI=PRTE-PSPHIPRTX (Texts(WBS))PRTX-PRPSPNR =PRTE-POSNRPRHIS(Proj. Hierarchy for WBS Element)PRPS-PSPNR =PRHIS-POSNRand PRPS-PSPHI=PRHIS-PSPHIPSTX (Project Texts (Header))PSTT (Project Texts)PRTX-PRTXTKY =PSTX-PRTXTKYPSTX-PRTXTKY =PSTT-PRTXTKYSAP PP - Project PlanningPROJECTSProject and WBS element numbers have a domain with a conv ersionfunction module which converts it from 8 numc input to 24 char on output.PSTTSAP - Sales and DistributionSAP SD - Shipping TablesSAP SD - Billing TablesCustomer Master DataCompany Code DataGeneral DataSales Area DataSAP SD - Links to FI TablesCustomer No (KUNNR)Sales Org (VKORG)Distribution Ch (VTWEG)Division (SPART)Partner Function (PARVW)Partner Counter (PARZA)Customer No (KUNNR)Customer No (KUNNR)Sales Org (VKORG)Distribution Ch (VTWEG)Division (SPART)KNVP(Customer M aster Partner Functions)KNA1(General Data in Customer M aster)KNVV(Customer M aster Sales Data)KNVD(Customer master record sales request form)Customer No (KUNNR)Sales Org (VKORG)Distribution Ch (VTWEG)Division (SPART)Output Type (KNB1(Customer master (company code))KNB5(Customer master (dunning data))Customer No (KUNNR)Companu Code (BUKRS)Dunning Area (M ABER)Customer No (KUNNR)Company Code (BUKRS)SAP SD - Links to MM Tables Material Master DataFI/COMichael Rhodes (MedPartners, inc.)MMJim Lewis (Whittman-Hart, inc.)Michael Rhodes (MedPartners, inc.)Master DataJim Lewis (Whittman-Hart, inc.)Contributions byPP。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
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。
CEZP Reporting Point Document Logs（行项目）CPZP Reporting Points –Periodic Totals(产看某期间的报告点)对象号与AFKO订单号关联；MRP RecordsMDKP MRP Document Header DataMDKPDBPLSC Planning Scenario (Long-term Planning)MDFD MRP Firming Dates(涉及到长期计划中的计划方案)MDVM Planning File EntriesS094 LIS -- Stock/Requirements Analysis(动态生成)MDTB MD04/MD05界面的数据表 DTNUM，只是一份计划条目清单；UMD01 保存MRP的界面参数ReservationsRKPF Reservations HeaderRESB Reservations/Dependent Requirements（保留相关的溯源）Planned OrdersPLAF PlannedOrdersOPIT 计划订单调度记录T457P 计划订单中订单类型的文本表格T460C 计划订单的订单/采购订单类型T460D 计划订单的订单/采购订单类型DPM 计划订单逻辑数据库Discrete Production（生产订单）从CAUFV找AUFRLAFKO OrderHeader（包含有BOM和ROUTING的组信息）(工序确认,上级订单号)(不要关联该表的物料号，经常会丢失。