Copy sum of a KF to another KF at detail level

[Former Member]

Hello,

I'm looking for a macro function that allows me to copy/show the sum of a KF at detailed level to another KF.

What it's needed for:

We are planning for several SALESORGS.

At salesorg level, I want to see what's the sum of  KF for all salesorgs, so that the user get's a feeling what part his salesorg is from global.

Example:

product P1

salesorg1 S1

salesorg2 S2

Combinations:

P1-S1

P1-S2

P1-S1 has 1000

P1-S2 has 5000

I now want to copy the 1000 of S1 and the 5000 of S2 to a KF where the sum of 6000 is visible on all levels of P1.

Can anybody help me here?

Thanks in advance

Christoph

[former_member187488]

Hi, there's no standard macro function to acheive this. Maybe you can use a BADI macro, in which use BAPI_PBSRVAPS_GETDETAIL2 to get the requested value and put it into the key figure.

[Former Member]

Create a new KF where the structural disagg is set to E and no time based disagg (Say this is KF2)

create a macro that will copy data at aggregated level of KF1 to KF2. after the macro is executed, you will see that the the KF2 will have 6000 at detail level as well.

Do let me know if this works.

Ashutosh