<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic SQ01, SQ01 - Sql Query  Dislplay problem in Application Development and Automation Discussions</title>
    <link>https://community.sap.com/t5/application-development-and-automation-discussions/sq01-sq01-sql-query-dislplay-problem/m-p/3418143#M820977</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi &lt;/P&gt;&lt;P&gt;Need help in SQL Query &lt;/P&gt;&lt;P&gt;I generated one sql query which has the following output in general .&lt;/P&gt;&lt;P&gt;-&lt;/P&gt;&lt;HR originaltext="--------------------------------------------------" /&gt;&lt;P&gt;Customer      name     	  description        amount&lt;/P&gt;&lt;P&gt;-&lt;/P&gt;&lt;HR originaltext="--------------------------------------------------" /&gt;&lt;P&gt;asrq1           sharekhan      Amount payed     	 10&lt;/P&gt;&lt;P&gt;asrq1           sharekhan      Amount Advance  	 20&lt;/P&gt;&lt;P&gt;asrq1           sharekhan      Amount due     	 30&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;but i need the output in the following way &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;-&lt;/P&gt;&lt;HR originaltext="--------------------------------------------------------------------------" /&gt;&lt;P&gt;Customer      name     	  AMount payed     Amount Advance    Amount Due&lt;/P&gt;&lt;P&gt;-&lt;/P&gt;&lt;HR originaltext="---------------------------------------------------------------------------" /&gt;&lt;P&gt;asrq1           sharekhan       	 10             20                        30&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;and iam new this sql query but came to know we can write code ..but iam unable to initiliaze to write&lt;/P&gt;&lt;P&gt;a peace of code as i dont know what are the select-options defined ..i saw in the include but didnt got it &lt;/P&gt;&lt;P&gt;% comes prefix of select-options,and iam unable to get he internal table which is displayed in the query .&lt;/P&gt;&lt;P&gt;can anyone help me in this answers will be awarded points.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 11 Feb 2008 13:02:02 GMT</pubDate>
    <dc:creator>Former Member</dc:creator>
    <dc:date>2008-02-11T13:02:02Z</dc:date>
    <item>
      <title>SQ01, SQ01 - Sql Query  Dislplay problem</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/sq01-sq01-sql-query-dislplay-problem/m-p/3418143#M820977</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi &lt;/P&gt;&lt;P&gt;Need help in SQL Query &lt;/P&gt;&lt;P&gt;I generated one sql query which has the following output in general .&lt;/P&gt;&lt;P&gt;-&lt;/P&gt;&lt;HR originaltext="--------------------------------------------------" /&gt;&lt;P&gt;Customer      name     	  description        amount&lt;/P&gt;&lt;P&gt;-&lt;/P&gt;&lt;HR originaltext="--------------------------------------------------" /&gt;&lt;P&gt;asrq1           sharekhan      Amount payed     	 10&lt;/P&gt;&lt;P&gt;asrq1           sharekhan      Amount Advance  	 20&lt;/P&gt;&lt;P&gt;asrq1           sharekhan      Amount due     	 30&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;but i need the output in the following way &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;-&lt;/P&gt;&lt;HR originaltext="--------------------------------------------------------------------------" /&gt;&lt;P&gt;Customer      name     	  AMount payed     Amount Advance    Amount Due&lt;/P&gt;&lt;P&gt;-&lt;/P&gt;&lt;HR originaltext="---------------------------------------------------------------------------" /&gt;&lt;P&gt;asrq1           sharekhan       	 10             20                        30&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;and iam new this sql query but came to know we can write code ..but iam unable to initiliaze to write&lt;/P&gt;&lt;P&gt;a peace of code as i dont know what are the select-options defined ..i saw in the include but didnt got it &lt;/P&gt;&lt;P&gt;% comes prefix of select-options,and iam unable to get he internal table which is displayed in the query .&lt;/P&gt;&lt;P&gt;can anyone help me in this answers will be awarded points.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 11 Feb 2008 13:02:02 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/sq01-sq01-sql-query-dislplay-problem/m-p/3418143#M820977</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-02-11T13:02:02Z</dc:date>
    </item>
    <item>
      <title>Re: SQ01, SQ01 - Sql Query  Dislplay problem</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/sq01-sq01-sql-query-dislplay-problem/m-p/3418144#M820978</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;and transaction FBL5N does not work in your company because ... ???&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 11 Feb 2008 13:40:30 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/sq01-sq01-sql-query-dislplay-problem/m-p/3418144#M820978</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-02-11T13:40:30Z</dc:date>
    </item>
  </channel>
</rss>

