Skip to Content

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

please validate my select stmt.

Can I use for all entries IN

with offset ?

SELECT KUNNR

FROM kna1

INTO TABLE gt_kna1

FOR ALL ENTRIES IN gt_soldto

WHERE name2+7(10) = gt_bstnk_storeno_kunnr-store_no

OR j_3astcu = gt_bstnk_storeno_kunnr-store_no.

Please guide me ... I need to select where kna1-name2 ( from 7th postion onwards ) contains the internal table value

then select kunnr field from kna1.

Thanks,

Tags:
Former Member replied

Hmmm....

Sorry - this isn't as simple as I first thought.

The solution I was thinking of involved patterns (Which is in the HELP for SELECT). But since you are using FOR ALL ENTRIES and not SELECT-OPTIONS or a range table, that doesn't help much.

You can still use a pattern, but it will involve looping through the internal table, and changing it to a pattern and using that in the SELECT.

An alternative is native SQL, but I think the first is better.

Sorry for my confusion Mea culpa

Rob

0 View this answer in context

Helpful Answer

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