title: trying to copy Table A to Table B within same schema
body: <p>I am trying to copy Table A to Table B within same schema. It works when tables are exactly same but it does not when target table has 3 additional fields. I am using </p>
  
  <pre><code> INSERT INTO ZVBAP SELECT * FROM VBAP
  </code></pre>
  
  <p>I have also used </p>
  
  <pre><code>Select col, col2, col3 into Table2 from Table1
  </code></pre>
  
  <p>This gives following error: </p>
  
  <pre><code>SAP DBTech JDBC: [337]: INTO clause not allowed for this SELECT statement: line 1 col 1675 (at pos 1674)
  </code></pre>
  
  <p>What do you recommend?</p>