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.