‎2006 Jul 28 11:17 AM
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.
‎2006 Jul 28 11:34 AM
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
‎2006 Jul 28 11:19 AM
‎2006 Jul 28 11:19 AM
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.
‎2006 Jul 28 11:23 AM
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
‎2006 Jul 28 11:25 AM
‎2006 Jul 28 11:32 AM
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.
‎2006 Jul 28 11:34 AM
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
‎2006 Jul 28 11:59 AM
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