SAP/๋ฐ์ดํ„ฐ ํƒ€์ž… Data Type

[SAP] ๋กœ์ปฌ ๋ฐ์ดํ„ฐ ๊ฐ์ฒด ์ดํ•ดํ•˜๊ธฐ (Simple, Structure, Internal Table)

์ธํฌ๋งˆํ‹ฑ 2025. 2. 6. 14:33

SAP ABAP์„ ์‚ฌ์šฉํ•˜๋ฉด ๋‹ค์–‘ํ•œ ์œ ํ˜•์˜ ๋ฐ์ดํ„ฐ ๊ฐ์ฒด(Data Object)๋ฅผ ๋‹ค๋ฃจ๊ฒŒ ๋ฉ๋‹ˆ๋‹ค. ABAP์—์„œ๋Š” ๋‹จ์ˆœ ๋ฐ์ดํ„ฐ(Single Data Object), ๊ตฌ์กฐ์ฒด(Structure), ๋‚ด๋ถ€ ํ…Œ์ด๋ธ”(Internal Table)์„ ํ†ตํ•ด ๋ฐ์ดํ„ฐ๋ฅผ ์ €์žฅํ•˜๊ณ  ๊ด€๋ฆฌํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

์ด๋ฒˆ ๊ธ€์—์„œ๋Š” ABAP์—์„œ ๋ฐ์ดํ„ฐ๋ฅผ ์ €์žฅํ•˜๋Š” ๊ธฐ๋ณธ ๋ฐฉ์‹๊ณผ ๊ตฌ์กฐ์ฒด ๋ฐ ๋‚ด๋ถ€ ํ…Œ์ด๋ธ”์— ๋Œ€ํ•ด ์ž์„ธํžˆ ์•Œ์•„๋ณด๊ฒ ์Šต๋‹ˆ๋‹ค.

 

 

ํ…Œ์ด๋ธ”์˜ ๊ตฌ์กฐ, ํ•„๋“œ, ๋„๋ฉ”์ธ, ๋ฐ์ดํ„ฐ ์š”์†Œ๋ฅผ SE11 ํ™œ์šฉํ•˜์—ฌ ๊ฒ€์ƒ‰ํ•˜๋Š” ๋ฐฉ๋ฒ• ํฌ์ŠคํŒ… ๋ณด๋Ÿฌ๊ฐ€๊ธฐโฌ‡๏ธ

 

ABAP ํ”„๋กœ๊ทธ๋ž˜๋ฐ: SELECT SINGLE๊ณผ SELECT์˜ ์ฐจ์ด, SE11/SE16 ํ™œ์šฉํ•˜๊ธฐ, ๋ณ€์ˆ˜ ์ ‘๋‘์‚ฌ ์„ค์ •

ABAP์—์„œ๋Š” SELECT๋ฌธ์„ ์‚ฌ์šฉํ•˜์—ฌ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ํ…Œ์ด๋ธ”์—์„œ ์ •๋ณด๋ฅผ ์กฐํšŒํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์ด๋ฒˆ ํฌ์ŠคํŒ…์—์„œ๋Š” SE11/SE16์„ ํ™œ์šฉํ•œ ํ…Œ์ด๋ธ” ๊ฒ€์ƒ‰,  SELECT SINGLE๊ณผ SELECT์˜ ์ฐจ์ด์ , ๊ทธ๋ฆฌ๊ณ  SCARR ํ…Œ์ด๋ธ”์„ ํ™œ

informatik.tistory.com

 

 

 


 

๐Ÿ“Œ ABAP ๋ฐ์ดํ„ฐ ๊ฐ์ฒด๋ž€?

ABAP์—์„œ ๋ฐ์ดํ„ฐ๋ฅผ ์ €์žฅํ•˜๋Š” ๋ณ€์ˆ˜์—๋Š” ์—ฌ๋Ÿฌ ๊ฐ€์ง€ ์œ ํ˜•์ด ์žˆ์Šต๋‹ˆ๋‹ค. ๊ฐ€์žฅ ๊ธฐ๋ณธ์ ์ธ ์œ ํ˜•์€ Simple Data Object์ด๋ฉฐ, ์ด๋ฅผ ํ™•์žฅํ•˜๋ฉด Structure(๊ตฌ์กฐ์ฒด)์™€ Internal Table(๋‚ด๋ถ€ ํ…Œ์ด๋ธ”)๋กœ ๊ตฌ์„ฑ๋ฉ๋‹ˆ๋‹ค.

 

 

1. Simple Data Object (๋‹จ์ˆœ ๋ฐ์ดํ„ฐ ๊ฐ์ฒด)

๋‹จ์ˆœ ๋ฐ์ดํ„ฐ ๊ฐ์ฒด(Simple Data Object)๋Š” ํ•˜๋‚˜์˜ ๊ฐ’์„ ์ €์žฅํ•˜๋Š” ๊ธฐ๋ณธ์ ์ธ ๋ณ€์ˆ˜์ž…๋‹ˆ๋‹ค.

  • ๋ฐ์ดํ„ฐ ์—˜๋ฆฌ๋จผํŠธ(Data Element)๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์„ ์–ธ
  • ๋ฌธ์ž, ์ˆซ์ž, ๋‚ ์งœ ๋“ฑ ๋‹ค์–‘ํ•œ ํ˜•์‹ ์ง€์›
  • โญ DATA ... TYPE [Data element] / TYPE [Structure - Component] / TYPE [Component Type]
