08-17-2012 6:03 AM
Dear Friends,
I have declared an internal table .
DATA: ITAB1 LIKE PA0001 OCCURS 0 WITH HEADER LINE.
and I have select the data into it.
SELECT * FROM PA0001 INTO CORRESPONDING FIELDS OF TABLE ITAB1
WHERE PERNR IN S_PERNR
AND WERKS IN S_WERKS
AND BTRTL IN S_BTRTL
AND ENDDA GE P_FPEND .
but now the problem is that I have to first select a filed MASSN which is in different table Pa0000 into itab1 .
and I have to delete the entries from itab1 where MASSN eq 'H6' .
so how can I full fill this , Please suggest .
Regards,
Rihan
Moderator message : Not enough re-search before posting, discussion locked.
Message was edited by: Vinod Kumar
08-17-2012 7:32 AM
first internal table .
DATA: ITAB1 LIKE PA0001 OCCURS 0 WITH HEADER LINE.
SELECT * FROM PA0001 INTO CORRESPONDING FIELDS OF TABLE ITAB1
WHERE PERNR IN S_PERNR
AND WERKS IN S_WERKS
AND BTRTL IN S_BTRTL
AND ENDDA GE P_FPEND .
second internal table .
DATA: ITAB LIKE PA0000 OCCURS 0 WITH HEADER LINE.
LOOP AT ITAB1 .
SELECT PERNR FROM PA0000 INTO ITAB-PERNR WHERE PERNR EQ ITAB1-PERNR AND MASSN EQ 'H6'.
IF SY-SUBRC EQ 0.
DELETE ITAB1.
ENDIF.
ENDSELECT.
ENDLOOP.
the requirement has been fullfilled by me .
Regards,
Rihan