๊ด€๋ฆฌ ๋ฉ”๋‰ด

CS Student’s SAP&Tech Journey๐Ÿ’ซ

[SAP] ์‹œ์Šคํ…œ ๋ณ€์ˆ˜ SY-XXXX ํ•œ๋ˆˆ์— ์ •๋ฆฌํ•˜๊ธฐ ๋ณธ๋ฌธ

SAP/ABAP ๋ฌธ๋ฒ• | Open SQL

[SAP] ์‹œ์Šคํ…œ ๋ณ€์ˆ˜ SY-XXXX ํ•œ๋ˆˆ์— ์ •๋ฆฌํ•˜๊ธฐ

์ธํฌ๋งˆํ‹ฑ 2025. 1. 30. 22:10

SAP ์‹œ์Šคํ…œ ๋ณ€์ˆ˜(SY-XXXX)๋Š” ํ”„๋กœ๊ทธ๋žจ ์‹คํ–‰ ์ค‘์— ์‹œ์Šคํ…œ์—์„œ ์ œ๊ณตํ•˜๋Š” ์ •๋ณด๋“ค์„ ์ €์žฅํ•˜๋Š” ๋‚ด์žฅ ๋ณ€์ˆ˜์ž…๋‹ˆ๋‹ค. ์ด๋ฒˆ ํฌ์ŠคํŒ…์—์„œ๋Š” ์ฃผ์š” ์‹œ์Šคํ…œ ๋ณ€์ˆ˜์™€ ๊ทธ ํ™œ์šฉ๋ฒ•์„ ์ •๋ฆฌํ•˜๊ฒ ์Šต๋‹ˆ๋‹ค.

 

 


 

๐Ÿ“Œ  ์ฃผ์š” SAP ์‹œ์Šคํ…œ ๋ณ€์ˆ˜ ๋ฐ ํ™œ์šฉ๋ฒ•

1. SY-MANDT (ํด๋ผ์ด์–ธํŠธ ๋ฒˆํ˜ธ)

ํด๋ผ์ด์–ธํŠธ(client) ๋ฒˆํ˜ธ๋ฅผ ๋‚˜ํƒ€๋‚ด๋ฉฐ, ๋ฉ€ํ‹ฐ ํด๋ผ์ด์–ธํŠธ ํ™˜๊ฒฝ์—์„œ ๋ฐ์ดํ„ฐ๋ฅผ ๊ตฌ๋ถ„ํ•˜๋Š” ๋ฐ ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค.

2. SY-UNAME (ํ˜„์žฌ ์‚ฌ์šฉ์ž ID)

ํ˜„์žฌ ๋กœ๊ทธ์ธํ•œ ์‚ฌ์šฉ์ž ID๋ฅผ ๊ฐ€์ ธ์˜ฌ ๋•Œ ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค.

3. SY-LANGU (์‚ฌ์šฉ์ž ์–ธ์–ด ์ฝ”๋“œ)

๋กœ๊ทธ์ธํ•œ ์‚ฌ์šฉ์ž์˜ ์–ธ์–ด ์„ค์ •์„ ๋‚˜ํƒ€๋‚ด๋ฉฐ, ๋‹ค๊ตญ์–ด ์ฒ˜๋ฆฌ์— ์œ ์šฉํ•ฉ๋‹ˆ๋‹ค.

4. SY-DATUM (ํ˜„์žฌ ๋‚ ์งœ)

ํ˜„์žฌ SAP ์‹œ์Šคํ…œ์˜ ๋‚ ์งœ๋ฅผ ๊ฐ€์ ธ์˜ต๋‹ˆ๋‹ค.

5. SY-UZEIT (ํ˜„์žฌ ์‹œ๊ฐ„)

ํ˜„์žฌ ์‹œ๊ฐ„์„ ์‹œ:๋ถ„:์ดˆ ํ˜•์‹์œผ๋กœ ๊ฐ€์ ธ์˜ต๋‹ˆ๋‹ค.

 

๐Ÿ“Œ SY-SUBRC (Return Code) ์˜๋ฏธ์™€ ์‚ฌ์šฉ๋ฒ•

1. SY-SUBRC๋ž€?

SY-SUBRC๋Š” ABAP ์—ฐ์‚ฐ์ด ์„ฑ๊ณตํ–ˆ๋Š”์ง€ ์—ฌ๋ถ€๋ฅผ ๋‚˜ํƒ€๋‚ด๋Š” ๋ฆฌํ„ด ์ฝ”๋“œ(Return Code)์ž…๋‹ˆ๋‹ค. ์ผ๋ฐ˜์ ์œผ๋กœ SELECT, FUNCTION CALL, FIND ๋“ฑ์˜ ๊ฒฐ๊ณผ๋ฅผ ํ™•์ธํ•˜๋Š” ๋ฐ ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค.

2. SELECT ๋ฌธ์—์„œ์˜ SY-SUBRC ํ™œ์šฉ

DATA: lt_scarr TYPE TABLE OF scarr,
      ls_scarr TYPE scarr.

SELECT * FROM scarr INTO TABLE lt_scarr WHERE carrid = 'LH'.

IF SY-SUBRC = 0.
    WRITE: '๋ฐ์ดํ„ฐ ์กฐํšŒ ์„ฑ๊ณต'.
ELSE.
    WRITE: '๋ฐ์ดํ„ฐ๊ฐ€ ์—†์Šต๋‹ˆ๋‹ค.'.
ENDIF.

์œ„ ์ฝ”๋“œ์—์„œ SY-SUBRC = 0์ด๋ฉด ์กฐํšŒ ์„ฑ๊ณต, ๊ทธ๋ ‡์ง€ ์•Š์œผ๋ฉด ๋ฐ์ดํ„ฐ๊ฐ€ ์กด์žฌํ•˜์ง€ ์•Š์Œ์„ ์˜๋ฏธํ•ฉ๋‹ˆ๋‹ค.

SELECT SINGLE * FROM XXXX.
IF sy-subrc = 0. " ๋ฐ์ดํ„ฐ๋ฅผ ์ทจ๋“ํ–ˆ๋Š”์ง€?

CALL Function 'XYZ'.
IF sy-subrc = 0. "ํ•จ์ˆ˜๋ฅผ ์ž˜ ํ˜ธ์ถœํ–ˆ๋Š”์ง€?

FIND 'HEL' IN gv_string.
IF sy-subrc = 0. "HEL๋‹จ์–ด๋ฅผ ์ฐพ์•˜๋Š”์ง€?

SELECT SINGLE * FROM XXXX.
WRITE: 'Result'. 
IF sy-subrc = 0. "WRITE๋ฌธ์„ ์ž˜ ์ถœ๋ ฅํ–ˆ๋Š”์ง€?

โญ sy-subrc์˜ ๋ฆฌํ„ด์€ ๋ฐ”๋กœ ์•ž ๋ฌธ์žฅ์„ ๋ฆฌํ„ดํ•˜๋ฏ€๋กœ ์•ž ๋ฌธ์žฅ์— ์ข…์†๋ฉ๋‹ˆ๋‹ค.