Application Development and Automation 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: 
Read only

SAP table

Former Member
0 Likes
1,524

Hi all,

Is there a way to export the details of a table shown in Data dictionary? (Or else which table holds the meta data of tables)

Thanks & regards,

ANanda

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,474

transaction <b>SE16N</b>

1)GO TO SE16 N

2)ENTER UR TABLE NAME

3)EXECUTE IT

4)IT DISPALY ALL THE DATA IN ALV SCREEN.

5)THERE IS EXPORT BUTTON IN ALV MENU

6)JUST EXPORT IT.

12 REPLIES 12
Read only

Former Member
0 Likes
1,475

transaction <b>SE16N</b>

1)GO TO SE16 N

2)ENTER UR TABLE NAME

3)EXECUTE IT

4)IT DISPALY ALL THE DATA IN ALV SCREEN.

5)THERE IS EXPORT BUTTON IN ALV MENU

6)JUST EXPORT IT.

Read only

0 Likes
1,474

hi,

thanks a lot for ur response..I don't wanna export the content rather the meta data of tables? Is there a way?

Ananda

Read only

0 Likes
1,474

Use the DD02L and DD03L tables, use the SE16 transaction for whatever tables and then you can export the content.

Regards,

Ravi

Read only

0 Likes
1,474

Hi ravi,

I tried that..but it says the table doesn't exist. Is it diff for diff versions?

Thanks,

Ananda

Read only

0 Likes
1,474

That cannot happen.

DD0(ZERO)2L, this has to exist in any version

Regards,

Ravi

Read only

0 Likes
1,474

hi all,

Thanks..solved prob

ananda

Read only

Former Member
0 Likes
1,474

Hi herath,

1. DD03L

table holds the meta data information (about fields)

2. Another main table is DD02L

regards,

amit m.

Read only

Former Member
0 Likes
1,474

The meta data is held in DD02L and DD03L tables.

Regards,

Ravi

Read only

Former Member
0 Likes
1,474

hi

u can check <b>dd02l</b> which holds the details of all sap tables

<b>dd03l</b> has info abt data elements

Read only

sridharreddy_kondam
Active Contributor
0 Likes
1,474

Hi Ananda,

Goto SE16N enter the Required talbe and after executing u gat an option to export to required details in format

and <b>dd02l</b> holds the metadata

Regards,

sridhar

Read only

Former Member
0 Likes
1,474

Hai

it is Run Tcode SE16N

Give Table : MARA and Press Execute Button

It displays ALV LIST Output

There is Export Option

Thanks & regards

Sreeni

Read only

0 Likes
1,474

hi,

use fm RFC_GET_NAMETAB

for export to excel you can use se16n with view dd03m

Andreas