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: 

Table structure

Former Member
0 Kudos

Hi Is there a way to download the table structure along with dataelements or is there a FM to get these details?

Thanks.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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.

5 REPLIES 5

Former Member
0 Kudos

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.

0 Kudos

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.

Former Member
0 Kudos

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>

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi,

try this

FM TR_NAMETAB_GET

rgds,

latheesh

Message was edited by: Latheesh Kaduthara