SAP HANA [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;1299 no data found: "DB"."(DO statement)":

[arsalkhan909]

"Dear Experts,

I am seeking assistance with an issue in SAP HANA. The FMS Query is working fine, but when I open the sales order form, it shows an error. Can you please help me resolve this issue?"

1). [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;1299 no data found: "ZIL_TEST"."(DO statement)": line 7 col 2 (at pos 98): FMS execution failed on field 'U_JT' with query name 'Job type in Sales Order v2'

the query is:

Declare item varchar(70);

Declare itemcat varchar(16);

Declare yds NUMERIC(19,6);

SELECT T1."ItemName",

T1."U_Main_Category",

$[$38.87.Number]

INTO

item,

itemcat,

yds

FROM "OITM" T1

where T1."ItemCode"= $[$38.1];

IF item LIKE '%Printed%' THEN

Select 'Slitting' AS ResultCredit from dummy;

ELSE

IF yds >= 230 or itemcat = 'Stationary' THEN

SELECT 'Slitting' AS ResultCredit from dummy;

ELSE

SELECT 'Rewinding' AS ResultCredit from dummy;

END IF;

END IF;

[HakanHaslaman]

I'm not familiar with this topic, but found this note, may it helps you further:
https://oslpredirect.sdn.sap.com/notes/3285340

[arsalkhan909]

Hey Hakan,

I Can't access to SAP Notes. It shows access denied

[CharlesFeng]

Hi arsalkhan909,

Can you please check if you are able open the note via below link?
3285340 - Formatted Searches: Standard Behaviors Guide and How-to Scenarios - SAP for Me

Best regards,
Charles

[CharlesFeng]

Hi arsalkhan909,

Can you please check if you are able open the note via below link?
3285340 - Formatted Searches: Standard Behaviors Guide and How-to Scenarios - SAP for Me

Best regards,
Charles