topic Re: SELECT where COND query in Application Development and Automation Discussions

SELECT where COND query

Former Member — Fri, 26 Dec 2008 17:36:58 GMT

I would like to take first 9 digit from a table column where input match with 9 digit.

for e.g PROJ table , column ZUONR(9).

How to do in the select statement where cond?

Select * from PROJ into IT_TAB where ZUONR(9) = input ZUONR.

Any suggestion

Re: SELECT where COND query

Former Member — Fri, 26 Dec 2008 17:41:11 GMT

Field ZUONR in PROJ not exist.

Reframe your question with right information and good language.

Re: SELECT where COND query

Former Member — Fri, 26 Dec 2008 17:55:24 GMT

I have an internal table with zvalue - containing 9 digit values only .

I'm using this value in a select statement of PROJ Where PSPID = intab value.

There are some cases where pspid has 10 digits so i need to compare only 9 digits of PSPID with my internal table value.

SELECT * FROM WHERE PSPID = ITAB-ZVALUE.

this select will retrieve only values where pspid has 9 digits.

but if proj-pspid has 10 digits i need to check the 9 digits of PSPID with my itab value.

Any suggestion

Edited by: Prabha on Dec 26, 2008 11:00 AM

Re: SELECT where COND query

Former Member — Fri, 26 Dec 2008 18:06:52 GMT

Press F1 on SELECT WHERE and look at wildcards.

Rob

Re: SELECT where COND query

GuyF — Fri, 26 Dec 2008 18:07:19 GMT

Hi,

Try Select * from PROJ into IT_TAB where PSPID(9) LIKE '%xxx'.

Guy.

Re: SELECT where COND query

Former Member — Fri, 26 Dec 2008 18:08:35 GMT

tables:proj."This is must
data:it_itab TYPE STANDARD TABLE OF proj WITH HEADER LINE.
Select * from PROJ. 
  IF proj-PSPID(9) = xxx.
APPEND proj to it_itab.
  ENDIF.
  ENDSELECT.

Re: SELECT where COND query

Former Member — Fri, 26 Dec 2008 18:14:26 GMT


> Hi,
> 
> Try Select * from PROJ into IT_TAB where PSPID(9) LIKE '%xxx'.
> 
> Guy.

This Will Syntax Error.

Re: SELECT where COND query

GuyF — Fri, 26 Dec 2008 18:16:57 GMT

I didn't mean "Try" as in the command, but as in "attempt the following code".

Re: SELECT where COND query

Former Member — Fri, 26 Dec 2008 18:32:07 GMT

Yes,I know every one gives here some Code snippet(only idea,Not exact code ).

But your basic suggestion( PSPID(9) with Select query ) would give syntax error.We cannot use Offsets with select queries.

Re: SELECT where COND query

Former Member — Fri, 26 Dec 2008 18:55:00 GMT

Without if condition is it possible in select statement?becoz i'm joining two table, other table has only 9 digit in the table coumn?

Re: SELECT where COND query

Former Member — Fri, 26 Dec 2008 19:08:23 GMT

LOOP AT itab.
           SELECT * FROM prpj.
    
if prpj-PSPID(9) = itab-pspid.
                      APPEND prpj TO itab2 .
endif.
      ENDSELECT.
    ENDLOOP.

With select query we cannot use Offsets anyway.So you may need to do work some around this only.

Re: SELECT where COND query

Former Member — Fri, 26 Dec 2008 21:54:39 GMT

Thanks for the help.