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。
- 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的组信息）(工序确认,上级订单号)(不要关联该表的物料号，经常会丢失。