Hi,
I need help please. I am poulating data for a custom field in master data reading from a DSO . After writing below logic , I am getting error message 'If the new OpenSQL syntax is used, it must be used throughout. This includes using @ to escape host variables'. Any idea why i am getting this error message ?
TYPES :BEGIN OF TY_ZEQU,
EQUIPMENT TYPE /BI0/OIEQUIPMENT,
/BIC/ZCFLDVAL TYPE /BIC/OIZCFLDVAL,
END OF TY_ZEQU.
DATA :IT_ZEQU TYPE STANDARD TABLE OF TY_ZEQU,
WA_ZEQU TYPE TY_ZEQU,
IT_RESULT TYPE STANDARD TABLE OF _ty_t_TG_1.
REFRESH :IT_ZEQU.
SELECT EQUIPMENT,/BIC/ZCFLDVAL FROM /BIC/AZAEQU00400
INTO TABLE IT_ZEQU
FOR ALL ENTRIES IN RESULT_PACKAGE[]
WHERE EQUIPMENT = RESULT_PACKAGE-UC_DEVICE AND
/BIC/ZCFLDNAM = 'READING_METHOD'.
IF RESULT_PACKAGE[] IS NOT INITIAL.
LOOP AT RESULT_PACKAGE ASSIGNING <RESULT_FIELDS>.
READ TABLE IT_ZEQU INTO WA_ZEQU
WITH KEY EQUIPMENT = <RESULT_FIELDS>-UC_DEVICE BINARY SEARCH.
IF SY-SUBRC = 0 .
<RESULT_FIELDS>-/BIC/ZCMTR_MD = WA_ZEQU-/BIC/ZCFLDVAL.
APPEND <RESULT_FIELDS> TO IT_RESULT.
ENDIF.
ENDLOOP.
REFRESH RESULT_PACKAGE.
RESULT_PACKAGE = IT_RESULT.
ENDIF.