topic Re: Select MARA ordered by select-options? in Application Development and Automation Discussions

Select MARA ordered by select-options?

Former Member — Mon, 05 Dec 2011 16:10:50 GMT

Hi,

it try to get the data from mara ordered by the select-option, is this possible.

Normally i use:


TABLES: MARA.
*
SELECT-OPTIONS:   S_MATNR FOR MARA-MATNR.
*
select * from mara where matnr in s_matnr.
  write: / mara-matnr.
endselect.

Is there any FM, BAPI or any parameter for "ORDER BY" which i get use?

Thanks.

Regards, dieter

Re: Select MARA ordered by select-options?

Former Member — Tue, 06 Dec 2011 03:51:11 GMT

change the select query like this:

select * from mara where matnr in s_matnr ORDER BY matnr.

If you are not using order by clause in select query by default it takes sorted values from table.

Regards,

Priyanka

Re: Select MARA ordered by select-options?

Former Member — Tue, 06 Dec 2011 05:25:46 GMT

Deiter,

your question is not very clear. what do you mean by order by select option?

Re: Select MARA ordered by select-options?

Former Member — Tue, 06 Dec 2011 08:07:14 GMT

Hi,

thanks for your answer.

What i mean is this:

In selection screen i insert this value: 3, 2, 4, 1.

the output is 1, 2, 3, 4, but i will get this: 3, 2, 4, 1 like my selection.

Is this possible?

Regards, Dieter

Re: Select MARA ordered by select-options?

kesavadas_thekkillath — Tue, 06 Dec 2011 08:13:34 GMT

Not possible through select query - Read SAP help. Try to do it in the coding if required.

Re: Select MARA ordered by select-options?

Former Member — Tue, 06 Dec 2011 09:13:51 GMT

Hi ,

Use ascending /descing in query.

select * from mara where matnr in s_matnr ORDER BY matnr descending

select * from mara where matnr in s_matnr ORDER BY matnr asceneding

As per requirement.

regards,

Praphull

Edited by: T Praphull on Dec 6, 2011 10:27 AM

Re: Select MARA ordered by select-options?

Former Member — Tue, 06 Dec 2011 09:30:56 GMT

you can use asc or desc :-

select <field > from mara order by <field> asc/desc.

by default it is asc thats why u were gertting 1 2 3 4 like that.

hope this helps ..

regards ,

somesh

Re: Select MARA ordered by select-options?

Former Member — Tue, 06 Dec 2011 09:43:18 GMT

Not possible..

Use in your coding section ..

thanks

Re: Select MARA ordered by select-options?

Former Member — Tue, 06 Dec 2011 14:42:40 GMT

It would be pretty difficult to do even with coding.

What do you do if the user has entered patterns, or exclusions or NEs?

Rob

Re: Select MARA ordered by select-options?

RaymondGiuseppi — Tue, 06 Dec 2011 15:12:11 GMT

Just for the fun

TABLES: mara.
* data def
DATA: t1_mara TYPE TABLE OF mara WITH HEADER LINE,
      t2_mara TYPE TABLE OF mara WITH HEADER LINE,
      s2_matnr TYPE RANGE OF mara-matnr.
* selection screen
SELECT-OPTIONS so_matnr FOR mara-matnr.

START-OF-SELECTION.
* load wholde data in temp itab
  SELECT * INTO TABLE t1_mara FROM mara
    WHERE matnr IN so_matnr
    ORDER BY matnr.
* now final itab
  REFRESH t2_mara.
* for every Include select option, process its own records
  LOOP AT so_matnr WHERE sign = 'I'.
    REFRESH s2_matnr.
    APPEND so_matnr TO s2_matnr.
    LOOP AT t1_mara WHERE matnr IN s2_matnr.
      APPEND t1_mara TO t2_mara.
      DELETE t1_mara.
    ENDLOOP.
  ENDLOOP.
* If there is no "I" records,
  IF t1_mara[] IS NOT INITIAL.
    APPEND LINES OF t1_mara TO t2_mara.
  ENDIF.
* free memory
  REFRESH t1_mara. " FREE
* Proof of concept
  LOOP AT t2_mara.
    WRITE: / t2_mara-matnr.
  ENDLOOP.

Regards,

Raymond

Re: Select MARA ordered by select-options?

Former Member — Tue, 06 Dec 2011 15:18:10 GMT

And what do you do if there are overlapping ranges:

1-10

5-20

Rob

Re: Select MARA ordered by select-options?

RaymondGiuseppi — Tue, 06 Dec 2011 15:20:09 GMT

First selection will win, if you accept duplicates, just remove the "DELETE t1_mara."

(only for 5-20 then 1-10, else no problem)

Regards,

Raymond

Re: Select MARA ordered by select-options?

Former Member — Tue, 06 Dec 2011 15:29:43 GMT

No, I mean that the requirements are contradictory. Do the entries 5-10 come after 1-4 because they are in the first select-options or after 1-10 because they are in the second.

Rob

Re: Select MARA ordered by select-options?

RaymondGiuseppi — Tue, 06 Dec 2011 15:34:56 GMT

- If you keep the delete, they come after 1-4 cause they are in the first range and will only appear once

- If you remove the delete they will come twice

The request should be completed for "duplicated selections", are they to be displayed once or as many times they were selected.

But honestly, no user ever dared to make such a request (am I too harsh?)

Regards,

Raymond

Re: Select MARA ordered by select-options?

Former Member — Tue, 06 Dec 2011 15:45:07 GMT


But honestly, no user ever dared to make such a request (am I too harsh?)

No, but the first thing a developer has to do after receiving new specs is to question them and make sure that the user understands exactly what they are asking for.

Only start coding after this is done.

Rob