topic Re: link between tables in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/link-between-tables/m-p/4639471#M1092158 <HTML><HEAD></HEAD><BODY><P>answered</P></BODY></HTML> Thu, 16 Oct 2008 11:40:50 GMT Former Member 2008-10-16T11:40:50Z link between tables https://community.sap.com/t5/application-development-and-automation-discussions/link-between-tables/m-p/4639467#M1092154 <HTML><HEAD></HEAD><BODY><P>hi frends dis is pramod i am working on fi report</P><P>i would like to know is there any link between these tables</P><P></P><P>coas-order matsre for controlling</P><P>prps-element master data</P><P>hw we can join these tables</P></BODY></HTML> Tue, 14 Oct 2008 10:51:46 GMT https://community.sap.com/t5/application-development-and-automation-discussions/link-between-tables/m-p/4639467#M1092154 Former Member 2008-10-14T10:51:46Z Re: link between tables https://community.sap.com/t5/application-development-and-automation-discussions/link-between-tables/m-p/4639468#M1092155 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>COAS is the view used... You may find the table from the view to be linked...</P><P></P><P>Please refer to the following:</P><P></P><P>sebastien.ferry.online.fr/abap/sap_tables.pdf</P><P></P><P><A href="https://community.sap.com/www.erpgenie.com/abap/tables_fi.htm" target="test_blank">www.erpgenie.com/abap/tables_fi.htm</A></P></BODY></HTML> Tue, 14 Oct 2008 11:14:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/link-between-tables/m-p/4639468#M1092155 Former Member 2008-10-14T11:14:13Z Re: link between tables https://community.sap.com/t5/application-development-and-automation-discussions/link-between-tables/m-p/4639469#M1092156 <HTML><HEAD></HEAD><BODY><P>Try like this</P><P></P><P>1. Execute SQVI t-code</P><P>2.Enter a Name in QUICK VIEW.</P><P>3. Click Create.</P><P>4.Enter Tilte and then in DATA SOURCE select TABLE JOIN and Press ENTER.</P><P></P><P>5. press SHIFt + F1 and go on adding the tables names that you want to find the relations ships each time by repeating STEP 5.</P><P></P><P></P><P>Also PRPS-pspnr , coas-PSPEL</P><P></P><P>Rhea.</P></BODY></HTML> Tue, 14 Oct 2008 11:25:26 GMT https://community.sap.com/t5/application-development-and-automation-discussions/link-between-tables/m-p/4639469#M1092156 Former Member 2008-10-14T11:25:26Z Re: link between tables https://community.sap.com/t5/application-development-and-automation-discussions/link-between-tables/m-p/4639470#M1092157 <HTML><HEAD></HEAD><BODY><P>try table QMEL.</P></BODY></HTML> Tue, 14 Oct 2008 11:47:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/link-between-tables/m-p/4639470#M1092157 Former Member 2008-10-14T11:47:14Z Re: link between tables https://community.sap.com/t5/application-development-and-automation-discussions/link-between-tables/m-p/4639471#M1092158 <HTML><HEAD></HEAD><BODY><P>answered</P></BODY></HTML> Thu, 16 Oct 2008 11:40:50 GMT https://community.sap.com/t5/application-development-and-automation-discussions/link-between-tables/m-p/4639471#M1092158 Former Member 2008-10-16T11:40:50Z