Skip to Content
0
Former Member
Dec 07, 2006 at 09:40 PM

Generic datasource data is not extracting properly

65 Views

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