topic Re: Fetching the values in Application Development and Automation Discussions

Fetching the values

Former Member — Thu, 04 Sep 2008 11:38:07 GMT

I want to get the values of many fields all are present in the bseg table except the 2 fields waers and hwae2.when I looked in the bseg table the data element BDIF2 has the ref field as hwae2 and in the same way the field DMBTR has the ref field as waers.How to code to get the 2 values?

Re: Fetching the values

Former Member — Thu, 04 Sep 2008 11:46:53 GMT

In the select quiry use the field name to retrieve the data from the DB table.

Murthy

Re: Fetching the values

Former Member — Thu, 04 Sep 2008 11:47:52 GMT

use Select...up to 2 rows

Re: Fetching the values

Former Member — Thu, 04 Sep 2008 12:00:05 GMT

You want to fech expect 2 fields or exclude all fields expect 2 fields that you have asked for . Your question itself is question bec of the last line.

Declare your internal table like bseg structure .If you fetch the other two fields also its not going to impact your performance so you can go ahead by using select * into itab from BSEG.

Re: Fetching the values

Former Member — Thu, 04 Sep 2008 12:01:22 GMT

Hi,

I think there is no other option other than specifying all the fields explicitly. But in your case specifying that many nearly 310 fields explicitly is not an easy task. So the best thing is select all the fields from database directly into internal table with same structure and don't use those two fields while using which you don't want.

Hope this will give you some idea,

Regards,

Aswini.