Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to search table in R3 and XI?

Former Member
0 Kudos

hi pals,

how to search table in R3..like if i go to se16..then if in enter *ara then f8 should give table details..is it right..

or se 16 i have to give ara like this..plz correct me how to search in se16 or other than this tcode se11 only...is it right...if any other way i can search table plz tell me...

thanks

Ruban

1 ACCEPTED SOLUTION

Former Member
0 Kudos

In se11/se16 Check table DD02L.

All tabes names come under DD02L-TABNAME.

To get the description of table use table DD02T.

All the information about DDIC is stored in tables starting with DD.

Then select required table.

In SE11/SE16 giving ARA and *ARA works!!!!

FM nametab_get to display

fields of table.

6 REPLIES 6

Former Member
0 Kudos

In se11/se16 Check table DD02L.

All tabes names come under DD02L-TABNAME.

To get the description of table use table DD02T.

All the information about DDIC is stored in tables starting with DD.

Then select required table.

In SE11/SE16 giving ARA and *ARA works!!!!

FM nametab_get to display

fields of table.

0 Kudos

hi,

could you explain me how to search any table in r3..

give some example..

i want to see KNA1 table, how i can see that table.

regards

prabaharan

ferry_lianto
Active Contributor
0 Kudos

Hi,

Please try these ...

1. Go to transaction SE11.

2. Enter Database table with KNA1.

3. Click on Display button.

4. System will display the detail components/fields of table KNA1.

5. Click on Contents button (CTRLShiftF10) to see contents of table KNA1.

Regards,

Ferry Lianto

0 Kudos

hi,

for what kind of details we have to go with se16

0 Kudos

If you want to see any database table contents, you need to go to SE16.

Enter table name, press enter, then entered (if required) conditions on selection screen and execute.

This shows data of corresponding table.

ashish

ferry_lianto
Active Contributor
0 Kudos

Hi,

Using transaction SE16, you can browse the content of a database table (i.e. KNA1).

Also it allows you to change the fields for selection, change the output list, format the list as well as sort. (These functions are under Settings menu).

Regards,

Ferry Lianto