
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 gmentfor 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 thegment level.
CE2****: Table CE2**** stores plan line item data. This table stores allvalues—characteristic values, value field values, and profitability gment 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 profitabilitygment number. CE3**** stores the values of value fields along with theprofitability gment number. CE3**** does not store any actual characteristicvalues (there are no characteristic fields in the databa structure ofCE3****), only the profitability gment number. CE3**** is also utilized bydrill-down reporting to enhance performance.
CE4****: Table CE4**** is the profitability gment level table. CE4SINO storeach possible combination of characteristic values (as they are posted) andassigns each combination a profitability gment number. Profitability gmentnumbers greatly enhance performance on drill-down reporting. CE4**** comes witha standard index and a condary index. SAP will determine which index providesthe best performance.
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
(此部分在獲利率報表中很有?)