Fetching the values

[Former Member]

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?

[Former Member]

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

Murthy

[Former Member]

use Select...up to 2 rows

[Former Member]

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.

[Former Member]

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.