topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 02 Nov 2006 23:34:14 GMT

Hello Experts,

Can anybody of you pleaes help me in writing the logic.

select matnr

werks

into table i_data

where matnr = i_mara-mantr

and werks IN s_werks.

here i have to execute the following logic if "S_WERKS" is not "US" and "EU".

loop at i_data.

..................................

endloop.

Thanks a lot.

Re: select statement

Former Member — Thu, 02 Nov 2006 23:37:17 GMT

RANGES R_WERKS FOR MARC-WERKS.

R_WERKS(3) = 'EEQ'.

R_WERKS-LOW = 'US'.

APPEND R_WERKS.

R_WERKS-LOW = 'EU'.

APPEND R_WERKS.

loop at i_data where werks in R_WERKS.

..................................

endloop.

Max

Re: select statement

Former Member — Thu, 02 Nov 2006 23:48:19 GMT

Thnx Max.

Can you please let me knwo if I want to check that condition before the "SELECT" statement how would I do that?

Thnx.

Re: select statement

Former Member — Thu, 02 Nov 2006 23:54:03 GMT

In the Initialization event you can populate the same into s_werks instead in r_werks. and use this s_werks in the select statement.

regards,

vamshi tallada

Re: select statement

Former Member — Fri, 03 Nov 2006 00:05:16 GMT

Have you tried:

select matnr
werks 
into table i_data
where matnr = i_mara-mantr
and ( werks IN s_werks and
      werks <> 'US' and
      werks <> 'EU ).

Max

Re: select statement

Former Member — Fri, 03 Nov 2006 00:08:49 GMT

i'm sorry for not giving u a clear idea of what I want.

the code is like this:

form get_data.

now i hve to check the plants (S_WERKS) first and if they are not 'US' and 'EU' then i hve to execute this following logic.

and if they are euqual to 'EU' or 'US', there is a different approach i hve to take.

select matnr

werks

into table i_data

where matnr = i_mara-matnr

and werks IN s_werks.

loop at i_data.

.......................

endloop.

Re: select statement

Former Member — Fri, 03 Nov 2006 00:23:53 GMT

Sorry...

DATA: BEGIN OF T_PLANT OCCURS 2,

WERKS TYPE WERKS,

END OF T_PLANT.

T_PLANT-WERKS = 'US'.

APPEND T_PLANT.

T_PLANT-WERKS = 'EU'.

APPEND T_PLANT.

DELETE T_PLANT WHERE WERKS IN S_WERKS.

IF SY-SUBRC <> 0.

> It means US and EU not in S_WERKS

ELSE.

DESCRIBE TABLE T_PLANT LINES SY-TABIX.

IF SY-TABIX = 0.

> It means US and EU are in S_WERKS

ELSE.

> It means US or EU are in S_WERKS

ENDIF.

Max

Re: select statement

Former Member — Fri, 03 Nov 2006 00:28:37 GMT

thanks for the help. i appreciate that.