topic Table relation in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/table-relation/m-p/6658139#M1445906 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>How can I link QAVE and MSEG table to get the GR number .</P><P></P><P>I need to write a select query to get two fields from QAVE table</P><P></P><P>1)VCODE</P><P></P><P>2)VBEWERTUNG</P><P></P><P>and match them from some MSEG field.</P><P></P><P>Thanks</P></BODY></HTML> Sat, 27 Feb 2010 14:34:30 GMT former_member622510 2010-02-27T14:34:30Z Table relation https://community.sap.com/t5/application-development-and-automation-discussions/table-relation/m-p/6658139#M1445906 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>How can I link QAVE and MSEG table to get the GR number .</P><P></P><P>I need to write a select query to get two fields from QAVE table</P><P></P><P>1)VCODE</P><P></P><P>2)VBEWERTUNG</P><P></P><P>and match them from some MSEG field.</P><P></P><P>Thanks</P></BODY></HTML> Sat, 27 Feb 2010 14:34:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-relation/m-p/6658139#M1445906 former_member622510 2010-02-27T14:34:30Z Re: Table relation https://community.sap.com/t5/application-development-and-automation-discussions/table-relation/m-p/6658140#M1445907 <HTML><HEAD></HEAD><BODY><P>Hi Gaurav,</P><P>welcome to SDN</P><P>use quick viewer, tcode is SQVI to find the relations between the given tables</P><P>and then write the required query accordings</P><P>cheers</P><P>S.Janagar</P></BODY></HTML> Sat, 27 Feb 2010 14:38:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-relation/m-p/6658140#M1445907 Former Member 2010-02-27T14:38:58Z