Hi,
I belive I have some issue regarding "for all entries" ?
clear: i_mara,i_mara[].
i_mara now includes 0 row.
i_mvke now includes 1 row.
Get MARA
select *
from mara
into corresponding fields of table i_mara
for all entries in i_mvke
where matnr eq i_mvke-matnr.
i_mara now includes 10000 rows.
i_mvke now includes 1 row.
I'm confused.... a for all entries in should work as a INNER JOIN ...?
I want i_mara to include only 1 row after the select..
//Martin
Message was edited by: Martin Andersson
Hi,
The <b>where matnr eq i_mvke-matnr</b> condition will fetch all records that match the given criteria. It you want to fetch only one record:
1. Issue ...UPTO 1 ROWS, or
2. Specify the WHERE clause upto complete key fields to uniquely identify a single row, or
3. Issue SELECT SINGLE...
Hope this helps.
Regards
Hello Martin,
you specify complete key of MARA, so this should work perfectly (just select into table, corresponding fields is slower).
Maybe your matnr in i_mvke hasn't correct format? Be sure, to use exact database format:
Most customers use rules, which are implemented in function module
CONVERSION_EXIT_ALPHA_INPUT
.
Regards,
Christian
Hi Martin,
Have you really <b>1</b> entry in table i_mvke ?
if there's no entry in i_mvke you'll get all entries
of mara in i_mara.
regards Andreas
Add a comment