Error in QM Data(Inspection types)

[Former Member]

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.

[Former Member]

Hi,

Try like below code

Select * from <DB> into <ITAB> wherr <Inspection Type> EQ ' '.

Regards

Md.MahaboobKhan

[Former Member]

If u need Inspection details..

1.Can use QALS ,QAVE Tables

Or

2. BAPI_INSPLOT_GETDETAIL Can be used to get the details..

Not sure whether this can help you..but this is what i have used for one inpection report..