secondsky/sap-skills

sap-btp-master-data-integration

Configures and integrates SAP Master Data Integration (MDI) service on SAP Business Technology Platform.

View source

How to use

  1. Copy the installation command and review the source package before installing it in your own agent environment.
  2. Check the source document for required tools, credentials and supported hosts.
  3. Describe your input and desired deliverable; review the output against the source material.
npx skills add https://github.com/secondsky/sap-skills --skill sap-btp-master-data-integration

Before you start

  • Installation does not include a model subscription, API allowance or permission to access your files.
  • Repository stars and installation counts describe activity, not an independent quality or security test.
Original skill document

Rendered from the source repository. Headings, examples, code, tables, links, and referenced images are preserved.

SAP BTP Master Data Integration

Related Skills

  • sap-btp-cloud-platform: Use for subaccount, entitlement, and service instance setup
  • sap-btp-connectivity: Use for destination and authentication configuration around connected systems
  • sap-btp-integration-suite: Use for MDI Adapter and broader integration orchestration scenarios
  • sap-api-style: Use when documenting MDI SOAP/API contracts and integration behavior

When to Use This Skill

Use this skill when setting up MDI tenants, connecting SAP applications, configuring distribution models, choosing MDI service plans, integrating business partner SOAP APIs, handling One Domain Model versions, or troubleshooting master data replication.

Table of Contents

SAP Master Data Integration (MDI) is a central master data hub on SAP BTP that enables applications to synchronize local master data databases with a centralized repository.

Quick Reference

What MDI Does

  • Replicates master data between connected applications
  • Supports 34 master data types via SAP One Domain Model
  • Provides filtering to control data distribution scope
  • Enables extensibility with custom fields

What MDI Does NOT Do

  • Consolidation (use SAP Master Data Governance)
  • Data quality control
  • Central governance workflows
  • Referential integrity validation

Core Concepts

Key Terms

TermDefinition
TenantIsolated MDI environment per subaccount with own database and configs
ClientApplication that integrates with MDI (producing or consuming)
Producing ClientSends change requests to MDI (upstream/writing client)
Consuming ClientReceives change events from MDI (downstream/reading client)
Distribution ModelConfiguration controlling which data replicates where
Change TokenUnique identifier per change request (max 36 chars)

Integration Models (SAP One Domain Model)

Business Partner - v2.1.1, v3.3.0 (multiversion support restricted for address data) Finance - Cost Center v3.1.0, Exchange Rate v4.0.0, Bank v3.0.0 Workforce - Person v5.0.0, Job Classification v4.0.0, Organizational Unit v4.0.0 Procurement - Purchasing Organization v4.0.0, Purchasing Group v6.0.0 Assets - Equipment v5.1.0, Functional Location v5.0.0 Products - Product v5.0.0, Product Group v5.0.0

For complete list see references/integration-models.md

Decision Trees

Which Service Plan?

Is application SAP-branded cloud?
├─ Yes → sap-integration plan (FREE)
└─ No → Is it SAP S/4HANA On-Premise?
         ├─ Yes → s4hana-onpremise plan (PAID - storage + bandwidth)
         └─ No → Use SAP Integration Suite with MDI Adapter

Which Authentication Method?

Mutual-TLS with X.509 certificates available?
├─ Yes → Use mTLS (RECOMMENDED)
│        credential-type: x509
│        Configure validity: DAYS/MONTHS/YEARS
└─ No → Use Client Credentials Grant (DEFAULT)
         Uses client_id/client_secret pairs

REST vs SOAP API?

Master data type is Business Partner?
├─ Yes → SOAP API available for:
│        - Business Partner replication
│        - BP Relationship replication
│        - Key Mapping replication
│        - Confirmations
└─ No → REST API (Events API, Requests API, KeyMapping API)

Setup Workflow

1. Prerequisites

  • SAP BTP global enterprise account (no trial/free tier)
  • Subaccount in supported region: EU10, US10, AP10, AP11
  • Cloud Foundry space within subaccount
  • User with BusinessConfigurationAdmin role

