Skip to Content
avatar image
Former Member

BPC Data Load from ECC System

Hi All,

We are on BPC 10.0, SP 7 NW Version.

We are taking data from SAP ECC System to BW System and from there, we are picking data to BPC System.

In BPC, we don't need all the transactional data from BW. We need only data that are part of Balance Sheet and P&L Statement.

Is there a way to filter out only those account to get loaded to BPC? I am getting error while loading from BW, as I didn't defined all BW Master data into BPC System.

Appreciate your inputs on this.

Thanks,

Sonti

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 19, 2012 at 12:53 AM

    Hi,

    You can use process chain /CPMB/LOAD_INFOPROV_UI to load transaction data from BW infoprovider by selection.

    Thanks,

    Raju

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2012 at 04:30 AM

    Hi Sonti,

    When you are importing Transaction data from BW to BPC, the master data has to be in sync or you have to maintain Conversion file.

    In GL_Account do you have any indicator for P&L and BS account. If you have then while running the DM Package you can set filter accordingly, so that only P&L and BS transaction data are extracted.

    Hope this helps.

    Regards,

    Priyanka

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2012 at 05:05 AM

    Hi Nagendra,

    If you want to load only certain accounts, you need to skip the rest. And this can be really difficult to maintain in BPC conversion.

    Since you are using NW, it would be easier to do this restriction in BW itself. You can have a cube with the same structure of you BPC application. Load the data from original cube to this BW cube. Use start or end routines or transformations using BADI, to do all the data massaging, and then finally load this data to BPC application.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded