Operational Reporting API - Sourcing

[michael866056]

Hello Gurus,

Customer needs to have a list of suppliers invited to every RFP. We’re planning on extract this information daily and use the ERP as a repository.

Supplier invited ID Document ID Status CreationDate IDXXXXXXXX Doc41999999 Complete 2020-05-25T20:22:25Z

Reviewing possible solutions i was able to fulfill the 80% of that requirement using the "operational reporting API for Sourcing". For this I created a copy of the view “RFXDocumentSourcingSystemView“, but for the suppliers it brings back basic data and I need the organization ID.

Any suggestion will be welcome.

[SeanMcGann]

Hi Michael,

The SupplierParticipationFact has most of the information that you are looking for. My suggestion would be to use that and create a custom view template. The body to create it would look something like:

{"documentType": "SupplierParticipationFact", "status": "published", "selectAttributes": ["Supplier","Event","EventInfo","EventEndDate","EventCreateDate"], "filterExpressions": [ { "name": "updatedDateTo", "field": "TimeUpdated", "op": "<=", "defaultValue": "2019-02-09T00:00:00Z" }, { "name": "updatedDateFrom", "field": "TimeUpdated", "op": ">", "defaultValue": "2019-02-04T00:00:00Z" } ] }

If you've never worked with this before, please see https://help.sap.com/viewer/bf0cde439a0142fbbaf511bfac5b594d/cloud/en-US/c463b520a1954fecbd6f83dc6f5...

This will not include the status, but you can filter on EventEndDate, if you need the status, please join this fact using the EventDim to add the event status in your external system. You can also leverage the reporting API to pull a list of event IDs and run them through the External Approval API for sourcing and Supplier management if you do not wish to use any joins.

Let us know if you have any questions.

Thanks,
Sean