title: Move FMOIX/FMCOX structures into Internal Table
body: <p>I am a newbie to ABAP (3 days experience) and I am currently on a task to write reports using ABAP code. It is like moving some data from a specific SAP database to a Business Intelligence staging area.</p>
  
  <p>So the core difficulty is that some data on the SAP server is in the format of dictionary structures (FMOIX, FMCOX, etc.) and I need to move these data into internal tables during program runtime. I was told that OPENSQL would not work in this case.</p>
  
  <p>If you still do not get what I mean, I can suggest several ways, actually given by my supervisor. First is to use GET event, say</p>
  
  <pre><code>GET FMOIX.
      IF FMOIX-zhdlt &gt; From_dat and FMOIX-zhdlt &lt; to_dat.
          Append FMOIX to itab.
      ENDIF.
  </code></pre>
  
  <p>The thing is that I am still not very clear about this GET event. Is it just a event handler thing, or can it loop through data records?</p>
  
  <p>What I googled for more than two days give me something like</p>
  
  <pre><code>LOOP at FMOIX.
      MOVE FMOIX to itab.
  ENDLOOP.
  </code></pre>
  
  <p>So what are the ways to move transactional structure like FMOIX into internal tables, say the internal table name is ITAB?</p>
  
  <p>Your answer would be greatly appreciated. Though I have time, I am totally new.
  Thanks a lot.</p>