‎2006 Jun 19 12:18 PM
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
‎2006 Jun 19 12:20 PM
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.
‎2006 Jun 19 12:20 PM
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.
‎2006 Jun 19 12:32 PM
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
‎2006 Jun 19 12:34 PM
Use the DD02L and DD03L tables, use the SE16 transaction for whatever tables and then you can export the content.
Regards,
Ravi
‎2006 Jun 19 12:40 PM
Hi ravi,
I tried that..but it says the table doesn't exist. Is it diff for diff versions?
Thanks,
Ananda
‎2006 Jun 19 12:46 PM
That cannot happen.
DD0(ZERO)2L, this has to exist in any version
Regards,
Ravi
‎2006 Jun 20 4:27 AM
‎2006 Jun 19 12:22 PM
Hi herath,
1. DD03L
table holds the meta data information (about fields)
2. Another main table is DD02L
regards,
amit m.
‎2006 Jun 19 12:22 PM
The meta data is held in DD02L and DD03L tables.
Regards,
Ravi
‎2006 Jun 19 12:23 PM
hi
u can check <b>dd02l</b> which holds the details of all sap tables
<b>dd03l</b> has info abt data elements
‎2006 Jun 19 12:23 PM
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
‎2006 Jun 19 12:25 PM
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
‎2006 Jun 19 12:28 PM
hi,
use fm RFC_GET_NAMETAB
for export to excel you can use se16n with view dd03m
Andreas