How to get available serial number using SAP Service Layer API

[former_member595685]

Hello experts,

I am using SerialNumberDetails service layer API endpoint to get serial numbers from SAP. Here I want to add filter to get only in stock serial numbers with this API.

I am using below API url currently.

GET: https://XXX.XXX.X.X:50000/b1s/v1/SerialNumberDetails?$filter=ItemCode eq 'S10000'

Response for above.

"value": [ { "DocEntry": 577, "ItemCode": "S10000", "ItemDescription": "Server Point 10000", "MfrSerialNo": null, "SerialNumber": "S1-000225", "LotNumber": null, "SystemNumber": 225, "AdmissionDate": "2019-03-06", "ManufacturingDate": null, "ExpirationDate": null, "MfrWarrantyStart": null, "MFrWarrantyEnd": null, "Location": null, "Details": "" },

Here How to filter based on in stock serial numbers?

Am I using correct endpoint here to get? Is there any other endpoint to get?

Can you please help on this?

Thanks

Irfan

[former_member197733]

Hi there,

To be clear, both Service Layer and DI API are built on top of the same business object library (OBServer.dll). This means they both expose the same features. The difference in favor of SL is that the underneath library is multi-thread AND SL also have some additions due the OData protocol implementation.

So, in terms of business functionalities, your question isn't specific to Service Layer but to DI API as well.

Here are some posts pointing the tables where you can find the Serial quantity, you could encapsulate a query using a HANA View and have it exposed as a Service Layer API

• inventory list with available serial numbers
• Available stock serial numbers report
• Query to get all serial numbers in a Goods Issue
  

[former_member693983]

Hello, i got this problem on SAP Business One hosted on Cloud.

Could you explain to me if i can do a Hana View and expose it to be available on SL endpoint ?

[ANKIT_CHAUHAN]

Hi romaric,

Refer to the section "SAP Business One Semantic Layer View Exposure" in Service Layer User Manual. This should help you for your cause.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support