SAP获利能力报表常用Tcode的区别

1. KE30：执行报表，COPA的常用报表（实际数据和计划数据），即：实际数据报表和计划数据报表可在KE30中显示。

2. KE91和KE31的区别：KE91是用来创建基于行项目的COPA报表（数据取自行项目表CE1XXXX和获利段表CE4XXXX，其中：XXXX为经营范围代码）；KE31是用来创建获利能力段的报表（该类报表的特性只能取KEQ3/KEQ4中的可用的获利能力特性，若KEQ3中将某特性设置为不可用，则KE31中无法取到该特性的信息），其数据取自获利段级别的数据表CE3XXXX和获利段数据表CE4XXXX。KE94与KE34的区别与此相同。

3. KE24与KE25的区别：KE24是取获利能力表的实际数据行项目，而KE25是取获利能力表的计划数据行项目。

4. KE30/KE24/KE25等COPA标准的报表，无法使用排除某个值来进行报表查询的，这主要是考虑到系统运行性能问题（即便排除了某个值，系统输出的报表也会将排除的值显示出来）。如果需要排除某值的查询，只能使用SE16/SE16N对COPA的数据表CE1XXXX-CE4XXXX进行查询.

COPA中常用四张表的CE1XXXX/ CE2XXXX/CE3XXXX/ CE4XXXX的解释如下：

CE1****: Table CE1**** stores actual line item data. This table stores allvalues—characteristic values, value field values, and the profitability segmentfor all actual posting in CO-PA. As with the actual line items table, allcharacteristics, including technical T-type characteristics, are included andposted to in CE1****. You can create drill-down reports from the line itemtables. You can display line items in CO-PA, but it is a veryperformance-exhaustive and lengthy process. You should access line items onlywhen you absolutely need to view characteristics that are not part of thesegment level.

CE2****: Table CE2**** stores plan line item data. This table stores allvalues—characteristic values, value field values, and profitability segment forall plan posting in CO-PA. All characteristic, including technical T-typecharacteristics, are included and posted to in CE2****.

CE3****: Table CE3**** stores data in its first summarized form. Where tableCE4**** stores only combinations of characteristics and creates a profitabilitysegment number. CE3**** stores the values of value fields along with theprofitability segment number. CE3**** does not store any actual characteristicvalues (there are no characteristic fields in the database structure ofCE3****), only the profitability segment number. CE3**** is also utilized bydrill-down reporting to enhance performance.

CE4****: Table CE4**** is the profitability segment level table. CE4SINO storeseach possible combination of characteristic values (as they are posted) andassigns each combination a profitability segment number. Profitability segmentnumbers greatly enhance performance on drill-down reporting. CE4**** comes witha standard index and a secondary index. SAP will determine which index providesthe best performance.

也可以参考SAP Library:http://help.sap.com/saphelp_46c/helpdata/en/74/e3a226e64e11d1a5300060087a7a87/content.htm

CE4****_ACCT与BSEG的关系（CE4****_ACCT的具体解释参阅SAPNote:199467）：

BSEG-PAOBJNR = CE4****_ACCT-PAOBJNR

CE4****_ACCT-CE4KEY = CE4****-PAOBJNR

CE4****-PAOBJNR = CE1****-PAOBJNR

 

行项目表 ：COVP (COEP& COBK),  

covp-PAOBJNR  =  CE4****-PAOBJNR

（此部分在获利率报表中很有用）