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: 

SAP table

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

0 Kudos

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

0 Kudos

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

Regards,

Ravi

0 Kudos

Hi ravi,

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

Thanks,

Ananda

0 Kudos

That cannot happen.

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

Regards,

Ravi

0 Kudos

hi all,

Thanks..solved prob

ananda

Former Member
0 Kudos

Hi herath,

1. DD03L

table holds the meta data information (about fields)

2. Another main table is DD02L

regards,

amit m.

Former Member
0 Kudos

The meta data is held in DD02L and DD03L tables.

Regards,

Ravi

Former Member
0 Kudos

hi

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

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

sridharreddy_kondam
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

0 Kudos

hi,

use fm RFC_GET_NAMETAB

for export to excel you can use se16n with view dd03m

Andreas