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:
Rob Burbank 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