topic Re: query on select query in Application Development and Automation Discussions

query on select query

Former Member — Tue, 24 Jul 2007 11:49:33 GMT

hi,

in my selection screen i have 5 fields

ie matnr mtart matkl erdsa from table mara and

werks from table marc

o/p

if i input any one of the 5 fields in the selection screen i need the output for all the 5 fields which matches the selection condition.

Thanks in advance.

Re: query on select query

Former Member — Tue, 24 Jul 2007 11:52:43 GMT

hi..

You can use AT SELECTION SCREEN ON FIELD (field) and then u can write the SELECT QUERY matching the condition..

Reward points if useful

Regards

Ashu

Re: query on select query

Former Member — Tue, 24 Jul 2007 11:54:42 GMT

hi,

you can build your condition in the query dynamically,

if a parameter is initial, or a star replace the value by %

....

first condition

...

IF matnr IS INITIAL.

matnr = '%'.

ELSE.

REPLACE ALL OCCURRENCES OF '*'

IN matnr WITH '%'.

REPLACE ALL OCCURRENCES OF '+'

IN matnr WITH '_'.

ENDIF.

CONCATENATE lv_condition

'AND MATNR LIKE MATNR'

INTO lv_condition

SEPARATED BY space.

....

select * from mara into lt_mara where (lv_condition).

grtz,

Koen

Re: query on select query

Former Member — Tue, 24 Jul 2007 11:58:42 GMT

hi selva

your question is not so clear

but as per my understanding

select mara_{matnr mara}mtart mara_{matkl mara}erdsa marc~werks from table mara

innerjoins marc on (use the condition here) where matnr in s_matnr and mrart in s_mtart and so on

Re: query on select query

Former Member — Tue, 24 Jul 2007 12:07:42 GMT

Hello,

Check this code :

[code]TABLES: mara,marc.

SELECT-OPTIONS: s_matnr FOR mara-matnr NO INTERVALS,

s_mtart FOR mara-mtart NO INTERVALS,

s_matkl FOR mara-matkl NO INTERVALS,

s_ersda FOR mara-ersda NO INTERVALS,

s_werks FOR marc-werks NO INTERVALS.

DATA: BEGIN OF itab OCCURS 0,

matnr TYPE matnr,

mtart TYPE mtart,

matkl TYPE matkl,

ersda TYPE ersda,

werks TYPE werks_d,

END OF itab.

DATA: wa_tab LIKE LINE OF itab.

SELECT a_{matnr a}mtart a_{matkl a}ersda

b~werks

FROM mara AS a JOIN marc AS b

ON b_{matnr = a}matnr

INTO TABLE itab

WHERE a~matnr IN s_matnr

AND a~mtart IN s_mtart

AND a~matkl IN s_matkl

AND a~ersda IN s_ersda

AND b~werks IN s_werks.

IF sy-subrc <> 0.

ENDIF.[code]

Regards,

Deepu.K

Re: query on select query

Former Member — Tue, 24 Jul 2007 12:09:24 GMT

hi i make myself clear,

in my selection screen i have 5 fields

ie matnr mtart matkl erdsa from table mara and

werks from table marc

o/p

if i input atleast one of the 5 fields in the selection screen

note:not neccesarily only one ie atleast one

i need the output for all the 5 fields which matches the selection condition ie based on the values in selection screen.

eg:

if i i/p 1 for matnr in selection screen

it should display the records for mtart matkl werks erdsa for matnr = 1.

Thanks in advance.

Re: query on select query

Former Member — Tue, 24 Jul 2007 12:11:35 GMT

Hello,

Check this code :

TABLES: mara,marc.

SELECT-OPTIONS: s_matnr FOR mara-matnr NO INTERVALS,
                s_mtart FOR mara-mtart NO INTERVALS,
                s_matkl FOR mara-matkl NO INTERVALS,
                s_ersda FOR mara-ersda NO INTERVALS,
                s_werks FOR marc-werks NO INTERVALS.


DATA: BEGIN OF itab OCCURS 0,
        matnr TYPE matnr,
        mtart TYPE mtart,
        matkl TYPE matkl,
        ersda TYPE ersda,
        werks TYPE werks_d,
      END OF itab.
DATA: wa_tab LIKE LINE OF itab.



SELECT a~matnr a~mtart a~matkl a~ersda
       b~werks
       FROM mara AS a JOIN marc AS b
       ON b~matnr = a~matnr
       INTO TABLE itab
       WHERE a~matnr IN s_matnr
       AND   a~mtart IN s_mtart
       AND   a~matkl IN s_matkl
       AND   a~ersda IN s_ersda
       AND   b~werks IN s_werks.

IF sy-subrc <> 0.
ENDIF.

Regards,

Deepu.K

Re: query on select query

Former Member — Tue, 24 Jul 2007 12:21:33 GMT

HI DEEPU..

THANK U VERY MUCH..

NOW ITS WORKING.

I AM USING THE SAME LOGIC BUT WITH PARAMETERS