topic Re: select-options in Application Development and Automation Discussions

select-options

Former Member — Fri, 15 Feb 2008 14:39:54 GMT

Hi all,

I have a declaration like

data : begin of it_data occurs 0,

matnr like mara-matnr,

ernam like mara-ernam,

end of it_data.

select-options s_data for it_data.

so frnds can anyone tell me what is the problems in using this select-options and any performance problem.

regards,

satish

Re: select-options

Former Member — Fri, 15 Feb 2008 14:44:08 GMT

Hi Satish,

You can not use SELECT-OPTION for an internal table.

You can only use Database tables.

And for using these table u have to define them in the top by using TABLES option.

Example if u want to use table field from MATNR in your select option.

Do like this.

TABLES : MATNR.

SELECT-OPTIUON.................................... and so on.

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Feb 15, 2008 2:51 PM

Re: select-options

Former Member — Fri, 15 Feb 2008 14:45:36 GMT

Hi,

Select-options are declared only for feilds not for table. In your requirement you have to declare as

select-options: s_matnr for mara-matnr,

s_erdat for mara-erdat.

then it will execute perfectly.

Thanks

Sarada

Re: select-options

Former Member — Fri, 15 Feb 2008 14:53:19 GMT

hi,

here s_data is internal Table.

The Components of This S_DATA is.

SIGN OPTION LOW-MATNR LOW-ERNAM HIGH-MATNR HIGH-ERNAM.

After execution of program if u give any value for low.

Every time it is assiging to LOW-MATNR.

we can not Assign the value LOW-ERNAM.

Similarly for HIGH-ERNAM also.

That is only the drawback with the above Declaration..

Anyway u done a Nice experiment.

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Feb 15, 2008 2:52 PM

Re: select-options

Former Member — Fri, 15 Feb 2008 15:08:04 GMT

Edited by: pranjali mode on Feb 15, 2008 4:36 PM

Re: select-options

RaymondGiuseppi — Fri, 15 Feb 2008 15:09:19 GMT

By using this syntax, you get a SELECT-OPTIONS on a CHAR field of length 30

Be aware than in low field (resp. high) the conversion exit for matnr has not been executed,

Also, user will have to count the character and no search help available.

And you wont be able to use this SELECT-OPTIONS in a SELECT ... WHERE X IN selopt.

Interesting, but what was your purpose?

Regards

Re: select-options

Former Member — Fri, 15 Feb 2008 15:35:43 GMT

Hi,

After execution, it will display low option and high option with 30char length each(18 matnr & 12 ernam)..

So when u wil fill 30 characters in low then it wil fill matnr-low and ernam-low in sequence same applies to high option. Here we can access all fields MATNR-LOW HIGH & ERNAM-LOW HIGH. And selection table strucre wil b like sign option matnr-low ernam-low matnr-high ernam-high.

So it will execute normally.

<REMOVED BY MODERATOR>

-Pranjali.

Edited by: Alvaro Tejada Galindo on Feb 15, 2008 2:53 PM

Re: select-options

Former Member — Fri, 15 Feb 2008 19:07:25 GMT

SELECT-OPTION for DB table fields not for internal table fields.

you use code like this

data : abc type mara-matnr. (instead of table it is efficient)

data : begin of it_data occurs 0,

matnr like mara-matnr,

ernam like mara-ernam,

end of it_data.

select-options s_data for abc.