AddCustomFieldValues
Adds values to custom fields configured for the specified supplier.
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 CustomField#TEMP (FieldName, Value) VALUES ('TestRiskN', '12.4')
INSERT INTO CustomField#TEMP (FieldName, Value) VALUES ('TestRiskU', 'https://www.test.com')
INSERT INTO CustomField#TEMP (FieldName, Value) VALUES ('TestRiskD', '2022-01-01')
INSERT INTO CustomField#TEMP (FieldName, Value) VALUES ('TestRiskFT', 'Test')
INSERT INTO SupplierCustomFields#TEMP (SMVendorId, CustomFields) VALUES ('S10666490', 'CustomField#TEMP')
INSERT INTO CustomField1#TEMP (FieldName, Value) VALUES ('TestRiskT','Removed')
INSERT INTO CustomField1#TEMP (FieldName, Value) VALUES ('TestRiskN', '12.7')
INSERT INTO CustomField1#TEMP (FieldName, Value) VALUES ('TestRiskU', 'https://www.test.com')
INSERT INTO CustomField1#TEMP (FieldName, Value) VALUES ('TestRiskD', '2023-01-01')
INSERT INTO CustomField1#TEMP (FieldName, Value) VALUES ('TestRiskFT', 'Test2')
INSERT INTO SupplierCustomFields#TEMP (SMVendorId, CustomFields) VALUES ('S10667863', 'CustomField1#TEMP')
EXECUTE AddCustomFieldValues SupplierCustomFields = 'SupplierCustomFields#TEMP'
SupplierCustomFields temporary table schema info:
Column Name | Type | Required | Description |
SMVendorId | string | False | A unique ID that SAP Ariba assigns automatically. |
CustomFields | string | False | The list of custom fields objects. Table reference: Internal_CustomField.rsd. |
CustomField temporary table schema info:
Column Name | Type | Required | Description |
FieldName | string | False | The name of the custom field. |
Value | string | False | The value for the custom field. |
Url | string | False | The URL for the custom field. |
Source | string | False | The source for the custom field. |
Note | string | False | The note for the custom field. |
Input
Name | Type | Description |
Realm | String | The requested realm. |
SupplierCustomFields | String | The list of suppliers and custom fields with values. |
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. |