Friday, 2 August 2024

Delta configuration for Standard API in S/4HANA cloud

In order to Create Delta for standard API:

Go to product master standard API in Business Accelerator Hub then click on tryout option.

Delta configuration for Standard API in S/4 HANA cloud

Now, we have to configure our system environment here as shown below

Delta configuration for Standard API in S/4 HANA cloud

Delta configuration for Standard API in S/4 HANA cloud

Delta configuration for Standard API in S/4 HANA cloud

Delta configuration for Standard API in S/4 HANA cloud

And after successfully configuring Now you can tryout any of these operations in Standard API

Delta configuration for Standard API in S/4 HANA cloud

Now in order to get delta, we have to take a delta pointer based on the fields in standard API. In this case I’m taking Lastchangedate field as delta pointer

Delta configuration for Standard API in S/4 HANA cloud

And Filter out records based on delta pointer (Lastchangedate) as shown below

Delta configuration for Standard API in S/4 HANA cloud

Here the logic is: LastChangeDate ge datetime'2024-01-14T00:00:00’ And it says lastchangedate is greater than or equals to 2024-01-14 and also there are other logics as well: LastChangeDate ge datetime'2024-06-13T00:00:00' and LastChangeDate lt datetime'2024-06-14T00:00:00' and it only gives records between 14th june to 13th june.

So After initializing this logic run as shown below

Delta configuration for Standard API in S/4 HANA cloud

we get records that are changed on or after 14th January 2024 in OData URL itself and it gives count of how many records are present as shown below

Delta configuration for Standard API in S/4 HANA cloud

Now we can check data by taking URL till highlighted part and run OData in PowerBI

Delta configuration for Standard API in S/4 HANA cloud

Now in Power BI, Select OData feed and add the required URL

Delta configuration for Standard API in S/4 HANA cloud

Delta configuration for Standard API in S/4 HANA cloud

And we can see required delta records here

Delta configuration for Standard API in S/4 HANA cloud

No comments:

Post a Comment