topic Re: select from internal table in Application Development and Automation Discussions

select from internal table

Former Member — Mon, 14 Nov 2005 11:03:31 GMT

Hi,

i need to select data from some internal table.

data : wa_vcera type /BIC/ASUSP00 .

"VCERA" is not defined in the ABAP Dictionary as a table, projection view, or database view.

What should I do?

Thanks

Radka

Re: select from internal table

Former Member — Mon, 14 Nov 2005 11:06:34 GMT

Hello,

You cannot SELECT data from an internal table. you can get the data from which meets specific conditions from one internal table to another.

By the way, how are you getting the data populated in this internal table ?

Regards,

Anand Mandalika.

Re: select from internal table

Former Member — Mon, 14 Nov 2005 11:09:04 GMT

You can also use SELECT for table view.

Max

Re: select from internal table

Former Member — Mon, 14 Nov 2005 11:09:54 GMT

Hi Radka,

If you want to process itab records you can loop at itab or you can read the records.

You declared work area not a internal table, it cant hold multiple records.

Can you please bit clear?

Siri.

Message was edited by: Srilatha T

Re: select from internal table

Former Member — Mon, 14 Nov 2005 11:10:12 GMT

Radka,

what type is this '/BIC/ASUSP00' ????

When i checked out in the Dictionary, I am unable to find it???

Thanks

Kam

Message was edited by: Kam

Re: select from internal table

jayanthi_jayaraman — Mon, 14 Nov 2005 11:12:38 GMT

Hi,

If you define

data : wa_vcera type /BIC/ASUSP00 .

then wa_vcera is thw workarea referring to the table or structure /BIC/ASUSP00.

If you selected data from database table and populated it into your internal table,then you can read the data from the internal table.

Kindly reward points by clicking the star on the left of reply,if it helps.

Re: select from internal table

Former Member — Mon, 14 Nov 2005 11:23:07 GMT

Thanks,

I have done it using loop.

Radka