메뉴 건너뛰기

SAP 한국 커뮤니티

There are three types of internal tables:

sapjoy 2007.03.11 12:37 조회 수 : 4000 추천:37

There are three types of internal tables:
1. Standard Tables
2. Sorted Tables
3. Hashed Tables

Standard Internal Tables

Standard tables have a linear index. You can access them using either the index or the key. If you use the key, the response time is in linear relationship to the number of table entries. The key of a standard table is always non-unique, and you may not include any specification for the uniqueness in the table definition.

This table type is particularly appropriate if you want to address individual table entries using the index. This is the quickest way to access table entries. To fill a standard table, append lines using the (APPEND) statement. You should read, modify and delete lines by referring to the index (INDEX option with the relevant ABAP command). The response time for accessing a standard table is in linear relation to the number of table entries. If you need to use key access, standard tables are appropriate if you can fill and process the table in separate steps. For example, you can fill a standard table by appending records and then sort it. If you then use key access with the binary search option (BINARY), the response time is in logarithmic relation to
the number of table entries.

Sorted Internal Tables

Sorted tables are always saved correctly sorted by key. They also have a linear key, and, like standard tables, you can access them using either the table index or the key. When you use the key, the response time is in logarithmic relationship to the number of table entries, since the system uses a binary search. The key of a sorted table can be either unique, or non-unique, and you must specify either UNIQUE or NON-UNIQUE in the table definition. Standard tables and sorted tables both belong to the generic group index tables.

This table type is particularly suitable if you want the table to be sorted while you are still adding entries to it. You fill the table using the (INSERT) statement, according to the sort sequence defined in the table key. Table entries that do not fit are recognised before they are inserted. The response time for access using the key is in logarithmic relation to the number of
table entries, since the system automatically uses a binary search. Sorted tables are appropriate for partially sequential processing in a LOOP, as long as the WHERE condition contains the beginning of the table key.

Hashed Internal Tables

Hashes tables have no internal linear index. You can only access hashed tables by specifying the key. The response time is constant, regardless of the number of table entries, since the search uses a hash algorithm. The key of a hashed table must be unique, and you must specify UNIQUE in the table definition.

This table type is particularly suitable if you want mainly to use key access for table entries. You cannot access hashed tables using the index. When you use key access, the response time remains constant, regardless of the number of table entries. As with database tables, the key of a hashed table is always unique. Hashed tables are therefore a useful way of constructing and
using internal tables that are similar to database tables.
번호 제목 글쓴이 날짜 조회 수
487 FTP 호출 프로그램 예제 [2] sapjoy 2014.11.28 5659
486 sap 화면 웹(web)으로 띄우기(ITS, SAPGUI HTML) [4] file sapjoy 2014.11.14 7203
485 Selection Screeen에서 저장버튼 Disable 처리 [3] 양키(이경환) 2014.11.13 3755
484 릴리즈된 cts 복구 하기 Program : RDDIT076 [2] sapjoy 2014.11.10 7338
483 스크린을 생성하여 팝업창을 띄웠는데요~닫기가 안되요 [3] 흐르는강물처럼 2014.10.06 5381
482 User Profile 설정하기 [4] file 아밥뽀 2014.09.21 2755
481 드롭다운 리스트 key값 조회하기 [4] file 아밥뽀 2014.09.21 3341
480 백그라운드로 프로그램 실행하기 [5] file 아밥뽀 2014.09.21 4831
479 BDC 수행시 COMMAND 명령어 sapjoy 2014.09.18 3300
478 명령어 결과에 따른 SY-SUBRC [5] sapjoy 2014.09.16 6965
477 테이블 inconsistency check 프로그램 [2] file sapjoy 2014.09.11 2111
476 SQL 실행 프로그램 - ZSQL [2] file 아밥뽀 2014.08.23 4703
475 SYST 시스템 변수 정리 [5] 아밥뽀 2014.08.23 17031
474 앞의 0으로 시작하는 문자 모두 지우기 sapjoy 2014.08.20 3354
473 archive 관련 transaction code [1] sapjoy 2014.08.20 2039
472 AL08에서 SAP 서버(인스턴스)별 사용자 확인 [1] sapjoy 2014.08.19 2306
471 SAP 모니터링 T-CODE [11] 아밥뽀 2014.07.08 8710
470 SAPLINK - 소스 업&다운 프로그램 입니다. [5] file abaper_qj 2014.06.18 6996
469 ALV 컬럼 고정하기 [5] file sapjoy 2014.06.18 4596
468 테이블 데이터 엑셀 업로드 프로그램 sapjoy 2014.06.17 4056