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

1、常用表字典ECCSCO TablesFI TablesMM TablesPP TablesSD TablesEAM常用表TableTableTypeApplicationClassDataClassDescriptionBKPFTRANSPFBTransaction会计核算凭证：抬头BNKATRANSPFBMaster银行主记录BSADTRANSPFBTransaction会计核算凭证：客户欠款已清项的凭证编号和行项目明细BSAKTRANSPFBTransaction会计核算：供应商的第二个索引（已结算项目）BSASTRANSPFBTransaction会计核算：总帐科目的第二个索引（已结算项

2、目）BSECCLUSTERFBTransaction一次性帐户数据凭证段BSEGCLUSTERFBTransaction会计核算凭证段BSETCLUSTERFBTransaction税收数据凭证段BSIDTRANSPFBTransaction会计核算凭证:客户欠款未清项的凭证编号和行项目明细BSIKTRANSPFBTransaction会计核算：供应商的第二次索引(未清项目)BSISTRANSPFBTransaction会计核算：用于总帐科目的第二个索引(未清项目)CE1SINO获利段行项目信息CE4SINO获利段信息表CEPCTRANSPKEMaster利润中心主数据表COBKTRANSPK

3、ATransaction成本控制对象：凭证抬头COEJTRANSPKATransaction成本控制对象：与财政年度相关的各行项目COEJLTRANSPKATransaction成本控制对象：业务类型行项目（按财政年）COEJRTRANSPKATransaction成本控制对象：统计关键数行项目（按财政年）COEJTTRANSPKATransaction成本控制对象：业务价格行项目（按财政年）COEPTRANSPKATransaction成本控制对象：与期间相关的各行项目COEPBTRANSPKATransaction成本控制对象：行项目差异/基于期间的结果分析COEPLTRANSPKATra

4、nsaction成本控制对象：业务类型行项目（按期间）COEPRTRANSPKATransaction成本控制对象：统计关键数行项目（按期间）COEPTTRANSPKATransaction成本控制对象：业务价格行项目（按期间）COKATRANSPKATransaction成本控制对象：成本要素控制数据COKLTRANSPKATransaction成本控制对象：作业类型的控制数据COKPTRANSPKATransaction成本控制对象：主要计划控制数据COKRTRANSPKATransaction成本控制对象：统计关键数控制数据COKSTRANSPKATransaction成本控制对象：次级

5、计划编制的控制数据COSBTRANSPKATransaction成本控制对象：差异总计/结果分析COSBDTRANSPKATransactionCO 对象: 差异/待摊, 已结算的COSLTRANSPKATransaction成本控制对象：作业类型总计COSPTRANSPKATransactionCO 对象：外部记帐的成本总计COSPDTRANSPKATransactionCO 对象: 已结算初级成本总计COSRTRANSPKATransactionCO 对象：统计关键指数总计COSSTRANSPKATransactionCO 对象:内部过帐成本总计COSSDTRANSPKATransacti

6、onCO 对象: 已结算次级成本总计COSTTRANSPKATransaction成本控制对象：价格总计CSKATRANSPKSMaster成本要素 (数据与科目表相关)CSKBTRANSPKSMaster成本要素 (数据与成本控制范围相关)CSKSTRANSPKSSMaster成本中心主数据CSKTTRANSPKSSMaster成本中心说明文本CSKUTRANSPKSMaster成本要素文本CSLATRANSPKSSMaster作业主档CSLTTRANSPKSSMaster作业类型文本CSSKTRANSPKSSMaster成本中心/成本要素CSSLTRANSPKSSMaster成本中心/作业

7、类型EBANTRANSPMETransaction采购申请EBKNTRANSPMETransaction采购申请帐户设置EBUBTRANSPMETransaction有关物料的运输请求的索引EINATRANSPMETransaction采购信息记录 - 一般数据EINETRANSPMETransaction采购信息记录 - 采购组织数据EIPATRANSPMETransaction订购价格历史：信息记录EKABTRANSPMETransaction批准凭证EKANTRANSPMETransaction供应商地址: 采购凭证EKBETRANSPMETransaction采购凭证历史EKBZTRA

8、NSPMETransaction每个采购凭证的历史：交货费用EKES供应商确认EKETTRANSPMETransaction计划协议中的计划项目EKKNTRANSPMETransaction采购凭证中的帐户设置EKKOTRANSPMETransaction采购凭证:抬头EKPBTRANSPMETransaction采购凭证:"已供物料"项EKPOTRANSPMETransaction采购凭证:项目EKUBTRANSPMETransaction有关物料的库存运输单的索引ESKNTRANSPMETransaction服务包中的帐户分配GLT0TRANSPFGTransactio

