ODATA Collections are not available for approval data

[former_member742111]

Hi All,

We have a requirement to find ODATA Collection to get the approval data from Standard BOs like (CustomerQuote, CustomerOrder, ServiceRequest etc). there are no such collections in standard ODATA service explorer.

We need only ODATA collection to get approval data as per our requirement. how can we achieve this.

Thanks in advance.

Regards,

Vinnu.

[former_member742111]

Hi Nikhil,

Thank you for your response.

Yes exactly. I want to read approvers data of particular transactions from approval tab. but I need to fetch this information only through ODATA collections(Custom/standard or any other way).

Is it possible or not?

Thanks in advance.

Regards,

Vinnu.

[former_member742111 · Accepted solution]

Hi Nikhil,

Thank you for above suggestion.

It led me towards the solution to get approver data(Approval tab data of any transaction like Sales quote, Sales Order, Service Request etc.) through ODATA query and Report.

We cannot get approver data directly from Data source "Approval Task Details (BTMAPPV01)" but we need to follow below procedure to get it.

The data source Approval Task Details must always be used as a joined data source along with application created data source. Application created data source should act as an anchor data source. Approval Task Details data source should never be consumed independently since it does not show any data on its own. Also, if the business documents are not enable for Multi-Step Approval process, then the report will never work.

For example:

Purchase order and supplier invoice are registered for Multi-Step Approval and the corresponding data source for the same is listed below, which should be set as an anchor data source.

Approval of Purchase orders – Data source available for Purchase order header data.

Approval of non-PO invoices – Data source available for Supplier invoice header data.

Please refer below SAP Note for all the steps to create report and ODATA Query.

2599498 - Errors in Approval Task Details Data Source ( https://apps.support.sap.com/sap/support/knowledge/en/2599498)

Hope this helps others who wants to read Approver data of particular Transaction.

Regards,

Vinnu.

[nikhilwalsetwar]

Hi vinodch,

What is your exact requirement? Do you want to read like who all approvers for a specific transaction? For example if the quote is submitted for approval and there are two approvals needed then you want to read this information?

Best,

Nikhil

[former_member742111]

Hi Nikhil,

Thank you for your response.

Yes exactly. I want to read approvers data of particular transactions from approval tab. but I need to fetch this information only through ODATA collections(Custom/standard or any other way).

Is it possible or not?

Thanks in advance.

Regards,

Vinnu.

[nikhilwalsetwar]

Hi vinodch,

Yes as of now there is not standard OData API but you can create a report using the Data source Approval Task Details (BTMAPPV01) and then build a OData API on this report and retrieve the Approver information as per your requirement.

Hope this helps.

Best,

Nikhil

[former_member809660]

hello wnikhil

If I need to provide this OData interface for external system use, how to solve the account problem? I don't want to give out accounts that can log into the system