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