Explain your experience with SAP or similar MRP (Material Requirements Planning) systems in a logistics context.
For the SQL portion, use the provided SAP-style inventory and MRP requirement tables. Return materials with open requirements due by February 15, 2025, where required quantity exceeds available inventory.
material_code, material_description, warehouse_code, available_qty, open_due_qty, shortage_qtyshortage_qty descending, then material_code ascending| Column | Type | Description |
|---|---|---|
| inventory_idPK | INT | Inventory record identifier |
| material_code | VARCHAR(20) | SAP material number |
| material_description | VARCHAR(100) | Material description |
| warehouse_code | VARCHAR(10) | Warehouse or logistics location |
| available_qty | INT | Quantity available for allocation |
| Column | Type | Description |
|---|---|---|
| requirement_idPK | INT | MRP requirement identifier |
| material_code | VARCHAR(20) | Required SAP material number |
| warehouse_code | VARCHAR(10) | Requirement warehouse |
| required_qty | INT | Required material quantity |
| due_date | DATE | Date the requirement is due |
| requirement_status | VARCHAR(20) | MRP requirement status |