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

DP sum with aggregation level

In DP I have a history of sales loaded at various plants in the keyfigure 9AVHISTORY. For example, the product 10 has the sales history in the plants 1001, 1002 and 1003.

How to use a macro, or something else, I can get the amount of the sales history of all plants on a characteristic combination of product 10 plant 1001?

Input:

Sales history:

Product 10:

Plant 1001 - 100

Plant 1002 - 300

Plant 1003 - 900

Desired result:

Product 10:

Plant 1001: 1300

Will be useful for any information on this topic.

Using Macros \ copying TS \ something else.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 07:54 AM

    hi Alexander

    You could also consider using realignment for achiving the desired result. You can use the addition logic to add the data from the source CVC to the destination CVC so that sum is displayed on the CVC. you can read more on alignment on the below link.

    http://help.sap.com/saphelp_apo/helpdata/en/c7/cf8f39bab68350e10000000a114084/frameset.htm

    Let me know if this helps.

    Thanks, Sandeep

    Add a comment
    10|10000 characters needed characters exceeded

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.