on 02-01-2017 11:35 AM
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
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.