cancel
Showing results for 
Search instead for 
Did you mean: 

Download BPS Plan data to Excel

Former Member
0 Kudos

Hello everyone,

I am wondering if BPS plan data can be downloaded to an excel format and then upload to BCS?

We are currently using an R/3-based BCS and wants to feed the plan data from BPS to BCS. I know that BCS will take excel formatted data load but any other suggestion to load BPS data to BCS will also be greatly appreciated. (We are currently going to BW version 3.1 and does not have the retractors in BW to bring data over from BPS to BCS.)

Thank you very much in advance for all your help,

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Eric,

You can save BPS as a local Excel file...

Just use the Save or Save as in the Excel menu line rather than the BPS Data/model save.

Hope this helps,

Mary

Former Member
0 Kudos

Thanks Mary for you advice. The other problem I am now seeing is converting the natural GL account data in BPS to Group Account data in BCS. I believe that I can have the account mapping done in BW and then download from BW an excel format file with Group Account information. I will then upload this Group account file to BCS. Has anyone else come across similar issue with getting BPS data to an R/3 based BCS and share with me their solutions?

Thank you,