SQL keywords used for table names

[Former Member]

Hey All,

I'm creating a Universe on top of a SQL relational database (New to the SAP BO tools). 2 of the tables are named 'Order' and 'Transaction' and I cannot rename these. When I build a business layer on top of these I get the following error message when trying to see values:

[Microsoft SQL Server Native Client 10.0] : Incorrect syntax near the keyword 'Order'.

And the following when trying to publish to a repository:

It was impossible to execute the business object 'X'. Check the object properties.

Any ideas how to get around this issue ?

Kev

[Former Member]

Thanks Marc that worked. Thought I already tried that

[marc_daniau]

To avoid keywords, you can define in the universe a derived table  named ORDERS for instance with a SQL defintion like this

SELECT "ORDER" as ORDERID, ORDERDATE, CUSTOMERID FROM "ORDER"

In this example a keyword is used for the table name and a column name