2. Create Tenant

1. Create subaccount in available region
2. Subscribe to SAP Master Data Integration Tenant application
3. One tenant maximum per subaccount
4. Separate tenants for dev/test/prod recommended

3. Connect Application

1. Create service instance (one per application - MANDATORY)
2. Choose service plan (sap-integration or s4hana-onpremise)
3. Set 'application' attribute (e.g., "s4" for S/4HANA Cloud)
4. Create service binding for credentials
5. Configure writePermissions for entity types

4. Configure Distribution Model

1. Access Business Data Orchestration UI
2. Create distribution model (provider → consumer)
3. Set filters (object selection + data scope)
4. Activate model

System Limitations

LimitValue
Change Request Size256 KB (512 KB for Business Partner)
Master Data Record Size512 KB
Change Token Length36 characters max
Delta Token Validity28 days
SOAP Payload Size10 MB
Change Token Charactersa-z, A-Z, 0-9, -, _

Client Configuration Attributes

businessSystemId

  • Required for SOAP API integration
  • Max 60 characters, unique per tenant
  • Must match SenderBusinessSystemID in SOAP messages

writePermissions

json
"writePermissions": [
  { "entityType": "sap.odm.finance.costobject.CostCenter" },
  { "entityType": "sap.odm.businesspartner.BusinessPartner" }
]

globalTenantId

  • Identifies last significant writer on Events API
  • 1-40 characters: alphanumeric, -, ., _, ~
  • Configure only if application documentation requires it

logSys

  • Logical system of last significant writer
  • Max 10 characters
  • Configure only if application documentation requires it

SOAP Endpoints

Base URL: https://one-mds.cfapps.{region}.hana.ondemand.com/businesspartner/v0/soap/

PurposeEndpoint
BP InboundBusinessPartnerBulkReplicateRequestIn
BP ConfirmationBusinessPartnerBulkReplicateRequestConfIn
BP Relationship InboundBusinessPartnerRelationshipBulkReplicateRequestIn
BP Relationship ConfirmationBusinessPartnerRelationshipBulkReplicateRequestConfirmIn
Key Mapping InboundKeyMappingBulkReplicateRequestIn
Key Mapping ConfirmationKeyMappingBulkReplicateRequestConfirmIn

Authentication: Basic (clientid:clientsecret with tenantId param) or OAuth

Destination Naming Convention (SOAP)

For business system ID SYSTEMID:

  • SYSTEMID_BPOUTBOUND - Business Partner replication
  • SYSTEMID_BPCONFIRM - Business Partner confirmation
  • SYSTEMID_BPRELOUTBOUND - Relationship replication
  • SYSTEMID_BPRELCONFIRM - Relationship confirmation
  • SYSTEMID_KMOUTBOUND - Key Mapping replication
  • SYSTEMID_KEYMAPCONFIRM - Key Mapping confirmation

Common Integration Scenarios

SAP S/4HANA Cloud

  • 20 supported objects including Business Partner, Cost Center, Product
  • Communication Arrangement: SAPCOM0659 (MDI), SAPCOM0594 (BDO)
  • Single system cannot connect to multiple MDI tenants

SAP S/4HANA On-Premise

  • 14 supported objects
  • Uses drfimg transaction for configuration
  • Outbound implementation: 986_3 for BP/REL via Services
  • Requires SAP Note 3065614

SAP SuccessFactors

  • Employee Central: Bank, Company Code, Cost Center, Workforce
  • Employee Central Payroll: Cost Center, Public Sector Management

SAP Ariba

  • 9 categories: Business Partner-Supplier, Company Code, Cost Center, etc.

For detailed integration guides see references/integration-guides.md

Security Best Practices

  1. Always use HTTPS - All MDI and XSUAA communications
  2. Validate certificates - Never disable certificate validation
  3. Rotate compromised credentials - Delete service key, create new one
  4. Minimal permissions - Grant only necessary writePermissions
  5. Separate subaccounts - Isolate MDI from unrelated BTP services

Troubleshooting

Delta Token Expired (28 days)

