003 - Tabela Interna / Work Area

Alexandre Cheung
Mind Map by Alexandre Cheung, updated more than 1 year ago
Alexandre Cheung
Created by Alexandre Cheung almost 4 years ago
5
0

Description

Tabela Interna e Work Area
Tags

Resource summary

003 - Tabela Interna / Work Area
1 MEMÓRIA TEMPORÁRIA
1.1 TABELAS INTERNAS

Annotations:

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

Annotations:

  • INTO TABLE ITAB. INTO CORRESPONDING FIELDS OF TABLE ITAB.
1.1.2 OPERAÇÕES
1.1.2.1 INSERÇÃO
1.1.2.1.1 APPEND / APPEND LINES OF

Annotations:

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

Annotations:

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

Annotations:

  • MODIFY <ITAB> FROM <WA> INDEX <INDEX NO> TRANSPORTING <FIELD1> <FIELD2> MODIFY <ITAB> FROM <WA> TRANSPORTING <FIELD1> <FIELD2> WHERE <CONDITION>
1.1.2.2 MODIFICAR
1.1.2.2.1 MODIFY

Annotations:

  • MODIFY <ITAB> FROM <WA> INDEX <INDEX NO> [TRANSPORTING <FIELD1> <FIELD2>] MODIFY FROM TRANSPORTING WHERE
1.1.2.3 ÚTEIS
1.1.2.3.1 SORT

Annotations:

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

Annotations:

  • DESCRIBE TABLE <ITAB> LINES <v_lines>
1.1.2.3.3 MOVE

Annotations:

  • <ITAB2[]> = <ITAB1[]>
1.1.2.3.4 COLLECT

Annotations:

  • COLLECT <WA> INTO <ITAB>
1.1.2.3.5 SY-TABIX

Annotations:

  • Armazena o índice do registro atual
1.1.2.4 LEITURA
1.1.2.4.1 READ TABLE ... WITH KEY

Annotations:

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

Annotations:

  • READ TABLE <ITAB> INTO <WA> INDEX <index_no>
1.1.2.5 PERCORRER
1.1.2.5.1 LOOP...ENDLOOP

Annotations:

  • 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.
1.1.2.6 DELETAR
1.1.2.6.1 DELETE

Annotations:

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

Annotations:

  • DELETE ADJACENT DUPLICATED FROM <ITAB> DELETE ADJACENT DUPLICATES FROM <ITAB> COMPARING <FIELD1> <FIELD2>
1.1.2.7 LIMPAR
1.1.2.7.1 CLEAR

Annotations:

  • CLEAR <WA>
1.1.2.7.2 REFRESH

Annotations:

  • REFRESH <ITAB>
1.1.2.7.3 FREE

Annotations:

  • FREE <WA>
1.1.3 TIPOS
1.1.3.1 STANDARD

Annotations:

  • Key / Index. Append / Insert Sort
1.1.3.2 SORTED

Annotations:

  • Key / Index. Insert
1.1.3.3 HASHED
1.2 WORK AREAS

Annotations:

  • DATA : <WA> TYPE <DBTABLE> .
1.2.1 INTO

Annotations:

  • INTO WA INTO CORRESPONDING FIELDS OF WA
1.3 ESTRUTURA
1.3.1 TYPES

Annotations:

  • TYPES : BEGIN OF TY_TABLE, MATNR TYPE MARA-MATNR, MTART TYPE MARA-MTART, MEINS TYPE MARA-MEINS, END OF TY_TABLE.
2 SELECT
2.1 REGISTRO ÚNICO
2.1.1 SELECT SINGLE

Annotations:

  • 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.1.2 UP TO 1 ROWS

Annotations:

  • 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]
2.2 INNER JOIN
2.2.1 TABELAS TRANSPARENTES
2.2.2 ~
2.2.3 ON
2.3 FAE

Annotations:

  • Obs: os campos da tabela interna não pode ser considerada no select.
2.3.1 TABELA INTERNA
2.3.1.1 IS NOT INITIAL
2.3.1.2 SEM REGISTROS DUPLICADOS
2.3.2 TABELA TRANSPARENTE
2.3.3 WHERE
Show full summary Hide full summary

Similar

Seriais Área Vermelha
Robson Gonzaga
SAP Simulado
andersonsiuta
Volcanoes
1jdjdjd1
IB Economics SL: Microeconomics
Han Zhang
GCSE REVISION TIMETABLE
TheJileyProducti
AS level Maths Equations to Remember
Gurdev Manchanda
Biology Unit 1a - GCSE - AQA
RosettaStoneDecoded
Photosynthesis and Respiration
Jessica Phillips
New English Literature GCSE
Sarah Egan
Forces and motion
Catarina Borges
Performance y Planificación de Vuelo
Adriana Forero