read operation

[Former Member]

how to read a data from an database table..

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

thanx yaar

regards

vijay

[Former Member]

hi,

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

eg..

Select matnr werks from MARC into table IT_MARC.

regards,

nazeer

[Former Member]

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

[Former Member]

Hi Vijay,

Press F1 on SELECT in Abap.

Regards, Dieter

[Former Member]

thanx 4 everyone.