003 - Tabela Interna / Work Area

Nota:

• DATA : <ITAB> TYPE TABLE OF <DBTABLE> .

1. INTO

   Nota:

   • INTO TABLE ITAB. INTO CORRESPONDING FIELDS OF TABLE ITAB.
2. OPERAÇÕES
   1. INSERÇÃO
      1. APPEND / APPEND LINES OF

         Nota:

         • APPEND <WA> TO <ITAB> APPEND LINES OF <ITAB1> FROM <index no> TO <index no2>
      2. INSERT / INSERT LINES

         Nota:

         • INSERT <WA> INTO <ITAB> INDEX <index><index></index> INSERT LINES OF <ITAB1> FROM <index no> TO <index no2>
      3. MODIFY

         Nota:

         • MODIFY <ITAB> FROM <WA> INDEX <INDEX NO> TRANSPORTING <FIELD1> <FIELD2> MODIFY <ITAB> FROM <WA> TRANSPORTING <FIELD1> <FIELD2> WHERE <CONDITION>
   2. MODIFICAR
      1. MODIFY

         Nota:

         • MODIFY <ITAB> FROM <WA> INDEX <INDEX NO> [TRANSPORTING <FIELD1> <FIELD2>] MODIFY FROM TRANSPORTING WHERE
   3. ÚTEIS
      1. SORT

         Nota:

         • SORT <ITAB> BY <FIELD1> <FIELD2>...ASCENDING/DESCENDING
      2. DESCRIBE TABLE

         Nota:

         • DESCRIBE TABLE <ITAB> LINES <v_lines>
      3. MOVE

         Nota:

         • <ITAB2[]> = <ITAB1[]>
      4. COLLECT

         Nota:

         • COLLECT <WA> INTO <ITAB>
      5. SY-TABIX

         Nota:

         • Armazena o índice do registro atual
   4. LEITURA
      1. READ TABLE ... WITH KEY

         Nota:

         • READ TABLE <ITAB> INTO <WA> WITH KEY <FIELD1> = <FIELD1 VALUE> <FIELD1> = <FIELD1 VALUE> BINARY SEARCH .
      2. READ TABLE .. INDEX

         Nota:

         • READ TABLE <ITAB> INTO <WA> INDEX <index_no>
   5. PERCORRER
      1. LOOP...ENDLOOP

         Nota:

         • LOOP AT <ITAB> INTO <WA> . ENDLOOP. LOOP AT <ITAB> INTO <WA> WHERE <FIELDS1> = <VALUE> . ENDLOOP. LOOP AT <ITAB> INTO <WA> FROM <INDEX1> TO <INDEX2>. ENDLOOP.
   6. DELETAR
      1. DELETE

         Nota:

         • DELETE <ITAB> INDEX <INDEX NO>. DELETE <ITAB> WHERE <FIELD1> = <FIELD1 VALUE>  <FIELD2> = <FIELD2 VALUE>.
      2. DELETE ADJACENT DUPLICATES

         Nota:

         • DELETE ADJACENT DUPLICATED FROM <ITAB> DELETE ADJACENT DUPLICATES FROM <ITAB> COMPARING <FIELD1> <FIELD2>
   7. LIMPAR
      1. CLEAR

         Nota:

         • CLEAR <WA>
      2. REFRESH

         Nota:

         • REFRESH <ITAB>
      3. FREE

         Nota:

         • FREE <WA>
3. TIPOS
   1. STANDARD

      Nota:

      • Key / Index. Append / Insert Sort
   2. SORTED

      Nota:

      • Key / Index. Insert
   3. HASHED

Nota:

• DATA : <WA> TYPE <DBTABLE> .

1. INTO

   Nota:

   • INTO WA INTO CORRESPONDING FIELDS OF WA

1. TYPES

   Nota:

   • TYPES : BEGIN OF TY_TABLE, MATNR TYPE MARA-MATNR, MTART TYPE MARA-MTART, MEINS TYPE MARA-MEINS, END OF TY_TABLE.

1. SELECT SINGLE

   Nota:

   • SELECT SINGLE * FROM DATABASETABLE INTO WA WHERE ALL KEY FIELDS Obs: quando o campo não é chave, a tabela é ordenada pela "condição do where"
2. UP TO 1 ROWS

   Nota:

   • SELECT * FROM DATABASETABLE INTO WA UP TO 1 ROWS WHERE ALL KEY FIELDS/SOME FIELDS. ENDSELECT. Obs1: quando o campo não é chave, a tabela é ordenada pela "condição do where" no [UP TO 1 ROWS] Obs2: quando o campo não é chave, a tabela captura os primeiros registros no [UP TO X ROWS]

1. TABELAS TRANSPARENTES
2. ~
3. ON

Nota:

• Obs: os campos da tabela interna não pode ser considerada no select.

1. TABELA INTERNA
   1. IS NOT INITIAL
   2. SEM REGISTROS DUPLICADOS
2. TABELA TRANSPARENTE
3. WHERE