Skip to Content

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

select stmt offset - how can I use select stmt to fetch data.

kna1-name2 contains store#XXXXXXX where XXXXXXX is a store number. example : store#3564261.

I must fetch this. how can i fetch this ?

Can I use

WHERE substr(name2,7,10) CS gt_soldto1-store_no

or can I use

WHERE name2+7(10) CS gt_soldto1-store_no

along with for all entries IN gt_soldto1

in the below select stmt.

*SELECT *

FROM kna1

INTO corresponding fields of TABLE gt_kna1

FOR ALL ENTRIES IN gt_soldto1

WHERE substr(name2,7,10) as gt_soldto1-store_no

OR j_3astcu = gt_soldto1-store_no

THANKS IN ADV

Tags:
Former Member
replied

Try this:

WHERE name LIKE 'store#%'.

0 View this answer in context

Helpful Answer

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