Hi SDN
I have a generic extractor, which is created based on QINF table.
I have appended customized field and below is the code in CMOD.
SELECT SINGLE *
FROM qmel
WHERE lifnum = <fs>-lieferant
AND qmart = 'KV'.
if sy-subrc = 0.
<fs>-zzqmart = qmel-qmart.
<fs>-zzqmdat = qmel-qmdat.
<fs>-zzartpr = qmel-artpr.
<fs>-zzpriok = qmel-priok.
<fs>-zzqmnum = qmel-qmnum.
endif.
SELECT SINGLE *
FROM qmfe
WHERE qmnum = <fs>-zzqmnum.
if sy-subrc = 0.
<fs>-zzoteil = qmfe-oteil.
<fs>-zzotgrp = qmfe-otgrp.
<fs>-zzotkat = qmfe-otkat.
<fs>-zzqm_itm = qmfe-fenum.
endif.
But -zzoteil = qmfe-oteil is not working properly.QMEL table has multiple records for this filed, but it is pulling only one record.My requirement is to pull all the records associted with that qmnum(Notification).If Notification has 3 oteil, I wanted all of them displayed in the report.
I appended Item number field to the structure, but it is still showing Item number 1, eventhough it has 3 Item numbers.
For example:OTEIL field has values as 0010 and 0020.For some records, it pulls 0010 and for some it pulls 0020.
Can someone please let me know where the problem is? and how to fix it?
Thanks and points will be assigned !!!
Kumar