9、n总帐科目主记录业务额IKPFTRANSPMBTransaction抬头：实地盘存凭证ISEGTRANSPMBTransaction盘点库存凭证项目KNA1客户主文件的一般数据KNASTRANSPFBMaster客户主数据（一般地区的增值税登记号）KNB1TRANSPFBMaster客户主数据 (公司代码)KNB4TRANSPFBMaster消费者收付历史KNB5TRANSPFBMaster客户主记录 (催款数据)KNBKTRANSPFBMaster客户主数据 (银行细目)KNC1TRANSPFBMaster客户主记录 (交易额)KNC3TRANSPFBMaster客户主数据 (特殊总帐业务额

10、)KNKATRANSPFBMaster客户主数据信贷管理: 中心数据KNKKTRANSPFBMaster客户主数据信贷管理: 控制范围数据KNMTTRANSPVAMaster客户-物料信息记录数据表KNMTKTRANSPVAMaster客户-物料信息记录标题表KNVATRANSPVVMaster客户主装货点KNVDTRANSPVDMaster客户主记录销售查询表KNVITRANSPVFMaster客户基本税指示符KNVKTRANSPVPMaster客户主要联系伙伴KNVLTRANSPVFMaster客户原执照KNVPTRANSPVPMaster客户主记录伙伴功能KNVSTRANSPVVMast

11、er客户主装运数据KNVTTRANSPVTMaster用于销售的客户主记录文本KNVVTRANSPVMaster客户主记录销售数据KONATRANSPVFMaster回扣协议KONDTRANSPVFMaster条件(数据)KONHTRANSPVFMaster条件(抬头)KONMTRANSPVFMaster定价( 1维数量等级 )KONPTRANSPVFMaster条件(项目)KONVCLUSTERVFMaster条件(事务数据)KONWTRANSPVFMaster条件(1 维值比例)LFA1TRANSPFBMaster供应商主数据 (一般地区)LFASTRANSPFBMaster供应商主数据

12、(增值税登记号的一般部分)LFB1TRANSPFBMaster供应商主数据 (公司代码)LFB5TRANSPFBMaster供应商主数据 (催款数据)LFBKTRANSPFBMaster供应商主数据 (银行细目)LFC1TRANSPFBMaster供应商主数据 (业务额)LFC3TRANSPFBMaster主供应商 (特殊总分类帐交易图表)LFM1TRANSPMETransaction供应商主记录购买组织数据LIKPTRANSPVLTransactionSD凭证 ： 交货抬头数据LIPSTRANSPVLTransactionSD凭证 ： 交货： 项目数据MAKTTRANSPMGMaster物料

13、描述(物料名称文本)MAPRTRANSPMGMaster有关预测的物料索引MARATRANSPMGMaster一般物料数据(物料主数据)MARCTRANSPMGMaster物料的工厂数据MARDTRANSPMGMaster物料的仓储位置数据MARMTRANSPMGMaster物料度量单位MARVTRANSPMGMaster物料控制记录MBEWTRANSPMGMaster商品评估MBEWH物料评估：历史MBPRTRANSPMGMaster生产仓位库存MCHATRANSPMGMaster物料批次MCHBTRANSPMGMaster批量库存(非限制使用的估价库存)MKPFTRANSPMBTransa

14、ction物料凭证：抬头MLANTRANSPMGMaster物料的税分类MLGNTRANSPMGMaster每一仓库号物料数据MLGTTRANSPMGMaster每一存储类型的物料数据MSEGTRANSPMBTransaction物料凭证：商品(行项目)MSKU客户的特殊库存MSTATRANSPMGMaster商品主记录状态MVERTRANSPMGMaster物料消耗量(损耗量)MVKETRANSPMGMaster物料销售数据NACHTRANSPVNTransaction细化的输出数据NASTTRANSPVNTransaction消息状态NBNKTRANSPFBOrganizational银行

15、的号码范围NKUKTRANSPFBOrganizational凭证自动编号范围OIB_TANKDIP油罐计量台帐OII_DIP_PARAM密度换算系数OII_DIP_QUAN油罐计量修正参数OIISOCISL库存对象特性: 库存地的索引/序号存取模式OIISOCKSOC: 存储对象特性段 :抬头(物料存储位置)OIISOCTSM分配相关时间 <-> 物料(库存地点时间段内存储的相关物料)PA0001人力资源主记录:信息类型0001 (原始分配)PA0002HR 主记录: 信息类型 0002 (人员数据)PAYRTRANSPFBZTransaction支付媒体文件(支付方式)PCEC

