Inspection Type for Material

Former Member · ‎2009 Mar 05

Hi

I want all the Materials having inspection types and also i want materials not

having inspetion types to be displayed...

im doing this by joining tables in SQVI transaction.

Im joining 3-tables

MARA

MARC

QMAT

now my problem is, it is displaying materials having Inspection type...

Bt it is not displaying Materials that are not having Inspection type...

Can any one help me on this?

Former Member · ‎2009 Mar 05

what is the join condition u have specified?

кu03B1ятu03B9к

Former Member · ‎2009 Mar 05

hi

in joining conditions i have specified

MARA and QMAT

Sandeep_Panghal · ‎2009 Mar 05

Join mara and marc on Matnr and join qmat and mara again on matnr.

AS you want to fetch all inspection types or no inspection types ,so no need to specify ART in WHERE clause , this should suffice .

Former Member · ‎2009 Mar 05

hi sandeep

Im not writing any query for this

im using table join...