topic Re: Excluding one field in select statement in Application Development and Automation Discussions

Excluding one field in select statement

Former Member — Thu, 19 Feb 2009 11:16:20 GMT

Hi Leads,

My table has 150 fields in total. from that I want to select only 149 fields into Internal table.

Is there any way to exclude only one field in the select statement, instead of writing all 149 fields?

Regards

Sandip

Re: Excluding one field in select statement

Former Member — Thu, 19 Feb 2009 11:20:25 GMT

Hi,

You can follow one smart trick.

Decalare a table type of same table by copying all fields.then remove the fields which do you not want to select.

then write Select Query as belwo

Select * from Database_Table name into corresponding fields of table Table_name....

-Rick

Re: Excluding one field in select statement

christine_evans — Thu, 19 Feb 2009 11:23:10 GMT


> Hi Leads,
> 
> My table has 150 fields in total. from that I want to select only 149 fields into Internal table. 
> Is there any way to exclude only one field in the select statement, instead of writing all 149 fields?
> 
> Regards
> Sandip

I'd use SELECT *. What difference does one extra field make anyway? Unless it is a very long field.

Re: Excluding one field in select statement

Former Member — Thu, 19 Feb 2009 11:25:47 GMT

hi,

you can declare the internal table with all the 150 fields...

in select also

select * from db into itab where some condition...

so in your internal table you will have all the 150 fields...use 149 fields and let the 150th field be there..it wont cause any problem

try not to use move corresponding as far as possible..

Re: Excluding one field in select statement

Former Member — Thu, 19 Feb 2009 11:28:07 GMT

Hi,

you have an option in SAP

GOTO ---> Pattern ---> radiobutton select * from  give the table name

it will ask you to select the fields you want you can check the fields you want and it will automatically write the select query.

regards

sarves

Re: Excluding one field in select statement

viquar_iqbal — Thu, 19 Feb 2009 11:43:22 GMT

click on pattern ->structured data object->with fields from structure->enter the name of table select fields click on ok and youll get the table with selected fields

Thanks

Viquar Iqbal

Re: Excluding one field in select statement

Former Member — Thu, 19 Feb 2009 11:45:53 GMT

hi..

I hav the requirement where I want to exclude MANDT field out of 150 fields.

So..I jus asked...

Anywayz...Got the short cut... and thanx for all the responses.

Regards

Sandip

Re: Excluding one field in select statement

Former Member — Thu, 19 Feb 2009 11:47:37 GMT

hi:

1st - create an internal table containing 149 fields

2nd - select * from table into corresponding fields of 1st

Regards

Shashi