hi,
LOOP AT ITAB.
IF S_KUNNR IS not INITIAL.
SELECT MAX( MBLNR ) FROM MSEG INTO MBLNR
WHERE MATNR EQ ITAB-MATNR
AND KUNNR EQ ITAB-KUNNR
AND BWART eq '951'.
else.
SELECT MAX( MBLNR ) FROM MSEG INTO MBLNR
WHERE MATNR EQ ITAB-MATNR
AND KUNNR ne ' '
and sobkz eq 'V'
AND BWART eq '951'.
endif.
******************************************************************************
top part is working
from that query i need mjahr also from mseg.
LOOP AT ITAB.
IF S_KUNNR IS not INITIAL.
SELECT MAX( MBLNR ) mjahr FROM MSEG INTO MBLNR mjahr
WHERE MATNR EQ ITAB-MATNR
AND KUNNR EQ ITAB-KUNNR
AND BWART eq '951'.
else.
SELECT MAX( MBLNR ) mjahr FROM MSEG INTO MBLNR mjahr
WHERE MATNR EQ ITAB-MATNR
AND KUNNR ne ' '
and sobkz eq 'V'
AND BWART eq '951'.
endif.
after adding mjahr in select query it is not working.from the statement i need both (max)mblnr
and mjahr.how to write query.