# SAP System Landscape Inventory Worksheet > Source: https://netray.co/tools/sap-system-landscape-inventory-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable inventory of your SAP systems and clients: SID, tier, release, database, owner and patch dates. Exports to Excel. ## Category sap ## Erp SAP ECC / S/4HANA ## Audience - SAP Basis admin - IT architect - GRC analyst ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### SID **Key:** sid **Type:** text #### Description **Key:** desc **Type:** text #### Tier **Key:** tier **Type:** select **Options:** - Sandbox - Development - Quality - Pre-production - Production - Training #### Product **Key:** product **Type:** select **Options:** - S/4HANA - ECC 6.0 - BW/4HANA - Solution Manager - Gateway - Fiori front end - GRC - Other #### Release or stack **Key:** release **Type:** text #### Database **Key:** db **Type:** select **Options:** - SAP HANA - Oracle - SQL Server - DB2 - MaxDB - ASE #### Host or cloud instance **Key:** host **Type:** text #### Named users **Key:** users **Type:** number #### System owner **Key:** owner **Type:** text #### Last kernel or SPS update **Key:** patched **Type:** date #### Backup tested **Key:** backup **Type:** select **Options:** - Yes - No - Unknown **Rows:** #### S/4HANA **Sid:** DEV **Desc:** S/4 development **Tier:** Development **Release:** 2023 FPS01 **Db:** SAP HANA **Host:** sapdev01 **Users:** 45 **Owner:** R. Kumar **Patched:** 2026-07-14 **Backup:** Yes #### S/4HANA **Sid:** QAS **Desc:** S/4 quality **Tier:** Quality **Release:** 2023 FPS01 **Db:** SAP HANA **Host:** sapqas01 **Users:** 80 **Owner:** R. Kumar **Patched:** 2026-07-21 **Backup:** Yes #### S/4HANA **Sid:** PRD **Desc:** S/4 production **Tier:** Production **Release:** 2023 FPS01 **Db:** SAP HANA **Host:** sapprd01 **Users:** 620 **Owner:** S. Meyer **Patched:** 2026-08-04 **Backup:** Yes #### Solution Manager **Sid:** SMP **Desc:** Solution Manager **Tier:** Production **Release:** 7.2 SP20 **Db:** SAP HANA **Host:** sapsol01 **Users:** 25 **Owner:** N. Okafor **Patched:** 2026-05-12 **Backup:** Unknown #### GRC **Sid:** GRP **Desc:** GRC Access Control **Tier:** Production **Release:** 12.0 **Db:** SAP HANA **Host:** sapgrc01 **Users:** 30 **Owner:** S. Meyer **Patched:** 2026-03-30 **Backup:** No **Totals:** #### Total named users **Key:** users **Agg:** sum **Format:** integer #### Systems listed **Key:** sid **Agg:** count **Format:** integer **Summary:** #### Average named users per system **Key:** avg_users **Expr:** sum_users / count **Format:** integer **Notes:** Add one row per system and client you want tracked. Use the release field for your own convention, for example product version plus feature pack or support package level. Check values against your system status screen (System, Status). ## Content **Intro:** Many SAP teams cannot answer the simple question of which systems they run, who owns them and when they were last patched. This worksheet is the single list to start from. **Sections:** #### How to use the worksheet **Body:** Add one row per SAP system. The SID, product, release and database can be read from the System Status screen of each system. Host, owner and backup status come from your infrastructure and operations records. Export to Excel and keep the file under change control, or paste it into your CMDB. Review it quarterly, and after every system copy, upgrade or decommission. **Bullets:** - Include satellite systems such as Gateway, GRC and Solution Manager - List non-production systems, since they often hold copied production data - Record an owner by name, not only by team - Mark whether the last backup restore was actually tested #### Why an inventory matters **Body:** Patching, access reviews, licence audits and incident response all start with a list of systems. Without it, a sandbox that was copied from production two years ago remains unpatched and holds real customer data. Security notes, kernel updates and support packages must be tracked per system. The inventory is also the base for scoping an access review or a migration. #### Reading the summary **Body:** Named users per system show where access reviews cost the most effort and where licence exposure sits. A production system with a small user count and no tested backup is a bigger risk than a large development system. Sort the exported sheet by last update date to find the systems furthest behind. #### Common mistakes **Body:** Common gaps are leaving out client-level details when clients have different purposes, missing technical systems such as the web dispatcher, and not recording the owner. Another is letting the sheet go stale after a project ends. **Cta:** If you need your ERP landscape documented and queryable in one place, Netray can connect read-only to your systems and help keep the inventory current. **Faq:** #### Do I need one row per client? **Answer:** If clients serve different purposes or hold different data, yes. Add the client number to the description. For systems with a single active client one row is enough. #### Where do I find the release information? **Answer:** In the SAP GUI under System, Status, which shows product version, kernel and database. Solution Manager can also report this centrally if it is set up. #### How often should the inventory be reviewed? **Answer:** Quarterly is a reasonable rhythm, plus after any upgrade, copy or retirement. Treat it as a controlled document if auditors request it. #### Can I use it for cloud-hosted SAP? **Answer:** Yes. Put the cloud instance name or hosting provider reference in the host column and add your hosting contact as the owner of the infrastructure side. ## Search terms sap system landscape inventory, sap landscape documentation excel, sap sid list template, sap system inventory template, sap landscape diagram worksheet, sap basis system list, sap client inventory excel --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json