258 lines
11 KiB
Markdown
258 lines
11 KiB
Markdown
# Exporting SAC Native Planning Data to SAP S/4HANA ACDOCP
|
|
|
|
Guide for exporting SAP Analytics Cloud native planning data to SAP S/4HANA ACDOCP table using the SAC Data Export Service.
|
|
|
|
**Source**: [ZPARTNER - SAC Export Native Planning to SAP S/4HANA ACDOCP](https://www.zpartner.eu/sac-export-native-planning-to-sap-s-4hana-acdocp/) by Andreas Theodoridis (July 2025)
|
|
|
|
---
|
|
|
|
## Table of Contents
|
|
|
|
1. [Architecture Overview](#architecture-overview)
|
|
2. [Prerequisites](#prerequisites)
|
|
3. [Configuration Steps](#configuration-steps)
|
|
4. [Dimension Mapping Requirements](#dimension-mapping-requirements)
|
|
5. [Export Scope and Behavior](#export-scope-and-behavior)
|
|
6. [Troubleshooting](#troubleshooting)
|
|
7. [SAP Documentation Links](#sap-documentation-links)
|
|
|
|
---
|
|
|
|
## Architecture Overview
|
|
|
|
The integration uses the SAC Data Export Service to push planning data from SAC to S/4HANA's ACDOCP table (central storage for ERP plan data).
|
|
|
|
```
|
|
┌─────────────────────────────────────────────────────────────────────┐
|
|
│ SAP Analytics Cloud │
|
|
│ ┌───────────────────┐ ┌─────────────────────────────────────┐ │
|
|
│ │ Native Planning │───>│ Data Export Service │ │
|
|
│ │ Model │ │ (Data Management workspace) │ │
|
|
│ └───────────────────┘ └──────────────┬──────────────────────┘ │
|
|
└──────────────────────────────────────────┼──────────────────────────┘
|
|
│ HTTPS
|
|
▼
|
|
┌──────────────────────────────────────────────────────────────────────┐
|
|
│ SAP Cloud Connector │
|
|
│ (for on-premise S/4HANA) │
|
|
└──────────────────────────────────────────┬───────────────────────────┘
|
|
│
|
|
▼
|
|
┌──────────────────────────────────────────────────────────────────────┐
|
|
│ SAP S/4HANA │
|
|
│ ┌───────────────────────────────────────────────────────────────┐ │
|
|
│ │ API_PLPACDOCPDATA_SRV (OData Service) │ │
|
|
│ └──────────────────────────────────────┬────────────────────────┘ │
|
|
│ │ │
|
|
│ ┌───────────────────────────────────────▼───────────────────────┐ │
|
|
│ │ ACDOCP Table (Plan Data Storage) │ │
|
|
│ └───────────────────────────────────────────────────────────────┘ │
|
|
└──────────────────────────────────────────────────────────────────────┘
|
|
```
|
|
|
|
**Required Components**:
|
|
1. SAC Native Planning Model
|
|
2. S/4HANA Connection (configured in SAC)
|
|
3. SAC Data Export Service (OData via Cloud Connector)
|
|
4. SAP S/4HANA ACDOCP table
|
|
|
|
---
|
|
|
|
## Prerequisites
|
|
|
|
### SAC Planning Model Configuration
|
|
|
|
| Requirement | Details |
|
|
|-------------|---------|
|
|
| **Legacy Mode** | Must be enabled on the planning model (prerequisite for export) |
|
|
| **Version Dimension** | Required; only public versions can be exported |
|
|
| **Date Dimension** | Required (FiscalYearPeriod or Fiscal Year + Fiscal Period) |
|
|
|
|
To enable Legacy Mode:
|
|
1. Open planning model in Modeler
|
|
2. Go to Model Preferences
|
|
3. Enable "Legacy Planning Model" option
|
|
|
|
### S/4HANA Configuration
|
|
|
|
| Component | Transaction/Action |
|
|
|-----------|-------------------|
|
|
| **OData Service** | Activate `API_PLPACDOCPDATA_SRV` in `/IWFND/MAINT_SERVICE` |
|
|
| **Master Data Services** | Additional OData services may be required for master data access |
|
|
| **Cloud Connector** | Configure for on-premise S/4HANA connectivity |
|
|
|
|
### SAC Connection Setup
|
|
|
|
Create an Import Data Connection to S/4HANA:
|
|
1. Go to Connections in SAC
|
|
2. Create new connection to S/4HANA system
|
|
3. Configure Cloud Connector settings (for on-premise)
|
|
|
|
---
|
|
|
|
## Configuration Steps
|
|
|
|
### Step 1: Create Data Export Job
|
|
|
|
1. Open the planning model in SAC
|
|
2. Navigate to **Data Management** workspace
|
|
3. Click **Create** → **Data Export Job**
|
|
4. Select the configured S/4HANA OData endpoint
|
|
|
|
### Step 2: Configure Dimension Mapping
|
|
|
|
Map SAC dimensions to S/4HANA ACDOCP fields:
|
|
|
|
| SAC Dimension | S/4HANA Field | Notes |
|
|
|---------------|---------------|-------|
|
|
| Version (Plan Category) | RVERS | Only public versions can be exported |
|
|
| Date (FiscalYearPeriod) | FISCPER / FISCYEAR + FISCPERIOD | Can use combined or separate fields |
|
|
| Account | RACCT | G/L Account (required) |
|
|
| Measure | Target Measure | Only ONE measure per export job |
|
|
| Cost Center | RCNTR | Must be linked to exported company code |
|
|
| Company Code | RBUKRS | Required for validation |
|
|
|
|
**Important**: Only valid combinations of dimension members will be exported. For example, cost centers must be linked to the company code in the export scope.
|
|
|
|
### Step 3: Set Filters
|
|
|
|
Configure filters to define the export scope:
|
|
- Select source data (members to export)
|
|
- Set target data selection
|
|
- **Note**: Filters cannot be changed after export job creation—name jobs descriptively!
|
|
|
|
### Step 4: Define Export Scope
|
|
|
|
Select dimensions to include in export scope:
|
|
- **FiscalYearPeriod**: Mandatory
|
|
- **PlanningCategory (Version)**: Mandatory
|
|
- Additional dimensions as needed
|
|
|
|
All members of marked dimensions will be overwritten if data is available.
|
|
|
|
### Step 5: Schedule or Run Export
|
|
|
|
- Run manually for testing
|
|
- Schedule for automated execution
|
|
- Name exports descriptively for tracking
|
|
|
|
---
|
|
|
|
## Export Scope and Behavior
|
|
|
|
### Overwrite Behavior
|
|
|
|
Exported data **overwrites existing data within the defined scope**:
|
|
|
|
```
|
|
Export Scope Example:
|
|
- CostCenter: 17101101
|
|
- FiscalYearPeriod: 2025
|
|
- PlanningCategory: Plan
|
|
|
|
Result: All Plan data for CostCenter 17101101 in 2025 is replaced
|
|
```
|
|
|
|
### Delta Records
|
|
|
|
From a technical perspective, S/4HANA generates **delta records** when data changes:
|
|
|
|
| Scenario | SAC Value | ACDOCP Result |
|
|
|----------|-----------|---------------|
|
|
| Initial export | 1000 | Record created: 1000 |
|
|
| Value changed | 1500 | Delta record: +500 (total: 1500) |
|
|
| Value set to 0 | 0 | Delta record: -1500 (total: 0) |
|
|
|
|
### Deletion Behavior
|
|
|
|
**Critical**: Deleting data in SAC does NOT delete data in ACDOCP:
|
|
- Deleted SAC values remain in ACDOCP until overwritten
|
|
- To remove values, set them to 0 in SAC and re-export
|
|
- Only exported data overwrites existing ACDOCP data
|
|
|
|
---
|
|
|
|
## Troubleshooting
|
|
|
|
### "Access Denied" for Master Data
|
|
|
|
**Symptom**: Error when selecting master data in target data selection
|
|
|
|
**Cause**: Missing OData services for master data access
|
|
|
|
**Solution**:
|
|
1. Check OData error log: Transaction `/IWFND/ERROR_LOG`
|
|
2. Identify missing services from error details
|
|
3. Activate required OData services in `/IWFND/MAINT_SERVICE`
|
|
|
|
### Field Mapping Errors
|
|
|
|
**Symptom**: Data rejection during export
|
|
|
|
**Cause**: Mismatches between SAC dimension values and S/4HANA valid combinations
|
|
|
|
**Solution**:
|
|
1. Download error details file from export job
|
|
2. Verify dimension member combinations are valid in S/4HANA
|
|
3. Ensure cost centers are linked to correct company codes
|
|
4. Check G/L accounts exist in target ledger
|
|
|
|
### Version Export Fails
|
|
|
|
**Symptom**: Cannot select version for export
|
|
|
|
**Cause**: Only public versions can be exported
|
|
|
|
**Solution**:
|
|
1. Publish private version before export
|
|
2. Use standardized version names (e.g., PLAN, FORECAST) that exist in ACDOCP
|
|
|
|
### Export Job Not Visible
|
|
|
|
**Symptom**: Cannot find export option in Data Management
|
|
|
|
**Cause**: Legacy mode not enabled
|
|
|
|
**Solution**: Enable Legacy Planning Model in model preferences
|
|
|
|
---
|
|
|
|
## SAP Documentation Links
|
|
|
|
### Official SAP Resources
|
|
|
|
| Resource | Link |
|
|
|----------|------|
|
|
| **KBA: Import/Export Job Checkpoints** | [SAP Note 3220268](https://userapps.support.sap.com/sap/support/knowledge/en/3220268) (S-User required) |
|
|
| **Cloud Connector Setup** | [SAP Help - Import Data Connection to S/4HANA](https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/63140f17362947fe8bcd9c6960db23bc.html) |
|
|
| **Exporting Plan Data to S/4HANA** | [SAP Help - Export Planning Data](https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE_UPA/e9090901b1e24f4d9d04f6f206abecd8/efee7f7a47844876a80565d50f1cffcd.html) |
|
|
| **OData Services for Export** | [SAP Help - OData Services](https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE_UPA/e9090901b1e24f4d9d04f6f206abecd8/15447e5bda934be28f3b16cfb456fb23.html) |
|
|
|
|
### Quick Reference
|
|
|
|
```
|
|
Key OData Service: API_PLPACDOCPDATA_SRV
|
|
Error Log Transaction: /IWFND/ERROR_LOG
|
|
Service Activation: /IWFND/MAINT_SERVICE
|
|
ACDOCP Verification: SE16N
|
|
```
|
|
|
|
---
|
|
|
|
## Summary
|
|
|
|
| Aspect | Key Point |
|
|
|--------|-----------|
|
|
| **Prerequisites** | Legacy mode ON, API_PLPACDOCPDATA_SRV activated |
|
|
| **Version Requirement** | Only public versions can be exported |
|
|
| **Measure Limit** | One target measure per export job |
|
|
| **Mandatory Scope** | FiscalYearPeriod + PlanningCategory always required |
|
|
| **Overwrite Behavior** | Exported data replaces existing within scope |
|
|
| **Deletions** | Set to 0 and re-export; deletions don't propagate automatically |
|
|
|
|
---
|
|
|
|
**License**: GPL-3.0
|
|
**Last Updated**: 2025-11-22
|
|
**Repository**: [https://github.com/secondsky/sap-skills](https://github.com/secondsky/sap-skills)
|