topic Re: How to retrieve data without using Select statement in Application Development and Automation Discussions

How to retrieve data without using Select statement

Former Member — Mon, 04 Dec 2006 07:12:33 GMT

hi guys,

does anyone know if there's a standard bapi to retrieve the data from a given table?

I can't use Select statement and it will cause an error since I'm using a variable for the tablename.

Points for helpful ideas.

Thanks!

Re: How to retrieve data without using Select statement

Former Member — Mon, 04 Dec 2006 07:15:32 GMT

Use the function RFC_READ_TABLE to read any table.

Regards

Ravi

Re: How to retrieve data without using Select statement

Former Member — Mon, 04 Dec 2006 07:16:00 GMT

Hi,

which table do you want to read data from,

you have FM's through which you can read data,

E.g. READ_KNA1,READ_VBUK etc...

check out in SE37.

Regards,

Raghavendra

Re: How to retrieve data without using Select statement

Former Member — Mon, 04 Dec 2006 07:30:38 GMT

assume <b>t_text</b> as the variable

read_vbak where ... (give condition)

In this, whole record for the current condition will retrieve. then u can use it.

Re: How to retrieve data without using Select statement

Former Member — Tue, 05 Dec 2006 06:56:06 GMT

Thanks Ravikumar, that helps.

Can I convert this (DATA table on RFC_READ_TABLE) into a separate fields? I am using CALL METHOD CL_ALV_TABLE_CREATE=>CREATE_DYNAMIC_TABLE that creates a dynamic table based on a number of fieldnames of p_table. And I already have an internal table for p_table = PA0001. The problem is to get the data that I got from RFC_READ_TABLE and trasfer into ref_table.

CALL METHOD CL_ALV_TABLE_CREATE=>CREATE_DYNAMIC_TABLE

EXPORTING

IT_FIELDCATALOG = lt_fcat

IMPORTING

EP_TABLE = ref_table.

Re: How to retrieve data without using Select statement

Former Member — Tue, 05 Dec 2006 06:56:32 GMT

Thanks guys!

Re: How to retrieve data without using Select statement

athavanraja — Tue, 05 Dec 2006 09:40:49 GMT

check this code sample to handle this data table.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f50dcd4e-0501-0010-3596-b686a7b51492

Regards

Raja