I've developed an add-on using the Extension Registration Data Center (Extension Package), following the instructions in the document [How to Package and Deploy SAP Business One Extensions for Lightweight Deployment].The add-on works fine in FP 2202 ...
Hey All,I have converted the store procedure from SQL Server to SAP HANA.In my enclosed SP I have commented some code of blocks(as they are not allowing to create SP).While I am uncommenting them, Error is generated of "SAP DBTech JDBC: [467] (at 425...
Hi @ramco1917 ,You can take help from the below post.https://community.sap.com/t5/enterprise-resource-planning-q-a/sap-b1-hana-query-with-date-parameter-in-variable/qaq-p/13916446 Thanks.Manish
Hi @Swathy ,If ( :object_type = '13' AND :transaction_type = 'A')
THEN
DECLARE temp_var_0 INT := 0;
SELECT COUNT(B."DocEntry") INTO temp_var_0
FROM OINV B
LEFT OUTER JOIN OUSR C ON B."UserSign" = C."USERID"
WHERE B.CANCELED IN ('C...
Hola @Aliset_Soris ,You can try the below query.SELECT
T0."ItemCode",
T0."ItemName" AS "ItemName",
(SELECT X1."Descr" FROM CUFD X0 INNER JOIN UFD1 X1 ON X0."TableID"=X1."TableID" AND X0."FieldID"=X1."FieldID"
WHERE X0."TableID"='OITM' AND X0."AliasI...
One of my clients shared a similar issue with me. When they try to click on the shortcuts, sometimes the shortcut gets dragged out of the common function area, causing the menu to disappear. I searched through SAP notes and blogs but couldn't find an...