16、TRANSPFBZOrganizational支票编号范围(预先编号)REGUATRANSPFBZTransaction收付建议的更改: 用户和时间REGUHTRANSPFBZTransaction来自支付程序的结算数据REGUPCLUSTERFBZTransaction来自收付程序的处理项目REGUSTRANSPFBZTransaction科目被收付建议冻结REGUVTRANSPFBZTransaction对于收付程序的控制记录S995销售公司产品分配SKA1TRANSPFBMaster总帐科目主记录 (科目表)SKATTRANSPFBMaster总帐科目主记录（科目表：说明）SKB1TRA

17、NSPFBMaster总帐科目主记录 (公司代码)T001TRANSPFBOrganizational公司代码T001BTRANSPFBOrganizational允许的记帐期T001LTRANSPMGOrganizational仓储地点 (油罐/加油站)T001WTRANSPMGOrganizational96T005TRANSPFBOrganizational0T005TTRANSPFBOrganizational国家名T012POOLFBOrganizational开户行T012TPOOLFBOrganizational开户行帐户名T148T客户的特殊库存描述T179TRANSPVSOr

18、ganizational物料: 产品层次T179TTRANSPVTOrganizational材料: 生产等级: 文本T190O产品分配：产品分配对象的定义TBSLPOOLFBOrganizational冲销/冲销条目的过帐代码TBSLTPOOLFBOrganizational冲销/冲销条目的过帐代码名称TCURCTRANSPFBOrganizational货币代码TCURFTRANSPFBOrganizational转换因子(货币汇率)TCURRTRANSPFBOrganizational汇率TCURTTRANSPFBOrganizational货币代码名TCURVTRANSPFBOrgan

19、izational货币换算的兑换率类型TCURWTRANSPFBOrganizational汇率类型的使用TGSBTRANSPFBOrganizational业务范围TGSBTTRANSPFBOrganizational业务部门名称TVBUROrganizational销售办公室TVGRTOrganizational销售小组 名称TVKBTOrganizational销售办公室 名称TVKGROrganizational销售小组TVKOOrganizational销售组织TVKOT销售组织:名称TVTWT机构单位：分销渠道：文本VAKGUTRANSPVIND销售索引 ： 报价有效期VAKPAT

20、RANSPVIND销售索引 ： 按合作伙伴功能的订单VAPMATRANSPVIND销售索引 ： 按物料的订单项目VBAGTRANSPVATransaction销售凭证 ： 按计划协议中细目的批准数据VBAKTRANSPVATransaction销售凭证 ： 抬头数据VBAPTRANSPVATransaction销售凭证 ： 项目数据VBFACLUSTERVATransaction销售凭证流VBFSTRANSPVTransaction汇总处理的错误日志VBKATRANSPVCKTransaction销售活动VBKDTRANSPVATransaction销售凭证 ： 业务数据VBKOFTRANSP

21、VINDSD索引： 按合作伙伴功能的未确定销售活动VBKPATRANSPVINDSD索引： 按合作伙伴功能的销售活动VBLKTRANSPVLTransactionSD凭证 ： 交货单抬头VBLSTRANSPVLTransaction汇总处理的交货单VBPATRANSPVPTransaction销售凭证:合作伙伴VBRKTRANSPVFTransaction发票抬头数据VBRPTRANSPVFTransaction发票项目数据VBSKTRANSPVTransaction关于销售凭证抬头的汇总处理VBSSTRANSPVTransaction汇总处理： 销售凭证VBUKTRANSPVTransact

22、ion销售凭证 ： 抬头状态和管理数据VBUPTRANSPVTransaction销售凭证 ： 项目状态VBUVCLUSTERVTransaction销售凭证 ： 不完整性日志VEPVGTRANSPVIND交货到期索引VETVGTRANSPVIND库存调拔的交货到期索引VKAOFTRANSPVIND销售索引 ： 未确定的销售活动VKDFSTRANSPVINDSD索引： 出具发票的初始状态VLKPATRANSPVIND销售索引 ： 按合伙人功能的交货VLPMATRANSPVIND销售索引 ： 物料的交货项目VRKPATRANSPVIND销售索引 ： 按合作伙伴功能的票据VRPMATRANSPVI

23、ND销售索引 ： 每一物料的开票项目VTFATRANSPVATransaction装运凭证流VTRDITRANSPVIND装运计划索引字 典TableTableTypeApplicationClassDataClassDescriptionDDO2LTRANSPFBTransaction表DDO2TTRANSPFBTransaction表文本DD03DTRANSPFBTransaction表格字段的动态程序字段DD03LTRANSPFBTransaction表格字段DD03TTRANSPFBTransaction表格字段文本(语言依赖)DD04LTRANSPFBTransaction数据元素D

24、D04TTRANSPFBTransaction数据元素文本DD05STRANSPFBTransaction外来码字段DD06LTRANSPFBTransaction存储池或簇结构DD06TTRANSPFBTransaction存储池或簇结构的文本DD07LTRANSPFBTransaction域的最大/最小值DD07TTRANSPFBTransaction域的文本DD08LTRANSPFBTransaction关系定义DD08TTRANSPFBTransaction关系定义的文本ECCSTableTableTypeApplicationClassDataClassDescriptionTF10

