# SAP Scheduling Agreement Delivery Schedule Worksheet > Source: https://netray.co/tools/sap-scheduling-agreement-delivery-schedule-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Lay out schedule lines for a scheduling agreement, track cumulative quantity against the target and see open balance. ## Category sap ## Erp SAP S/4HANA ## Audience - Buyer - Production planner - SAP MM consultant ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Delivery date **Key:** week **Type:** date #### Material **Key:** material **Type:** text #### Scheduled qty **Key:** sched_qty **Type:** number #### Received qty **Key:** gr_qty **Type:** number #### Open qty **Key:** open_qty **Type:** number **Expr:** sched_qty - gr_qty **Format:** number #### Unit price **Key:** unit_price **Type:** number **Format:** currency #### Open value **Key:** open_val **Type:** number **Expr:** (sched_qty - gr_qty) * unit_price **Format:** currency #### Status **Key:** status **Type:** select **Options:** - Firm - Trade-off zone - Forecast - Delivered - Late **Rows:** **Week:** 2026-11-02 **Material:** MAT-50021 Gear housing **Sched qty:** 400 **Gr qty:** 400 **Unit price:** 18.2 **Status:** Delivered **Week:** 2026-11-09 **Material:** MAT-50021 Gear housing **Sched qty:** 400 **Gr qty:** 250 **Unit price:** 18.2 **Status:** Late **Week:** 2026-11-16 **Material:** MAT-50021 Gear housing **Sched qty:** 500 **Gr qty:** 0 **Unit price:** 18.2 **Status:** Firm **Week:** 2026-11-23 **Material:** MAT-50021 Gear housing **Sched qty:** 500 **Gr qty:** 0 **Unit price:** 18.2 **Status:** Trade-off zone **Week:** 2026-11-30 **Material:** MAT-50021 Gear housing **Sched qty:** 600 **Gr qty:** 0 **Unit price:** 18.2 **Status:** Forecast **Totals:** #### Total scheduled **Key:** sched_qty **Agg:** sum **Format:** number #### Total received **Key:** gr_qty **Agg:** sum **Format:** number #### Total open **Key:** open_qty **Agg:** sum **Format:** number #### Open value **Key:** open_val **Agg:** sum **Format:** currency **Summary:** #### Receipt rate on scheduled quantity **Key:** fill **Expr:** if(gt(sum_sched_qty,0), sum_gr_qty / sum_sched_qty * 100, 0) **Format:** percent **Currency:** $ **Notes:** In SAP a scheduling agreement holds schedule lines with delivery dates and quantities, and releases are transmitted to the vendor. The firm and trade-off zones come from the release creation profile. Confirm your own zone settings before relying on the status labels. ## Content **Intro:** A scheduling agreement is a long-term outline agreement in SAP where the buyer sends a rolling delivery schedule to the vendor. This worksheet helps you draft, check and track the schedule lines and cumulative quantities before you maintain them in SAP. **Sections:** #### How to use the worksheet **Body:** Enter one row per schedule line with the delivery date, material and scheduled quantity. As receipts arrive, enter the received quantity so the sheet shows open quantity and open value. Use the status column to mark each line as firm, in the trade-off zone, forecast, delivered or late. The summary gives the receipt rate against the schedule, which you can discuss with the vendor in a weekly call. Export to Excel to share with the vendor or to feed an upload. #### How scheduling agreements work in SAP **Body:** You create a scheduling agreement with ME31L and maintain its schedule lines in ME38. MRP can generate the schedule lines automatically when the source list and the MRP indicator are set. Releases are created with ME84 and sent to the vendor with the release documentation, using forecast delivery schedules or just-in-time schedules. Cumulative received quantity is tracked by the system, which supports reconciliation when the vendor and buyer compare totals. #### Firm and trade-off zones **Body:** Release creation profiles can define a firm zone, where quantities are committed and the vendor should produce, and a trade-off zone, where quantities may change within agreed limits. Beyond that, schedule lines are forecasts for capacity planning only. Writing the zone beside each line avoids arguments about what was binding. Whatever you show to the vendor should match what the system transmits, so check the release documentation. #### Common mistakes **Body:** Teams change schedule lines in a spreadsheet and forget to update SAP, so MRP and the vendor work from different numbers. Another mistake is ignoring late lines, which keep inflating open quantity and distort the next release. Sending forecast lines as if they were firm commits the vendor to materials you may not need. Finally, check that the cumulative quantity at the vendor matches yours at the start of each month. **Cta:** Netray can build a read-only view of late schedule lines and open commitments across your SAP scheduling agreements. **Faq:** #### What is the difference between a scheduling agreement and a contract? **Answer:** A scheduling agreement carries delivery dates and quantities as schedule lines and drives releases to the vendor. A quantity or value contract sets overall terms and is called off by individual purchase orders. #### Which SAP transactions maintain scheduling agreements? **Answer:** ME31L creates a scheduling agreement, ME32L changes it, ME33L displays it and ME38 maintains schedule lines. ME84 generates releases and ME2L lists agreements by vendor. #### Can MRP create schedule lines? **Answer:** Yes. If the source list and the scheduling agreement are set up for MRP, planning generates or updates schedule lines automatically, subject to the MRP indicator in the source list. #### How do I handle late deliveries? **Answer:** Keep the original schedule line, record the received quantity and discuss a catch-up plan with the vendor. Reschedule only through a documented change, and check how late lines affect the next release. ## Search terms sap scheduling agreement template, sap me31l schedule lines, delivery schedule excel, scheduling agreement release worksheet, sap me38 delivery schedule, cumulative quantity schedule agreement, supplier delivery schedule format --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json