topic Re: FM to read Database table in Application Development and Automation Discussions

FM to read Database table

Former Member — Mon, 07 Sep 2009 09:53:08 GMT

Hi,

Is there any FM to read values from database table. I can do it by writing select query but I want to do it through an FM .

Please help me.

Thanks,

Sravanthi

Re: FM to read Database table

former_member222860 — Mon, 07 Sep 2009 09:55:43 GMT

Use this FM

RFC_GET_TABLE_ENTRIES

Re: FM to read Database table

SuhaSaha — Mon, 07 Sep 2009 09:56:49 GMT


> Is there any FM to read values from database table. I can do it by writing select query but I want to do it through an FM .

Why do you want to do so? Is it like you hate SELECT statements?

@Mahesh: Is it easy(& also performance efficient) to write a SELECT stmt or use RFC_GET_TABLE_ENTRIES(where you have no filter to select data) to select data ?

Suhas

Re: FM to read Database table

kesavadas_thekkillath — Mon, 07 Sep 2009 10:02:36 GMT

SELECT_SINGLE_FROM_DBTAB

Re: FM to read Database table

Former Member — Mon, 07 Sep 2009 10:12:18 GMT

You will require FM , only when you do not have authorization to directly access the table.

OR you need to fetch data from remote system. Analyse your requirement and proceed.