Hi Dreddy,
Information from our SAP person: Because SAP R/3 contains a vast amount of views WebFOCUS is not able to collect all of them to presentation on the Web Console.
The following code should be able to create the synonym for the desired view.
CREATE SYNONYM baseapp/&SYNNAME
FOR &VIEWNAME TABLE
DBMS SQLSAP AT &SYSNAME
END
&SYNNAME: The master file name
&VIEWNAME: The actual view name
&SYSNAME: SAP R/3 connection ID defined in the SAP R/3 adapter properties.
This should be run from the Procedures page on the Web Console.
For this type of questions, please contact Information Builders' Customer Support Services and open a case for assistance. There could be an underlying technical problem that needs troubleshooting. To open a case, you may either call at 1-800-736-6130, or access online at
InfoResponse.
Hope this helps.
Cheers,
Kerry
Kerry Zhan
Focal Point Moderator
Information Builders, Inc.