메뉴 건너뛰기

SAP 한국 커뮤니티

add 구문

sapjoy 2006.12.03 02:59 조회 수 : 6538 추천:36

ADD

Variants


1. ADD n TO m.
2. ADD n1 THEN n2 UNTIL nz GIVING m.
3. ADD n1 THEN n2 UNTIL nz TO m.
4. ADD n1 THEN n2 UNTIL nz
...ACCORDING TO sel ...GIVING m.
5. ADD n1 FROM m1 TO mz GIVING m.

Variant 1
ADD n TO m.

Effect
Adds the contents of n to the contents of M and stores the result in m .
This is equivalent to: m = m + n.

Example

DATA: NUMBER TYPE I VALUE 3,
      SUM    TYPE I VALUE 5.
ADD NUMBER TO SUM.

The field SUM now contains 8, whilst the contents of the field NUMBER remains unchanged at 3.

Note
The details about conversions and performance described under COMPUTE are identical for ADD .

Note
Runtime errors

BCD_BADDATA : P field contains incorrect BCD format.
BCD_FIELD_OVERFLOW : Result field too small (type P ).
BCD_OVERFLOW : Overflow with arithmetic operation (type P .
COMPUTE_INT_PLUS_OVERFLOW : Integer overflow when adding.

Related COMPUTE , ADD-CORRESPONDING .

Variant 2
ADD n1 THEN n2 UNTIL nz GIVING m.

Effect
Adds the contents of the fields n1, n2, ..., nz together and stores the result in m , where n1 is the first, n2 the second and nz the last of a sequence of fields the same distance apart. They can be either database fields or internal fields, but they must all have the same type and length.
This is equivalent to: m = n1 + n2 + ... + nz.

Example

DATA: BEGIN OF NUMBERS,
        ONE   TYPE P VALUE 10,
        TWO   TYPE P VALUE 20,
        THREE TYPE P VALUE 30,
        FOUR  TYPE P VALUE 40,
        FIVE  TYPE P VALUE 50,
        SIX   TYPE P VALUE 60,
      END   OF NUMBERS,
      SUM TYPE I VALUE 1000.
ADD NUMBERS-ONE THEN  NUMBERS-TWO
                UNTIL NUMBERS-FIVE GIVING SUM.

The field SUM now contains 150 but its initial value is unimportant. The fields within the field string NUMBERS remain unchanged.

Variant 3
ADD n1 THEN n2 UNTIL nz TO m.

Effect
Calculates the total as in variant 2 but then adds it to the contents of the field m .
This is equivalent to: m = m + n1 + n2 + ... + nz

Example

DATA: BEGIN OF NUMBERS,
        ONE   TYPE P VALUE 10,
        TWO   TYPE P VALUE 20,
        THREE TYPE P VALUE 30,
        FOUR  TYPE P VALUE 40,
        FIVE  TYPE P VALUE 50,
      END   OF NUMBERS,
      SUM TYPE I VALUE 1000.
ADD NUMBERS-ONE THEN  NUMBERS-TWO
                UNTIL NUMBERS-FIVE TO SUM.

The field SUM now contains 1150.

Variant 4
ADD n1 THEN n2 UNTIL nz
...ACCORDING TO sel ...GIVING m.

Effect
Calculates the total as in variants 2 and 3. In this case, however, the operands from a sequence of fields of the same type are restricted to a partial sequence by the selection specification sel generated by SELECT-OPTIONS or RANGES . The partial sequence results from the indexes that satisfy the condition IN sel (see IF ).

Example

DATA: BEGIN OF NUMBERS,
        ONE   TYPE P VALUE 10,
        TWO   TYPE P VALUE 20,
        THREE TYPE P VALUE 30,
        FOUR  TYPE P VALUE 40,
        FIVE  TYPE P VALUE 50,
      END   OF NUMBERS,
      SUM   TYPE I VALUE 1000,
      INDEX TYPE I.
RANGES SELECTION FOR INDEX.

SELECTION-SIGN   = 'I'.
SELECTION-OPTION = 'BT'.
SELECTION-LOW    = 2.
SELECTION-HIGH   = 4.
APPEND SELECTION.

ADD NUMBERS-ONE THEN NUMBERS-TWO
                UNTIL NUMBERS-FIVE
                ACCORDING TO SELECTION
                GIVING SUM.

SUM now contains 90. Only the component fields TWO to FOUR were selected from the field string NUMBERS and added together.

Variant 5
ADD n1 FROM m1 TO mz GIVING m.

Effect
The field n1 must be the first in a sequence of consecutive fields of the same type. m1 and mz should contain the numbers of the first and last fields in this sequence to be added together (whether fixed or variable). The total is stored in m .

Example

DATA: BEGIN OF NUMBERS,
        ONE   TYPE P VALUE 10,
        TWO   TYPE P VALUE 20,
        THREE TYPE P VALUE 30,
        FOUR  TYPE P VALUE 40,
        FIVE  TYPE P VALUE 50,
      END   OF NUMBERS,
      START TYPE I VALUE 2,
      SUM   TYPE I VALUE 1000.
ADD NUMBERS-ONE FROM START TO 4 GIVING SUM.

The field SUM now contains 90.

Note
Performance The details for conversion and performance specified for COMPUTE are equally valid for ADD .
The runtime required for adding two numbers of type I or F is about 2 (standardized microseconds), for type P it is roughly 8 msn.

Note
Runtime errors

Besides the runtime errors listed in variant 1, the error ADDF_INT_OVERFLOW can occur instead of COMPUTE_INT_PLUS_OVERFLOW in other variants.

Index
?SAP AG 1996
번호 제목 글쓴이 날짜 조회 수
388 message table의 각 필드들을 모아서 하나의 문장으로 [4] 꿀단지 2011.10.11 7280
387 문자열에 있는 값이 숫자만으로 되어있는지 문자가 포함됐는지 체크하는 함수 [3] 꿀단지 2011.10.11 20665
386 CALL FUNCTION 'STRING_REPLACE' [1] 꿀단지 2011.10.11 5577
385 SAP 오피스의 메일박스에 메일 전송하는 함수 꿀단지 2011.10.11 5807
384 업로드할 엑셀 파일을 TXT 파일(탭으로 분리된)로 내리지 않고 엑셀파일로 꿀단지 2011.10.11 6475
383 ALV 색상 번호와 사용 목적 꿀단지 2011.10.11 5024
382 CS_BOM [1] 꿀단지 2011.10.11 5636
381 바피사용이유 [18] 꿀단지 2011.10.11 8659
380 ▲123,456' 으로 표시하게 한다 [3] 꿀단지 2011.10.11 5753
379 Mac Notebook을 쓰는 사람들을 위한 조그만 팁. [2] Bigbrother 2011.09.21 5116
378 Do Varying 간단한 예제 및 설명입니다^^ [6] file JJB 2011.08.31 6234
377 Word Wrab 기능을사용해보자. [2] file 양키 2011.07.20 5650
376 Area 메뉴 일괄 다운로드 하기 [5] file 고담 2011.06.16 8348
375 시분초를 가져오는 구문 [8] 양키 2011.05.26 8716
374 한글 자음 분석해보기. [5] file 공백 2011.05.19 7344
373 [Tip] Explorer 8.0 & SAP GUI 7.2 fancky 2011.05.19 6663
372 Automated Note Search & Customer Code Detection 소주와 막걸리 2011.04.28 6420
371 SAP Notes Viewer for iPad/iPhone [4] D.Y.Kim 2011.04.21 6279
370 where 조건을 상황에따라 바꿔볼까? [8] 양키 2011.04.14 8833
369 간단한 계산공식은 Macro를 사용하자 [5] 양키 2011.04.14 9651