Projects
Retrieve details about the specified sourcing project.
View-Specific Information
Select
The add-in uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.
- ProjectId supports the '=' comparison operator.
SELECT * FROM Projects WHERE ProjectId = 'WS12345'
Update
You can update projects by executing UPDATE statements with a Project Id. For example:
UPDATE Projects SET Title='Sourcing Project',Status='Gray',State='Active',Currency='USD',Description='Sourcing Project' WHERE ProjectId = 'WS12345'
Columns
| Name | Type | ReadOnly | References | Description |
| ProjectId [KEY] | String | False |
Specifies the internal Id of the sourcing project. | |
| DisplayVersion | String | False |
Specifies the sourcing project version. Ignored for POST and PUT requests. | |
| ParentProjectId | String | False |
Specifies the internal ID of the parent project. A value in this field indicates that the project is a subproject. | |
| ParentProjectTitle | String | False |
Specifies the title of the parent project. Value is present when it is a subproject. | |
| LocalizedParentProjectTitle | String | False |
Indicates that internationalization is supported. | |
| ParentDocumentId | String | False |
Specifies the internal ID of the parent project. Value is present when sourcing project is a subproject. | |
| ParentIdsTitlesMap | String | False |
Specifies the custom data type that contains keys and values to represent different objects. | |
| PredecessorProjectId | String | False |
Specifies the internal ID of the predecessor project. Present only for follow-on projects. | |
| PredecessorProjectName | String | False |
Specifies the title of the predecessor project. Present only for follow-on projects. | |
| PredecessorProjectsMap | String | False |
Predecessor projects map. | |
| FollowOnProjectsMap | String | False |
Indicates a follow on project. Value is present only when you create a sourcing project using a guided sourcing template. | |
| CopyFromProjectId | String | False |
Copy from project id. | |
| TemplateProjectTitle | String | False |
Specifies the template name used when creating this full sourcing project. | |
| TemplateProjectInternalId | String | False |
Specifies the internal ID of the sourcing template to use or used when creating this sourcing project. Required for POST requests; ignored in all other requests. Example, Try it out with: SYS0208. | |
| TemplateQuestions | String | False |
Specifies questions defined within a template. | |
| HasEditTemplatePermission | Bool | False |
Has edit template permission. | |
| ProcessId | String | False |
Indicates a unique process ID for the template that was used to create the project. Example: PI26620833. | |
| ProcessStatus | String | False |
Process Status. By default, this field has the \\'Enable for template Field Setter\\' option enabled, and a template can be configured to set the field value based on the response to a template question or when a task is completed. | |
| State | String | False |
Specifies the project state. When creating a project, the only valid values are Active and Planned. Planned indicates the project has not begun; if you set this to Planned, you can also specify a Planned Start Date and Planned End Date. The states 'On Hold', 'Completed' and 'Cancelled' are available while editing the project. Required for PUT requests. | |
| Status | String | False |
Indicates the status of the sourcing project. Possible values: Gray: New project, Green: On track, Yellow: At-risk, Red: Off track. Required for PUT requests. | |
| Title | String | False |
Specifies the title (name) of the sourcing project. Required for PUT requests. Example, Try it out with: title. | |
| LocalizedTitle | String | False |
Indicates that internationalization is supported. | |
| BaseLanguage | String | False |
Specifies the language used in the sourcing project if there is no translated text for the user's language. | |
| Description | String | False |
Specifies the description of the sourcing project. | |
| Origin | String | False |
Specifies the sourcing project origin. Ignored for POST and PUT requests. Possible values: 0: OriginAriba, 1: OriginExternal, 2: OriginProcurement, 3: OriginGuidedBuying, 4: OriginSpendVisibility, 5: OriginProductSourcing, 6: OriginCategoryBuyer, 7: OriginS4HANA, 8: OriginCentralProcurement. | |
| Regions | String | False |
Specifies the geographic regions for the project or event. The values for this field can be used to pre-populate projects and events with team members, content, and approvers specific to the region. | |
| Departments | String | False |
The departments or internal business units in your organization involved in the event. | |
| Commodities | String | False |
Specifies the commodities for the project or event. Your company might refer to commodities as categories, UNSPSC codes, or by another term. An example of a commodity is office supplies. The values for this field can be used to pre-populate projects with team members, content, and approvers specific to the commodity. | |
| Permissions | String | False |
Permissions. | |
| AllowedTasks | String | False |
Allowed tasks. | |
| ProjectReason | String | False |
Specifies the reason for the project execution. It is used for reporting purposes only. | |
| ExecutionStrategy | String | False |
Specifies the strategy planned to be used to execute the project. An offline project is executed outside of Ariba Sourcing. Supplier Performance refers to an SPM project. Low-cost country sourcing refers to acquiring materials from countries with lower labor and production costs. This field is populated from the project header. This field is used only for reporting. | |
| GettingStarted | String | False |
Getting started. | |
| PlannedEventType | String | False |
Specifies the type of event planned to be used in the project. Possible values: RFI, RFP, Auction, and Forward Auction. This field is used only for reporting. This field is present if the project state is Planned. | |
| IsProjectWatched | Bool | False |
Is project watched. | |
| IsSourcingRequest | Bool | False |
Is sourcing request. | |
| SourcingMechanism | String | False |
Specifies the system from which this project originated. Example: Ariba (indicates Ariba sourcing services), Internal (indicates SAP Ariba Sourcing resources that are internal to your company), Other (a sourcing resource that is neither internal to your company nor Ariba sourcing services). | |
| Currency | String | False |
Project currency. Required for PUT requests. Example, Try it out with: USD. | |
| ContractMonths | Double | False |
Contract months. | |
| MessageBoardId | String | False |
Specifies the internal ID of the NoteBox, which contains the threads and posts of a given workspace. | |
| IsTest | Bool | False |
Is test. | |
| LastModified | Datetime | False |
Last modified. | |
| CreateDate | Datetime | False |
Create date. | |
| BeginDate | Datetime | False |
Specifies the start date for the sourcing project. | |
| DueDate | Datetime | False |
Due date. | |
| EndDate | Datetime | False |
End date. | |
| PlannedStartDate | Datetime | False |
Specifies the planned start date and time for the sourcing project. | |
| PlannedEndDate | Datetime | False |
Specifies the planned end date and time for the sourcing project. | |
| ContractEffectiveDate | Datetime | False |
Contract effective date. | |
| TargetSavingPct | Double | False |
Specifies the percentage of target savings you want to obtain as a result of the project. | |
| ActualSavingPct | Double | False |
Specifies the percentage of savings you want to obtain as a result of the project. | |
| ActualSavingAmount | Decimal | False |
Actual saving amount. | |
| ActualSavingCurrency | String | False |
Actual saving currency. | |
| BaselineSpendAmount | Decimal | False |
Indicates the spend amount expected to be covered by this project. | |
| BaselineSpendCurrency | String | False |
Indicates the spend amount expected to be covered by this project. | |
| BusinessSystemBusinessSystemId | String | False |
Name of the external system (ERP) that the project is integrated with. | |
| BusinessSystemBusinessSystemName | String | False |
Name of the external system (ERP) that the project is integrated with. | |
| BusinessSystemBusinessSystemType | String | False |
Name of the external system (ERP) that the project is integrated with. | |
| BusinessSystemCompanyCode | String | False |
Name of the external system (ERP) that the project is integrated with. Specifies the custom data type that contains keys and values to represent different objects. | |
| BusinessSystemDocumentCategory | String | False |
Name of the external system (ERP) that the project is integrated with. Specifies the custom data type that contains keys and values to represent different objects. | |
| BusinessSystemDocumentType | String | False |
Name of the external system (ERP) that the project is integrated with. Specifies the custom data type that contains keys and values to represent different objects. | |
| BusinessSystemPurchasingGroup | String | False |
Name of the external system (ERP) that the project is integrated with. Specifies the custom data type that contains keys and values to represent different objects. | |
| BusinessSystemPurchasingOrganization | String | False |
Name of the external system (ERP) that the project is integrated with. Specifies the custom data type that contains keys and values to represent different objects. | |
| BusinessSystemPaymentTerms | String | False |
Name of the external system (ERP) that the project is integrated with. Specifies the custom data type that contains keys and values to represent different objects. | |
| OwnerOrganization | String | False |
Owner organization. | |
| OwnerOrgANId | String | False |
Specifies the Ariba Network ID for a user's organization. | |
| OwnerOrgName | String | False |
Specifies the organization name of the user. | |
| OwnerTimeZoneID | String | False |
Specifies the user's time zone. | |
| OwnerEmailAddress | String | False |
Specifies the email address for the user. | |
| OwnerName | String | False |
Specifies the user's full name (for GET responses). | |
| OwnerUniqueName | String | False |
Specifies the unique name for the user; used as a login ID. | |
| OwnerPasswordAdapter | String | False |
Specifies the password adapter to authenticate the user. Example: PasswordAdapter1 or SourcingSupplierUser. | |
| OwnerIsRecommended | Bool | False |
Owner is recommended. | |
| FlattenedOwnerUsers | String | False |
Flattened owner users. |