Get production orders from SAP DMC. Supports filtering, sorting by date, and limiting results (e.g., to find the most recent orders or a specific time range).

Get full details of a specific production order by order number.

Get manufacturing resources / equipment in a plant.

Get status and details of a specific resource.

Get inventory details from legacy SAP ERP via OData v2. Queries with standard OData filtering.

Retrieve records for a Managed Data Object (MDO) in SAP DMC via OData v4 with optional OData query parameters.

Get the exact case-sensitive column/field names for any of the 53 OData v4 extractor entities (e.g. ORDER, LABOR_SCHEDULE, SFC, PLANT) so you can construct valid query filters.

Query any extractor entity in SAP DMC via OData v4 Extractor. Returns paginated results (defaults to 100 records). 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.

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.

Specialized tool to query labor schedules (LABOR_SCHEDULE table) for workforce planning, shifts, and supervisor tracking. 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.

Specialized tool to query Shop Floor Control records (SFC table) representing individual production lots/units. 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.

Specialized tool to query manufacturing workcenters (WORKCENTER table) representing groups of resources/machines. 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.

Specialized tool to query individual production resources/equipment (RESOURCE table). 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.

Specialized tool to query material master definitions (MATERIAL table) for products, assemblies, and components. 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.

Specialized tool to query Bill of Materials components (BOM_COMPONENT table) linking parents to assembly materials. 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.

Specialized tool to query equipment/resource downtime events (DOWNTIME table) for OEE and utilization tracking. REQUIRED WORKFLOW: After fetching all records (paginating if needed) and analyzing/forecasting, 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.

Specialized tool to query production schedules and operational execution logs (ORDER_SCHEDULE table). 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.

Specialized tool to query individual step executions and yield/scrap logs for SFCs (SFC_PRODUCTION_EVENTS table). 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.

Generate local Markdown and HTML reports in the reports/ directory and send them directly to Teams via a Power Automate webhook.