fetch field names & Description for Table

[Former Member]

Hi,

My requirement is if i enter the Table name i have to get all the field names and description .Please tell me how to do.

Thanks,

Mohan

[Former Member]

Hi,

My requirement is if i enter the Table name i have to get all the field names and description .Please tell me how to do.

Thanks,

Mohan

[former_member229729]

Hi,

TABLES: DFIES,
        X030L.

DATA: BEGIN OF INTTAB OCCURS 100.
        INCLUDE STRUCTURE DFIES.
DATA: END OF INTTAB.

PARAMETERS: TABLENM TYPE DDOBJNAME       DEFAULT 'MSEG',
            FIELDNM TYPE DFIES-FIELDNAME DEFAULT 'MENGE'.

      call function 'DDIF_FIELDINFO_GET'
        exporting
          tabname              = TABLENM
          FIELDNAME            = FIELDNM
          LANGU                = SY-LANGU
*         LFIELDNAME           = ' '
*         ALL_TYPES            = ' '
*       IMPORTING
*         X030L_WA             = WATAB
*         DDOBJTYPE            =
*         DFIES_WA             =
*         LINES_DESCR          =
        TABLES
          DFIES_TAB            = INTTAB
*         FIXED_VALUES         =
        EXCEPTIONS
          NOT_FOUND            = 1
          INTERNAL_ERROR       = 2
          OTHERS               = 3.

      if sy-subrc <> 0.
         WRITE:/ 'Field name not found'.
      endif.

      LOOP AT INTTAB.
         WRITE:/ INTTAB-TABNAME, INTTAB-FIELDNAME, INTTAB-FIELDTEXT.
      ENDLOOP.

Thanks and regards,

Ramani N

[Sandeep_Panghal]

Try this :

SELECT * FROM dd03l

INTO TABLE tab_fields

WHERE

tabname = i_tabname .

[Former Member]

Hi,

Try this fm CATSXT_GET_DDIC_FIELDINFO

Regards

Debarshi

[Former Member]

thanks..!! u solved my problem....