Data Dictionary Structure

[Former Member]

Hi

I was wondering if anyone would have a function call that would pull back the data dictionary structure for tables like TVARV. I tried VIEW_GET_DDIC_INFO but I recieve and error saying that no TVDIR entry exsits. Is there anything else that might work? If not is there a table that I could use to pull a select for all the table field information?

Thanks

John

[Former Member]

Hi

I was wondering if anyone would have a function call that would pull back the data dictionary structure for tables like TVARV. I tried VIEW_GET_DDIC_INFO but I recieve and error saying that no TVDIR entry exsits. Is there anything else that might work? If not is there a table that I could use to pull a select for all the table field information?

Thanks

John

[RichHeilman]

Here ya go.

report zrich_0002.


data: ddfields type table of ddfield with header line.

parameters: p_tab(30) type c.

call function 'DD_NAMETAB_TO_DDFIELDS'
  exporting
*   KEYFIELDS       = 'X'
*   NULLABLE        = 'X'
    tabname         = p_tab
* IMPORTING
*   SUBRC           =
  tables
    ddfields        = ddfields.


loop at ddfields.
  write:/ ddfields-fieldname,
          ddfields-position,
          ddfields-keyflag,
          ddfields-datatype,
          ddfields-leng,
          ddfields-decimals,
          ddfields-nullable.
endloop.

If this post has helped you, please award points accordingly. Thanks.

Regards,

Rich HEilman

[Former Member]

Thank you that works perfectly