SAP Knowledge Base Article - Public

3067923 - Unable to export Total Rate and Export Rate from SAC to the S/4HANA ACCOSTRATE table

Symptom

The following issue occurs in SAP Analytics Cloud for Planning (SAC):

  • You export cost rates from SAP Analytics Cloud to SAP S/4HANA with Activity Type Plan Cost Rates – ACCOSTRATE.
  • After the export job is finished, you find the Total Rate and Export Rate in S/4HANA table ACCOSTRATE are all 0.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP Analytics Cloud (Enterprise)

Cause

The SAC dimension mapped to S/4HANA Target Field Fixed Variable Type is not maintained properly.

Resolution

In the SAC dimension mapped to S/4HANA Target Field Fixed Variable Type, please maintain 3 members FIX, VAR, TOTAL.
TOTAL should be the parent of FIX and VAR.
See the attached screenshot which is taken from dimension SAP_FI_BPL_FIXVARIABLE as an example.

Besides, if you are not sure how to maintain the SAC dimensions, you can import the Integrated Financial Planning for SAP S/4HANA business content and check the pre-delivered dimensions of model SAP__FI_BPL_IM_COSTCENTER.

See Also

Keywords

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, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, C_ACTYTYPEPLANCOSTRATE_SRV , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , Problem

Product

SAP Analytics Cloud 1.0

Attachments

example.png
image.png