소스입니다.
DATA :BEGIN OF it_test OCCURS 0,
vbeln LIKE vbak-vbeln,
posnr LIKE vbap-posnr,
END OF it_test.
EXEC SQL PERFORMING loop_output.
select B.ORDER_NUMC
from cx_ord_in_mod@crm A,
S_ORDER@crm B,
S_ORDER_ITEM@crm C,
S_ORDER_ITEM_X@crm D,
sapr3.vbap e
where e.mandt = '100'
into :it_test-vbeln
and e.vbeln = lpad(b.order_num, 10, 0)
and e.posnr = lpad(c.ln_num * 10, 6, 0)
and B.ORDER_NUM = A.X_ORDER_NUM
AND C.ORDER_ID = B.ROW_ID
AND D.ROW_ID = C.ROW_ID
AND A.x_work_flag = 'E'
AND A.CREATED >= '2007-05-02'.
ENDEXEC.
form loop_output.
append it_test.
endform.
write:/ it_test-vbeln.
이렇게 해도 에러는 나네요..
미치것네요..
에러내용은 : the error occurred in the current database connection "default".
..................................