# SAP Interface Volume and Storage Sizing Worksheet > Source: https://netray.co/tools/sap-interface-volume-sizing-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable worksheet that turns messages per day, average size and retention into daily megabytes, peak hourly load and total storage. ## Category sap ## Erp SAP S/4HANA ## Audience - SAP Basis administrator - SAP integration architect - Capacity planner ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Interface **Key:** interface **Type:** text #### Message type **Key:** type **Type:** text #### Messages per day **Key:** msgs **Type:** number #### Average size **Key:** kb **Type:** number **Unit:** KB #### Peak factor **Key:** peak **Type:** number **Help:** Peak hour load as a multiple of the average hour #### Retention **Key:** keep **Type:** number **Unit:** days #### MB per day **Key:** mb_day **Type:** number **Expr:** msgs * kb / 1024 **Format:** decimal #### Peak msgs per hour **Key:** peak_hr **Type:** number **Expr:** msgs / 24 * peak **Format:** integer #### Retained MB **Key:** store_mb **Type:** number **Expr:** msgs * kb / 1024 * keep **Format:** number **Rows:** **Interface:** Customer orders **Type:** ORDERS **Msgs:** 4200 **Kb:** 6 **Peak:** 3 **Keep:** 90 **Interface:** Ship notices **Type:** DESADV **Msgs:** 1800 **Kb:** 4 **Peak:** 4 **Keep:** 90 **Interface:** Invoices out **Type:** INVOIC **Msgs:** 2500 **Kb:** 5 **Peak:** 2.5 **Keep:** 180 **Interface:** Material master sync **Type:** MATMAS **Msgs:** 600 **Kb:** 18 **Peak:** 6 **Keep:** 30 **Interface:** Production confirmations **Type:** Custom **Msgs:** 9000 **Kb:** 2 **Peak:** 3.5 **Keep:** 60 **Totals:** #### Total messages per day **Key:** msgs **Agg:** sum **Format:** integer #### Total MB per day **Key:** mb_day **Agg:** sum **Format:** decimal #### Total retained MB **Key:** store_mb **Agg:** sum **Format:** number **Summary:** #### Total retained GB **Key:** gb **Expr:** sum_store_mb / 1024 **Format:** decimal **Primary:** true #### Average message size KB **Key:** avg_kb **Expr:** sum_mb_day * 1024 / sum_msgs **Format:** decimal **Notes:** These are payload estimates. Database storage for IDocs is larger because each segment is stored with control and status data, so multiply by a factor measured in your own system. Check real table growth for EDIDC, EDID4 and EDIDS before committing to a number. ## Content **Intro:** Interface volume drives work process load, middleware licensing and database growth. This worksheet turns the few numbers you already know into daily volume, peak rate and retained storage per interface. **Sections:** #### How to use the worksheet **Body:** Enter one row per interface. Messages per day and average size can be taken from existing statistics: count IDocs per message type per day from EDIDC and take sizes from your middleware message monitor. For new interfaces, ask the business for order, shipment or invoice counts and use a similar existing message as a size proxy. The peak factor captures bursts, such as an EDI batch arriving at 06:00. Retention is how long you keep messages online before archiving. The sheet then computes daily megabytes, peak messages per hour and total retained megabytes. **Bullets:** - Use actual averages over a busy month, not a quiet one - Set the peak factor from hourly counts if you have them - Include test and retry traffic for noisy interfaces #### The arithmetic behind each column **Body:** Megabytes per day is messages times average kilobytes divided by 1024. Peak messages per hour is messages per day divided by 24, multiplied by the peak factor. Retained megabytes is daily megabytes times retention days. The summary converts retained megabytes to gigabytes and back calculates the weighted average message size. These are simple payload figures. IDoc storage in the database carries additional overhead per segment and status record, so treat the output as a lower bound and calibrate with your own table growth. #### Reading the results **Body:** Look first at the peak column. A workload that averages 400 messages per hour but peaks at 2,000 needs enough dialog or background work processes to absorb the burst, or a queue that drains in a reasonable time. Then look at retained storage: long retention on a high volume, low value interface is the usual place to save space by shortening retention or archiving earlier. Compare totals with the capacity of your middleware tenant or licence tier, since many have message count limits. **Bullets:** - Check peaks against available work processes - Shorten retention on high volume, low value messages - Revisit sizing before large customer onboarding **Cta:** Netray can extract real IDoc volumes by message type and hour from your system so the sizing uses measured peaks rather than estimates. **Faq:** #### How big is a typical IDoc? **Answer:** It varies widely. A small status message can be a few hundred bytes, an ORDERS IDoc with many line items can reach tens of kilobytes and a large MATMAS with many views can be larger still. Measure your own traffic rather than relying on a general figure. #### Which tables grow because of IDocs? **Answer:** EDIDC holds control records, EDID4 holds data records and EDIDS holds status records. EDID4 is usually the largest. Archiving with object IDOC and deleting old records keeps them in check. #### What is a good peak factor? **Answer:** There is no universal value. Divide the busiest hour count by the average hourly count from a real month. Interfaces fed by batch EDI or file drops often have much higher factors than interactive ones. #### Does this cover CPI or PO message limits? **Answer:** It gives you daily message counts, which you can compare with your middleware licence or tenant limits. Check your contract and monitor for the exact metering rules. ## Search terms sap idoc volume sizing, idoc storage estimate, sap interface capacity planning, idoc archiving sizing, sap message volume worksheet, cpi message volume estimate, sap integration sizing excel --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json