Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Error in QM Data(Inspection types)

former_member342013
Contributor

‎03-10-2009 5:25 AM

0 Kudos

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.

2 REPLIES 2

Former Member

‎03-10-2009 5:41 AM

0 Kudos

Hi,

Try like below code

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

Regards

Md.MahaboobKhan

Former Member

‎03-10-2009 5:43 AM

0 Kudos

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