topic Data Dictionary Structure in Application Development and Automation Discussions

Data Dictionary Structure

Former Member — Wed, 27 Jul 2005 20:39:21 GMT

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

Re: Data Dictionary Structure

RichHeilman — Wed, 27 Jul 2005 20:49:24 GMT

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

Re: Data Dictionary Structure

Former Member — Wed, 27 Jul 2005 20:53:08 GMT

Thank you that works perfectly