Selece Query..

[Former Member]

Hi,

Is there any select statement <b>to select all the fields from a table xyz, except one field ???</b>

Thanks!!

Kode

[RichHeilman]

No, there is no syntax like that, but you could simply get all records, then delete the one that you don't want using the DELETE statement.

Regards,

Rich Heilman

[Former Member]

Get all the fields into an internal table and then do a modify blanking out just that one field that you don't want. Something like this.

select * from dbtab into itab where <...>.

clear itab-dontwantthisfield.

modify itab transporting dontwantthisfield where dontwantthisfield is not initial.

[Former Member]

HI Priya,

No it is not possible.

either u have to use select * or u use select field1 field2 .. to select the data from a table.

use the second option<b> select field1 field2 ..</b> if you really want to exclue one field

Thanks

Mahesh

[former_member192429]

Hi Priya,

You can do this..

Create an internal table with all the fields required.

Write select * from dbtab into CORRESPONDING FIELDS OF TABLE ITAB

WHERE...

This avoid writing every field in the query.

Hope this solves your problem.

-Kriss

[Former Member]

This problem is solved ..Thanks to all.

[former_member192429]

Please let me know how is it resolved. Award the points please..

-Kriss

[Former Member]

Hi Kriss,

Actually they changed the requirement a bit. So I didn't get a chance to use any of these solutions. But I got a very good information.

Anyways I will reward points..

[former_member192429]

Thanks for the info and rewards!!!