topic Error in QM Data(Inspection types) in Application Development and Automation Discussions

Error in QM Data(Inspection types)

Former Member — Tue, 10 Mar 2009 05:25:45 GMT

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

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 — Tue, 10 Mar 2009 05:41:01 GMT

Hi,

Try like below code

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

Regards

Md.MahaboobKhan

Former Member — Tue, 10 Mar 2009 05:43:17 GMT

If u need Inspection details..

1.Can use QALS ,QAVE Tables

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..