Data retraction from SAP BPC to SAP ECC

[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.

[former_member186338]

"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'

...

[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.

[former_member186338]

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

[former_member544285]

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.

[former_member544285]

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

[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.

[former_member186338]

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

[Former Member]

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.

[former_member186338]

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.

[former_member186338]

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.