database tables

[Former Member]

Gud Morning Every one

I am Srikanth frm hyderabad and have small query in ABAP Programming .

1)How can we know which tables and thier corresponding fields are thier in DATABASE

2)Also how can we extract data frm DATABASE

Regards,

SRIKANTH

[sathish_perumal]

Hi,

Use Transaction SE11.

Regards,

Sathish

Note : Reward answers suitably

[Former Member]

hi srikanth

you can use the transaction <b>SE11 / SE12</b>.

Kindly check the PDF for more info.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCDWBDIC/BCDWBDIC.pdf

Reward points if it is helpful

Regards

Alfred

[anversha_s]

hi,

You can use the txn SE11 to view the database tables.

You can find any type of field in SAP using this table in SE12.

how to fetch the data. u can do it using queries.

eg:

data: itaba type table of ztaba with header line.

select * into table itaba from ztaba.

loop at itaba.

write itaba-field_name.

endloop.

Please visit this link. I hope this will help you a lot.

LINK : http://sapabap.iespana.es/sapabap/manuales/learnabap/

http://help.sap.com/saphelp_nw2004s/helpdata/en/43/41341147041806e10000000a1553f6/frameset.htm

rgds

anver

if hlped mark points

[Former Member]

For different table u can check se11 and se12 tcodes.

For example:

for Customer Master Table name is KNA1

for material Master Table name is mara

And u can select data using select statment.Check sap help for detailed usage of select.

Regards

[Former Member]

hi

1. the first query has been answered well- as above

2. as for the extract- two options exist.

a) use an internal table and display it- as above

b) in se11- give name of table- display- utilities-table content-display

you will get a selection screen- click on number of entries (on the application bar) to get an idea of the no.of records in the table. adjust the width of the output list and maximum no.of hits to accomodate all the records. press f8

the table data is displayed. now click on system-list-save-localfile. now choose the file you want to save the data to- excel, rich format etc., and you can save it on your desktop.

note- excel will hold only 65353*256 entries! if you exceed it, a dump will result.

c) use se16- table browser and do the same..

hope its worth some points.

thanks.