topic Re: Repository Function Module in Application Development and Automation Discussions

Repository Function Module

Former Member — Thu, 12 Mar 2009 08:08:34 GMT

Hello Everybody,

I have a program that should find all tables that contain a certain field. I have found the FM RS_EU_CROSSREF and I wrote:

CALL FUNCTION 'RS_EU_CROSSREF'

EXPORTING

i_find_obj_cls = 'DTF'

i_scope_obj_cls = 'DT'

TABLES

i_findstrings = lt_findstrings

o_founds = lt_result.

I get the message that this function is not supported for DB Tables. If I change DTF (for field) with DD (for Domain) then it works ok, but I need to look for the field and not the domain.

Has anyone used it before and knows how should I call the function?

Thanks a lot!

Re: Repository Function Module

Former Member — Thu, 12 Mar 2009 08:17:25 GMT

The data base tables DD02L , DD03L etc will have all the tables and field names information.

You can query these tables with suitable joins and find the required information

Mathews

Re: Repository Function Module

Former Member — Thu, 12 Mar 2009 08:18:58 GMT

hi,

GOTO se11.

Give the required table.

Place cursor on the required field and click the where used list. It gives you various options with respect to , where you want to search for that particular field.

You get list of programs where it has been used.

Thanks

Sharath

Re: Repository Function Module

Former Member — Thu, 12 Mar 2009 12:23:22 GMT

Hello Mathews,

I didn't know about the tables, thaks for the hint. However, it takes forever when I do a SELECT, since the table has millions of records. I guess I still have to see if that function module works.

Regards

Re: Repository Function Module

Former Member — Thu, 12 Mar 2009 12:28:56 GMT

Hi,

I think you must have used joins.....

I dont think joins are required...

Use the query given below,

it will work for sure,

select tabname
  from DD03L
  into lt_tabname
for all entries in lt_fielname
where fieldname = lt_fieldname-fieldname.

Regards,

Siddarth

Re: Repository Function Module

Former Member — Mon, 16 Mar 2009 14:59:52 GMT

Hello Siddarth,

thanks for your help. The query seems to work, very slowly, but it works.

I would like to ask you something else: do you know also where the short description of the tables are saved? I only found the description of the tablefield.

Thanks and regards!

Re: Repository Function Module

Former Member — Mon, 16 Mar 2009 15:49:55 GMT

Hi,

Sure!!!

The short text of the tables are stored in DD02T table.....

Regards,

Siddarth

Re: Repository Function Module

Former Member — Tue, 17 Mar 2009 07:50:22 GMT

Hello Siddarth,

thank you and regards.