Skip to Content
0

SP ISSUE in HANA

Feb 01, 2017 at 11:35 AM

80

avatar image
Former Member

HI Experts

Im Using SAP business one 9.2 hana based i write the following SP

Select(MIN(IFNULL(T3."BaseQty",0) * IFNULL(T3."IssuedQty",0))) INTO CNT4 FROM OIGN T0 INNER JOIN IGN1 T1 ON T0."DocEntry" = T1."DocEntry" Inner Join OWOR T2 ON T2."DocEntry" = T1."BaseRef" Inner Join WOR1 T3 ON T3."DocEntry" = T3."DocEntry" WHERE T0."DocEntry" = :list_of_cols_val_tab_del AND T0."BPLName" = 'KNT' AND T2."ItemCode" = T1."ItemCode" and T0."DocType" = '202'AND T3."ItemType" = '4' ;

(SELECT count(*) INTO cnt FROM OIGN T0 INNER JOIN IGN1 T1 ON T0."DocEntry" = T1."DocEntry" Inner Join OWOR T2 ON T2."DocEntry" = T1."BaseRef" Inner Join WOR1 T3 ON T3."DocEntry" = T3."DocEntry" WHERE T0."BPLName" = 'KNT' AND T2."ItemCode" = T1."ItemCode" and T0."DocType" = '202' and T0."DocEntry" = :list_of_cols_val_tab_del AND T1."Quantity" > CNT4); IF :cnt>0 THEN error := -3007; error_message := 'Receipt Qty is Greater Than Min(issue * Base) Qty';

SP is executed successfully in HANA studio but when i make receipt from production in SAP this shows me the following error

[SAP AG][LIBODBCHDB32 DLL][HDBODBC32] General error;328 invalid name of function or procedure: tmp_qry_sp_7a041168-20ab-45e7-9dbc-a69e2cca5094: line 1 col 29 'Business Place' (OBPL) (at pos 28)

Kindly guide where am i missing

Regards

Jamil

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers