https://community.sap.com/t5/application-development-and-automation-discussions/block-alv/m-p/2687658#M621594 <HTML><HEAD></HEAD><BODY><P>If you are not sure where data is coming from, you can turn the SQL Trace (Performance Trace = transaction ST05) on and run the standard SAP transaction / report where you normally see this data. Then turn the trace off and examine the output... not only can you see which tables are used, but you can often pick up really good examples of how SAP have structured their database accesses, and even possibly find function modules that return the data you want.</P></BODY></HTML> Mon, 13 Aug 2007 03:27:36 GMT Former Member 2007-08-13T03:27:36Z https://community.sap.com/t5/application-development-and-automation-discussions/block-alv/m-p/2687656#M621592 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> I have a doubt in block ALV.If in the first block,If I have fields that need 2 be extracted from different database tables.</P><P> How can I extract the data by using SELECT.</P><P>For ex,In the first block,If I have employee name,organisation,ID.........which are from different database tables.Hou can I write SELECT statement.</P></BODY></HTML> Sun, 12 Aug 2007 18:50:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/block-alv/m-p/2687656#M621592 Former Member 2007-08-12T18:50:13Z https://community.sap.com/t5/application-development-and-automation-discussions/block-alv/m-p/2687657#M621593 <HTML><HEAD></HEAD><BODY><P>Probably you need to write a JOIN (Check Help under Open SQL syntax).</P><P></P><P>Check &lt;a href="http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb39c4358411d1829f0000e829fbfe/content.htm"&gt;this link&lt;/a&gt;.</P><P></P><P>Regards.</P><P>Please reward points if helpful.</P></BODY></HTML> Sun, 12 Aug 2007 23:36:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/block-alv/m-p/2687657#M621593 alejandro_bindi 2007-08-12T23:36:52Z https://community.sap.com/t5/application-development-and-automation-discussions/block-alv/m-p/2687658#M621594 <HTML><HEAD></HEAD><BODY><P>If you are not sure where data is coming from, you can turn the SQL Trace (Performance Trace = transaction ST05) on and run the standard SAP transaction / report where you normally see this data. Then turn the trace off and examine the output... not only can you see which tables are used, but you can often pick up really good examples of how SAP have structured their database accesses, and even possibly find function modules that return the data you want.</P></BODY></HTML> Mon, 13 Aug 2007 03:27:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/block-alv/m-p/2687658#M621594 Former Member 2007-08-13T03:27:36Z