topic Re: Table structure in Application Development and Automation Discussions

Table structure

Former Member — Mon, 05 Jun 2006 06:59:04 GMT

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

Thanks.

Re: Table structure

Former Member — Mon, 05 Jun 2006 07:03:24 GMT

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.

Re: Table structure

Former Member — Mon, 05 Jun 2006 07:09:37 GMT

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.

Re: Table structure

Former Member — Mon, 05 Jun 2006 07:09:38 GMT

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>

Re: Table structure

Former Member — Mon, 05 Jun 2006 07:10:05 GMT

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.

Re: Table structure

Former Member — Mon, 05 Jun 2006 07:10:28 GMT

Hi,

try this

FM TR_NAMETAB_GET

rgds,

latheesh

Message was edited by: Latheesh Kaduthara