Showing results for 
Search instead for 
Did you mean: 

How to get available serial number using SAP Service Layer API

0 Kudos

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?



Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Thank you Ralph for your response. I will check this out.

0 Kudos

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

0 Kudos

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 ?

Product and Topic Expert
Product and Topic Expert
0 Kudos

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,


SAP Business One Support