| Field | Description | Type | Key |
|---|---|---|---|
| MANDT | Client | CLNT (3) | Key |
| MATNR | Material Number | CHAR (18) | Key |
| WERKS | Plant | CHAR (4) | Key |
| DISMM | MRP Type | CHAR (2) | |
| DISPO | MRP Controller | CHAR (3) | |
| PLIFZ | Planned Delivery Time in Days | DEC (3) |
-- Material master joined to plant-level planning data
SELECT
mara.MATNR AS material,
marc.WERKS AS plant,
marc.DISMM AS mrp_type,
marc.DISPO AS mrp_controller,
marc.PLIFZ AS planned_delivery_days
FROM <catalog>.<schema>.MARA AS mara
JOIN <catalog>.<schema>.MARC AS marc
ON marc.MATNR = mara.MATNR
WHERE marc.WERKS = '<WERKS>'