Skip to Content
0
Former Member
Dec 29, 2009 at 06:19 AM

Range table in INTO clause

5025 Views

Hi Experts,

I Have a table ZMCTR1AM_CNSTNTS with two columns n its entries are as follows.

FIELDNM FIELD_VAL_

Panel Names

Field Group Names

Field Last Name

Field Suffix

Field First Name

Field Middle Initial

Field Nick Name

I have to separate entries in this table based on FIELD_NM = 'PANEL', FIELD_NM = 'FIELD GROUP' and FIELD_NM = 'FIELD' and put them in separate range table.

My range table declaration is as follows,

DATA: ra_panel TYPE RANGE OF JQTATTRIBUTE-PANEL,

ra_field_group TYPE RANGE OF JQTATTRIBUTE-FIELD_GROUP,

ra_field TYPE RANGE OF JQTATTRIBUTE-FIELD.

My select query which didnt work,

SELECT field_val

FROM ZMCTR1AM_CNSTNTS

INTO TABLE ra_panel

WHERE field_nm EQ 'PANEL'.

I havent worked on ranges and tried a lot of search. But didnt find any info. that i could use. Can someone tel me how do i go about doing it. I cannot use SELECT...ENDSELECT and WITH HEADER LINE as coding stds.

Thanks in advance.

Edited by: Herwin Wilmet Dsouza on Dec 29, 2009 7:20 AM