topic Re: Select Statement Error in Application Development and Automation Discussions

Select Statement Error

Former Member — Mon, 22 Sep 2008 18:30:53 GMT

Friends,

I am trying to read values from MARC table.

This is the code i wrote:

data zstruct type marc.

select strgr into zstruct from marc.

endselect.

When the program is run, the values of strgr are not getting populated in zstruct.

Please let me know what is missing.

Thanks and Regards.

Re: Select Statement Error

naimesh_patel — Mon, 22 Sep 2008 18:36:38 GMT

You can use like this:


data: zstruct type marc.

select strgr into corresponding fields of zstruct from marc.

endselect.

But this it is not performance efficient.

You should take the values in the internal table and than process it.


data: zstruct type standard table of marc.

select * from marc into table zstruct where .....

Regards,

Naimesh Patel

Re: Select Statement Error

Sm1tje — Mon, 22 Sep 2008 18:38:37 GMT

you are trying to insert ONE field into a structure.

Better to declare a variable for strgr an move it into that.

Re: Select Statement Error

Former Member — Mon, 22 Sep 2008 19:40:47 GMT

Hi,

I have modified the code as follows:

data: zs type marc.

data: zstruct type standard table of marc.

select strgr from marc into table zstruct.

loop at zstruct into zs.

write zs-strgr.

endloop.

Still, the values are not getting populated in the internal table.

Please let me know what is missing.

Thanks and Regards.

Re: Select Statement Error

Former Member — Mon, 22 Sep 2008 19:43:52 GMT

Hi,

In your code.

Data: zstruct type marc.

When you declare like this, zstruct will have structure of marc. which contains all fields available in MARC table.

And you retriving only one field ie strgr from the table MARC and passing to the structure. now system will get confuse where to place this field in the given zstruct structure . so you have to use

select strgr into corresponding fields of zstruct from marc.

endselect.

now the sap system will put the outputdata from the select statement into structure field zstruct-strgr .

select strgr into corresponding fields of zstruct from marc.

write 😕 zstruct-strgr.

endselect.

now you will get the proper result.

Hope you got it.

Regards

Vardhan

Re: Select Statement Error

Former Member — Mon, 22 Sep 2008 19:48:31 GMT

Try:

DATA: zs TYPE marc.

DATA: zstruct TYPE STANDARD TABLE OF marc.

SELECT strgr
  FROM marc
  INTO CORRESPONDING FIELDS OF TABLE zstruct.

LOOP AT zstruct INTO zs.

  WRITE zs-strgr.

ENDLOOP.

Rob

Re: Select Statement Error

Former Member — Mon, 22 Sep 2008 19:48:48 GMT

in the select statement you have to use

select strgr from marc into corresponding fields of table zstruct.

now it will work

hope you got it

Regards

Vardhan

Re: Select Statement Error

naimesh_patel — Mon, 22 Sep 2008 20:07:38 GMT

Since you are selecting only one field from the MARC and your target (ZSTRUCT) has all the fields of the MARC you need to use the CORRESPONDING FIELDS OF addition in the Select query

I have modified your code.


data: zs type marc.
data: zstruct type standard table of marc.

select strgr 
   from marc 
   into corresponding fields of table zstruct.

loop at zstruct into zs.
  write / zs-strgr.
endloop.

Regards,

Naimesh Patel

Re: Select Statement Error

Former Member — Mon, 22 Sep 2008 20:14:33 GMT

Rob,

I tried running your code, but there is no output when your code is executed.

Thanks,

Arun.

Re: Select Statement Error

Former Member — Mon, 22 Sep 2008 20:23:15 GMT

That's because you don't have the '/' after the WRITE. (See Naimesh's code.)

Rob

Re: Select Statement Error

Former Member — Mon, 22 Sep 2008 20:31:44 GMT

Check out the table whether it contains data or not

data: zs type marc.

data: zstruct type standard table of marc.

select strgr

from marc

into corresponding fields of table zstruct.

if not ztruct[] is initial.

loop at zstruct into zs.

write / zs-strgr.

endloop.

else

message z(i001) with 'No Data in table'.

endif.

hope you will get the output now

Regards

Vardhan

Re: Select Statement Error

Former Member — Tue, 23 Sep 2008 06:30:29 GMT

You should also select all the key fields from the marc table into the internal table,

other than the strgr field.

Re: Select Statement Error

Former Member — Tue, 23 Sep 2008 06:47:31 GMT

Hello,

It is not necessary to select any key field.

Please try the following syntax.

select strgr from marc into CORRESPONDING FIELDS OF zstruct .

it will get values.

have tested it.

Thanks,

Rajat

Re: Select Statement Error

Former Member — Tue, 23 Sep 2008 07:01:32 GMT

Hi,

Instead of declaring internal table of type marc why don't you declare internal table with only one field

data:begin of t_marc occurs 0,

field1 type marc-field1,

end of t_marc.

select field1 from marc into table t_marc where 'condition'.

Re: Select Statement Error

Former Member — Wed, 24 Sep 2008 00:37:30 GMT

'/' is a formatting character to display items line by line. I dont think that would affect the logic of the program.

Re: Select Statement Error

Former Member — Wed, 24 Sep 2008 01:05:19 GMT

abap_inter,

I get the following error message when i use your code:

"Tables with headers are no longer supported in OO context"

Thanks and Regards.

Re: Select Statement Error

Former Member — Wed, 24 Sep 2008 01:30:54 GMT

Since i am using the code in web Dynpro, i have posted this question in WDA forum. I am closing this thread.

Thanks and Regards.

Re: Select Statement Error

Former Member — Wed, 24 Sep 2008 08:17:27 GMT

TYPES: BEGIN OF is_marc,

matnr TYPE matnr,

strgr TYPE strgr,

END OF is_marc.

DATA: zstruct TYPE STANDARD TABLE OF is_marc.

DATA: zs TYPE is_marc.

SELECT strgr FROM marc INTO CORRESPONDING FIELDS OF TABLE zstruct WHERE strgr ne ' '.

LOOP AT zstruct INTO zs.

WRITE: / zs-strgr.

ENDLOOP.

Re: Select Statement Error

Former Member — Wed, 24 Sep 2008 12:48:54 GMT


> '/' is a formatting character to display items line by line. I dont think that would affect the logic of the program.

It absolutely does affect the output of the program. If not there, it will put all output on the same line. Using it causes each WRITE to go to a new line.

Rob

Re: Select Statement Error

Former Member — Wed, 24 Sep 2008 13:07:00 GMT

Rob,

You are right. It affects the output of the program no doubt.

My reply specifically mentioned "logic of the program."

The internal table is not getting populated with values and thats where the problem lies. Not in the program output where "/" has its effects.

Thanks and Regards.