APIs for Key Figures - SAP Subscription Billing

[former_member772797]

Are there any specific API's that can be used to get Key Figures like Billing Net total for a a specific Market in a given period etc ?

a few example scenario:

1. Total Number of Subscriptions/Billing document per Market (Market as input parameter) for a specific period

2. Sum of Recurring Billing documents per Market (Market as input parameter) for a specific period

Regards

Shakeel

[former_member755598]

Hi Shakeel,

I’ve responded one scenario at a time:

1. Total Number of Subscriptions/Billing document per Market (Market as input parameter) for a specific period

Bills

Check out the API Reference for GET /bills at Overview | Bills | SAP API Business Hub

You can filter for market using market.id and date using to and from.

In the response header, you will see x-count. That is what you have asked for: total number of billing documents that match your filtering attributes

Subscriptions

API Reference | Subscriptions | SAP API Business Hub

The following attributes are supported for filtering:
- market.id

- validFrom

- validUntil

- There are also a lot of other date-related filter attributes that you could use

Again, x-count in the response header contains the total number of elements (in this case subscriptions) that match your filtering attributes

2. Sum of Recurring Billing documents per Market (Market as input parameter) for a specific period

If I understand correctly that you are asking for the totals or subtotals across a range of bills to be summed: No, there is no API to do this. In your downstream system is probably where you want to find this type of analytics functionality. Keep an eye on the roadmap for future functionality related to analytics: SAP Road Map Explorer.


I hope that helps.

Cheers,
Chris

[former_member772797]

Thanks Chris, count is fine. but we need total sum of charges for given parameters without looping among all records, something possible ?

[former_member755598]

Hi Shakeel, no there is no ootb functionality to do that. It would be appropriate to calculate such as sum in a downstream system that can analyze the filtered results.