Mapping two account into one

[Former Member]

Hello Expert,

I am using BPC 7.5 SP07. I want to aggregate the value of two or more account into one account. I have maintain following in Conversion files.

External - Internal Amount

10001.....10000...5

10002.....10000...6

Now, I want Amount 11 in the account 10000. But my account 10000 is showing only 6 (as it is replacing 5, instead of aggregating 5+6=11).

Please tell me, do I need to use any formula in conversion file.

Please advice

[Former Member]

Hi Aryan,

Are you sure about your query? We can always map many external IDs into one internal BPC ID. I can give an example of time mapping. There are 12 periods in BPC (APR-MAR) and all your special periods (in the source system like period 13-16) can be mapped to period 12 i.e. MAR in BPC (example).

Another example that we have is ....multiple store IDs in SAP can be mapped into a single store ID (internal) in BPC. The sales would aggregate in BPC.

What is not possible and would overwrite is - One external ID and if you want to that into multiple different internal IDs. It would only go into the last one. The first one would always get overwritten by the last one.

Please Check.

Thanks,

Sreeni

[Former Member]

Hi Sreeni,

In conversion files, I am able to map multiple external ID to one Internal ID, as you pointed out. You are also correct to say that first one would always get overwritten by the last on. But I want aggregation of all multiple ID value to one Internal ID from first to last i.e., all value should be merge instead of overwriting).

Please let me know if you could suggest any way to do this.

Best Regards

Aryan

[Former Member]

Many-to-one is not allowed in conversion file , so create first, one staging cube in bw itself.

Then in tranformation mappiing(bw side) map two accounts to single account via abap code.

Finally load data from staging cube to BPC application.

[Former Member]

Dear Naresh,

Thanks for your reply.

I will try and update you accordingly.

[Former Member]

Hi Aryan,

A simple way is to use the start routine in BPC transformation to do the mapping.

But you need to store the lookup values for account may be in master data while mapping in abap badi.

Regards,

Sachin

[Former Member]

Hello Sachin,

Thanks for the reply.

Your solution seems to be easier, Could you please elaborate it little more to proceed.

Best Regards

Aryan

[Former Member]

Hi Aryan,

Using start routines you can read the incoming data from BW cube and manipulate and map to the target account using abap badi.

So you need call the start routine in the transformation file,this option is the best provided you know abap well.

This sdn guide will help you know how to implement start routine.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/50c39fa1-6f95-2d10-2a95-b594de8e1...

Cheers,

Sachin