cancel
Showing results for 
Search instead for 
Did you mean: 

SAP IBP Odata call to retrieve Last Modified Date

b007eee
Explorer
0 Kudos
375

Hi Experts ,

I am facing a problem trying to retrieve the last modified date for master data types from IBP,

https://myXXXXXX-api.scmibp1.ondemand.com/sap/opu/odata/IBP/MASTER_DATA_API_SRV/XXXPRODUCT?&$select=... eq 'ABC1234'

When I remove the select from the call I can't see the last LastModifiedDate as a criteria to select / filter but I can see if via the excel masterdata app.

adding the below filter to the call also fails to retrieve any data.

$filter=LastModifiedDate ge datetime'2023-10-01T00:00:00' ' and LastModifiedDate le datetime'2023-10-23T23:59:59'

Kind Regards, Richard

Accepted Solutions (0)

Answers (2)

Answers (2)

b007eee
Explorer
0 Kudos

Unfortunately the above will no longer work from 2311 release as the OData call is being deprecated and the new OData call doesn't have LASTMODIFIEDDATE available to select / filter.

b007eee
Explorer
0 Kudos

We've managed to get the call working now.

https://myXXXXXX-api.scmibp1.ondemand.com/sap/opu/odata/IBP/EXTRACT_ODATA_SRV/XXXXXXX?$filter=LASTMO... ge datetime'2023-10-22T00:00:00'&$select=PRDID, LASTMODIFIEDDATE

https://myXXXXXX-api.scmibp1.ondemand.com/sap/opu/odata/IBP/EXTRACT_ODATA_SRV/<Planning Area>?$filter=LASTMODIFIEDDATE ge datetime'2023-10-22T00:00:00'&$select=PRDID, LASTMODIFIEDDATE