topic Select Multiple fields in Application Development and Automation Discussions

Select Multiple fields

Former Member — Mon, 28 Jun 2010 19:17:02 GMT

Hi ,

Am an ABAP novice... Have a requirement where I want to selct around 80 different fields from the table MARA and populate into an internal table..The simple select statement would be

select fld1........fld 80 from MARA into.....

Is there a way that I do not have to mention each and every of the FLd 1 to 50 in my select stmnt and still be able to select all required fields in a single select statement.

If there is a way it would make my task much easier and I guess would be better programming...

Thanks

Re: Select Multiple fields

kesavadas_thekkillath — Mon, 28 Jun 2010 19:20:26 GMT

select *

Re: Select Multiple fields

Former Member — Mon, 28 Jun 2010 19:26:47 GMT



data itab type standard table of mara.

Select *
from   mara
into corresponding fields of table itab.

This will solve your problem.

Regards

Mishra

Re: Select Multiple fields

Former Member — Mon, 28 Jun 2010 19:34:48 GMT

Moderator message - Unfortunately, this forum is not a place to learn ABAP. I suggest that you get one of the good ABAP books that are out there and maybe join an internet forum that caters to beginners And proofread you question before posting it. Leaving obvious errors gives the impression that you don't really care. Do you have 50 or 80 fields to SELECT? thread locked Rob