efeumutaslan/SAP-SKILLS / skills/sap-signavio
sap-signavio
VerifiedSAP Signavio process management and mining skill. Use when modeling BPMN 2.0 processes, running process mining (Process Intelligence), configuring process KPIs, or integrating Signavio with S/4HANA and SBPA. If the user mentions Signavio, process mining, BPMN modeling, conformance checking, or process transformation, use this skill.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 9.8 KB |
| templates/event-log-extraction.sql | other | 3.2 KB |
templates/event-log-extraction.sql
View on GitHub-- SAP Signavio Process Mining — Event Log Extraction Template
-- Replace: {{SOURCE_TABLE}}, {{CASE_ID}}, {{ACTIVITY}}, {{TIMESTAMP}}
-- Target format: Case ID | Activity | Timestamp | (optional dimensions)
-- ============================================================
-- Purchase-to-Pay (P2P) Event Log from S/4HANA
-- ============================================================
SELECT
ekko.ebeln AS case_id, -- PO Number
CASE
WHEN eban.banfn IS NOT NULL AND ekko.ebeln IS NULL
THEN 'Purchase Requisition Created'
WHEN ekko.aedat = ekko.bedat
THEN 'Purchase Order Created'
WHEN ekbe.belnr IS NOT NULL AND ekbe.bewtp = 'E'
THEN 'Goods Receipt Posted'
WHEN ekbe.belnr IS NOT NULL AND ekbe.bewtp = 'Q'
THEN 'Invoice Receipt Verified'
WHEN bseg.augbl IS NOT NULL
THEN 'Payment Executed'
END AS activity,
COALESCE(ekko.aedat, eban.badat) AS event_timestamp,
ekko.bukrs AS company_code,
ekko.ekorg AS purchasing_org,
ekko.lifnr AS vendor,
ekko.bsart AS document_type,
ekpo.netwr AS net_value,
ekpo.waers AS currency
FROM ekko
LEFT JOIN ekpo ON ekko.ebeln = ekpo.ebeln
LEFT JOIN eban ON ekpo.banfn = eban.banfn AND ekpo.bnfpo = eban.bnfpo
LEFT JOIN ekbe ON ekpo.ebeln = ekbe.ebeln AND ekpo.ebelp = ekbe.ebelp
LEFT JOIN bseg ON ekbe.belnr = bseg.belnr AND ekbe.gjahr = bseg.gjahr
WHERE ekko.aedat >= '{{START_DATE}}'
AND ekko.aedat <= '{{END_DATE}}'
ORDER BY case_id, event_timestamp;
-- ============================================================
-- Order-to-Cash (O2C) Event Log from S/4HANA
-- ============================================================
SELECT
vbak.vbeln AS case_id, -- Sales Order
CASE
WHEN vbak.audat IS NOT NULL AND likp.vbeln IS NULL
THEN 'Sales Order Created'
WHEN likp.wadat_ist IS NOT NULL
THEN 'Delivery Completed'
WHEN vbrk.fkdat IS NOT NULL
THEN 'Billing Document Created'
WHEN bsad.augdt IS NOT NULL
THEN 'Payment Received'
END AS activity,
COALESCE(vbak.erdat, likp.erdat, vbrk.erdat) AS event_timestamp,
vbak.vkorg AS sales_org,
vbak.kunnr AS customer,
vbak.auart AS order_type,
vbap.netwr AS net_value
FROM vbak
LEFT JOIN vbap ON vbak.vbeln = vbap.vbeln
LEFT JOIN vbfa ON vbak.vbeln = vbfa.vbelv
LEFT JOIN likp ON vbfa.vbeln = likp.vbeln AND vbfa.vbtyp_n = 'J'
LEFT JOIN vbrk ON vbfa.vbeln = vbrk.vbeln AND vbfa.vbtyp_n = 'M'
LEFT JOIN bsad ON vbrk.vbeln = bsad.vbeln
WHERE vbak.erdat >= '{{START_DATE}}'
AND vbak.erdat <= '{{END_DATE}}'
ORDER BY case_id, event_timestamp;
-- ============================================================
-- CSV Export Format (for Signavio import)
-- ============================================================
-- Required columns: Case ID, Activity, Start Timestamp
-- Optional: End Timestamp, Resource, Cost, any dimension
-- Date format: YYYY-MM-DD HH:MM:SS or ISO 8601
-- Encoding: UTF-8
-- Separator: comma or semicolon
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| reverse-engineer-anythingmorluto/reaReverse engineer native, managed, Electron/JavaScript, packaged, firmware, and browser targets with REA, and build agent environments (AgentEnv bundles) of web applications from a live instance or a capture, and of Linux desktop apps with a task from a request. Use shipped-artifact or requested runtime evidence to explain features, compare versions, decompile code, or guide a reconstruction. Skip REA for ordinary source-repository architecture analysis. | Stars: 472k | Updated | Claude CodeCodex | Unverified | Install |
| diagnosing-superpowersobra/superpowersUse when a superpowers session went wrong and your human partner wants to know why — repeated work, ignored plans, stumbles, poor results, a skill that didn't fire, "it took too long", "why is it so expensive", "what is it doing" — or wants to build a bug report for the superpowers maintainers, for the current session or a past one identified by id or path, on any harness. | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| dispatching-parallel-agentsobra/superpowersUse when facing 2+ independent tasks that can be worked on without shared state or sequential dependencies | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| executing-plansobra/superpowersUse when executing an implementation plan in the current session as the implementer yourself — your human partner chose inline execution, or no subagent tool is available | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |