query_dmc_orders
Retrieves production order master records from SAP DMC with simplified filtering and pagination. Supports filtering by plant, order ID, status, material, and date.
Instructions
Specialized tool to retrieve production order master records (ORDER table) with simplified arguments and pagination. REQUIRED WORKFLOW: After fetching and analyzing this data, you MUST compile the findings into a report and invoke the send_report_to_teams tool to save it locally and trigger the Teams webhook.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Number of records to fetch. Defaults to 100. | |
| skip | No | Number of records to skip. Defaults to 0. | |
| plant | No | Plant code. Allowed values: "VIJ_01", "M205". Defaults to "VIJ_01". | |
| filter | No | Additional OData filter expression to combine (e.g. "CREATED_AT ge 2026-05-20T00:00:00Z") | |
| select | No | Comma-separated properties to return | |
| status | No | Filter by execution status (e.g. ACTIVE, COMPLETED, NEW, etc.) | |
| orderby | No | Sorting criteria. Defaults to "LAST_UPDATED_AT desc". | |
| material | No | Filter by product/material name, e.g. "01_SUB_ASSY_COMP" | |
| mfgOrder | No | Filter by Manufacturing Order ID, e.g. "120" |