SAP获利能力报表常用Tcode的区别
KE30:執行報表,COPA的常用報表(實際數據和計劃數據),即:實際數據報表和計劃數據報表可在KE30中顯示。
KE91和KE31的區別:KE91是用來創建基于行項目的COPA報表(數據取自行項目表CE1XXXX和獲利段表CE4XXXX,其中:XXXX為經營范圍代碼);KE31是用來創建獲利能力段的報表(該類報表的特性只能取KEQ3/KEQ4中的可用的獲利能力特性,若KEQ3中將某特性設置為不可用,則KE31中無法取到該特性的信息),其數據取自獲利段級別的數據表CE3XXXX和獲利段數據表CE4XXXX。KE94與KE34的區別與此相同。
KE24與KE25的區別:KE24是取獲利能力表的實際數據行項目,而KE25是取獲利能力表的計劃數據行項目。
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
(此部分在獲利率報表中很有用)
?
總結
以上是生活随笔為你收集整理的SAP获利能力报表常用Tcode的区别的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: SAP财务报表不平之分析
- 下一篇: SAP一句话入门:Human Resou