목록open sql #sap #abap #where exists #where not exists (1)

0v0__DEV

[11] ABAP OPEN SQL - WHERE EXISTS, WHERE NOT EXISTS

개발 중 exists와 not exists 를 사용했는데, 예상과 다르게 데이터가 출력되어 두 구문에 대해 작성해본다! 1. WHERE NOT EXSITS SELECT * FROM scarr WHERE CARRID IN ( 'AA', 'AB', 'AC', 'AD' ) INTO TABLE @DATA(lt_itab).SELECT a~* FROM scarr AS a INNER JOIN @lt_itab AS b ON a~CARRID = b~CARRID WHERE NOT EXISTS ( SELECT * FROM scarr WHERE CARRID EQ 'CO' ) INTO TABLE @DATA(lt_scarr).SCAR..
SAP BASIC 2024. 8. 23. 10:52
이전 Prev 1 Next 다음