topic FM for extracting data in Application Development and Automation Discussions

FM for extracting data

Former Member — Thu, 06 Apr 2006 10:04:29 GMT

Hi Friends,

Can any body tell me is there any FM avilable to extract the data from any datbase table? Or shall we have to create a new FM..?

Thanks in Advance.

Re: FM for extracting data

rainer_hbenthal — Thu, 06 Apr 2006 10:10:34 GMT

The name of this FM is SELECT.

Re: FM for extracting data

vinod_gunaware2 — Thu, 06 Apr 2006 10:13:51 GMT

It all depend upon requrement, For standard like material,sales orders there are functon modules and BAPI.

Otherwise u have to use select statement in that funcion module.

regards

vinod

Re: FM for extracting data

Former Member — Thu, 06 Apr 2006 10:14:50 GMT

Hello Jak,

Usually SAP has developed FM for extracting data from the data bas tables like MARA_SINGLE_READ and so on.. U need to find them. If however they are not there then alternatively u can use SELECT stmt.

Re: FM for extracting data

Former Member — Thu, 06 Apr 2006 10:18:25 GMT

Hi,

you can do it with the help of FM <b>RFC_READ_TABLE</b>

Regards

vijay

Re: FM for extracting data

athavanraja — Thu, 06 Apr 2006 10:24:17 GMT

you can use the following FMs as well

RFC_GET_TABLE_ENTRIES

TABLE_ENTRIES_GET_VIA_RFC

Regards

Raja

Re: FM for extracting data

Former Member — Thu, 06 Apr 2006 10:27:39 GMT

Jak,

I think you are asking related to the custom tables in CRM question.

You can use RFC_READ_TABLE and specify the table name.

Regards,

Ravi

Re: FM for extracting data

Former Member — Thu, 06 Apr 2006 10:30:30 GMT

Hi all,

Thank You very much.

Points are given.

Re: FM for extracting data

Former Member — Thu, 06 Apr 2006 10:33:42 GMT

Hi jak,

did you check my post,

don't forget to reward for helpful answers.

Regards

vijay

Re: FM for extracting data

Former Member — Thu, 06 Apr 2006 10:36:08 GMT

Hi Vijay,

I checked your post .Thank You.

I al ready given reward points.

Re: FM for extracting data

Former Member — Thu, 06 Apr 2006 10:44:12 GMT

Hi Frineds,

I am little confuse in the FM RFC_CREATE_TABLE.

How to give the import paramaters?..Can any body give example..for those parameters..

QUERY_TABLE:

DELIMITER :

NO_DATA :

ROWSKIPS :

ROWCOUNT :

Thanks in Advance

Re: FM for extracting data

Former Member — Thu, 06 Apr 2006 10:49:26 GMT

   call function 'RFC_READ_TABLE'
         destination                rfc_sys
         exporting
              query_table          = 'DOKHL'
*             DELIMITER            = ' '
*             NO_DATA              = ' '
*             ROWSKIPS             = 0
*             ROWCOUNT             = 0
         tables
              options              = options1
              fields               = nametab1
              data                 = stmp_dokhl
         exceptions
              table_not_available  = 1
              table_without_data   = 2
              option_not_valid     = 3
              field_not_valid      = 4
              not_authorized       = 5
              data_buffer_exceeded = 6
              others               = 7 .

Check it...

Re: FM for extracting data

Former Member — Thu, 06 Apr 2006 10:53:19 GMT

Hi,

check this report<b> GETSU22TRACEDATA</b>, and in this it is used to read the data of table.

Regards

vijay

Re: FM for extracting data

athavanraja — Thu, 06 Apr 2006 10:55:23 GMT

check out this code sample, it may be of interest to you

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/abap-code-samples/abap code sample using rfc_read_table for webas.pdf

Regards

Raja

Re: FM for extracting data

Former Member — Thu, 06 Apr 2006 11:32:48 GMT

HI,

in FM RFC_READ_TABLE can i give a z-table in the query_table parameter?

Actually my requirement is reading data from z-tables.

whn given MARA table in query_table parameter it showing structure i mean fields of table but not showing data of table.can any body give solution?If i want to fetch data from morethan 30 or 40 z-tables , how ths FM will be help full?

Thanks in Advance.

Re: FM for extracting data

Former Member — Thu, 06 Apr 2006 11:42:01 GMT

Jak,

I think you can read only one table at one time using this. So, you will have to call this function so many times.

Rather, write a RFC on the CRM side, get all the data you want and call that from the R/3 side.

Regards,

Ravi

Re: FM for extracting data

Former Member — Thu, 06 Apr 2006 11:49:34 GMT

Hi Ravi,

Can you give some hints for writing RFC.

Bcoz..I don't know how to write RFC's

My requirement is: i have to fetch all the data from 40 z-tables in R/3 and i have to send to CRM system.

For this whre i have to wrire RFC , in R/3 or CRM?

Thanks in Advance.

Re: FM for extracting data

Former Member — Thu, 06 Apr 2006 11:57:39 GMT

Jak,

Depends on where you want to fetch the data from and where do you want to call it from. Please refer to the yesterday's thread where we discussed the same thing.

Here I am assuming that the data is in CRM and you want to pull that into R/3. If that is the case, code your RFC in CRM and call that from R/3.

However, given that we are talking about 40 Z tables, performance might be a concern here.

Writing a RFC is nothing but writing a function module with apprporiate parameters of tables that you want to fetch. SELECT the data and dump into the internal tables defined as parameters of the RFC.

Regards,

Ravi

Re: FM for extracting data

Former Member — Thu, 06 Apr 2006 12:00:53 GMT

Hi Jak,

there will not be much difference in FM and RFC.

you can do the it similar to FM. and if you want more tables then you should call so many times.

you need to check the option Remote enable.

Regards

vijay

Re: FM for extracting data

Former Member — Thu, 06 Apr 2006 12:21:18 GMT

Hi Ravi Kumar,

As per my uderstanding..the scenario is like this:

I have to fetch the data from z-tables in R/3 only.And i have create RFC in R/3 only.and i have to call that RFC from CRM.So i have to ftech the data from all z-tables and put in 40 internal tables separately and i have to pass all these internal tables in tables parameter of RFC.After that i have to call this RFC from CRM.

Am i right?...If any thig wrong in this pls clarify me..

Becoz..this solution i need little urgent.

Thanks & Regards