cancel
Showing results for 
Search instead for 
Did you mean: 

Delta configurationfor Standard API in S/4 HANA cloud

Harshhith
Explorer
276

In order to Create Delta for standard API:

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

Harshhith_0-1721900049413.png

 

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

Harshhith_1-1721900049429.png

 

 

Harshhith_2-1721900049431.png

 

Harshhith_3-1721900049433.png

 

Harshhith_4-1721900049435.png

 

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

Harshhith_5-1721900049440.png

 

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

Harshhith_6-1721900049447.png

 

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

Harshhith_7-1721900049452.png

 

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

Harshhith_8-1721900049456.png

 

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

Harshhith_9-1721900049458.png

 

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

Harshhith_10-1721900049460.png

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

Harshhith_11-1721900049466.png

Harshhith_12-1721900049469.png

And we can see required delta records here

Harshhith_13-1721900049481.png

 

Mark_W
Product and Topic Expert
Product and Topic Expert
0 Kudos
We helped you to accept the answer, since there were no updates after 7 days. You can unaccept it anytime if you have further questions.
View Entire Topic
OwenLiu
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello,

From my understanding this is like sharing information rather than a question.

If so, suggest you choose to create Blog.

Thanks & Best Regards,
Owen

Harshhith
Explorer
0 Kudos
yeah sure my mistake thanks for the response