Problems with manual results analysis
Note: In addition to 'results analysis', the term 'work in process' will also be used.
Missing documentation
Manual results analysis is briefly described in the following.
(1) Entering results analysis data for manual additions and changes
(1.1) - with transactions KKA1, KKA2 und KKA3
(1.1.1) - in periodic display
(1.1.2) - in cumulative display
(1.2) - with transactions KKA4, KKA5 and KKA6 (Rel. 2.2 or higher)
(1.3) - with and without derivation of the cost of sales
(2) Deleting manual results analysis data
(3) Interaction of automatic and manual results analysis with
(3.1) - manual additions
(3.2) - manual changes
(4) Display in reporting
(4.1) - with the cost element report (projects, Rel. 2.2 or higher)
(4.2) - with the cost/revenue structure report (projects only)
(4.3) - with the line-item report
(4.4) - with your own reports
(5) Transfer of old data with the transactions KKA4, KKA5 and KKA6
(Rel. 2.2 or higher)
(6) Manual entry of the cost of sales (Rel. 3.0)
(6.1) - Enter with transactions KKG1, KKG2 and KKG3
(6.2) - Interaction with automatic results analysis - derivation of the
work in process and the reserves for unrealized costs
(6.3) - Display in reporting
(7) Currencies
(8) Known errors in manual results analysis
Entering results analysis data for manual additions and changes with transactions KKA1, KKA2 and KKA3
Results analysis for single objects is carried out with transactions KKA1 - KKA3. From the first screen after the transaction is called up, the protocol screen, you go into manual results analysis. A list with all results analysis data in cumulative form is displayed. Choosing Display -> By period' (or 'Display -> Not cumulative' in Rel. 2.1 and Rel. 2.2) you go into the display by period. In these lists you can page and enter the results analysis data manually.
Entering results analysis data in periodic display
Example:
Assume the following initial situation:
Period 1 2 3
Value manual by period 100 50 50
Value manual cumulative 100 150 200
You change only the values of period 2 in the periodic display from 50 to 60:
Period 1 2 3
Value manual by period 100 60 50
The system then calculates the following cumulative values:
Period 1 2 3
Value manual cumulative 100 160 210
The result is that a value of 10 is added in period 2.
Entering results analysis data in the cumulative display
Example:
Assume the following initial situation:
Period 1 2 3
Value manual by period 100 50 50
Value manual cumulative 100 150 200
You now change the values of period 2 in the cumulative display from 150 to 160:
Period 1 2 3
Value manual cumulative 100 160 200
The system then calculates the following values by period:
Period 1 2 3
Value manual by period 100 60 40
The result is that in period 2 a value of 10 is added and in period 3 a value of 10 is subtracted.
Entering results analysis data with transactions KKA4, KKA5 and KKA6
Transactions KKA4 to KKA6 are available starting with Release 2.2. You can use these transactions to add manual results analysis data.
Example:
Assume the following initial situation:
Period 1 2 3
Value manual by period 100 50 50
Value manual cumulative 100 150 200
To add the value 10 to period 2, call up the transaction, enter the period 2 and the object number, and continue to the list for entering data. In the list you enter the value 10 and fill in the fields 'Typ', 'CUC' and 'LID'. After saving, you have the following new situation:
Period 1 2 3
Value manual by period 100 60 50
Value manual cumulative 100 160 210
Manual entry of results analysis data with and without derivation of the cost of sales
With automatic results analysis, for each line ID the relationship (1.A) holds:
(1.A) Actual costs
- Work in process
+ Reserves for unrealized costs
= Cost of sales
If you did not switch off the 'COS freely' indicator (cost of sales freely) in Customizing for results analysis, then you cannot manually change the cost of sales. The system calculates the change on the basis of the manual change to the work in process and the reserves, so that relationship (1.A) remains valid.
If you switched off the 'COS freely' indicator in the valuation method, then you can also manually change the cost of sales. Whether relationship (1.A) is then still valid depends on your manual changes.
Deleting manual results analysis data
Manual results analysis data that you entered as described in section 1 can be reset in the same way for specific periods.
Starting with Release 2.2 you can delete an object's entire manual results analysis data at once with transactions KKA7, KKA8 and KKA9.
Interaction of automatic and manual results analysis
In Customizing for results analysis with the valuation methods there is the field 'Manual RA' (manual results analysis). This field can have the setting 'Z' (manual addition) or 'E' (manual change).
Interaction with manual additions
If you have set the valuation method to 'manual addition', automatic results analysis is not affected by manual changes.
Interaction with manual changes
If you set the valuation method to 'manual change', the manual changes of the closed periods are automatically cancelled in the first open period. This method is used with final results analysis.
Example:
Period 1 is the closing period. Results analysis was started for period 3. The following values result:
Period 1 2 3
Value automatic by period 1000 500 500
Value manual by period 0 100 0
Value automatic cumulative 1000 1500 2000
Value manual cumulative 0 100 100
Value total cumultive 1000 1600 2100
The closing period is now set to period 2. When results analysis is now carried out for period 3, the following values result:
Period 1 2 3
Value automatic by period 1000 500 400
Value manual by period 0 100 0
Value automatic cumulative 1000 1500 1900
Value manual cumulative 0 100 100
Value total cumulative 1000 1600 2000
In period 3 the automatic value was reduced by 100. That is the amount that was manually added in period 2. The period values are stored in the database.
Note: Maintain the closing period in Customizing for results analysis in the version. Starting with Release 2.2 you can change the closing period through the application menu.
Display in reporting
For better understanding you should know the following: The values from manual results analysis are saved under the same cost element as the values from automatic results analysis. The only difference is that the values of the manual changes are edited under operation KABM and those of the automatic results analysis under KABG. In each case the period values are saved in the database. If you wanted to have the manual changes under a separate results analysis cost element, you would have to reserve separate line IDs.
Display in reporting with the cost element report
With the cost element report you can display the results analysis data according to cost element for specific periods. For projects, this report is available in Release 2.2 or higher.
Up to and including Release 2.2, the cost element report cannot use the operation as a means of differentiation, so the manual and automatic values cannot be displayed separately here.
In Release 3.0 the report for the orders and the sales orders can use the operation as a means of differentiating.
When you have entered manual values with cumulative display, as described under 1.1.2, you can only see the manual changes if the report does not cumulate the values from periods 2 and 3. The manual changes of the two periods would add up to zero.
Display in reporting with the cost/revenue structure report
This report is only for projects. You can see the results analysis data arranged according to cost elemlent groups but there is no breakdown according to period. You can only see the manual changes that were entered with the method described under (1.1.1) and (1.2) The manual changes under as described under (1.1.2) cannot be shown here because they always add up to zero.
Display in reporting with the line-item report
If updating line items is switched on in the definition of the results analysis version, the changes to the results analysis data of a results analysis run are logged in the form of line items.
For orders, there is at present only a standard line-item report that evaluates the line items of a results analysis run. The operation is not shown, so no distinction is made between manual and automatic changes.
Display in reporting with your own reports
The results analysis data are in table COSB. The automatically calculated values are marked with COSB-VRGNG = 'KABG' and the manual changes with COSB-VRGNG = 'KABM'. KABG and KABM are operations.
The line items of the results analysis are in table COEPB, the header of the line-item document in table COBK. The operation is shown in the field COEPB-VRGNG.
Transfer of old data with transactions KKA4, KKA5 and KKA6
In Release 2.2 or later, you can bring the data into your old system through the batch input interface with transactions KKA4, KKA5 and KKA6. To do this you must go into Customizing for results analysis and turn on the 'Transfer old data' switch. The old data accessed in this way are then written to the object as if they had been automatically calculated. Old data can only be captured for an object in one period.
Manual entry of the cost of sales
In Release 3.0 it is possible to manually enter the cost of sales. Automatic results analysis then calculates the work in process and the reserves.
Entry with transactions KKG1, KKG2 and KKG3
Transactions KKG1, KKG2 and KKG3 are used to enter the cost of sales manually. In these transactions you can enter the cost of sales for each line ID, or enter the total value under any line ID which is then distributed to the individual line IDs by automatic results analysis.
Interaction with automatic results analysis - derivation of work in process and reserves for unrealized costs
The apportionment of the manually entered cost of sales to the line IDs can be accepted as is or automatically split up equivalent to the planned or actual data.
Work in process and reserves for unrealized costs are calculated from the different between the actual costs and the cost of sales, just as with other similar results analysis methods.
Display in reporting
The manually entered costs of sales are updated under the same cost elements as the values in automatic results analysis, but under the special operation 'KABF'. For display in reporting, see the explanations in section (4).
Currencies
The results analysis data are always carried in the controlling area currency. In Release 3.0 they are also carried in company code currency.
If the company code currency is not the same as the controlling area currency, please observe the following:
With transactions KKA4 to KKA6 and KKG1 to KKG3, the results analysis data are always entered in the controlling area currency, converted to the company code currency when the function 'Save' is called up, and updated in both currencies.
With transactions KKA1 to KKA3 the data are first processed in the controlling area currency, converted when the Save function is called up, and finally offered for editing in the company code currency. When the converted values are manually changed again in the company code currency, the changes are not converted back into the controlling area currency. Calling up the Save function updates the data.
Known errors in manual results analysis
Note 18449, 'Manual results analysis, periodic display',
Release 2.1A - 2.1J and 2.2A - 2.2D
Note 18874, 'Manual results analysis, cumulated display',
Release 2.1* and 2.2A - 2.2D
No comments:
Post a Comment