Code: Alles auswählen.
SELECT matnr FROM mara
INTO TABLE itab
WHERE matnr IN imatnr
AND matnr NE ''.
LOOP AT itab.
SELECT SINGLE knumh FROM a006
INTO itab-knumh
WHERE matnr = itab-matnr
and pltyp in ipltyp
and waerk = 'EUR'
and datbi >= sy-datum
and datab =< sy-datum.
select single kbetr from konp
into itab-kbetr
where knumh = itab-knumh
and konwa = 'EUR'
and loevm_ko = ''.
select single kznep from konp
into itab-kznep
where knumh = itab-knumh
and loevm_ko = ''.
WRITE: / itab-matnr, itab-kbetr, itab-kznep.
ENDLOOP.
Code: Alles auswählen.
SELECT c~carrname p~connid f~fldate
INTO CORRESPONDING FIELDS OF TABLE itab
FROM ( ( scarr AS c
INNER JOIN spfli AS p ON p~carrid = c~carrid
AND p~cityfrom = p_cityfr
AND p~cityto = p_cityto )
INNER JOIN sflight AS f ON f~carrid = p~carrid
AND f~connid = p~connid ).
Code: Alles auswählen.
LOOP AT itab.
select a~knumh k~kbetr k~kznep
into corresponding fields of itab
from (a006 as a inner join konp as k on
a~knumh = k~knumh)
where ....
ENDLOOP.
Code: Alles auswählen.
SELECT mar~matnr a6~kunumh kp~kbetr kp~kznep
FROM (
( mara as ma
INNER JOIN a006 AS a6 ON a6~matnr = ma~matnr
AND ma~pltyp IN ipltyp
AND ma~waerk = 'EUR'
AND datbi GE sy-datum
AND datab LE sy-datum )
INNER JOIN konp AS kp ON kp~knumh = a6~knumh
AND kp~konwa = 'EUR'
AND kp~loevm_ko = '')
INTO CORRESPONDING FIELDS OF TABLE itab
WHERE matnr IN imatnr
AND matnr NE ''.