Skip to Content

Data retraction from SAP BPC to SAP ECC

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 27, 2017 at 09:40 AM

    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.

    Add comment
    10|10000 characters needed 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.

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 27, 2017 at 08:22 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 27, 2017 at 01:03 PM

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

    ...

    Add comment
    10|10000 characters needed characters exceeded

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