topic Re: Find fields of a table programatically in Application Development and Automation Discussions

Find fields of a table programatically

Former Member — Thu, 11 Dec 2008 19:23:40 GMT

Hello All,

is there any way to find out all fields of a table programatically ...?

Like if VBAK is give ...i need the list of all standard and custom fields of that table

Regards,

Re: Find fields of a table programatically

Former Member — Thu, 11 Dec 2008 19:29:20 GMT

Please search the forum. This question has been answered many times.

Rob

Re: Find fields of a table programatically

Former Member — Thu, 11 Dec 2008 21:02:45 GMT

I just searched with GETTABLEFIELDS>F4 in SE37 , i got my answer.

Re: Find fields of a table programatically

former_member156446 — Thu, 11 Dec 2008 21:08:21 GMT

Hi Tcode

if you write a simple select on DD03L and DD03T your problem is solved.

else you have a FM:

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.

This FM will help u too..

MSS_MON_TABLE_COLUMNS