SAP Knowledge Base Article - Preview

1749066 - Crystal Report that is based on a synonym will display incorrect data when synonym has the same exact name as stored procedure


  • If you have multiple schemas on the Database and these schemas have all a synonym with exact same names pointing to the stored procedure in the original schema; the report will only show the data that comes from the original stored procedure.
  • Also note that this only happens if you keep table prefix blank for the report object.



  • SAP BusinessObjects XI 3.1
  • Crystal Reports


SAP BusinessObjects Enterprise XI 3.0 ; SAP BusinessObjects Enterprise XI 3.1


oracle, synonym, stored procedure, wrong data, ADAPT01632741 , KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.