Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 11 at 10:59 AM

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

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 10 at 11:51 PM

    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

    Add comment
    10|10000 characters needed characters exceeded