Store SQL query as qvd

[Iwin]

Hi All,

I want to store following query as qvd .

What should I put in load statement as I am getting column not found error currently.

[Or]

Load * would work fine, for obvious reasons.

If you need to manually spell out the columns, check what is returned by the query without a load statement and use that exact naming convention. In Oracle SQL queries, this will often be all UPPERCASE field names (and without the table qualifier).

[dineshm030]

The column is not available in the mtt table.

[NitinK7]

tablename:

load *;

SELECT 

your sql field

store  tablename  into  [your folder path /tablename.qvd](qvd);