topic Re: read operation in Application Development and Automation Discussions

read operation

Former Member — Mon, 14 May 2007 13:01:52 GMT

how to read a data from an database table..

Re: read operation

Former Member — Mon, 14 May 2007 13:04:26 GMT

Use :

Select query or already if you have data at internal table ,you need to read one by one record then use :

sort int_table by fld1.

Read table int_table with key name = name binary search.

Reward Points if it is useful.

Thanks

Seshu

Re: read operation

Former Member — Mon, 14 May 2007 13:04:38 GMT

Hi Vijay,

you cannot read data from database table directly.

But u need to select.. the data and post it into a INternal table and then u can read the data from a internal table.

unless u fetch the data from database table and populate into a a internaltable, one cannot read

Reward points if helpful

revert back if any issue.

regards

naveen

Re: read operation

Former Member — Mon, 14 May 2007 13:04:52 GMT

hi,

You should use SELECT staements to read data from DB tables,

eg..

Select matnr werks from MARC into table IT_MARC.

regards,

nazeer

Re: read operation

Former Member — Mon, 14 May 2007 13:07:12 GMT

hi,

Using SQL queries ,

suppose say u wanna read data from MARA table i.e Material Master .

Create an internal table like mara

chk the code below,

Data it_mara like mara occurs 0 with header line.

select * from mara into table it_mara.

loop at it_mara.

write 😕 it_mara-matnr,

....

,.....

endloop.

This is just a start ,

regards ,

Kannan

Re: read operation

Former Member — Mon, 14 May 2007 13:18:40 GMT

Hi Vijay,

Press F1 on SELECT in Abap.

Regards, Dieter

Re: read operation

Former Member — Mon, 14 May 2007 13:21:37 GMT

hi naveen,

press f1 in read option.

in that there is an option for reading table from database,

i dont know how to use .

if u know,plz tell.

regards vijay

Re: read operation

Former Member — Mon, 14 May 2007 13:26:59 GMT

Hi Vijay,

yes, ihave gone through that but it is Obsolete and no one uses that as it effects the performance.

i have gon ethrough the Documentation, at this movement its not clear ,,, i will try to go thru that and reply back...

But keep in mind NO ONE USES THIS READ DATABASE TABLE....

Regards

Naveen

Re: read operation

Former Member — Mon, 14 May 2007 13:32:23 GMT

thanx yaar

regards

vijay

Re: read operation

Former Member — Mon, 14 May 2007 13:33:21 GMT

thanx 4 everyone.