cancel
Showing results for 
Search instead for 
Did you mean: 

Ugrent help. User exit- Read data from BW BPS layout and write to ODS

Former Member
0 Kudos

Hi,

I am new to BW BPS and have a req. where i need to read data from BPS layout (EXCEL) and write it to ODS.

Is there any function module or user exit which read data from excel layout and upload it to ODS. Or can any one help me out how can i write a code for this.

It is urgent and i need your help.

Appreciate any kind of input.

Thanks

Mamatha

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Mamatha,

The data that is displayed in a BW BPS layout is stored in a transactional cube in the BW system. If you need that data in an ODS, you should simply create a transformation/update rule which will load from the cube to the ODS.

Please note that the most recent BPS data resides in a yellow status request in the cube and to be able to load it further, it should first be turned green - this can be done manually/in a process chain.

Former Member
0 Kudos

Hi,

Thank you so much for your quick response.

Yes, that will be one way to go.

I need to read comments from my BW BPS layout and store it in ODS. We are not using tran. cube for this. That is the reason why we are need FM to read comments from BPS layout and store it in ODS.

Please let me know if there is any way thru coding i can read the comment values from layout and store it in ODS. vice versa.

Thanks

Mamatha

Former Member
0 Kudos
Former Member
0 Kudos

Hi Mayank,

We have gone thru that doc. before it self. we are Using the same logice in our case.

In this doc. col 1 for matgrp and col 2 for calmonth is hardcoded. as we know the col for the key fields.

but

In our case mat grp. and calmontha are mentioned in the header window of the layout and comments etc are mentioned in the main window of the layout. I dont see any row and col. for the header window and that is where i am facing problem for reading comments based on key fields.

Please guide me if there is any way i can read comments in my scenario.

Appreciate your help.

Points rewards.

Thanks

mamatha

Former Member
0 Kudos

Hi Mayank,

Our scenario is to maintain comments on the BPS planning layout (excel frontend).

i.e, Read and Write the comments from BPS planning layout (excel frontend) to ODS.

Can we achieve this using Transactional Infocube? Does SAP out-of the box allows us to Read and Write the comments or Text fields from BPS planning layout (excel frontend) to ODS.

I was reading the an article on this.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60938938-de6f-2910-2080-fc80d38e...

Is there a better a way to do the same thru InfoCubes.

thank you so much for your advice on this

Regards,

mamatha

Former Member
0 Kudos

points rewarded.

Answers (3)

Answers (3)

Former Member
0 Kudos

issue solved.

Former Member
0 Kudos

Hi Mamatha,

You can use Analysis process designer,if you don't want to create transfer/update rules. It a very simple procedure.You can find this application in SAP BW7.0.

Goto RSA1 then press (CtrlshiftF5) over ther you will find General as a Analysis Process create a new process and start what you want.

Regards,

Deepak

Former Member
0 Kudos

points rewarded

Former Member
0 Kudos

Dear Mamatha,

read following documents. i hope it will work for you.

[http://www.geocities.com/cynarad/reference_for_bps_programming.pdf]

[Accessing BW Master Data in BPS Functions using ABAP ( Exit Function )|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d3dcc423-0b01-0010-4382-aa3e0784b61e]

Regards,

Malik

Give me points if its helpful for you.

Former Member
0 Kudos

Hi,

Thank you so much for the doc.

That gives me an idea of extracting the data from layout.

I need to read comments from layout and store it in ods. not sure if there is any FM for reading specific cell data from layout.

I will give a try with the examples provide in this doc. and see if i can read comments from layout.

Appreciate your help.

Thanks

Mamatha

Former Member
0 Kudos

points rewarded