topic Re: Inspection Type for Material in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/inspection-type-for-material/m-p/5286055#M1219727 <HTML><HEAD></HEAD><BODY><P>Join mara and marc on Matnr and join qmat and mara again on matnr.</P><P>AS you want to fetch all inspection types or no inspection types ,so no need to specify ART in WHERE clause , this should suffice .</P></BODY></HTML> Thu, 05 Mar 2009 06:37:50 GMT Sandeep_Panghal 2009-03-05T06:37:50Z Inspection Type for Material https://community.sap.com/t5/application-development-and-automation-discussions/inspection-type-for-material/m-p/5286052#M1219724 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want all the Materials having inspection types and also i want materials not </P><P>having inspetion types to be displayed...</P><P></P><P>im doing this by joining tables in SQVI transaction.</P><P></P><P>Im joining 3-tables </P><P>MARA</P><P>MARC</P><P>QMAT</P><P></P><P>now my problem is, it is displaying materials having Inspection type...</P><P>Bt it is not displaying Materials that are not having Inspection type...</P><P></P><P>Can any one help me on this?</P></BODY></HTML> Thu, 05 Mar 2009 06:28:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/inspection-type-for-material/m-p/5286052#M1219724 Former Member 2009-03-05T06:28:59Z Re: Inspection Type for Material https://community.sap.com/t5/application-development-and-automation-discussions/inspection-type-for-material/m-p/5286053#M1219725 <HTML><HEAD></HEAD><BODY><P>what is the join condition u have specified?</P><P></P><P><SPAN __default_attr="16" __jive_macro_name="size">кu03B1ятu03B9к</SPAN></P></BODY></HTML> Thu, 05 Mar 2009 06:35:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/inspection-type-for-material/m-p/5286053#M1219725 Former Member 2009-03-05T06:35:31Z Re: Inspection Type for Material https://community.sap.com/t5/application-development-and-automation-discussions/inspection-type-for-material/m-p/5286054#M1219726 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>in joining conditions i have specified</P><P>MARA and QMAT</P></BODY></HTML> Thu, 05 Mar 2009 06:37:20 GMT https://community.sap.com/t5/application-development-and-automation-discussions/inspection-type-for-material/m-p/5286054#M1219726 Former Member 2009-03-05T06:37:20Z Re: Inspection Type for Material https://community.sap.com/t5/application-development-and-automation-discussions/inspection-type-for-material/m-p/5286055#M1219727 <HTML><HEAD></HEAD><BODY><P>Join mara and marc on Matnr and join qmat and mara again on matnr.</P><P>AS you want to fetch all inspection types or no inspection types ,so no need to specify ART in WHERE clause , this should suffice .</P></BODY></HTML> Thu, 05 Mar 2009 06:37:50 GMT https://community.sap.com/t5/application-development-and-automation-discussions/inspection-type-for-material/m-p/5286055#M1219727 Sandeep_Panghal 2009-03-05T06:37:50Z Re: Inspection Type for Material https://community.sap.com/t5/application-development-and-automation-discussions/inspection-type-for-material/m-p/5286056#M1219728 <HTML><HEAD></HEAD><BODY><P>hi sandeep</P><P></P><P>Im not writing any query for this </P><P>im using table join...</P></BODY></HTML> Thu, 05 Mar 2009 06:39:50 GMT https://community.sap.com/t5/application-development-and-automation-discussions/inspection-type-for-material/m-p/5286056#M1219728 Former Member 2009-03-05T06:39:50Z