Skip to Content
0
Former Member
Sep 22, 2005 at 04:05 PM

AddOn and DI Api

79 Views

Hello everybody,

I have the following issue in DI API:

I am developing an addon, and it requires complicated query like this:

SELECT OITM.ITEMCODE, ITEMNAME, A.ONHAND AS QTY_SQFT_INSTOCK,

U_NPCS AS QTY_PCS_INSTOCK ,

(SELECT SUM(QUANTITY) AS QUANTITY FROM QUT1 WHERE ITEMCODE = A.ITEMCODE AND WHSCODE= A.WHSCODE ) AS QTY_SQFT_HOLD,

(SELECT SUM(U_TSQ) AS U_TSQ FROM QUT1 WHERE ITEMCODE = A.ITEMCODE AND WHSCODE= A.WHSCODE) AS QTY_PCS_HOLD,

(SELECT PRICE FROM ITM1 WHERE PRICELIST = 9 AND ITEMCODE = A.ITEMCODE ) AS WSP,

(SELECT PRICE FROM ITM1 WHERE PRICELIST = 8 AND ITEMCODE = A.ITEMCODE AND WHSCODE= A.WHSCODE) AS RSP,

'DEFINE FIELD' AS DSP

FROM OITW A, OITM

WHERE A.ITEMCODE = OITM.ITEMCODE

AND WHSCODE = '01'

AND OITM.ITEMCODE >= 'A00001'

AND OITM.ITEMCODE <= 'A00007'

ORDER BY OITM.ITEMCODE, ITEMNAME

and I need to link the query result to a user matrix, I think that I have to use DI Api to get this query.

I get the server name, company name, user name from SBO_Application.company, but I can not get the password connect to SAPbobsCOM.Company, any body can tell me how to do this??

Thanks in advance.

Hector