Description | Query Production Orders |
Name | QueryProductionOrderIn |
Namespace | http://sap.com/xi/A1S/Global |
Process Component Description | Production |
Process Component Name | Production |
Process Component Namespace | http://sap.com/xi/AP/LogisticsExecution/Global |
Deployment Unit Description | Production and Site Logistics Execution |
Endpoint Activation | By Scoping of Process Component | Operations |
Release Status | Released |
An interface to query production order data.
The web service interface Query Production Order In enables external applications to connect to the SAP Business ByDesign system and to query production orders. This is used when external systems want to access and manage production order data in the system.
It has the FindByElements operation that is used to query for one or more instances of the production order, based on the query filter parameters passed.
You can find general information about Web services, their structure and consumption in the Web Services documentation.
Here is an example of a simple web service request:
<n0:ProductionOrderByOverviewQuery_sync xmlns:n0="http://sap.com/xi/SAPGlobal20/Global"> <ProcessingConditions> <QueryHitsMaximumNumberValue>10</QueryHitsMaximumNumberValue> <QueryHitsUnlimitedIndicator></QueryHitsUnlimitedIndicator> </ProcessingConditions> <ProductionOrderSelectionByElements> <SelectionByProductionOrderID> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryID schemeID="Token 10" schemeAgencyID="Token 11" schemeAgencySchemeAgencyID="Tok">61</LowerBoundaryID> </SelectionByProductionOrderID> </ProductionOrderSelectionByElements> </n0:ProductionOrderByOverviewQuery_sync>
Scenarios
Here is an example of a web service request that requests for a production order based on request ID:
<n0:ProductionOrderByOverviewQuery_sync xmlns:n0="http://sap.com/xi/SAPGlobal20/Global"> <ProcessingConditions> <QueryHitsMaximumNumberValue>10</QueryHitsMaximumNumberValue> <QueryHitsUnlimitedIndicator></QueryHitsUnlimitedIndicator> </ProcessingConditions> <ProductionOrderSelectionByElements> <SelectionByProductionRequestID> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryID schemeID="Token 30" schemeAgencyID="Token 31" schemeAgencySchemeAgencyID="Tok">1</LowerBoundaryID> </SelectionByProductionRequestID> </ProductionOrderSelectionByElements> </n0:ProductionOrderByOverviewQuery_sync>
Here is an example of a web service request for a production order based on 2 different order IDs:
<n0:ProductionOrderByOverviewQuery_sync xmlns:n0="http://sap.com/xi/SAPGlobal20/Global"> <ProcessingConditions> <QueryHitsMaximumNumberValue>10</QueryHitsMaximumNumberValue> <QueryHitsUnlimitedIndicator></QueryHitsUnlimitedIndicator> </ProcessingConditions> <ProductionOrderSelectionByElements> <SelectionByProductionRequestID> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryID schemeID="Token 30" schemeAgencyID="Token 31" schemeAgencySchemeAgencyID="Tok">1</LowerBoundaryID> <LowerBoundaryID schemeID="Token 30" schemeAgencyID="Token 31" schemeAgencySchemeAgencyID="Tok">61</LowerBoundaryID> </SelectionByProductionRequestID> </ProductionOrderSelectionByElements> </n0:ProductionOrderByOverviewQuery_sync>
Here is an example of a web service request for a production order based on Lower and Upper Range :
<n0:ProductionOrderByOverviewQuery_sync xmlns:n0="http://sap.com/xi/SAPGlobal20/Global"> <ProcessingConditions> <QueryHitsMaximumNumberValue>1000</QueryHitsMaximumNumberValue> <QueryHitsUnlimitedIndicator></QueryHitsUnlimitedIndicator> </ProcessingConditions> <ProductionOrderSelectionByElements> <SelectionByProductionOrderID> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>3</IntervalBoundaryTypeCode> <LowerBoundaryID schemeID="Token 10" schemeAgencyID="Token 11" schemeAgencySchemeAgencyID="Tok">1</LowerBoundaryID> <UpperBoundaryID schemeID="Token 14" schemeAgencyID="Token 15" schemeAgencySchemeAgencyID="Tok">150</UpperBoundaryID> </SelectionByProductionOrderID> </ProductionOrderSelectionByElements> </n0:ProductionOrderByOverviewQuery_sync>
Here is an example of a web service request that requests for production orders based on production order creation date time:
Note that the CreationDateTime must have the value in the format
YYYY-MM-DDTHH:MM:SS.1234567Z
<n0:ProductionOrderByOverviewQuery_sync xmlns:n0="http://sap.com/xi/SAPGlobal20/Global"> <ProcessingConditions> <QueryHitsMaximumNumberValue>500</QueryHitsMaximumNumberValue> <QueryHitsUnlimitedIndicator></QueryHitsUnlimitedIndicator> </ProcessingConditions> <ProductionOrderSelectionByElements> <SelectionByProductionOrderCreationDateTime> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>3</IntervalBoundaryTypeCode> <LowerBoundaryDate>2015-01-01T00:00:00.0000000Z</LowerBoundaryDate> <UpperBoundaryDate>2015-11-05T00:00:00.0000000Z</UpperBoundaryDate> </SelectionByProductionOrderCreationDateTime> </ProductionOrderSelectionByElements> </n0:ProductionOrderByOverviewQuery_sync>
Description | Find production orders |
Name | ProductionOrderQueryByOverview |
Synchronous | yes |
Release Status | Released |
To query Production Orders.
The QUERY_PRODUCTION_ORDER operation queries the data of one or more Production Orders.
The Production Order contains all general information as well as about Input/output products.
The following are the attributes and elements of the Production Order.
Elements | Description |
SelectionByProductionOrderID | Identifier for a Production Order |
SelectionByProductionRequestID | Identifier for a Production Request |
SelectionByProductionOrderStatus | Production Order Status |
SelectionByProductionOrderScheduleStatus | Production Order Schedule Status |
SelectionByProductionOrderResourceID | Identifier for a Resource ID |
SelectionByProductionOrderResourceDescription | Resource Description |
SelectionByProductionOrderRequestStartDateTime | Production Order Request Start Date Time |
SelectionByProductionOrderRequestEndDateTime | Production Order Request End Date Time |
SelectionByProductionOrderLatestStartDateTime | Production Order Latest Start Date Time |
SelectionByProductionOrderLatestEndDateTime | Production Order Latest End Date Time |
SelectionByProductionOrderCreationDateTime | Production Order Creation Date Time |
SelectionByProductionOrderLastChangeDateTime | Production Order Last Change Date Time |
SelectionByProductionOrderReleaseDueDate | Production Order Release Due Date |
SelectionByMaterialOutputProductID | Output Product |
SelectionByMaterialOutputProductDescription | Output Product Description |
SelectionByMaterialOutputProductSpecificationID | Output Product Specification ID |
SelectionByMaterialOutputProductSpecificationDesc | Output Product Specification Description |
SelectionByMaterialOutputProductGroup | Output Product Group |
SelectionByMaterialInputProductID | Input Product |
SelectionByMaterialInputProductDescription | Input Product Description |
SelectionByLogisticAreaID | Logistic Area ID |
SelectionByLogisticAreaDescription | Logistic Area Description |
SelectionByIdentifiedStockID | Identified Stock ID |
SelectionByIdentifiedStockDescription | Identified Stock Description |
SelectionBySiteID | Site ID |
Elements | Description |
ProductionOrderStatus | Production Order Status |
ProductionOrderPriority | Production Order Priority |
ProductionOrderID | Production Order ID |
ProductionOrderUUID | Production Order UUID |
ProductionOrderReleaseDate | Production Order Release Date |
ProductionOrderScheduleStatus | Production Order Schedule Status |
ProductionOrderStartDate | Production Order Start Date |
ProductionOrderRequestedStartDate | Production Order Requested Start Date |
ProductionOrderRequestedEndDate | Production Order Requested End Date |
ProductionOrderLotID | Production Order Lot ID |
ProductionOrderRequestID | Production Order Request ID |
SystemAdministrativeData | Administrative Data |
ProductionOrderSiteID | Production Order Site ID |
ProductionOrderSiteUUID | Production Order Site UUID |
MaterialOutputUUID | Material Output UUID |
ProductionOrderOutputProductID | Output Product ID |
ProductionOrderOutputProductDesc | Output Product Description |
ProductionOrderOpenQuantity | Open Quantity |
ProductionOrderFulfilledQuantity | Fullfilled Quantity |
ProductionOrderPlannedQuantity | Planned Quantity |
ProductionOrderProductionSpecificationID | Specification ID |
ProductionOrderProductSpecificationDescription | Specification Description |
This is a coded representation of Production Order status.
Execution Status Code Value Description
1 | In Preparation |
2 | Released |
3 | Started |
4 | Finished |
5 | Closed |
6 | Canceled |
Scheduling Status Code Value Description
1 | Not Scheduled |
2 | Basic Dates Scheduled |
3 | Scheduled |
Priority Status Code Value Description
2 | Urgent |
3 | Normal |
7 | Low |
Logistics Task Generation Strategy Code Description
1 | Activity |
2 | Operation |
3 | Activity including Reporting Points |
4 | Operation including Reporting Point |
5 | Reporting Point including Operations and Activities |
6 | Reporting Point and all Operations |
7 | Reporting Point and all Activities |
Identified Stock Type Code Description
1 | Batch |
2 | Lot |
3 | Optional Specified Stock |
4 | Mandatory Specified Stock |
This interface operation support extensibility.
Here is an example of a web service request to query an existing production order:
<n0:ProductionOrderByOverviewQuery_sync xmlns:n0="http://sap.com/xi/SAPGlobal20/Global"> <ProcessingConditions> <QueryHitsMaximumNumberValue>10</QueryHitsMaximumNumberValue> <QueryHitsUnlimitedIndicator></QueryHitsUnlimitedIndicator> </ProcessingConditions> <ProductionOrderSelectionByElements> <SelectionByProductionOrderID> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryID schemeID="Token 10" schemeAgencyID="Token 11" schemeAgencySchemeAgencyID="Tok">61</LowerBoundaryID> </SelectionByProductionOrderID> </ProductionOrderSelectionByElements> </n0:ProductionOrderByOverviewQuery_sync>