Skip to Content
author's profile photo Former Member
Former Member

CO-PA Top down distribution for account based profitability based on cost element

I am trying to perform a top down distribution in account based profitability analysis. I am repeatedly receiving error message KG338 No entries exist using ERP 6.0 EHP7.

I am very much concerned that my screens for Processing instructions and Selection criteria do not exactly match those in "Yes, You Can Use Top-Down Distribution with Account Based CO-PA", which appeared in Financial Expert, May, 2015, fairly recently..

I haven’t been able to find an example of an account based TTD based on cost element (rather than quantity).

The available documentation seems to focus on costing based profitability, and the one example I found in the above article used quantity as the basis for distribution, not cost element.

I have successfully posted two general ledger entries on 01/01/2017:

One journal entry is reference data using the following fields, all of which have values:
Company code
Sales organization
Material group
Sales employee
Account which is 615101 Accrued commission expense

The second journal entry (to be distributed) has only the following fields populated, all the others are blank.
Company code
Sales employee
Account which is 615100 Commission adjustments

I have used document flow to verify that indeed both of these documents were posted to PSG profitability segments.

I am trying to populate sales organization, customer, material group, and product characteristics based on the characteristics for cost element 615101, but to retain the original cost element 615100..

Note that the account numbers are different.

Here are the settings I’ve made:

Initial Screen

Actual data 001/2017 to 001/2017
Reference data 001/2017 to 001/2017
Actual data (X)
Reference base Val/CO Area currency
Test run (X)

Processing instructions

Sales org
Material group

Copy (retain)
Company code
Business area
Cost element (I want retain original cost element 615100, not change it)

All other characteristics

Selection criteria (I’ve tried all three, none of them work)

Cost element = From: 615100 To: Blank
Cost element = From: 615100 To: 615101
Cost element = From: 615101 To: Blank

Reference base selection

Source 615101
-> A little arrow, the significance of which escapes me
= The equal sign
Reference data 615100

Value fields
(X) WKGBTR Val/COArea currency

I clicked [Check] icon and no errors were found.
Next I saved these values as a variant, then [Execute]

Message: No entries exist (KG338)

The displayed logs are completely empty.

Can anyone suggest what settings should be changed so that that this top down distribution will work?

Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.