Skip to Content
Business Trends

Query Projects in SAP Business ByDesign using SOAP UI

This web service is used to query projects. It has the FindProjectByElements operation which is used to query for one or more instances of the project based on the query filter parameters passed.

Description Query Projects
Name QueryProjectIn
Process Component Name ProjectProcessing
Operation Find Projects

FindProjectByElements is an operation to query the project data by the selection elements passed in the request.

You can query based on the below elements;

SelectionByElements UI Element
SelectionByResponsibleUnitID Responsible Unit ID
SelectionByProjectID Project ID
SelectionByProjectName Project Name
SelectionByProjectType Project Type
SelectionByCustomerID Customer ID
SelectionByRequestingUnitID Requesting Unit ID
SelectionByBillableIndicator Billable Indicator
SelectionByIntercompanyIndicator Intercompany Indicator
SelectionByResponsibleEmployeeID Person Responsible ID

Note:

Billable indicator takes the values ‘True’ or ‘False’. To query for projects that are billable, set the value for field IntervalBoundaryTypeCode under the tag SelectionByBillableIndicator to ‘True’.

 

Mandatory Fields:

  • In the ProcessingConditions tag, the QueryHitsUnlimitedIndicator field is mandatory, which takes the values ‘True’ or ‘False’.
  • IntervalBoundaryTypeCode field is a mandatory field in each of the selection tags. This field takes the values as given in the generic document

Constraint:

  • If a large volume of data is to be retrieved, the consumer must implement the retrieval logic in batches. The data can be limited by using QueryHitsMaximumNumberValue field in the ProcessingConditions tag.
  • For the selection fields, in each SelectionField tag, the field InclusionExclusionCode takes the values ‘E’ Or ‘I’.
    • E- Excluding
    • I- Including

Project Types:

The project types provided by SAP are:

Project Type Code Value
10 Cost collecting project
20 Direct cost project
21 Marketing project
22 Strategic sourcing project
23 Research and development project
24 Customer project w/o sales integration
25 Customer project with sales integration
26 Multi-customer project
27 Intercompany Project

Examples:

Example for using various query paramaters

Query projects based on Project ID:

<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:glob=”http://sap.com/xi/SAPGlobal20/Global”>
<soapenv:Header/>
<soapenv:Body>
<glob:ProjectByElementsQuery>
<ProcessingConditions>
<QueryHitsMaximumNumberValue>20</QueryHitsMaximumNumberValue>
<QueryHitsUnlimitedIndicator>false</QueryHitsUnlimitedIndicator>
</ProcessingConditions>
<ProjectSelectionByElements>
<SelectionByProjectID>
<InclusionExclusionCode>I</InclusionExclusionCode>
<IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode>
<LowerBoundaryProjectID>COC1</LowerBoundaryProjectID>
</SelectionByProjectID>
</ProjectSelectionByElements>
</glob:ProjectByElementsQuery>
</soapenv:Body>
</soapenv:Envelope>`

 

Query projects based on Responsible Unit ID:

<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:glob=”http://sap.com/xi/SAPGlobal20/Global”>
<soapenv:Header/>
<soapenv:Body>
<glob:ProjectByElementsQuery>
<ProcessingConditions>
<QueryHitsMaximumNumberValue>20</QueryHitsMaximumNumberValue>
<QueryHitsUnlimitedIndicator>false</QueryHitsUnlimitedIndicator>
</ProcessingConditions>
<ProjectSelectionByElements>
<SelectionByResponsibleUnitID>
<InclusionExclusionCode>I</InclusionExclusionCode>
<IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode>
<LowerBoundaryRespUnitID>A1110</LowerBoundaryRespUnitID>
</SelectionByResponsibleUnitID>
</ProjectSelectionByElements>
</glob:ProjectByElementsQuery>
</soapenv:Body>
</soapenv:Envelope>`

Be the first to leave a comment
You must be Logged on to comment or reply to a post.