SAP BPC Comment Functionality

[Former Member]

Hi Expert,

While the copy the TXN data user want to copy the comment also is there any possible functionality provide by bpc while copying the TXN data comment also copied.I try to find out possible solution in SCN but  I can't find sufficient discussion on it.I just want to know is it possible without any ABAP enhancement.

Regards

Khokan

[Shrikant_Jadhav · Accepted solution]

Hi Khokan,

Copying transaction data and copying comments are two different process chains.

As standard functions you can not do this in one go. You need to write  BADI.

Shrikant

[Former Member · Accepted solution]

Hi Shrikant,

Thanks for your quick reply.I want to know some more thing after implement badi can I use existing  copy package function for copy both TXN data and Comment function, or need to create new process chain for copy the both functionality.

Thanks

Khokan

[damovand · Accepted solution]

Hi Shrikant,

You cannot copy comment along with transaction data.  In BPC comments are stored in a different table than transaction data. That is why at any time you will have to treat comments separately.

In BPC transaction data are stored in Fact tables but comments are stored in a table that is dynamically generated and holds only comments. The copy package will act only on the Fact table. 

Please let me know if you are interested to know more.

Best Regards,

Leila

[gajendra_moond · Accepted solution]

Hi Leila

In APO, you can update external comments only in planning book via BADI. I believe an equivalent must be available for BPC that can be called to update the comments table to do the same.

An alternate solution -  You can leverage VBA to generate a comments file as per the structure of comments table.

Create an input template and then use VBA to populate comments on ithe same ntersection cells based on the previously generated file and save. This will be a one time activity to update your comments table of the existing comments.

[damovand · Accepted solution]

Hi Gajendra,

There are many ways to update comments in BPC but I think this particular question was in regard to copying comments using BPC standard copy package which is not possible.

Best Regards,

Leila

[Former Member · Accepted solution]

Hi Leila & Gajendra,

Thanks for your reply my question is while copying the transaction data user want to copying the comment function also to different category, like plan to forecast.Currently they are doing this by manual excel vlookup function. I want to know if it possible by VBA then send me some more details like coding and how to setup inputschedule etc.

Regards

Khokan

[Former Member · Accepted solution]

Hi Khokan,

There is a standard copy comment package, what you can try is to link the standard copy data package with the copy comment package in a package link.

no need for BADI, all out of the box.

Andy

[Former Member · Accepted solution]

Hi Andy,

Yes you are right there is one standard package available in DM.I need your some more help. Is there any extra configuration needed for copy the comment function from one version to another version?If needed kindly guide me how I configure it or any document available for this functionality. Again thanks for your valuable solution.

Thanks

Khokan 

[Former Member · Accepted solution]

Hi Khokan,

You just need to add the package to your data manger. no extra configuration is required.

When you run the package it will ask you what data you want to copy, and yes, you can copy from one version to another.

Just run the package and you will see.

Andy

[Former Member · Accepted solution]

Hi Andy

I Just test the data manager package and it's work fine.Thanks a lot have a nice day.

Thanks

Khokan