Symptom:After apparently incorrect data was displayed in a report, you can inspect the data on the level of the physical tables (or views on this). As a result, you can make a decision on whether the error is to be searched for in the report definition or in the incorrect data. This way, the cause of the error can be significantly narrowed down, for example for a message to SAP, and its processing significantly speeded up.
Cause and prerequisitesSolutionReport RKACSHOW allows a data analysis of the tables relevant to CO reporting. The data for this can be selected in many ways.
Key:
* only from Release 3.0
() only up to Release 2.2
Selection screen:
---------------------------------------------------------------------
| Object number [1] |
| |
| Controlling area [2] |
| Cost center [3] |
| Activity type [4] |
| |
| Order / Network [5] |
| Activity [6] |
| |
| Project [7] |
| WBS element [8] |
| |
|*Sales order [9] |
|*Sales order item [10] |
| |
| Restrictions |
| Ledger [11] |
| Value type [12] |
| Version [13] |
| Fiscal year [14] |
| Cost element [15] |
---------------------------------------------------------------------
A group of specifications must always be made on the selection screen. The groups are also separated optically in the selection screen:
- [1] The object number contains all of the necessary specifications for the report
Report
- [2] - [4] create reports using a cost center / activity type
Example: we are intersted in cost center 2000 in
controlling area 0001. This cost center carries primary
costs so that the activity type remains empty.
- [5] - [6] create reports using an order and a business transaction
- [7] - [8] create reports using a project
- [9] - [10] create reports using a sales order
To restrict the data selected for the specified cost element itemization even further, the fields [11] - [15] are available. There is not a required entry here, unlike [1] - [10].
Example: You only want to see data from cost element 400000 and enter cost element 400000 for [15].
- ad [1] The object number consists of the object type (positions 1-2), and further specifications that are necessary for the unique identification of the cost object. The object number of a cost center (object type KS) contains the controlling area (positions 3-6) and the cost center name (from position 7) for the further functional specification.
Example:
Enter object number KS00010000002000.
- KS The cost object is a cost center
The object types are defined in the domain J_OBART
- ad [4] activity type
Apart from individual values, there are also the following possible entries here:
: Only activity-independent values are selected
* : All activity types are selected (as of Release 3.0)
- ad [9] only as of Release 3.0
- ad [10] only as of Release 3.0
The following selection screen appears after executing the report:
Selection screen
In the indented entries, line items are displayed and the totals records in the others. From the totals record display, you can branch back into the line item display. Choose the data list relevant for your case by double-clicking:
COKA cost element: Control data cost element
COKP cost element: Primary planned control data
COSPA cost element: Cost totals - ext.postings - all periods
COSPD cost element: Total ext.costs - settled from this
* COVP cost element: Line item period-related and doc.header
* COVJA cost element: line items by year + doc.header all periods
* COOI open items management: Line items
* V_COFP line items (cash flow) and document header
* COEPD cost element: Line item settlement nonvaluated w.status
* COEPBR cost element: Line item settlement valuated
COKS cost element: Secondary planned control data
COSSA cost element: Cost totals - int.postings - all periods
COSSD cost element: Total int.costs - settled from this
COVP cost element: Line item period-related and doc.header
COVJA cost element: line items by year + doc. header all periods
( COOI ) open items management: Line item
COKR cost element: Control data statistical values
COSRA cost element: Totals stat.key figures - all periods
COVPR cost element: OI stat. key figs - period-related + doc.header
COVJRA cost element: OI stat.key figures by year - all periods
COKL cost element: Control data activity type
COSLA cost element: Totals activity types - all periods
COVPL cost element: Line item act.types for each-rel.+doc.header
COVJLA cost element: EP OI act.types by year+ + CoCde - all periods
COSTA cost element: Totals activity prices - all periods
COVPT cost element: Line item act.prices for each-rel.+doc.header
COVJTA cost element: OI act.prices by year u. +doc.header - all periods
COSBA cost element: Totals variances/calculations of imputed costs - all periods
COSBD cost element: Totals for variances/imputed costs - settled from this
COVPB cost element: Line items for variances/imputed costs and document header
*COANZ index 'Objects for which down payment requests were made
*FMSU FI-FM totals records
* V_COFP line items (cash flow) and document header
*RPSCO project information database: Costs, revenues, finances
Importance of some tables:
COSPA = CO table Totals records Primary costs
All periods = CO-external postings (for example from FI)
COSSA = CO table Totals records Secondary costs
All periods = CO-internal postings (for example,
from internal activity allocation, distributions and so on)
COVP = CO tables View (line items COEP and
line item document headers COBK) Period-related
COSRA = CO table Totals records of the statistical
key figures from All periods
COSLA = CO table Totals records Activity types
All periods
Example:
Display after double-click on COSPA:
---------------------------------------------------------------------
| Objekt.............. KST 0001 2000 General Cost Center |
| File COSPA |
| ----------------------------------------------------------------- |
| LEDNR OBJNR GJAHR WRTTP VERSN KSTAR |
| ----------------------------------------------------------------- |
| 00 KS00010000002000 1995 04 000 0000400000 |
| ----------------------------------------------------------------- |
| HRKFT VRGNG VBUND PARGB BEKNZ TWAER |
| ----------------------------------------------------------------- |
| COIN H DEM |
| COIN S DEM |
| COIN 999999 S DEM |
---------------------------------------------------------------------
you can now choose a data record by double-clicking and display all the fields of the data record:
---------------------------------------------------------------------
| Objekt.............. KST 0001 2000 General Cost Center |
| Field contents COSPA |
| ----------------------------------------------------------------- |
| Field name Field contents |
| ----------------------------------------------------------------- |
| LEDNR 00 |
| OBJNR KS00010000002000 |
| GJAHR 1995 |
| WRTTP 04 |
| VERSN 000 |
| KSTAR 0000400000 |
| HRKFT |
| VRGNG COIN |
| VBUND |
| PARGB |
| BEKNZ H |
| TWAER DEM |
| MEINH kg |
| WTG001 2,001,150.00- DEM . . . WTG016 0.00 DEM |
| WOG001 2,150.00- DEM . . . WOG016 0.00- DEM |
| WKG001 0.00 DEM . . . WKG016 0.00 DEM |
| WKF001 0.00 DEM . . . WKF016 0.00 DEM |
| PAG001 0.00 DEM . . . PAG016 0.00 DEM |
| MEG001 0.000 . . . MEG016 0.000 |
| MEF001 0.000 . . . MEF016 0.000 |
| MUV001 X . . . MUV016 X. |
---------------------------------------------------------------------
The importance of the individual fields can be found in the ABAP/4 dictionary (transaction SE11).
Example:
1. Field WRTTP
- Importance of the field WRTTP ?
Procedure: SE11, table COSPA, ->
==> Result: WRTTP = value type
- Possible values of the field WRTTP ?
Procedure: SE11, table COSPA, -> Fields -> Double-click on WRTTP -> Data element -> Domain -> Fixed values
==> Result:
01 Plan
04 Actual
05 Target
10 Statistical plan
11 Statistical actual
...und others.
2. Field VRGNG
- Importance of the field VRGNG ?
Procedure: SE11, table COSPA, -> Fields
==> Result: VRGNG = CO activity
- Possible values for VRGNG ?
Procedure: SE11, table COSPA, -> Fields -> Double-click on VRGNG -> Data element.
==> Result: Value table T022 or TJ01
Further procedure:
SE16, table T022 ==> display possible values
SE16, table T022T (T for texts) ==> Display possible values and
their meaning.
3. Meaning of some fields:
WKGxxx = Value in Controlling area currency Total
MEGxxx = Quantity Total
xxx = Periods in the period block (PERBL).
For periods <= 16: PERBL = 16
Application:Execute a cost center cost element report in controlling area 1. Incorrect values are displayed for a cost center 2000 for cost element 400000. You now want to check whether this is due to incorrectly posted data in the database Call transaction SE38 and execute report RKACSHOW. Enter KS00010000002000 as a cost object number or 1 for controlling area and 2000 for the cost center. Since it is primary costs for cost element 400000, do not enter an activity type. Execute the report. In the selection screen that now follows, choose COSPA. In the display of the totals records, you can now choose a data record and display the values of the individual fields (double-click or 'Details') or change to the line item display ('Line item'). From there, you can also display the documents for the line items, subdivided into document headers and line items.
Explanation of some of the fields of RPSCOTable RPSCO is the basis of all drilldown reports in the
Project System. This is also called the project information database.
Field Explanation
-----------------------------------------------------------------------
OBJNR Internal object consisting of
an object type and number
LEDNR Values in a ledger are updated in
one currency.
Example:
Controlling area currency USD in ledger number 0001
Object currency DEM in ledger number 0002
Posting of 300 USD in period 8.
Exchange rate DEM/USD: 1,5
LEDNR TWAER WLP008 WTP008
0001 USD of 300 300
0002 USD 450 300
WRTTP Value type (plan = 01, actual = 04) see fixed values of the domain)
TRGKZ Object indicator
The object indicator is used for classification of the
costs objects.
ACPOS Value category
The value category consists of a group or
a range of cost elements and/or commitment items.
VORGA business transaction (see Transaction BS33)
VERSN Plan version (0=original plan)
ABKAT Category variance/calculation of imputed costs
(for example 01 = price variance, 04 = quantity variance)
BELTP Debit category
0
1 Costs and credit payments
2 Revenues and debit payments
3 Balance sheet item
Additional key words Reporting, example error messages:
GR392 Row & in key figure block & does not contain any data
GR438 No appropriate selection entries exist
GR463 No values were found in the selected interval
GR551 No data exists for your selection
GR601 & & does not contain any data pages
GR605 List is empty (function cannot be executed)
incorrect data, no data, Report Writer, incorrect numbers, instructions, information ----- SUPPORTGUIDE 20010411140028 -----
REPORTWRITER, SGRW_AMOUNT, SGRW_RC_STRUCTURE, SGRW_DATA
SGRW_OM