25、0Financial Statement ItemsTF101FS items: short and medium textsTF102FS items: long textsTF103Breakdown CategoriesTF104Breakdown categories: NameTF105FS Item CategoriesTF106FS Item Categories: DescriptionTF110TRANSPKEMasterSubitem CategoriesTF111Subitem Categories: DescriptionTF115SubitemsTF116Subite

26、ms: short and medium textsTF117Subitems: long textsTF120TRANSPKEMasterConsolidation Charts of AccountsTF121Consolidation Charts of Accounts: DescriptioTF123Additional rules for running program SAPF124TF130FS item hierarchiesTF131Item hierarchies: NameTF140Selected FS ItemsTF150TRANSPKEMasterDimensio

27、nsTF151Dimensions: Texts and user-specific namesTF152Dimensions, screen list, consolidation unitsTF153Dimensions, screen list, consolidation groupTF154Dimensions year- and period-dependentTF155Dimensions: Assign Task GroupsTF160Consolidation UnitsTF161Consolidation units: textsTF162Consolidation uni

28、t 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

29、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-depend

30、entTF183Consolidation 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, peri

31、od-dependentTF193Hierarchies, version-dependentTF194Hierarchies, version- and period category-deTF195Hierarchy levelsTF196Hierarchy levels: textsTF197Hierarchy levels usedTF198Hierarchy level relationshipsTF199AOrganizational elementsTF199BOrganizational elements: TextsTF199CCharacteristic Values of

32、 Organizational ElemTF199DChar. Values of Organizational Elements: TexTF199EOrganizational Element RelationshipsTFIN010Consolidation Unit IntegrationECMCAEC-CS: Journal Entry table(Actual)CO TablesTableTableTypeApplicationClassDataClassDescriptionCEPCCOBKCOEJCOEJLCOEJRCOEJTCOEPCOEPBCOEPLCOEPRCOEPTCO

33、KACOKLCOKPCOKRCOKSCOSBCOSBDCOSLCOSPCOSPDCOSRCOSSCOSSDCOSTCSKACSKBCSKSCSKTCSKUCSLACSLTCSSKCSSLTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPTRANSPKEK

34、AKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKAKSKSKSSKSSKSKSSKSSKSSKSSMasterTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTransactionTra

35、nsactionTransactionTransactionTransactionMasterMasterMasterMasterMasterMasterMasterMasterMasterProfit 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:

36、 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: C

37、ost 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 Objec

38、t: 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 account

39、s)Cost elements (data dependent on controlling area)Cost center masterCost center textsCost element textsActivity masterActivity type textsCost center /cost elementCost center / activityFI TablesTableTableTypeApplicationClassDataClassDescriptionBKPFTRANSPFBTransactionAccounting document headerBNKATR

40、ANSPFBMasterBank master recordBSADTRANSPFBTransactionAccounting: Secondary index for customers (cleared items)BSAKTRANSPFBTransactionAccounting: Secondary index for vendors (cleared items)BSASTRANSPFBTransactionAccounting: Secondary index for G/L accounts (cleareditems)BSECCLUSTERFBTransactionOne-ti

41、me account data document segmentBSEGCLUSTERFBTransactionAccounting document segmentBSETCLUSTERFBTransactionTax data document segmentBSIDTRANSPFBTransactionAccounting: Secondary index for customersBSIKTRANSPFBTransactionAccounting: Secondary index for vendorsBSISTRANSPFBTransactionAccounting: Seconda

42、ry 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 p

43、ayment historyKNB5TRANSPFBMasterCustomer master (dunning data)KNBKTRANSPFBMasterCustomer master (bank details)KNC1TRANSPFBMasterCustomer master (transaction figures)KNC3TRANSPFBMasterCustomer master (special G/L transaction figures)KNKATRANSPFBMasterCustomer master credit management: Central dataKNK

44、KTRANSPFBMasterCustomer master credit management: Control area dataLFA1TRANSPFBMasterVendor master (general section)LFASTRANSPFBMasterVendor master (VAT registration numbers general section)LFB1TRANSPFBMasterVendor master (company code)LFB5TRANSPFBMasterVendor master (dunning data)LFBKTRANSPFBMaster

45、Vendor master (bank details)LFC1TRANSPFBMasterVendor master (transaction figures)LFC3TRANSPFBMasterVendor master (special G/L transaction figures)NBNKTRANSPFBOrganizationalNumber range for banksNKUKTRANSPFBOrganizationalNumber range for change documentsPAYRTRANSPFBZTransactionPayment transfer medium

46、 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