Skip to Content
1

How to read data from OITM and OITW with a UDF value condition using Service layer

Nov 09, 2017 at 04:46 AM

48

avatar image
Former Member

Hi Expert ,

I am new user of service layer rest api .I want to read data from OITM and OITW with udf condition value . Below is the example of DIServer query we have used :

select WareHouseDet.ItemCode,U_WebID,WareHouseDet.OnHand,OITM.U_LastStock from OITM inner join (select OITW.ItemCode,sum(OITW.OnHand-OITW.IsCommited) as OnHand FROM OITW where OITW.WhsCode in ('01','04') GROUP BY OITW.ItemCode ) as WareHouseDet on WareHouseDet.ItemCode=OITM.ItemCode where WareHouseDet.OnHand != (isnull(OITM.U_LastStock,0)) and U_WebID!=''

same data i want to read using service layer from sap b1.Please suggest how to read?

Thanks

Surajit Kundu

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

2 Answers

Ralph Oliveira
Jan 11 at 10:59 AM
0

On top of Samuel's answer. Just apply the Odata URI convention to filter your record,

see: 4.5. Filter System Query Option ($filter)

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 10 at 11:51 PM
0

I am not sure what you are doing here, BUT if you want the OITW table in the service layer you are out of luck, but the if you do

/b1s/v1/StockTakings

then you can get a list of itemcodes and warehousecodes that are linked

Share
10 |10000 characters needed characters left characters exceeded