topic Re: Get Table Meta Data with RFC in Application Development and Automation Discussions

Get Table Meta Data with RFC

Former Member — Mon, 19 Feb 2007 16:29:05 GMT

Hi,

I wonder if there is a way to get the meta data from a table or structure using RFCs.

More detailed:

I am using RFCs to read data from tables and structures. It would be nice to have a way to also get the table definitions, like column headers, column types and contraints, etc. using RFC.

Does somebody know how to do that? (My test system is an IDES)

Thanks in advance

Stefan

Re: Get Table Meta Data with RFC

Former Member — Mon, 19 Feb 2007 16:34:18 GMT

Hi,

Have you looked FM RFC_READ_TABLE or DDIF_FIELDINFO_GET?

Regards,

Ferry Lianto

Re: Get Table Meta Data with RFC

Former Member — Mon, 19 Feb 2007 16:46:43 GMT

Thanks Ferry,

could you please provide me with a simple code example calling this FM?

I am not quite sure how to use the OPTIONS table as input.

That would be very nice.

Thanks

Stefan

Re: Get Table Meta Data with RFC

Former Member — Mon, 19 Feb 2007 17:02:25 GMT

Hi Stefan,

Please check program RSIWA007 for sample code on how to use FM RFC_READ_TABLE.

Also try FM DDIF_FIELDINFO_GET first perhaps it is easier to use.

Regards,

Ferry Lianto

Re: Get Table Meta Data with RFC

Former Member — Mon, 19 Feb 2007 17:08:22 GMT

great, thanks

Stefan

Re: Get Table Meta Data with RFC

Former Member — Tue, 20 Feb 2007 23:01:52 GMT

It's me again,

Today, I had a closer look on what you gave me yesterday. I think the problem is that I asked for the wrong information.

What I am actually looking for isn't meta information for tables, but information about the "Associated Type" that is associated with every import, export, or table parameter of a function module.

If I double-click on one of those types in transaction se37 after choosing a function module, I get a wonderful overview about the structure including 'component', 'component type', 'data type', 'length', etc.

Is there an RFC I can call that gives me exactly this information?

Best,

Stefan

Re: Get Table Meta Data with RFC

Former Member — Wed, 21 Feb 2007 22:50:18 GMT

Hi Stefan

Does FM RFC_GET_FUNCTION_INTERFACE help you? It looks like there are some other interesting FMs in the same function group, RFC1, and also RFC2 ...

Regards

Glen

Re: Get Table Meta Data with RFC

Former Member — Wed, 21 Feb 2007 23:01:40 GMT

Topic moved to