Create datasource for processing group text

[Former Member]

Hi All,

I want to create a datasource in R/3 to pull the text for Processing group in BW. Currently only codes are pulled in BW for processing group. It would be great help if somebody can provide me details regarding the same. A step by step solution will be of gr8 help.

Thanks

[Former Member · Accepted solution]

HI

In R/3 execute the TCODE RSO2

Then create a text data source.(ZZ...)

Then assign the table from which you need to get the data, or create view for the required fields in SE11 first and then assign the VIew in RSO2 in the field View/tables,

Then Save and generate Data source.

Then come to BW select the application component under which you created the data source.

Replicate the data source.

Then assign info source.

Extract the data.

Regards

RaM

[Former Member · Accepted solution]

HI All,

Thanks for the response. I tried to create the datasource. I entered all the necessary fields with the view name but when I click on save its giving me message

"Only transparent tables and database views can be extracted"

Please let me know how to proceed on this.

Thanks.

[Former Member · Accepted solution]

Hi Varun,

Check if you are using only Transparent Tables or Views and not Structures for your Generic DataSource.

Regards,

Tom.