Dear Friends,
LOOP AT IT_ZSD012_001 INTO WA_ZSD012_001.
SELECT A~MATNR A~LABST A~UMLME A~INSME A~EINME A~SPEME A~RETME B~MTART
APPENDING TABLE IT_INVENTORY
FROM MARD AS A
INNER JOIN MARA AS B ON B~MATNR EQ A~MATNR
WHERE A~MATNR = '1.1.1'
and A~WERKS EQ WA_ZSD012_001-PARAM_1
AND A~LGORT EQ WA_ZSD012_001-VALUE
AND A~LABST GT 0
OR ( A~UMLME GT 0
OR A~INSME GT 0
OR A~EINME GT 0
OR A~SPEME GT 0
OR A~RETME GT 0 )
AND B~MTART IN ('ZFG1' , 'ZFG4' , 'ZR12' ).
ENDLOOP.
this is my code (select statement)
but this is not working, when i execute this so many materials came to the itab it should come only "1.1.1"
my requirement is i want to get data from MARD agaist WERKS, LGORT and also MARA-MTART in that groups.
its came with zero inventory, i want to avid them how can i do this.
hope you can understand what i an said?
Thanks in advanced