<?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 New ABAP syntax for into table - Offset no longer valid in Application Development and Automation Discussions</title>
    <link>https://community.sap.com/t5/application-development-and-automation-discussions/new-abap-syntax-for-into-table-offset-no-longer-valid/m-p/667202#M29253</link>
    <description>&lt;P&gt;Hi,&lt;/P&gt;
  &lt;P&gt;&lt;/P&gt;
  &lt;P&gt;I checked below link for inner join and inline declaration of table . So copy pasted the code from below link&lt;/P&gt;
  &lt;P&gt;&lt;A href="https://help.sap.com/doc/abapdocu_751_index_htm/7.51/en-US/abenselect_inline_decl_abexa.htm"&gt;Inner join&lt;/A&gt;&lt;/P&gt;
  &lt;P&gt;got error as below :&lt;/P&gt;
  &lt;P&gt;&lt;IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/235367-red-data.png" /&gt;&lt;/P&gt;
  &lt;P&gt;Though the code was copy, pasted then I changed the sequence of into table as below then got offset error&lt;/P&gt;
  &lt;P&gt;&lt;/P&gt;
  &lt;P&gt;&lt;IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/235368-error-1.png" /&gt;&lt;/P&gt;
  &lt;P&gt;&lt;/P&gt;
  &lt;P&gt;Again to check in simple code and no join, still getting offset error&lt;/P&gt;
  &lt;P&gt;Using the new syntax, pls help me understand what exactly the error is saying &lt;/P&gt;
  &lt;P&gt;SELECT bukrs,belnr,gjahr&lt;BR /&gt;FROM bkpf&lt;BR /&gt;INTO TABLE @data(lt_bkpf) ( row - 47)&lt;BR /&gt;WHERE bukrs = @p_bukrs&lt;BR /&gt;AND belnr = @p_belnr.&lt;/P&gt;
  &lt;P&gt;&lt;IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/235366-error.png" /&gt;&lt;/P&gt;
  &lt;P&gt;&lt;/P&gt;
  &lt;P&gt;&lt;/P&gt;
  &lt;P&gt;Thanks,&lt;/P&gt;
  &lt;P&gt;Mohan&lt;/P&gt;</description>
    <pubDate>Sun, 14 Oct 2018 18:39:37 GMT</pubDate>
    <dc:creator>TMSingh_SAP</dc:creator>
    <dc:date>2018-10-14T18:39:37Z</dc:date>
    <item>
      <title>New ABAP syntax for into table - Offset no longer valid</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/new-abap-syntax-for-into-table-offset-no-longer-valid/m-p/667202#M29253</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;
  &lt;P&gt;&lt;/P&gt;
  &lt;P&gt;I checked below link for inner join and inline declaration of table . So copy pasted the code from below link&lt;/P&gt;
  &lt;P&gt;&lt;A href="https://help.sap.com/doc/abapdocu_751_index_htm/7.51/en-US/abenselect_inline_decl_abexa.htm"&gt;Inner join&lt;/A&gt;&lt;/P&gt;
  &lt;P&gt;got error as below :&lt;/P&gt;
  &lt;P&gt;&lt;IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/235367-red-data.png" /&gt;&lt;/P&gt;
  &lt;P&gt;Though the code was copy, pasted then I changed the sequence of into table as below then got offset error&lt;/P&gt;
  &lt;P&gt;&lt;/P&gt;
  &lt;P&gt;&lt;IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/235368-error-1.png" /&gt;&lt;/P&gt;
  &lt;P&gt;&lt;/P&gt;
  &lt;P&gt;Again to check in simple code and no join, still getting offset error&lt;/P&gt;
  &lt;P&gt;Using the new syntax, pls help me understand what exactly the error is saying &lt;/P&gt;
  &lt;P&gt;SELECT bukrs,belnr,gjahr&lt;BR /&gt;FROM bkpf&lt;BR /&gt;INTO TABLE @data(lt_bkpf) ( row - 47)&lt;BR /&gt;WHERE bukrs = @p_bukrs&lt;BR /&gt;AND belnr = @p_belnr.&lt;/P&gt;
  &lt;P&gt;&lt;IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/235366-error.png" /&gt;&lt;/P&gt;
  &lt;P&gt;&lt;/P&gt;
  &lt;P&gt;&lt;/P&gt;
  &lt;P&gt;Thanks,&lt;/P&gt;
  &lt;P&gt;Mohan&lt;/P&gt;</description>
      <pubDate>Sun, 14 Oct 2018 18:39:37 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/new-abap-syntax-for-into-table-offset-no-longer-valid/m-p/667202#M29253</guid>
      <dc:creator>TMSingh_SAP</dc:creator>
      <dc:date>2018-10-14T18:39:37Z</dc:date>
    </item>
    <item>
      <title>Re: New ABAP syntax for into table - Offset no longer valid</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/new-abap-syntax-for-into-table-offset-no-longer-valid/m-p/667203#M29254</link>
      <description>&lt;P&gt;Have you thought about the fact, that it could be a wrong message at your error tab?&lt;/P&gt;&lt;P&gt;And why don't you use ADT, not sure, if all syntax checks are also available via SE38...&lt;/P&gt;&lt;P&gt;Without a system, I would suggest, that the second select is valid (first screen).&lt;/P&gt;&lt;P&gt;The into at the end is located at the right position when using escaping.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;And what's that with (row-47).. what do you try here?&lt;/P&gt;</description>
      <pubDate>Sun, 14 Oct 2018 20:36:46 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/new-abap-syntax-for-into-table-offset-no-longer-valid/m-p/667203#M29254</guid>
      <dc:creator>Florian</dc:creator>
      <dc:date>2018-10-14T20:36:46Z</dc:date>
    </item>
    <item>
      <title>Re: New ABAP syntax for into table - Offset no longer valid</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/new-abap-syntax-for-into-table-offset-no-longer-valid/m-p/667204#M29255</link>
      <description>&lt;P&gt;Thanks Florian.  I checked in ADT and the syntax for inner join is fine. &lt;/P&gt;&lt;P&gt;Some of the syntax in GUI like inline declaration for variable/Work area work but inline table gives syntax. Even some syntax like aggregation in select works in GUI.&lt;/P&gt;&lt;P&gt; I thought of some basic inline syntax declaration works in GUI then why this offeset issue with inline table declaration.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;Mohan&lt;/P&gt;</description>
      <pubDate>Mon, 15 Oct 2018 04:44:27 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/new-abap-syntax-for-into-table-offset-no-longer-valid/m-p/667204#M29255</guid>
      <dc:creator>TMSingh_SAP</dc:creator>
      <dc:date>2018-10-15T04:44:27Z</dc:date>
    </item>
  </channel>
</rss>

