Hi
i want all inspection types for all materials...
n i want to display materials that are not having inspection types...
i WANT BELOW OUTPUT.
Eg: MATNR- WERKS- ART
10002-1120- 01
02
03
10003-1130
I have Written this below Query'
My Problem is im not getting all Inspection types for material it is displaying only one inspection type
Can anybody help me on this?
SELECT MATNR
WERKS
FROM MARC
INTO CORRESPONDING FIELDS OF TABLE IT_FINAL
WHERE MATNR IN S_MATNR.
IF IT_FINAL[] IS NOT INITIAL.
SELECT ART
MATNR
WERKS
FROM QMAT
INTO CORRESPONDING FIELDS OF TABLE IT_QMAT
FOR ALL ENTRIES IN IT_FINAL
WHERE MATNR = IT_FINAL-MATNR
AND WERKS = IT_FINAL-WERKS.
ENDIF.