topic database tables in Application Development and Automation Discussions

database tables

Former Member — Sat, 07 Oct 2006 06:23:16 GMT

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

Re: database tables

sathish_perumal — Sat, 07 Oct 2006 06:26:02 GMT

Hi,

Use Transaction SE11.

Regards,

Sathish

Note : Reward answers suitably

Re: database tables

Former Member — Sat, 07 Oct 2006 06:32:20 GMT

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

Re: database tables

anversha_s — Sat, 07 Oct 2006 06:37:54 GMT

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

Re: database tables

Former Member — Sat, 07 Oct 2006 07:10:59 GMT

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

Re: database tables

Former Member — Sat, 07 Oct 2006 08:25:40 GMT

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.