Application Development and Automation 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: 
Read only

Table Fields

Former Member
0 Likes
885

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.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
840

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

7 REPLIES 7
Read only

Former Member
0 Likes
840

1)se84

2)st05

3)se49

Read only

Former Member
0 Likes
840

hi sakthi,

1. table is : DD03L

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

3.

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.

Read only

Former Member
0 Likes
840

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

Read only

Former Member
0 Likes
840

check in SE11.

regards

Prabhu

Read only

Former Member
0 Likes
840

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.

Read only

Former Member
0 Likes
841

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

Read only

shivananddeshmu
Explorer
0 Likes
840

Hi

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