ReplaceComplianceData
This operation will replace compliance data for a single supplier. To delete the existing compliance data for a specified supplier, send an empty request body. To replace the existing compliance data for a specified supplier, send the replacment data in the response body.
Execute
This stored procedure includes a #TEMP table input. Below is an example execution.
The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.
INSERT INTO Evidences#TEMP (UniqueId, Source, Provider, PenaltyAmount, IsoCurrencyCode, Url, EffectiveStartDate, EffectiveEndDate, SupportingIndicatorStatus, Note) VALUES ('1', 'Test', 'providerName', '1000.5', 'USD', 'https://www.test.com', '2020-01-01', '2020-05-01', 'SANCTION', 'summary')
INSERT INTO Evidences#TEMP (UniqueId, Source, Provider, PenaltyAmount, IsoCurrencyCode, Url, EffectiveStartDate, EffectiveEndDate, SupportingIndicatorStatus, Note) VALUES ('2', 'example', 'anotherProvider', '750.25', 'EUR', 'https://www.test.com', '2021-03-15', '2021-08-15', 'WATCHLIST', 'description')
EXECUTE ReplaceComplianceData
SMVendorId = 'S10666588',
SanctionIndicatorStatus = 'VIOLATION_FOUND',
WatchlistIndicatorStatus = 'VIOLATION_NOT_FOUND',
Note = 'Note.',
Evidences = 'Evidences#TEMP',
To delete the existing compliance data for a specified supplier, only the SMVendorId needs to be specified.
EXECUTE ReplaceComplianceData SMVendorId = 'S10666588',
Evidences temporary table schema info:
| Column Name | Type | Required | Description |
| UniqueId | string | False | An ID that you provide to uniquely identify the evidence data. This isn't a mandatory field. You only need to provide this ID if you want to have the ability to update it later. |
| Source | string | False | The source is the origin of the evidence about the supplier. An example is when there are multiple articles supporting the evidence about the supplier, only the most relevant source is shown. You can use the information in the source to find articles from other sources. The URL for a source must start with https or http. |
| Provider | string | False | The provider of the compliance data for the supplier. Your provider can have evidence data from multiple sources. |
| PenaltyAmount | decimal | False | The currency amount of any penalty applied to the supplier for the violation. |
| IsoCurrencyCode | string | False | The ISO 4217 currency code that represents the alphabetic currency for the penaltyAmount. |
| Url | string | False | The URL used to provide proof of the evidence. The URL is a clickable link. An example is a link to an article. |
| EffectiveStartDate | date | False | The date the compliance violation started. |
| EffectiveEndDate | date | False | The date the compliance violation ended. |
| SupportingIndicatorStatus | string | False | The fields from the risk configurations such as sanction and watchlist. |
| Note | string | False | Any note you add about the evidence of the supplier's violation. You can add a note of up to 3000 characters. |
Input
| Name | Type | Description |
| Realm | String | The requested realm. |
| SMVendorId | String | A unique ID that SAP Ariba assigns automatically. |
| SanctionIndicatorStatus | String | The status that tells you if a sanction was found for the supplier.
The allowed values are VIOLATION_FOUND, VIOLATION_NOT_FOUND, VIOLATION_EXPIRED, NOT_SCREENED. |
| WatchlistIndicatorStatus | String | The status that tells you if the supplier is on a watchlist.
The allowed values are VIOLATION_FOUND, VIOLATION_NOT_FOUND, VIOLATION_EXPIRED, NOT_SCREENED. |
| SupplierScreenedAt | Date | The date you screened the supplier for compliance data. |
| Note | String | Any note you add when you screen the supplier. You can add a note of up to 3000 characters. |
| Evidences | String | Evidence data. |
Result Set Columns
| Name | Type | Description |
| Success | String | Indicates whether or not the operation was successful. |
| Details | String | Any extra details on the operation's execution. |