SD

    SAP Data Extraction & Cleanup

    1

    Cleans raw SAP S/4HANA and ECC exports into analysis-ready Excel tables, with movement type, document type, posting key, and field-name references.

    Free

    1 useSecurity scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more
    SD

    SAP Data Extraction & Cleanup

    Example session with this skill installed

    Here's an MB51 export for January. Clean it up into a pivot-ready table and flag the reversals.

    • Read your context and instructions
    • Compiled the sap data extraction

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Use this skill to clean, transform, and prepare raw SAP exports (S/4HANA or ECC) for analysis in Excel. SAP exports are notoriously messy; this skill makes sure the data is properly structured and tied out before any analysis begins.

    SAP is heavily configured, so the references below are standard defaults, not guarantees. Before relying on them:

    • Configuration: Document types, posting keys, movement types, account lengths, and fiscal year variants can be customized. If a code in the user's data doesn't match the reference below, ask or check the user's configuration rather than assuming.
    • Release and interface: S/4HANA users may export from Fiori apps instead of classic transactions, and field labels differ between the two. Recognize either.
    • User settings: Decimal notation and date format come from each user's SAP profile (SU3 → Defaults), so two people exporting the same report can get different formats. Detect the format from the data itself.
    • House conventions: If the user has a standard cleanup layout, field-name mapping, or table naming convention, follow it.
    • Other ERPs: The cleanup workflow (Steps 1–6) applies to messy exports from any ERP. Only the SAP code references are SAP-specific.

    Not every even number is a reversal (122 is reversed by 123; 702 is a loss, not a reversal of 701). To identify reversals reliably, use a lookup table of the user's reversal movement types, or the reversal/reference document fields in the export (in MSEG/MATDOC, the reversed material document is shown in the reference fields). Reversal pairs that net to zero inflate transaction counts if not filtered.

    SAP code references reflect standard settings; document types, posting keys, and movement types can be customized, so the skill checks against the user's configuration when codes don't match. Works on exported data in Excel; it does not connect to SAP directly.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    1 use

    Times used to date

    Free forever

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 14 days ago

    • Free with an Agensi account

    Permissions

    No special permissions declared or detected

    Listed14 days ago

    What's inside

    Frequently Asked Questions

    Cleans raw SAP S/4HANA and ECC exports into analysis-ready Excel tables, with movement type, document type, posting key, and field-name references.

    This skill uses the open SKILL.md standard. Use it through an MCP-compatible agent connected to Agensi, and check the compatibility information on this page for confirmed agents and required capabilities.

    Connect your AI agent to Agensi through MCP, then ask it to use SAP Data Extraction & Cleanup on your task. Your agent loads the latest approved version each time. Paid skills require a purchase or active subscription. Skill files are not available for download; your licence does not allow you to save, copy or export any part of a skill.