Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

validate my select stmt please

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.

Tags:
Former Member
Former Member replied
" 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 )
0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question