BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
edv2017
Fluorite | Level 6

Hi,

 

We have installed the Surveyor and follow a parallel approach. First approach is transferring the metadata and transfer specific BW infoprovider transactional content afterwards.

 

We also have a second approach to select data directly using SQL. Is this possible?

 

We do not seem to have a correct statement.

The source system is BW on HANA.

Technical name of advanced DSO: CDDPOA02

 

We are trying statements like this:

 

LIBNAME SAPBW SASIOSR3  sysnr=10 ashost=asapbwci00.hosting.corp trace=0  destgroup="SAS1" BatchMode=1 language=EN

! Client=100 USER=TESTSAS PASSWORD=XXXXXXXXXXXX;

NOTE: Libref SAPBW was successfully assigned as follows:

      Engine:        R3

      Physical Name: asapbwci00.hosting.corp

 

PROC SQL; 

SELECT count(*)
FROM SAPBW.CDDPOA02;

 

And get errors like these:
ERROR: Exception while using RFC to SAP: TABLE_NOT_AVAILABLE

 

We also tried:

SELECT count(*)
FROM SAPBW./BIC/ACDDPOA022;

 

or some more statements. All to no luck.

 

Any idea which statement works?

 

Best Regards,

Eelco de Vries

1 ACCEPTED SOLUTION

Accepted Solutions
edv2017
Fluorite | Level 6

We found the solution by using aliases in the PROC SQL FROM statement to the BW DSO tables.

View solution in original post

3 REPLIES 3
LinusH
Tourmaline | Level 20
Contact your SAP BW admin to verify that you have the necessary rights and set correct options to be able to access that specific table. He/she should also be able to check the logs for more specific information about your access attempt.
You could also add
Options sastrace=',,,d' sastraceloc = saslog nostsuffix msglevel=i;
to possible get out more info in the SAS log.
Data never sleeps
edv2017
Fluorite | Level 6

Hi LinusH,

 

Indeed we are also testing new BW authorizations, but this is not where the solution is expected.

 

Since when we try a normal metadata table in BW we get the authorization message:

 

SELECT count(*)

FROM SAPBW.RSDIOBJT;

ERROR: Exception while using RFC to SAP: NOT_AUTHORIZED

 

And not the TABLE_NOT_AVAILABLE message.

 

 

So it is purely how to access the BW advanced DSO object via a SQL statement.

 

Best Regards,

Eelco de Vries

edv2017
Fluorite | Level 6

We found the solution by using aliases in the PROC SQL FROM statement to the BW DSO tables.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 4540 views
  • 0 likes
  • 2 in conversation