DATA gv_result TYPE BC400_ACT. " ๋ฐ์ดํ„ฐ ์—˜๋ฆฌ๋จผํŠธ ์‚ฌ์šฉ
DATA gv_date TYPE BC400_S_FLIGHT-CARRID. " ์ŠคํŠธ๋Ÿญ์ฒ˜์˜ ํ•„๋“œ ์‚ฌ์šฉ
DATA gv_date TYPE S_DATE. " ๋ฐ์ดํ„ฐ ์—˜๋ฆฌ๋จผํŠธ ์‚ฌ์šฉ

SE11๋กœ ๊ฒ€์ƒ‰์‹œ, BC400_ACT์™€ S_DATE๋Š” ๋ฐ์ดํ„ฐ ์—˜๋ฆฌ๋จผํŠธ / BC400_S_FLIGHT์€ ์ŠคํŠธ๋Ÿญ์ฒ˜, CARRID๋Š” ์ŠคํŠธ๋Ÿญ์ฒ˜์˜ ํ•„๋“œ

 

2. Structure (๊ตฌ์กฐ์ฒด) ( = Work Area (WA))

๊ตฌ์กฐ์ฒด(Structure)๋Š” ์—ฌ๋Ÿฌ ๊ฐœ์˜ ํ•„๋“œ(Field)๋ฅผ ํ•˜๋‚˜์˜ ๊ทธ๋ฃน์œผ๋กœ ๋ฌถ์–ด์„œ ์‚ฌ์šฉํ•˜๋Š” ๋ฐ์ดํ„ฐ ํƒ€์ž…์ž…๋‹ˆ๋‹ค.

  • ํ…Œ์ด๋ธ”์˜ ํ–‰(Row)์ฒ˜๋Ÿผ ์—ฌ๋Ÿฌ ํ•„๋“œ๋ฅผ ํ•˜๋‚˜์˜ ๋‹จ์œ„๋กœ ๋‹ค๋ฃฐ ๋•Œ ์‚ฌ์šฉ
  • TYPES๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์‚ฌ์šฉ์ž ์ •์˜ ๊ตฌ์กฐ์ฒด๋ฅผ ์ƒ์„ฑ ๊ฐ€๋Šฅ
  • โญ DATA ... TYPE [Structure] / TYPE [Transparent Table] 
DATA gs_flight TYPE BC400_S_FLIGHT. โ€œ ์ŠคํŠธ๋Ÿญ์ฒ˜ ํƒ€์ž…
DATA custom TYPE SCUSTOM. โ€œํ…Œ์ด๋ธ”(Transparent Table)

SE11๋กœ ๊ฒ€์ƒ‰์‹œ, BC400_S_FLIGHT๋Š” ์ŠคํŠธ๋Ÿญ์ฒ˜ ํƒ€์ž…, SCUSTOM์€ ํ…Œ์ด๋ธ”

 

โœ… Transparent Table ๊ณผ Table TYPE ์ฐจ์ด์ 

๊ตฌ๋ถ„ Transparent Table Table TYPE
์ €์žฅ ์œ„์น˜ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค(DB) ABAP ๋Ÿฐํƒ€์ž„(๋ฉ”๋ชจ๋ฆฌ)
๋ชฉ์  ์‹ค์ œ ๋ฐ์ดํ„ฐ๋ฅผ ์ €์žฅ ๋‚ด๋ถ€ ํ…Œ์ด๋ธ”์˜ ๋ฐ์ดํ„ฐ ํƒ€์ž… ์ •์˜
DB ์กฐํšŒ ๊ฐ€๋Šฅ ์—ฌ๋ถ€ ๊ฐ€๋Šฅ (SELECT ๊ฐ€๋Šฅ) ๋ถˆ๊ฐ€๋Šฅ
์‹ค์ œ ํ…Œ์ด๋ธ” ์—ฌ๋ถ€ O (๋ฌผ๋ฆฌ์  ํ…Œ์ด๋ธ”) X (๋ฐ์ดํ„ฐ ํƒ€์ž…)
์‚ฌ์šฉ์ฒ˜ ํŠธ๋žœ์žญ์…˜ ๋ฐ์ดํ„ฐ ์ €์žฅ ํ”„๋กœ๊ทธ๋žจ ๋‚ด๋ถ€ ํ…Œ์ด๋ธ” ์ •์˜

 

3. Internal Table (๋‚ด๋ถ€ ํ…Œ์ด๋ธ”)

Internal Table(๋‚ด๋ถ€ ํ…Œ์ด๋ธ”)์€ ๊ฐ™์€ ๊ตฌ์กฐ(Structure)๋ฅผ ๊ฐ€์ง„ ๋ฐ์ดํ„ฐ์˜ ์ง‘ํ•ฉ์„ ์ €์žฅํ•˜๋Š” ๋ฐฉ์‹์ž…๋‹ˆ๋‹ค.

  • ๋Œ€๋Ÿ‰์˜ ๋ฐ์ดํ„ฐ๋ฅผ ๊ด€๋ฆฌํ•  ๋•Œ ์‚ฌ์šฉ
  • ๋™์  ๋ฐฐ์—ด๊ณผ ์œ ์‚ฌํ•œ ๊ฐœ๋…
  • Standard Table, Sorted Table, Hashed Table์˜ 3๊ฐ€์ง€ ์œ ํ˜•์ด ์žˆ์Œ
  • โญ DATA ... TYPE [Table Type]
DATA gt_carrier TYPE BC400_T_CARRIERS. โ€œ ํ…Œ์ด๋ธ” ํƒ€์ž…

SE11๋กœ ๊ฒ€์ƒ‰์‹œ, BC400_T_CARRIERS๋Š” ํ…Œ์ด๋ธ” ํƒ€์ž