Showing results for 
Search instead for 
Did you mean: 

Retriving data from backend tables

Former Member
0 Kudos

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,


Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos


Former Member
0 Kudos

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.



Former Member
0 Kudos


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.