topic Re: SAP table in Application Development and Automation Discussions

SAP table

Former Member — Mon, 19 Jun 2006 11:18:55 GMT

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

Re: SAP table

Former Member — Mon, 19 Jun 2006 11:20:10 GMT

transaction SE16N

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.

Re: SAP table

Former Member — Mon, 19 Jun 2006 11:22:28 GMT

Hi herath,

1. DD03L

table holds the meta data information (about fields)

2. Another main table is DD02L

regards,

amit m.

Re: SAP table

Former Member — Mon, 19 Jun 2006 11:22:48 GMT

The meta data is held in DD02L and DD03L tables.

Regards,

Ravi

Re: SAP table

Former Member — Mon, 19 Jun 2006 11:23:03 GMT

u can check dd02l which holds the details of all sap tables

dd03l has info abt data elements

Re: SAP table

sridharreddy_kondam — Mon, 19 Jun 2006 11:23:31 GMT

Hi Ananda,

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

and dd02l holds the metadata

Regards,

sridhar

Re: SAP table

Former Member — Mon, 19 Jun 2006 11:25:19 GMT

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

Re: SAP table

andreas_mann3 — Mon, 19 Jun 2006 11:28:36 GMT

hi,

use fm RFC_GET_NAMETAB

for export to excel you can use se16n with view dd03m

Andreas

Re: SAP table

Former Member — Mon, 19 Jun 2006 11:32:26 GMT

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

Re: SAP table

Former Member — Mon, 19 Jun 2006 11:34:05 GMT

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

Regards,

Ravi

Re: SAP table

Former Member — Mon, 19 Jun 2006 11:40:15 GMT

Hi ravi,

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

Thanks,

Ananda

Re: SAP table

Former Member — Mon, 19 Jun 2006 11:46:07 GMT

That cannot happen.

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

Regards,

Ravi

Re: SAP table

Former Member — Tue, 20 Jun 2006 03:27:03 GMT

hi all,

Thanks..solved prob

ananda