SAP Knowledge Base Article - Public

3339315 - How can you clear the destination data when you export data from SAP Analytics Cloud to S/4HANA Cloud or S/4HANA On-premise?

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_SRVFinancial Plan Data - ACDOCPExporting Plan Data to SAP S/4HANA or SAP S/4HANA Cloud
C_ACTYTYPEPLANCOSTRATE_SRVActivity Types Plan Cost Rates - ACCOSTRATEExporting Cost Rates to SAP S/4HANA or SAP S/4HANA Cloud
C_SKF_SRVStatistical Key Figures - FINSSKFExporting Statistical Key Figures to SAP S/4HANA or SAP S/4HANA Cloud
FINCS_PLNG_INTEG_SRVGroup Reporting Planning IntegrationExporting Group Financial Plan Data to SAP S/4HANA or SAP S/4HANA Cloud
C_ACTYTYPECOSTRATECOMPSPLIT_SRVActivity Type Plan Cost Rate Component SplitExporting 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

Product

SAP Analytics Cloud 1.0