syntax for sql statment for SAP BW?

[Former Member]

Hi Friends,

Am new to SAP BODS...

I have a global variable $G_check and inside the value field am trying to fetch data from SAP BW source..

sql( 'SBW_MSGReporting_DS01','Select Distinct REQUEST from '\B96\AROA1W00' ')

am getting syntax error ....am not sure how to give table name for SAP BW('\B96\AROA1W00') ...

can any one correct my sql statement ....

[Former Member]

Hi,

Best way of extracting data from BW is Open Hub or ABAP Data Flow. If your data volume is low even you can use normal data flow.

Try chaing \ to / because BW table names format /Bxx/xxxxxxx.

Regards,

Chenna.