Writing data to application server using SQL Query

[Kartik2]

Dear all,

I have searched the forum and found only one solution to write data to application server using SQL Query and that is by writing an OPEN DATASET statement in START OF SELECTION program block of query infoset, TRANSFER statement in RECORD PROCESSING block and CLOSE DATASET statement in END OF SELECTION program block of query infoset.

This technique writes the data to application server, I would like to know if this is the only approach or is there any easy approach which does not involve any programming knowledge.

Secondly, with the present approach data is being written to application server as well as it is being displayed in ALV grid, is there any way to block the ALV grid display. My requirement is to have only application server data.

Regards,

Kartik

[ThangaPrakash]

Hello Kartik,

AFAI, you can transfer files to application server only through OPEN DATASET, TRANSFER and CLOSE DATASET.

If you don't want to display it in ALV. then comment out the FM "REUSE_ALV_GRID_DISPLAY". anyhow you wopuld be sending the final internal table data to create file and comment out the FM as above.

Regards,

Thanga