topic Re: validate my select stmt please in Application Development and Automation Discussions

validate my select stmt please

Former Member — Fri, 17 Oct 2008 01:23:24 GMT

In my below select stmt,

I don't want to select when j_3astcu is SPACE

I mean when gt_soldto1-store_no is SPACE i don't want that value to be selected ?

how can I apply this logic below ?

IF NOT gt_soldto1[] IS INITIAL.

SELECT * " kunnr name2 j_3astcu

FROM kna1

INTO corresponding fields of TABLE gt_kna1

FOR ALL ENTRIES IN gt_soldto1

WHERE ( name2 LIKE 'Store#%'

OR name2 LIKE 'Store%' )

OR ( j_3astcu <> SPACE

AND j_3astcu = gt_soldto1-store_no )

AND LAND1 = 'US'.

OR LAND1 = 'US'.

ENDIF. " IF NOT gt_soldto[] IS INITIAL.

HELP ME PLEASE.

THANKS IN ADV.

Re: validate my select stmt please

Former Member — Fri, 17 Oct 2008 01:47:57 GMT

change the follwoing in where as

*j_3astcu NE SPACE*

AND j_3astcu = gt_soldto1-store_no )

rest in where condition you know better

Re: validate my select stmt please

Former Member — Fri, 17 Oct 2008 02:11:33 GMT

I used

OR ( j_3astcu

NE

SPACE

but it is not working

Re: validate my select stmt please

Former Member — Fri, 17 Oct 2008 02:15:22 GMT

Why you have 'OR' in the where condition?

paste your statement again, and tell what you want to do with that

Re: validate my select stmt please

Former Member — Fri, 17 Oct 2008 03:20:28 GMT

remove that space check from where condition. after the select delete if you want

SELECT * " kunnr name2 j_3astcu
FROM kna1
INTO corresponding fields of TABLE gt_kna1
FOR ALL ENTRIES IN gt_soldto1
WHERE ( name2 LIKE 'Store#%'
OR name2 LIKE 'Store%' )
OR  j_3astcu = gt_soldto1-store_no 
OR LAND1 = 'US'.
if sy-subrc eq 0,
 delete gt_kna1 where j_3astcu = ''.
endif.

Re: validate my select stmt please

Former Member — Mon, 20 Oct 2008 02:47:32 GMT

Will the below stmt helps?

SELECT * " kunnr name2 j_3astcu

FROM kna1

INTO corresponding fields of TABLE gt_kna1

FOR ALL ENTRIES IN gt_soldto1

WHERE ( name2 LIKE 'Store#%'

OR name2 LIKE 'Store%' )

OR ( j_3astcu NE SPACE

AND j_3astcu = gt_soldto1-store_no )

OR LAND1 = 'US'.

(   j_3astcu  NE SPACE
AND  j_3astcu = gt_soldto1-store_no )

Instead of deleting ?

Sorry .

THANKS IN ADV.

Re: validate my select stmt please

Former Member — Mon, 20 Oct 2008 03:39:41 GMT


" OR condition will help you..? i am doubtful. if it true or false , it will select the record
OR ( j_3astcu NE SPACE
AND j_3astcu = gt_soldto1-store_no )