topic Re: Table Fields in Application Development and Automation Discussions

Table Fields

Former Member — Fri, 28 Jul 2006 10:17:30 GMT

Hai,

Is there any method to find the fields of the given table. The field may be from a included structure also. In case of reporting I need to customize the columns to be displayed.

Re: Table Fields

Former Member — Fri, 28 Jul 2006 10:19:06 GMT

1)se84

2)st05

3)se49

Re: Table Fields

Former Member — Fri, 28 Jul 2006 10:19:54 GMT

hi sakthi,

1. table is : DD03L

2. The texts for the fields are contained in DD03T.

In case of reporting I need to customize the columns to be displayed.

For this u can use the FM,

REUSE_ALV_FIELDCATALOG_MERGE

in which we pass our structure/table name,

and it returns,

an internal table (called as field catalogue)

which contains,

the various fields

, their descriptions for heading,

, their lengths,

, their data type

, their format

etc etc.

regards,

amit m.

Re: Table Fields

Former Member — Fri, 28 Jul 2006 10:23:11 GMT

The field data for a table is stored in DD03L. I dont know whether the information helps or not since I am not 100% sure about your querry.

Regards

Anurag

Re: Table Fields

Former Member — Fri, 28 Jul 2006 10:25:56 GMT

check in SE11.

regards

Prabhu

Re: Table Fields

Former Member — Fri, 28 Jul 2006 10:32:23 GMT

Hai,

I need to use the function within the ABAP Code, Tx is not necessary, one method is to use the function module REUSE_ALV_FIELDCATALOG_MERGE. Is there any other function module.

Re: Table Fields

Former Member — Fri, 28 Jul 2006 10:34:28 GMT

Hi Sakthi

Check FM: CUTA_DD_TABLE_KEYFIELDS_GET for the fields, position, length and check table. FM: DDIF_TABL_GET can be helpful in determining the foreign key relations.

Regards

Eswar

Note: Reward for Useful replies

Re: Table Fields

shivananddeshmu — Fri, 28 Jul 2006 10:59:13 GMT

You can get the all details including the field name and types of all the tables and structures defined in dictionary using FM DDIF_FIELDINFO_GET

CALL FUNCTION 'DDIF_FIELDINFO_GET'

EXPORTING

tabname = 'MARA'

FIELDNAME = ' '
LANGU = SY-LANGU
LFIELDNAME = ' '
ALL_TYPES = ' '
IMPORTING
X030L_WA =
DDOBJTYPE =
DFIES_WA =
LINES_DESCR =

TABLES

dfies_tab = lt_dfies

FIXED_VALUES =

EXCEPTIONS

not_found = 1

internal_error = 2

OTHERS = 3

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

Reward if useful.

Regards

Shivanand