sap-se16nlisted

Queries any SAP table via SE16N using SAP GUI Scripting and downloads the result set as a tab-delimited text file. Supports filtering by any combination of table fields with single value, multi-value (IN list), or range (BT) selection, and any of the standard SE16N operators (EQ, NE, GT, LT, GE, LE, BT, NB, CP, NP, IN). Optionally restricts the output columns to a specific set of fields; if no SELECT list is given, all fields are returned. Detects the "no values found" path and writes a marker file instead of an empty download. Typical use: dump rows from any SAP table for inspection or as reference data for development. Snapshot modes add a table-state assertion primitive: `snapshot save <name>` captures a query result under {artifact_dir}\snapshots; `snapshot diff <a> <b>` row-diffs two snapshots on declared key columns (ignoring volatile columns) via the shared keyed-diff engine — ADDED/REMOVED/CHANGED/SAME; `snapshot list` enumerates them. Prerequisites: Active SAP GUI session (use /sap-login first). `sna
sapdev-ai/sap-dev · ★ 7 · Testing & QA · score 73

Install: claude install-skill sapdev-ai/sap-dev

# SAP SE16N Table Query Skill You query a SAP table via transaction SE16N and download the result set as a tab-delimited text file. Filters and the optional output-field list are passed to the underlying VBScript via a side-channel parameters file so that an arbitrary number of filter fields and values can be specified. Task: $ARGUMENTS **Mode dispatch.** If the first token is `snapshot`, go to **Snapshot Modes** (below): `save` runs the normal query flow (Steps 0–6) then captures the result; `diff` / `list` are pure-local and skip the SAP query. If the first token is `agg`, go to **Aggregation Mode (SE16H)** — server-side GROUP BY + MIN/MAX/AVG + per-group count, a separate SAP flow (transaction SE16H) that does NOT run Steps 3–6. Any other first token is the **normal query flow** (Steps 0–6, default — unchanged). --- ## Shared Resources | File | Purpose | |---|---| | `<SAP_DEV_CORE_SHARED_DIR>/rules/skill_operating_rules.md` | Mandatory operating rules | | `<SAP_DEV_CORE_SHARED_DIR>/rules/language_independence_rules.md` | GUI-scripting language independence — identify by component ID + DDIC field name, status-bar checks via `MessageType` codes (S/W/E/I/A), VKey instead of menu-text, no branching on `.Text`/`.Tooltip`/window titles | | `<SKILL_DIR>/references/sap_se16n_snapshot.ps1` | Snapshot `save`/`diff`/`list` (pure-local); the diff delegates to the shared keyed-diff engine. | | `<SKILL_DIR>/references/sap_se16h_agg.vbs` | `agg` mode — drives SE16H (program `SAPLSE