Excel Add-In for SAP Ariba Source

Build 24.0.9060

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 NameTypeRequired Description
SMVendorId stringFalse A unique ID that SAP Ariba assigns automatically.
CustomFields stringFalse The list of custom fields objects. Table reference: Internal_CustomField.rsd.

CustomField temporary table schema info:

Column NameTypeRequired Description
FieldName stringFalse The name of the custom field.
Value stringFalse The value for the custom field.
Url stringFalse The URL for the custom field.
Source stringFalse The source for the custom field.
Note stringFalse 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060