【转】COPA重要的四张表CE1XXXX-CE4XXXX

COPA重要的四张表CE1XXXX、CE2XXXX、CE3XXXX、CE4XXXX ：

CE1XXXX: 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.

表CE1****存储实际行项目数据。此表存储CO-PA中所有实际过账的特征值、值字段值和盈利能力段。与实际行项目表一样，所有特征（包括技术T型特征）都包含在CE1****中并过账。您可以从行项目表创建钻取报告。但是你可以在一个冗长的过程中显示它。只有在绝对需要查看不属于段级别的特征时，才应访问行项目。

 

CE2XXXX: 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****.

表CE2****存储计划行项目数据。此表存储了CO-PA中所有计划过账的特征值、值字段值和盈利能力段。所有特征，包括技术T型特征，都包含在CE2****中并过账。

 

CE3XXXX: 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.

表CE3****以汇总形式存储数据。其中，表4****只存储特征组合，并创建获利能力段编号。CE3****存储值字段的值以及获利能力段编号。CE3****不存储任何实际的特征值（在E3****的数据库结构中没有特征字段），只有盈利能力段编号。CE3****还通过向下钻取报告来提高性能。

 

CE4XXXX : Table CE4**** is the profitability segment level table. CE4****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.

表CE4****是盈利能力段级别的表。CE4****存储所有可能的特征值组合（如已发布），并为每个组合分配一个盈利分配编号。盈利能力细分数字大大提高了向下钻取报告的性能。CE4****有一个标准索引和一个二级索引。SAP将确定哪个指数提供最佳性能。