06-05-2006 7:59 AM
Hi Is there a way to download the table structure along with dataelements or is there a FM to get these details?
Thanks.
06-05-2006 8:10 AM
Hello Sri,
Have a look at the program.
<a href="http://members.aol.com/_ht_a/skarkada/sap/tblinfo/tblinfo.htm">Table download</a>. This will generate the list which u can download using SYSTEM->List->save. U can also take a look at OBe8.
06-05-2006 8:03 AM
Hi sri,
1. DB_GET_TABLE_FIELDS
2. This FM will get u all the field names,
data types, their length, default value etc.
regards,
amit m.
06-05-2006 8:09 AM
PARAMETERS: TABNAME TYPE DDOBJNAME.
DATA T_DFIES LIKE STANDARD TABLE OF DFIES.
CALL FUNCTION 'DDIF_FIELDINFO_GET'
EXPORTING
TABNAME = TABNAME
TABLES
DFIES_TAB = T_DFIES
FIXED_VALUES =
EXCEPTIONS
NOT_FOUND = 1
INTERNAL_ERROR = 2
OTHERS = 3
.
IF SY-SUBRC = 0.
06-05-2006 8:09 AM
Hi,
Try FM DB_GET_TABLE_FIELDS.
Import parameters:
FIELD_INFO
TABNAME
U get the details of the fields in table DBFIELDS which shall give u
Name of the DB field
Position of the field in the table
Identifies a key field of a table
Position of the index column within the indexes (1,2..)
Definition of a database domain
Length (No. of Characters)
Null values allowed
Default value for a DB column
Prefix/Suffix for a DB default value
Regards,
Tanveer.
<b>Please mark helpful answers</b>
06-05-2006 8:10 AM
Hello Sri,
Have a look at the program.
<a href="http://members.aol.com/_ht_a/skarkada/sap/tblinfo/tblinfo.htm">Table download</a>. This will generate the list which u can download using SYSTEM->List->save. U can also take a look at OBe8.
06-05-2006 8:10 AM
Hi,
try this
FM TR_NAMETAB_GET
rgds,
latheesh
Message was edited by: Latheesh Kaduthara