topic Re: simple qa:::select -option status in Application Development and Automation Discussions

simple qa:::select -option status

Former Member — Sun, 03 Dec 2006 12:32:01 GMT

i have itab, in itab i have field stat that have 3 status ( a,b,c)

in the select-option i put a , ineed to get all the lines that have a ( ab,ac,a,aa....)

i use delete itab not where stat co status but it's not work fine.

Re: simple qa:::select -option status

Former Member — Sun, 03 Dec 2006 12:42:24 GMT

In select options use a* It will give all combinations.

Regards

Kathirvel

Re: simple qa:::select -option status

Former Member — Sun, 03 Dec 2006 12:49:45 GMT

i have a b c

a b

a a

b b c

c b c

a c in the itab.

i put in s.option a and i want all the lines that have a

( ihave space between the status)

Re: simple qa:::select -option status

Former Member — Sun, 03 Dec 2006 13:17:10 GMT

Then try a,

It will give all combination with or with out space and containing a in it.

Regards

Kathirvel

Re: simple qa:::select -option status

Former Member — Sun, 03 Dec 2006 14:01:56 GMT

but what is the code

delete itab where stat in status?

Re: simple qa:::select -option status

Clemenss — Sun, 03 Dec 2006 17:14:10 GMT

select-options:

s_status for itab-status.

delete itab where stat not in s_status.

when a was entered in select-options

delete itab where stat not in s_status

equivalent to

delete itab where stat NA 'a'.

Regards,

Clemens

Re: simple qa:::select -option status

Former Member — Sun, 03 Dec 2006 18:06:07 GMT

In your select options just put a,

It will give all combination with or with out space and containing a in it say ( ab,ac,a,aa....).

Then you need not use delete itab because a will provide you details pnlt that has a in it, as required for you.

To be more clear please post your code, we will be in a better state to provide suggestion.

Regards

Kathirvel

Re: simple qa:::select -option status

Former Member — Mon, 04 Dec 2006 11:44:58 GMT

delete itab NA not work....

i have in my itab, stat= abc acb abb

abc

abc abb

abb

acc

i insert in my s.option i_status: abc

i need to get all the three lines

what is rhe right statment delete???????????????

Re: simple qa:::select -option status

Former Member — Mon, 04 Dec 2006 12:03:39 GMT

Hi,

I hope the following code will helps you. You can write the code in at selection-screen event.

-- Retrieve all the domain values by calling FM

   CALL FUNCTION 'GET_DOMAIN_VALUES'
  EXPORTING
    domname              =  <domain name>
   TEXT                      = 'X'
   FILL_DD07L_TAB    = 'X'
 TABLES
   VALUES_TAB         = lt_values_tab <fixed value in domain>
   VALUES_DD07L     = <fixed values in DD07L Structure>
 EXCEPTIONS
   NO_VALUES_FOUND  = 1
   OTHERS                     = 2 .
IF sy-subrc <> 0.
Message 'Error ' type 'E'.
ENDIF.

* Read select-option values was supplied
if so_input is not initial.
read table so_input into wa_input index 1.

* Construct all the combination of in select-option parameter
loop at lt_values_tab into wa_values_tab.
 concatenate wa_input-low wa_values_tab-DOMVALUE_L into so_input-low.
 wa_input-sign = 'I'.
 wa_input-option = 'I'.
 append  wa_input into so_input.
Endloop.
endif.

Re: simple qa:::select -option status

jayanthi_jayaraman — Mon, 04 Dec 2006 12:17:15 GMT

Hi,

Just try

delete from itab where not stat in s_stat.

Re: simple qa:::select -option status

Clemenss — Mon, 04 Dec 2006 13:10:15 GMT

Hi,

wa_input-option = 'I'.

will cause a dump.

Regards,

Clemens