Retriving data from backend tables

[Former Member]

Hi All,

I have one requirement to retrive the data from backend tables.

Is there any code to retrive only the first row of table from backend.

Please provide me any solution for this.

Thanks in Advance!

Thanks & Regards,

Sreelakshmi.

[Former Member]

Thanks!

[Former Member]

Hi ,

First create a Function module and within it write a query to only select first record from table.

and pass the record in a table .Then expose the function module as Remote.

Then create a model in the webdynpro application and use the function module that will only return

one piece of data. Bind the data in the context and display it in table in webdynpro.

Thanks

Ritushree

[Former Member]

Hi,

create a remote enabled rfc with export parameter IT_RESULT TYPE ZSSHDR(transp. table).

use code :

DATA: itab type table of ZSSHDR .

select * from ZSSHDR into table itab .

Read table itab into it_result index 1.

in RFC.

use this rfc in ur DC.

Amit