query_dmc_materials
Query material master definitions for products, assemblies, and components in SAP DMC to support manufacturing analysis and report generation.
Instructions
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.
Input 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. | |
| type | No | Filter by material type, e.g. "MANUFACTURED", "PURCHASED" | |
| plant | No | Plant code. Allowed values: "VIJ_01", "M205". Defaults to "VIJ_01". | |
| filter | No | Additional OData filter expression to combine | |
| select | No | Comma-separated properties to return | |
| status | No | Filter by status (e.g. CURRENT, DELETED) | |
| orderby | No | Sorting criteria. Defaults to "LAST_UPDATED_AT desc". | |
| material | No | Filter by material name/number, e.g. "01_SUB_ASSY_COMP" |