on 11-12-2007 9:50 PM
I'm trying to find out how a field used in a current report is defined. For example, columns 2-13 are monthly columns. Double clicking on the column name (April), for example, brings up the box "Element Definition: April;$Year. The Value Field is Net Sales. Clicking the drop down box brings up a group of fields, including Net Sales.
The Field Name for Net Sales is MA0001. How do I find out how this field is defined and what accounts are included in it?
Thanks for any help you can give.
Hi
For COPA, these values are coming from Key figure schemes. You have to define the elements of the key figure "net sales", etc. It is available in COPA information system>Report Components.
S Jayaram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thank you for your answer. I was able to track 'Net Sales' as a part of a Key Figure Structure and as an element of Key Figure 'Net Sales'. However, when I get into CO-PA, Information System, there is no line for 'Report Components'.
There are the following lines/folders: Display Line Item List, Define Report,Current Settings, Background Processing. I looked at all the possibilities in those line items/folders and nothing was there. Is there another way to get at it?
Thanks again.
It is there in Information system>Report components>Define Key figure schemes
S Jayaram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
A report painter works basically with key figures and characteristics from a table. The table is assigned to a library.
When you double click the column name April, you would certainly see a basic key figure. This key figure together with certain characteristics decides what value to appear when the user runs the report. Here 'period' is the main characteristics. Period together with the year makes sense. The year can be given either in the General Data Selection (Edit > Gen.Data Seln.) or individually in every period column.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.