Skip to Content
0

Data retraction from SAP BPC to SAP ECC

Nov 27, 2017 at 07:58 AM

245

avatar image
Former Member

Hello,

I would like to retract plan data from SAP BPC to ECC, so that the actual vs plan data can be compared in ECC.

At first data needs to be copied from BPC cube to a new BW cube. The data from this cube is retracted to an ECC table using remote function call(RFC)

To achieve this, whether can I use the existing standard/ Z tablein ECC or do I need to create a new table for this mapping.

Also let me know if there is any other method through which I can achieve retraction.

Regards,

bharadwaj.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

avatar image
Former Member Nov 27, 2017 at 09:40 AM
0

Hi vadim,

Thank you. Need more clarification on whether I can use the standard / Z table or do I need to create a new table for retraction. Request you to elaborate the process of extraction through RFC.

Thanks,

bharadwaj.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Please explain what do you want to retract!

"I can use the standard / Z table or do I need to create a new table for retraction" - meanigless without understanding of the business process.

0
avatar image
Former Member Nov 27, 2017 at 10:30 AM
0

Hi Anjaneya,

Firstly you need to know what data are you going to retract to ECC - Cost/Revenue?

Secondly research for the standard function available to post the data. If not available, consider developing custom function and make it RFC-enabled

Then lastly create BADI in enhancement spot "UJD_RETRACT". From BPC, execute DMP /CPMB/EXPORT_TD_TO_BADI. This will trigger the BADI you created.

Hope it helps

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Hendry,

I would like to retract both Cost and Revenue data from BPC to ECC. How to create a custom function and what's the use of this function.

Thanks,

Bharadwaj.

0

From my own experience: custom logic badi can be more useful compared to UJD_RETRACT (scope can be set in script logic).

0
Vadim Kalinin Nov 27, 2017 at 08:22 AM
0

Unfortunately the link:

https://archive.sap.com/documents/docs/DOC-4229

is not working, please request the correction in Using SAP.com tag.

You can also create a custom logic badi to do the same.

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Nov 27, 2017 at 01:03 PM
0

"I would like to retract both Cost and Expense data from BPC to ECC. How to create a custom function and what's the use of this function."

Sample from retract document mentioned in my answer:

"In this guide, we will show you how to use the BPC NW Retraction BAdI to post primary costs back to
SAP ERP Cost Center Planning with a Cost Center Planning BAPI."

...

call function 'BAPI_COSTACTPLN_POSTPRIMCOST'

...

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you vadim. I will create a custom BAPI(Which is RFC enabled) as per the requirement. This retraction data will be posted to which table in ECC?

Thanks,

bharadwaj.

0

"which table in ECC" - "as per the requirement" (not clear!)

0
Former Member

Anjaneya - make sure you know what you're doing. If you're not sure which table - then probably someone else has to create the function for you. Perhaps someone who is familiar with CO module

As Vadim mentioned, 'BAPI_COSTACTPLN_POSTPRIMCOST' is used to post cost and this should serve your requirement well if you're looking for retracting cost/expense.

0