UserProfiles
Returns a collection of user profiles.
View-Specific Information
Select
The connector uses the SAP Ariba API to process WHERE clause conditions that are built with the following column and operators:
- ApprovableId supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [UserProfiles]
SELECT * FROM [UserProfiles] WHERE [ApprovableId] = 'Val1'
The connector processes other filters client-side within the connector.
Columns
| Name | Type | References | Description |
| ApprovableId [KEY] | String | The unique identifier of the approvable user profile. | |
| UniqueName | String | The system unique name of the user profile. | |
| Name | String | The display name of the user profile. | |
| FullUrl | String | The URL of the user profile in Ariba. | |
| HasGroupAddition | Bool | Indicates whether a group was added in the change set. | |
| ProfileChanged | Bool | Indicates whether the profile changed. | |
| DelegatingAuthority | Bool | Indicates whether delegating authority is enabled. | |
| AssigningCharges | Bool | Indicates whether assigning charges is enabled. | |
| OldChangesName | String | User display name in the pre-change snapshot. | |
| OldChangesEmployeeNumber | String | Employee identifier in the pre-change snapshot. | |
| OldChangesEmailAddress | String | Primary user email address in the pre-change snapshot. | |
| OldChangesDeliverTo | String | Default deliver-to value used on purchasing documents in the pre-change snapshot. | |
| OldChangesSupervisor | String | Supervisor reference for approval routing in the pre-change snapshot. | |
| OldChangesLimitedResponsibilityGroups | String | Limited-responsibility group assignment payload in the pre-change snapshot. | |
| OldChangesGlBusinessUnit | String | General ledger business unit setting in the pre-change snapshot. | |
| OldChangesPurchaseBusinessUnit | String | Purchasing business unit setting in the pre-change snapshot. | |
| OldChangesSapPlant | String | Default SAP plant setting in the pre-change snapshot. | |
| OldChangesReleaseAuthority | String | Release authority configuration in the pre-change snapshot. | |
| OldChangesPurchaseOrg | String | Purchasing organization code in the pre-change snapshot. | |
| OldChangesPurchaseGroup | String | Purchasing group code in the pre-change snapshot. | |
| OldChangesAccountingCompanyCode | String | Company code used for default accounting in the pre-change snapshot. | |
| OldChangesAccountingBusinessUnit | String | Business unit used for default accounting in the pre-change snapshot. | |
| OldChangesAccountingCostCenter | String | Cost center used for default accounting in the pre-change snapshot. | |
| OldChangesAccountingProcurementUnit | String | Procurement unit used for default accounting in the pre-change snapshot. | |
| OldChangesAccountingAccount | String | General ledger account used for default accounting in the pre-change snapshot. | |
| OldChangesAccountingSubAccount | String | Sub-account used for default accounting in the pre-change snapshot. | |
| OldChangesAccountingLocation | String | Location dimension used for default accounting in the pre-change snapshot. | |
| OldChangesAccountingDepartment | String | Department dimension used for default accounting in the pre-change snapshot. | |
| OldChangesAccountingProduct | String | Product dimension used for default accounting in the pre-change snapshot. | |
| OldChangesAccountingStatisticsCode | String | Statistics code used for default accounting in the pre-change snapshot. | |
| OldChangesBillingAddressName | String | Display name of the billing location in the pre-change snapshot. | |
| OldChangesBillingAddressUniqueName | String | System identifier of the billing location in the pre-change snapshot. | |
| OldChangesBillingAddressCity | String | City of the billing location in the pre-change snapshot. | |
| OldChangesBillingAddressState | String | State or region of the billing location in the pre-change snapshot. | |
| OldChangesBillingAddressCountry | String | Country code of the billing location in the pre-change snapshot. | |
| OldChangesBillingAddressPostalCode | String | Postal code of the billing location in the pre-change snapshot. | |
| OldChangesBillingAddressPhone | String | Phone contact for the billing location in the pre-change snapshot. | |
| OldChangesBillingAddressFax | String | Fax contact for the billing location in the pre-change snapshot. | |
| OldChangesBillingAddressEmailAddress | String | Email contact for the billing location in the pre-change snapshot. | |
| OldChangesShipToName | String | Display name of the default ship-to location in the pre-change snapshot. | |
| OldChangesShipToUniqueName | String | System identifier of the default ship-to location in the pre-change snapshot. | |
| OldChangesShipToCity | String | City of the default ship-to location in the pre-change snapshot. | |
| OldChangesShipToState | String | State or region of the default ship-to location in the pre-change snapshot. | |
| OldChangesShipToCountry | String | Country code of the default ship-to location in the pre-change snapshot. | |
| OldChangesShipToPostalCode | String | Postal code of the default ship-to location in the pre-change snapshot. | |
| OldChangesShipToPhone | String | Phone contact for the default ship-to location in the pre-change snapshot. | |
| OldChangesShipToFax | String | Fax contact for the default ship-to location in the pre-change snapshot. | |
| OldChangesShipToEmailAddress | String | Email contact for the default ship-to location in the pre-change snapshot. | |
| OldChangesGroups | String | Role and permission groups assigned to the user in the pre-change snapshot. | |
| NewChangesName | String | User display name in the post-change snapshot. | |
| NewChangesEmployeeNumber | String | Employee identifier in the post-change snapshot. | |
| NewChangesEmailAddress | String | Primary user email address in the post-change snapshot. | |
| NewChangesDeliverTo | String | Default deliver-to value used on purchasing documents in the post-change snapshot. | |
| NewChangesSupervisor | String | Supervisor reference for approval routing in the post-change snapshot. | |
| NewChangesLimitedResponsibilityGroups | String | Limited-responsibility group assignment payload in the post-change snapshot. | |
| NewChangesGlBusinessUnit | String | General ledger business unit setting in the post-change snapshot. | |
| NewChangesPurchaseBusinessUnit | String | Purchasing business unit setting in the post-change snapshot. | |
| NewChangesSapPlant | String | Default SAP plant setting in the post-change snapshot. | |
| NewChangesReleaseAuthority | String | Release authority configuration in the post-change snapshot. | |
| NewChangesPurchaseOrg | String | Purchasing organization code in the post-change snapshot. | |
| NewChangesPurchaseGroup | String | Purchasing group code in the post-change snapshot. | |
| NewChangesAccountingCompanyCode | String | Company code used for default accounting in the post-change snapshot. | |
| NewChangesAccountingBusinessUnit | String | Business unit used for default accounting in the post-change snapshot. | |
| NewChangesAccountingCostCenter | String | Cost center used for default accounting in the post-change snapshot. | |
| NewChangesAccountingProcurementUnit | String | Procurement unit used for default accounting in the post-change snapshot. | |
| NewChangesAccountingAccount | String | General ledger account used for default accounting in the post-change snapshot. | |
| NewChangesAccountingSubAccount | String | Sub-account used for default accounting in the post-change snapshot. | |
| NewChangesAccountingLocation | String | Location dimension used for default accounting in the post-change snapshot. | |
| NewChangesAccountingDepartment | String | Department dimension used for default accounting in the post-change snapshot. | |
| NewChangesAccountingProduct | String | Product dimension used for default accounting in the post-change snapshot. | |
| NewChangesAccountingStatisticsCode | String | Statistics code used for default accounting in the post-change snapshot. | |
| NewChangesBillingAddressName | String | Display name of the billing location in the post-change snapshot. | |
| NewChangesBillingAddressUniqueName | String | System identifier of the billing location in the post-change snapshot. | |
| NewChangesBillingAddressCity | String | City of the billing location in the post-change snapshot. | |
| NewChangesBillingAddressState | String | State or region of the billing location in the post-change snapshot. | |
| NewChangesBillingAddressCountry | String | Country code of the billing location in the post-change snapshot. | |
| NewChangesBillingAddressPostalCode | String | Postal code of the billing location in the post-change snapshot. | |
| NewChangesBillingAddressPhone | String | Phone contact for the billing location in the post-change snapshot. | |
| NewChangesBillingAddressFax | String | Fax contact for the billing location in the post-change snapshot. | |
| NewChangesBillingAddressEmailAddress | String | Email contact for the billing location in the post-change snapshot. | |
| NewChangesShipToName | String | Display name of the default ship-to location in the post-change snapshot. | |
| NewChangesShipToUniqueName | String | System identifier of the default ship-to location in the post-change snapshot. | |
| NewChangesShipToCity | String | City of the default ship-to location in the post-change snapshot. | |
| NewChangesShipToState | String | State or region of the default ship-to location in the post-change snapshot. | |
| NewChangesShipToCountry | String | Country code of the default ship-to location in the post-change snapshot. | |
| NewChangesShipToPostalCode | String | Postal code of the default ship-to location in the post-change snapshot. | |
| NewChangesShipToPhone | String | Phone contact for the default ship-to location in the post-change snapshot. | |
| NewChangesShipToFax | String | Fax contact for the default ship-to location in the post-change snapshot. | |
| NewChangesShipToEmailAddress | String | Email contact for the default ship-to location in the post-change snapshot. | |
| NewChangesGroups | String | Role and permission groups assigned to the user in the post-change snapshot. |