【转】SAP常用后台数据表大全(FI-CO-MM-SD-PP等).docx

常用表字典ECCSCO TablesFI TablesMM TablesPP TablesSD TablesEAM常用表TableTableTypeApplicationClassDataClassDescriptionBKPFTRANSPFBTransaction会计核算凭证：抬头BNKATRANSPFBMaster银行主记录BSADTRANSPFBTransaction会计核算凭证：客户欠款已清项的凭证编号和行项目明细BSAKTRANSPFBTransaction会计核算：供应商的第二个索引（已结算项目）BSASTRANSPFBTransaction会计核算：总帐科目的第二个索引（已结算项目）BSECCLUSTERFBTransaction一次性帐户数据凭证段BSEGCLUSTERFBTransaction会计核算凭证段BSETCLUSTERFBTransaction税收数据凭证段BSIDTRANSPFBTransaction会计核算凭证:客户欠款未清项的凭证编号和行项目明细BSIKTRANSPFBTransaction会计核算：供应商的第二次索引(未清项目)BSISTRANSPFBTransaction会计核算：用于总帐科目的第二个索引(未清项目)CE1SINO获利段行项目信息CE4SINO获利段信息表CEPCTRANSPKEMaster利润中心主数据表COBKTRANSPKATransaction成本控制对象：凭证抬头COEJTRANSPKATransaction成本控制对象：与财政年度相关的各行项目COEJLTRANSPKATransaction成本控制对象：业务类型行项目（按财政年）COEJRTRANSPKATransaction成本控制对象：统计关键数行项目（按财政年）COEJTTRANSPKATransaction成本控制对象：业务价格行项目（按财政年）COEPTRANSPKATransaction成本控制对象：与期间相关的各行项目COEPBTRANSPKATransaction成本控制对象：行项目差异/基于期间的结果分析COEPLTRANSPKATransaction成本控制对象：业务类型行项目（按期间）COEPRTRANSPKATransaction成本控制对象：统计关键数行项目（按期间）COEPTTRANSPKATransaction成本控制对象：业务价格行项目（按期间）COKATRANSPKATransaction成本控制对象：成本要素控制数据COKLTRANSPKATransaction成本控制对象：作业类型的控制数据COKPTRANSPKATransaction成本控制对象：主要计划控制数据COKRTRANSPKATransaction成本控制对象：统计关键数控制数据COKSTRANSPKATransaction成本控制对象：次级计划编制的控制数据COSBTRANSPKATransaction成本控制对象：差异总计/结果分析COSBDTRANSPKATransactionCO 对象: 差异/待摊, 已结算的COSLTRANSPKATransaction成本控制对象：作业类型总计COSPTRANSPKATransactionCO 对象：外部记帐的成本总计COSPDTRANSPKATransactionCO 对象: 已结算初级成本总计COSRTRANSPKATransactionCO 对象：统计关键指数总计COSSTRANSPKATransactionCO 对象:内部过帐成本总计COSSDTRANSPKATransactionCO 对象: 已结算次级成本总计COSTTRANSPKATransaction成本控制对象：价格总计CSKATRANSPKSMaster成本要素 (数据与科目表相关)CSKBTRANSPKSMaster成本要素 (数据与成本控制范围相关)CSKSTRANSPKSSMaster成本中心主数据CSKTTRANSPKSSMaster成本中心说明文本CSKUTRANSPKSMaster成本要素文本CSLATRANSPKSSMaster作业主档CSLTTRANSPKSSMaster作业类型文本CSSKTRANSPKSSMaster成本中心/成本要素CSSLTRANSPKSSMaster成本中心/作业类型EBANTRANSPMETransaction采购申请EBKNTRANSPMETransaction采购申请帐户设置EBUBTRANSPMETransaction有关物料的运输请求的索引EINATRANSPMETransaction采购信息记录 - 一般数据EINETRANSPMETransaction采购信息记录 - 采购组织数据EIPATRANSPMETransaction订购价格历史：信息记录EKABTRANSPMETransaction批准凭证EKANTRANSPMETransaction供应商地址: 采购凭证EKBETRANSPMETransaction采购凭证历史EKBZTRANSPMETransaction每个采购凭证的历史：交货费用EKES供应商确认EKETTRANSPMETransaction计划协议中的计划项目EKKNTRANSPMETransaction采购凭证中的帐户设置EKKOTRANSPMETransaction采购凭证:抬头EKPBTRANSPMETransaction采购凭证:已供物料项EKPOTRANSPMETransaction采购凭证:项目EKUBTRANSPMETransaction有关物料的库存运输单的索引ESKNTRANSPMETransaction服务包中的帐户分配GLT0TRANSPFGTransaction总帐科目主记录业务额IKPFTRANSPMBTransaction抬头：实地盘存凭证ISEGTRANSPMBTransaction盘点库存凭证项目KNA1客户主文件的一般数据KNASTRANSPFBMaster客户主数据（一般地区的增值税登记号）KNB1TRANSPFBMaster客户主数据 (公司代码)KNB4TRANSPFBMaster消费者收付历史KNB5TRANSPFBMaster客户主记录 (催款数据)KNBKTRANSPFBMaster客户主数据 (银行细目)KNC1TRANSPFBMaster客户主记录 (交易额)KNC3TRANSPFBMaster客户主数据 (特殊总帐业务额)KNKATRANSPFBMaster客户主数据信贷管理: 中心数据KNKKTRANSPFBMaster客户主数据信贷管理: 控制范围数据KNMTTRANSPVAMaster客户-物料信息记录数据表KNMTKTRANSPVAMaster客户-物料信息记录标题表KNVATRANSPVVMaster客户主装货点KNVDTRANSPVDMaster客户主记录销售查询表KNVITRANSPVFMaster客户基本税指示符KNVKTRANSPVPMaster客户主要联系伙伴KNVLTRANSPVFMaster客户原执照KNVPTRANSPVPMaster客户主记录伙伴功能KNVSTRANSPVVMaster客户主装运数据KNVTTRANSPVTMaster用于销售的客户主记录文本KNVVTRANSPVMaster客户主记录销售数据KONATRANSPVFMaster回扣协议KONDTRANSPVFMaster条件(数据)KONHTRANSPVFMaster条件(抬头)KONMTRANSPVFMaster定价( 1维数量等级 )KONPTRANSPVFMaster条件(项目)KONVCLUSTERVFMaster条件(事务数据)KONWTRANSPVFMaster条件(1 维值比例)LFA1TRANSPFBMaster供应商主数据 (一般地区)LFASTRANSPFBMaster供应商主数据 (增值税登记号的一般部分)LFB1TRANSPFBMaster供应商主数据 (公司代码)LFB5TRANSPFBMaster供应商主数据 (催款数据)LFBKTRANSPFBMaster供应商主数据 (银行细目)LFC1TRANSPFBMaster供应商主数据 (业务额)LFC3TRANSPFBMaster主供应商 (特殊总分类帐交易图表)LFM1TRANSPMETransaction供应商主记录购买组织数据LIKPTRANSPVLTransactionSD凭证 ： 交货抬头数据LIPSTRANSPVLTransactionSD凭证 ： 交货： 项目数据MAKTTRANSPMGMaster物料描述(物料名称文本)MAPRTRANSPMGMaster有关预测的物料索引MARATRANSPMGMaster一般物料数据(物料主数据)MARCTRANSPMGMaster物料的工厂数据MARDTRANSPMGMaster物料的仓储位置数据MARMTRANSPMGMaster物料度量单位MARVTRANSPMGMaster物料控制记录MBEWTRANSPMGMaster商品评估MBEWH物料评估：历史MBPRTRANSPMGMaster生产仓位库存MCHATRANSPMGMaster物料批次MCHBTRANSPMGMaster批量库存(非限制使用的估价库存)MKPFTRANSPMBTransaction物料凭证：抬头MLANTRANSPMGMaster物料的税分类MLGNTRANSPMGMaster每一仓库号物料数据MLGTTRANSPMGMaster每一存储类型的物料数据MSEGTRANSPMBTransaction物料凭证：商品(行项目)MSKU客户的特殊库存MSTATRANSPMGMaster商品主记录状态MVERTRANSPMGMaster物料消耗量(损耗量)MVKETRANSPMGMaster物料销售数据NACHTRANSPVNTransaction细化的输出数据NASTTRANSPVNTransaction消息状态NBNKTRANSPFBOrganizational银行的号码范围NKUKTRANSPFBOrganizational凭证自动编号范围OIB_TANKDIP油罐计量台帐OII_DIP_PARAM密度换算系数OII_DIP_QUAN油罐计量修正参数OIISOCISL库存对象特性: 库存地的索引/序号存取模式OIISOCKSOC: 存储对象特性段 :抬头(物料存储位置)OIISOCTSM分配相关时间 物料(库存地点时间段内存储的相关物料)PA0001人力资源主记录:信息类型0001 (原始分配)PA0002HR 主记录: 信息类型 0002 (人员数据)PAYRTRANSPFBZTransaction支付媒体文件(支付方式)PCECTRANSPFBZOrganizational支票编号范围(预先编号)REGUATRANSPFBZTransaction收付建议的更改: 用户和时间REGUHTRANSPFBZTransaction来自支付程序的结算数据REGUPCLUSTERFBZTransaction来自收付程序的处理项目REGUSTRANSPFBZTransaction科目被收付建议冻结REGUVTRANSPFBZTransaction对于收付程序的控制记录S995销售公司产品分配SKA1TRANSPFBMaster总帐科目主记录 (科目表)SKATTRANSPFBMaster总帐科目主记录（科目表：说明）SKB1TRANSPFBMaster总帐科目主记录 (公司代码)T001TRANSPFBOrganizational公司代码T001BTRANSPFBOrganizational允许的记帐期T001LTRANSPMGOrganizational仓储地点 (油罐/加油站)T001WTRANSPMGOrganizational96T005TRANSPFBOrganizational0T005TTRANSPFBOrganizational国家名T012POOLFBOrganizational开户行T012TPOOLFBOrganizational开户行帐户名T148T客户的特殊库存描述T179TRANSPVSOrganizational物料: 产品层次T179TTRANSPVTOrganizational材料: 生产等级: 文本T190O产品分配：产品分配对象的定义TBSLPOOLFBOrganizational冲销/冲销条目的过帐代码TBSLTPOOLFBOrganizational冲销/冲销条目的过帐代码名称TCURCTRANSPFBOrganizational货币代码TCURFTRANSPFBOrganizational转换因子(货币汇率)TCURRTRANSPFBOrganizational汇率TCURTTRANSPFBOrganizational货币代码名TCURVTRANSPFBOrganizational货币换算的兑换率类型TCURWTRANSPFBOrganizational汇率类型的使用TGSBTRANSPFBOrganizational业务范围TGSBTTRANSPFBOrganizational业务部门名称TVBUROrganizational销售办公室TVGRTOrganizational销售小组 名称TVKBTOrganizational销售办公室 名称TVKGROrganizational销售小组TVKOOrganizational销售组织TVKOT销售组织:名称TVTWT机构单位：分销渠道：文本VAKGUTRANSPVIND销售索引 ： 报价有效期VAKPATRANSPVIND销售索引 ： 按合作伙伴功能的订单VAPMATRANSPVIND销售索引 ： 按物料的订单项目VBAGTRANSPVATransaction销售凭证 ： 按计划协议中细目的批准数据VBAKTRANSPVATransaction销售凭证 ： 抬头数据VBAPTRANSPVATransaction销售凭证 ： 项目数据VBFACLUSTERVATransaction销售凭证流VBFSTRANSPVTransaction汇总处理的错误日志VBKATRANSPVCKTransaction销售活动VBKDTRANSPVATransaction销售凭证 ： 业务数据VBKOFTRANSPVINDSD索引： 按合作伙伴功能的未确定销售活动VBKPATRANSPVINDSD索引： 按合作伙伴功能的销售活动VBLKTRANSPVLTransactionSD凭证 ： 交货单抬头VBLSTRANSPVLTransaction汇总处理的交货单VBPATRANSPVPTransaction销售凭证:合作伙伴VBRKTRANSPVFTransaction发票抬头数据VBRPTRANSPVFTransaction发票项目数据VBSKTRANSPVTransaction关于销售凭证抬头的汇总处理VBSSTRANSPVTransaction汇总处理： 销售凭证VBUKTRANSPVTransaction销售凭证 ： 抬头状态和管理数据VBUPTRANSPVTransaction销售凭证 ： 项目状态VBUVCLUSTERVTransaction销售凭证 ： 不完整性日志VEPVGTRANSPVIND交货到期索引VETVGTRANSPVIND库存调拔的交货到期索引VKAOFTRANSPVIND销售索引 ： 未确定的销售活动VKDFSTRANSPVINDSD索引： 出具发票的初始状态VLKPATRANSPVIND销售索引 ： 按合伙人功能的交货VLPMATRANSPVIND销售索引 ： 物料的交货项目VRKPATRANSPVIND销售索引 ： 按合作伙伴功能的票据VRPMATRANSPVIND销售索引 ： 每一物料的开票项目VTFATRANSPVATransaction装运凭证流VTRDITRANSPVIND装运计划索引字 典TableTableTypeApplicationClassDataClassDescriptionDDO2LTRANSPFBTransaction表DDO2TTRANSPFBTransaction表文本DD03DTRANSPFBTransaction表格字段的动态程序字段DD03LTRANSPFBTransaction表格字段DD03TTRANSPFBTransaction表格字段文本(语言依赖)DD04LTRANSPFBTransaction数据元素DD04TTRANSPFBTransaction数据元素文本DD05STRANSPFBTransaction外来码字段DD06LTRANSPFBTransaction存储池或簇结构DD06TTRANSPFBTransaction存储池或簇结构的文本DD07LTRANSPFBTransaction域的最大/最小值DD07TTRANSPFBTransaction域的文本DD08LTRANSPFBTransaction关系定义DD08TTRANSPFBTransaction关系定义的文本ECCSTableTableTypeApplicationClassDataClassDescriptionTF100Financial Statement ItemsTF101FS items: short and medium textsTF102FS items: long textsTF103Breakdown CategoriesTF104Breakdown categories: NameTF105FS Item CategoriesTF106FS Item Categories: DescriptionTF110TRANSPKEMasterSubitem CategoriesTF111Subitem Categories: DescriptionTF115SubitemsTF116Subitems: short and medium textsTF117Subitems: long textsTF120TRANSPKEMasterConsolidation Charts of AccountsTF121Consolidation Charts of Accounts: DescriptioTF123Additional rules for running program SAPF124TF130FS item hierarchiesTF131Item hierarchies: NameTF140Selected FS ItemsTF150TRANSPKEMasterDimensionsTF151Dimensions: Texts and user-specific namesTF152Dimensions, screen list, consolidation unitsTF153Dimensions, screen list, consolidation groupTF154Dimensions year- and period-dependentTF155Dimensions: Assign Task GroupsTF160Consolidation UnitsTF161Consolidation units: textsTF162Consolidation unit correspondenceTF164Consolidation unit year-dependentTF165Consolidation units version-dependentTF166Consolidation units version- and period cateTF167Consolidation units version- and period-depeTF168Consolidation units ledger-dependentTF169Version/period-dependent Cons Units: Tax RaTF170Position of contact personTF171Position of Contact Person: DescriptionTF172Contact person assignmentsTF173Reasons for InclusionTF174Reasons for inclusion: short and medium textTF175Reasons for inclusion: long textsTF180Consolidation GroupsTF181Consolidation groups: TextsTF182Consolidation groups, version-dependentTF183Consolidation groups, version- and period caTF184Consolidation groups, version- and year-depeTF187Consolidation Group Set AssignmentsTF188Consolidation group assignment of task groupTF189Assignment of CG/CU, version- and period-depTF190HierarchiesTF191Hierarchies: textsTF192Hierarchies, period-dependentTF193Hierarchies, version-dependentTF194Hierarchies, version- and period category-deTF195Hierarchy levelsTF196Hierarchy levels: textsTF197Hierarchy levels usedTF198Hierarchy level relationshipsTF199AOrganizational elementsTF199BOrganizational elements: TextsTF199CCharacteristic Values of Organizational ElemTF199DChar. Values of Organizational Elements: TexTF199EOrganizational Element RelationshipsTFIN010Consolidation Unit IntegrationECMCAEC-CS: Journal Entry table(Actual)CO TablesTableTableTypeApplicationClassDataClassDescriptionCEPCCOBKCOEJCOEJLCOEJRCOEJTCOEPCOEPBCOEPLCOEPRCOEPTCOKACOKLCOKPCOKRCOKSCOSBCOSBDCOSLCOSPCOSPDCOSRCOSSCOSSDCOSTCSKACSKBCSKSCSKTCSKUCSLACSLTCSSKCSSLTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPKEKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKSKSKSSKSSKSKSSKSSKSSKSSMasterTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionMasterMasterMasterMasterMasterMasterMasterMasterMasterProfit center master data tableCO Object: Document headerCO object: year-related line itemsCO Object: Line Items for Activity Types (by Year)CO Object: Statistical Key Figure Line Items (by Year)CO Object: Activity Price Line Items (by Year)CO object: period-related line itemsCO Object: Line Items Variance/Period-based Results AnalysisCO Object: Line Items for Activity Types (by Period)CO Object: Statistical Key Figure Line Items (by Period)CO Object: Activity Price Line Items (by Period)CO Object: Cost Element Control DataCO Object: Activity type control dataCO Object: Primary Planning Control DataCO Object: Statistical Key Figure Control DataCO Object: Control Data for Secondary PlanningCO Object: Total Variances/Results AnalysesCO Object: Total of variances/accruals, of which settledCO Object: Activity Type TotalsCO Object: Cost Totals - External PostingsCO Object: Settled Primary Cost TotalsCO Object: Statistical Ratio TotalsCO Object: Cost Totals - Internal PostingsCO Object: Settled Secondary Cost TotalsCO object: standard rate totalsCost elements (data dependent on chart of accounts)Cost elements (data dependent on controlling area)Cost center masterCost center textsCost element textsActivity masterActivity type textsCost center /cost elementCost center / activityFI TablesTableTableTypeApplicationClassDataClassDescriptionBKPFTRANSPFBTransactionAccounting document headerBNKATRANSPFBMasterBank master recordBSADTRANSPFBTransactionAccounting: Secondary index for customers (cleared items)BSAKTRANSPFBTransactionAccounting: Secondary index for vendors (cleared items)BSASTRANSPFBTransactionAccounting: Secondary index for G/L accounts (cleareditems)BSECCLUSTERFBTransactionOne-time account data document segmentBSEGCLUSTERFBTransactionAccounting document segmentBSETCLUSTERFBTransactionTax data document segmentBSIDTRANSPFBTransactionAccounting: Secondary index for customersBSIKTRANSPFBTransactionAccounting: Secondary index for vendorsBSISTRANSPFBTransactionAccounting: Secondary index for G/L accountsGLT0TRANSPFGTransactionG/L Account Master Record Monthly Debits and CreditsKNA1TRANSPFBMasterGeneral Data in Customer MasterKNASTRANSPFBMasterCustomer master (VAT registration numbers generalsection)KNB1TRANSPFBMasterCustomer master (company code)KNB4TRANSPFBMasterCustomer payment historyKNB5TRANSPFBMasterCustomer master (dunning data)KNBKTRANSPFBMasterCustomer master (bank details)KNC1TRANSPFBMasterCustomer master (transaction figures)KNC3TRANSPFBMasterCustomer master (special G/L transaction figures)KNKATRANSPFBMasterCustomer master credit management: Central dataKNKKTRANSPFBMasterCustomer master credit management: Control area dataLFA1TRANSPFBMasterVendor master (general section)LFASTRANSPFBMasterVendor master (VAT registration numbers general section)LFB1TRANSPFBMasterVendor master (company code)LFB5TRANSPFBMasterVendor master (dunning data)LFBKTRANSPFBMasterVendor master (bank details)LFC1TRANSPFBMasterVendor master (transaction figures)LFC3TRANSPFBMasterVendor master (special G/L transaction figures)NBNKTRANSPFBOrganizationalNumber range for banksNKUKTRANSPFBOrganizationalNumber range for change documentsPAYRTRANSPFBZTransactionPayment transfer medium filePCECTRANSPFBZOrganizationalPrenumbered ChecksREGUATRANSPFBZTransactionChange of payment proposals: user and timeREGUHTRANSPFBZTransactionSettlement data from payment programREGUPCLUSTERFBZTransactionProcessed items from payment programREGUSTRANSPFBZTransactionAcounts blocked by payment proposalREGUVTRANSPFBZTransactionControl records for the payment programSKA1TRANSPFBMasterG/L accounts master (chart of accounts)SKATTRANSPFBMasterG/L account master record (chart of accounts: description)SKB1TRANSPFBMasterG/L account master (