Symptom
How can you clear the destination data when you export data from SAP Analytics Cloud to S/4HANA Cloud or S/4HANA On-premise?
Environment
- SAP Analytics Cloud (Enterprise)
- S/4HANA Cloud
- S/4HANA On-premise
Resolution
1. Note that the "Delete Scope" is NOT configurable for S/4HANA Group Reporting (GR) Planning Integration. It is hardcoded.
2. The following export data sources in S/4HANA Cloud or S/4HANA On-premise allow you to select the Replace or Delete Scope.
- Financial Plan Data - ACDOCP
- Activity Types Plan Cost Rates - ACCOSTRATE
- Statistical Key Figures - FINSSKF
- Activity Type Plan Cost Rate Component Split - C_ACTYTYPECOSTRATECOMPSPLIT_SRV
Below is the text from the online help on how to do this (see the online help for further information):
Choose Next to define the plan data scope for the export.
The plan data scope (or deletion scope) defines the plan data record set that will be reversed (overwritten) by the exported plan data record. Existing plan data in the SAP S/4HANA system that contains any combination of the values of these dimensions will be reversed (overwritten) before the exported data is posted.
In the Export Method popover, select the dimensions for your plan data scope.
The examples in the topic Examples: Financial Data Import illustrates how the system determines the plan data scope.
The 'X' in the CSV file corresponds to the selected checkbox in the SAP Analytics Cloud system.
Caution: S/4HANA data in that scope will be cleaned / cleared / deleted first.
Online help links:
API_FINANCIALPLANDATA_SRV | Financial Plan Data - ACDOCP | Exporting Plan Data to SAP S/4HANA or SAP S/4HANA Cloud |
C_ACTYTYPEPLANCOSTRATE_SRV | Activity Types Plan Cost Rates - ACCOSTRATE | Exporting Cost Rates to SAP S/4HANA or SAP S/4HANA Cloud |
C_SKF_SRV | Statistical Key Figures - FINSSKF | Exporting Statistical Key Figures to SAP S/4HANA or SAP S/4HANA Cloud |
FINCS_PLNG_INTEG_SRV | Group Reporting Planning Integration | Exporting Group Financial Plan Data to SAP S/4HANA or SAP S/4HANA Cloud |
C_ACTYTYPECOSTRATECOMPSPLIT_SRV | Activity Type Plan Cost Rate Component Split | Exporting Activity Type Cost Rate Component Split to SAP S/4HANA |
3. When exporting data to the ACDOCU table, then implicitly a delete scope consists of the following dimensions:
- Consolidation ChartOfAccounts
- Consolidation Unit
- Consolidation Version
- FiscalPeriod
- FiscalYear
See Also
Keywords
delete scope replace clear data specific version in ACDOCU,Financial Plan Data - ACDOCP Activity Types Plan Cost Rates - ACCOSTRATE Statistical Key Figures - FINSSKF Activity Type Plan Cost Rate Component Split - C_ACTYTYPECOSTRATECOMPSPLIT_SRVerror in rectraction of planning data to S4 HANA Cloud EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Import, Acquired, Acquire, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, Troubleshoot, Troubleshooting, bp, bps, T-shooting SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , LOD-ANA-PL , Planning , Problem