Clients must perform initial load if unable to sync within 28 days.

Change Request Rejected (Size)

Reduce payload size below 256 KB (512 KB for Business Partner).

Missing Mandatory Partner Function

Configure partner determination logic in MDI for C4C → S/4HANA scenarios. Template available in SAP Note 2987243.

Platform Status

Check SAP Trust Center: https://www.sap.com/about/cloud-trust-center/

Support Component

BC-CP-CF-ONEMDS

Bundled Resources

Core Documentation

  1. references/setup-guide-complete.md (12.2K lines) - Complete setup guide with prerequisites, tenant management, client configuration, and version history
  2. references/glossary-and-pricing.md (7.3K lines) - Comprehensive glossary, pricing tiers, qualifying applications, and maintenance windows
  3. references/features-complete.md (11.6K lines) - All MDI features including REST/SOAP events, Local ID APIs, and data privacy

Integration Resources

  1. references/integration-models.md (3.4K lines) - Complete ODM types and versions for all supported master data
  2. references/integration-guides.md (6.8K lines) - System-specific setup guides for S/4HANA, SuccessFactors, Ariba, and more
  3. references/soap-api-reference.md (17.7K lines) - Complete SOAP web services reference with field mappings

Advanced Topics

  1. references/security-and-privacy.md (7.7K lines) - Security guidelines, data protection, and filtering configurations
  2. references/extensibility.md (4.5K lines) - Custom extensions, field definitions, and WSDL generation
  3. references/monitoring.md (7.3K lines) - Business Data Orchestration monitoring and troubleshooting

Documentation Sources

Primary Documentation: https://help.sap.com/docs/master-data-integration GitHub Source: https://github.com/SAP-docs/sap-btp-master-data-integration API Catalog: https://api.sap.com (filter: SAP Master Data Integration) SAP Discovery Center: https://discovery-center.cloud.sap/serviceCatalog/master-data-integration

Related by task

from this repository

More skills

All skills
secondsky
Community

sap-hana-cli

Assists with SAP HANA Developer CLI (hana-cli) for database development and administration. Use when: installing hana-cli, connecting to SAP HANA databases, inspecting database objects (tables, views, procedures, functions), managing HDI containers, executing SQL queries, converting metadata to CDS/EDMX/OpenAPI formats, managing SAP HANA Cloud instances, working with BTP CLI integration, or troubleshooting hana-cli commands. Covers: 91 commands, 17+ output formats, HDI container management, clou

1h installs
1
GitHub stars
501
Updated
Nov 13
secondsky
Community

sap-sqlscript

This skill should be used when the user asks to "write a SQLScript procedure", "create HANA stored procedure", "implement AMDP method", "optimize SQLScript performance", "handle SQLScript exceptions", "debug HANA procedure", "create table function", "inspect a browser-based Datasphere SQL editor with Microsoft Edge CDP", or mentions SQLScript, SAP HANA procedures, AMDP, EXIT HANDLER, or code-to-data paradigm. Comprehensive SQLScript development guidance for SAP HANA database programming includin

1h installs
1
GitHub stars
501
Updated
Nov 13
secondsky
Community

sap-sac-planning

SAP Analytics Cloud (SAC) planning guidance for planning models, planning-enabled stories, data actions, multi actions, version management, data locking, calendar/input workflows, allocations, value driver trees, BPC live planning, and Seamless Planning with SAP Datasphere. Use this for planning design, planning APIs, data action debugging, planning performance reviews, and authenticated SAC planning story triage in Microsoft Edge via CDP; use sap-sac-scripting for non-planning SAC scripts and s

1h installs
2
GitHub stars
497
Updated
Nov 13
secondsky
Community

claude-automation-recommender

Analyze a codebase and recommend Claude Code automations (hooks, subagents, skills, plugins, MCP servers). Use when user asks for automation recommendations, wants to optimize their Claude Code setup, mentions improving Claude Code workflows, asks how to first set up Claude Code for a project, or wants to know what Claude Code features they should use.

1h installs
1
GitHub stars
497
Updated
Nov 13