topic fetch field names & Description for Table in Application Development and Automation Discussions

fetch field names & Description for Table

Former Member — Thu, 14 May 2009 07:55:15 GMT

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

Re: fetch field names & Description for Table

former_member229729 — Thu, 14 May 2009 08:04:10 GMT

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

Re: fetch field names & Description for Table

Sandeep_Panghal — Thu, 14 May 2009 08:05:49 GMT

Try this :

SELECT * FROM dd03l

INTO TABLE tab_fields

WHERE

tabname = i_tabname .

Re: fetch field names & Description for Table

Former Member — Thu, 14 May 2009 08:06:28 GMT

Hi,

Try this fm CATSXT_GET_DDIC_FIELDINFO

Regards

Debarshi

Re: fetch field names & Description for Table

Former Member — Thu, 14 May 2009 08:16:06 GMT

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