topic Re: Standard Function Modules required in Application Development and Automation Discussions

Standard Function Modules required

Former Member — Thu, 12 Mar 2009 05:14:21 GMT

I am look for a standard Function Module / RFC / BAPI for the below

Get the list of table (for a given search criteria like if I give m* it should return me list of

tables starting with m)

Get details of the table (its field details)

Regards,

Samson.

Re: Standard Function Modules required

GauthamV — Thu, 12 Mar 2009 05:15:18 GMT

Tables - DD02L,DD03L.

Re: Standard Function Modules required

sreeramkumar_madisetty — Thu, 12 Mar 2009 05:17:17 GMT

Hi Friends

Refer table : TFDIR.

Regards,

Sreeram Kumar.Madisetty

Re: Standard Function Modules required

Former Member — Thu, 12 Mar 2009 05:19:56 GMT

Hi,

To get field details of table , you can use function module

DDIF_FIELDINFO_GET

Regards

Re: Standard Function Modules required

Former Member — Thu, 12 Mar 2009 05:20:07 GMT

1) to get the list of tables : you can check in DD02L table

2) To get the list of field details based on table: there is a custom program which can give you all the field details. (please check the forum, if i find any ... i will post again)

Regards,

~Satya

Re: Standard Function Modules required

Former Member — Thu, 12 Mar 2009 05:24:04 GMT

FM: DDIF_FIELDINFO_GET solved the second requirment.

Thanks & Regards,

Samson.

Re: Standard Function Modules required

Former Member — Thu, 12 Mar 2009 05:25:46 GMT

Select TABNAME fron dd02l into Itab where Tabname like M*

Select FIELDNAME ROLLNAME DOMNAME DATATYPE from dd03l into itab2 fro all entries in Itab where tabname = itab-tabname.

Or:

Select TABNAME fron dd02l into Itab where Tabname like M*

Loo at Itab.

Pass table name in each loop pass to FM: GET_FIELDTAB or DDIF_FIELDINFO_GET

GET_FIELDTAB -

>If you pass table it will give you related fields.

Endloop.

Regards,

Gurpreet

Re: Standard Function Modules required

Former Member — Thu, 12 Mar 2009 05:32:20 GMT

Hello all,

I am specific in finding FM / RFC / BAPI only and not looking into tables and logic to get this working.

I need a FM / RFC / BAPI to get list of tables based on table name search like m* for mara,marc etc.

Thanks for you posts.

Regards,

Samson.

Re: Standard Function Modules required

Former Member — Thu, 12 Mar 2009 05:34:31 GMT

Hi Samson,

Pls check this function module "RS_DD_F4_OBJECT".

Ex: You can pass MAR* and can get all the tables which starts with MAR..

Regards,

Raghu

Re: Standard Function Modules required

GauthamV — Thu, 12 Mar 2009 05:40:11 GMT

Use this fm.

F4_DD_TABLES

Re: Standard Function Modules required

Former Member — Thu, 12 Mar 2009 05:40:18 GMT

Try this:

F4_DD_TABLES

regards,

Gurpreet

Re: Standard Function Modules required

Former Member — Thu, 12 Mar 2009 06:08:46 GMT

Thanks folks

I got the required FMs

Get list of table : RPY_TABLE_SELECT
Get details of table : DDIF_FIELDINFO_GET

Regards,

Samson.