Skip to Content
0
Mar 10, 2009 at 05:25 AM

Error in QM Data(Inspection types)

10 Views

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.