topic Re: Select Statment condition in Application Development and Automation Discussions

Select Statment condition

Former Member — Thu, 05 Feb 2009 15:52:49 GMT

Hi All,

I have a following select statement.

SELECT TSTC~PGMNA

TSTC~TCODE

TSTCT~TTEXT

TRDIR~SECU

INTO CORRESPONDING FIELDS OF TABLE IT_TEST

FROM ( TSTC inner join tstct on tstct_{tcode = tstc}tcode

INNER JOIN TRDIR ON TRDIR_{NAME = TSTC}PGMNA )

WHERE PGMNA IN S_PGNAME

and SPRSL IN S_LKEY.

in the above code I need to enter a condition that it should look out for only those Tcodes in the table TSTC where TSTC~PGMNA = ' ' " (space) ... so can you please tell me how can I do that.

thanks,

Rajeev

Re: Select Statment condition

ThomasZloch — Thu, 05 Feb 2009 15:57:40 GMT

Is S_PGNAME on your selection screen? If yes, then the desired condition can be entered there.

The INNER JOIN TRDIR needs to be changed to an LEFT OUTER JOIN, since there will not be an entry in TRDIR for these cases.

Thomas

P.S. include SPRSL = SY-LANGU in your join of TSTCT, otherwise there could be duplicates due to multi-language descriptions.

Re: Select Statment condition

Former Member — Thu, 05 Feb 2009 16:06:45 GMT

Thanks for the reply thomas.... now I am not worried about the TRDIR table... as you are right TRDIR table will not hold good in this case:

but can you please explain a more how to take care of that TSTC~PGMNA = ' ' condition? as I don't user to add this conditon.. what I want when ever a user execute this report he should see only those T-cdoes whch don't have program names.

my updated code is :

SELECT TSTC~PGMNA

TSTC~TCODE

TSTCT~SPRSL

TSTCT~TTEXT

INTO CORRESPONDING FIELDS OF TABLE IT_TCODELISTING

FROM ( TSTC inner join tstct on tstct_{tcode = tstc}tcode)

WHERE PGMNA IN S_PGNAME

and SPRSL IN S_LKEY.

Thanks,

Rajeev

Re: Select Statment condition

Former Member — Thu, 05 Feb 2009 16:14:22 GMT

Hi Rajeev,

SELECT TSTC~PGMNA

TSTC~TCODE

TSTCT~SPRSL

TSTCT~TTEXT

INTO CORRESPONDING FIELDS OF TABLE IT_TCODELISTING

FROM ( TSTC inner join tstct on tstct_{tcode = tstc}tcode)

WHERE PGMNA IN S_PGNAME

and SPRSL IN S_LKEY.

In your code you are checking using S_PGNAME, if input is not specified in Selection screen it will fectch all records.

So you can do

1) check WHERE PGMNA = ' '

why you are checking using S_PGNAME?

If you want to use S_PGNAME then

S_PGNAME-LOW = ' '.

S_PGNAME-OPTION = 'EQ'.

S_PGNAME-SIGN = 'I'.

APPEND S_PGNAME.

Regards,

Sunil

Edited by: Sunil Reddy Sibbala on Feb 5, 2009 5:25 PM

Re: Select Statment condition

ThomasZloch — Thu, 05 Feb 2009 16:14:41 GMT

Well, then either

> WHERE PGMNA = SPACE

> WHERE PGMNA IN S_PGNAME

and filling S_PGNAME before for selecting blank values: OPTION = "EQ", SIGN = "I", LOW = SPACE.

Thomas

Re: Select Statment condition

Former Member — Thu, 05 Feb 2009 16:29:57 GMT

Thanks for the reply Sunil... basically what I am looking for is the ability for the user to see all the Custom T_codes which doesn't have any program name assigned to it. So can you please tell me how can I get that.

THanks,

Rajeev

Re: Select Statment condition

Former Member — Thu, 05 Feb 2009 16:34:27 GMT

Hi,

This query could help you.

SELECT TSTC~PGMNA

TSTC~TCODE

TSTCT~SPRSL

TSTCT~TTEXT

INTO CORRESPONDING FIELDS OF TABLE IT_TCODELISTING

FROM TSTC

JOIN TSTCT

ON TSTCT_{TCODE = TSTC}TCODE

WHERE TSTC~PGMNA = ' '

AND TSTC~TCODE = 'Z#'

AND TSTCT~SPRSL = S_LKEY.

Thanks,

Pranav

Re: Select Statment condition

Former Member — Thu, 05 Feb 2009 16:39:03 GMT

Hi Pranav,

It didn't work.... it didn't fetch any data in the internal table

Re: Select Statment condition

Former Member — Thu, 05 Feb 2009 16:51:56 GMT

Hi,

Sorry you have to put LIKE there. Try this.

SELECT TSTC~PGMNA

TSTC~TCODE

TSTCT~SPRSL

TSTCT~TTEXT

INTO CORRESPONDING FIELDS OF TABLE IT_TCODELISTING

FROM TSTC

JOIN TSTCT

ON TSTCT_{TCODE = TSTC}TCODE

WHERE TSTC~PGMNA = ' '

AND TSTC~TCODE LIKE 'Z%' (or 'Y%')

AND TSTCT~SPRSL = S_LKEY.

Thanks,

Sudha

Re: Select Statment condition

Former Member — Thu, 05 Feb 2009 17:01:02 GMT

It's still behaving the same and not fetching anything in the internal table... somehow it's just skipping the whole select statement

tahnks,

Rajeev

Re: Select Statment condition

Former Member — Thu, 05 Feb 2009 17:04:58 GMT

It is working to me. Do you have any conditions before the select query?

Pranav

Re: Select Statment condition

Former Member — Thu, 05 Feb 2009 17:15:52 GMT

Rajeev - rather than just cutting and pasitng the code, do some desk checking to see if you can find the error before posting back to the forum.

Rob

Re: Select Statment condition

Former Member — Fri, 06 Feb 2009 02:48:05 GMT

Hi Pranav...

thanks for the reply... the conditon for tstc - pgmna = ' '... is not working!!!