Hi all,
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.
i need mjahr also from mseg .Top part is working.
********************************************************************************
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 its not working.how to write query for that.