3220268 - Checkpoints: Import and Export Job for SAC model via S/4HANA connection

1. This article includes a summary of critical steps to set up S4HANA ODATA connection in SAP Analytics Cloud (SAC) as well as troubleshooting suggestions. 
2. User is using S4HANA service connection (https://<S4HANA SERVER:PORT>/XXX in SAP Analytics Cloud (SAC) to export data to S4HANA or S4HANA Cloud.
3. User is not able to set up S4HANA Service in SAC
4. User is not able to see some S4HANA Services in SAC
5. User gets the following issue when running a S4HANA export:
   
   1. S4HANA side Error:
      1. FINS_ACDOC_PLANNING
         
         1. FINS_ACDOC_PLANNING 020 Customer <XXX> doesn't exist.
         2. FINS_ACDOC_PLANNING 005 "Plan data scope doesn't contain value for field FIKRS." 
         3. FINS_ACDOC_PLANNING Data contains no valid plan category 
         4. FINS_ACDOC_PLANNING 009 Category XXX doesn't exist.  
         5. Cost center XXX does not exist
      2. Error occurred in derivation rule. CO-PA Characteristic Derivation K/111
      3. Profit center  is locked in controlling area. KM089
      4. Exported amount duplicated doubled
          
   2. Gateway Related Error:
      1. Response from external server has status code of 404
      2. Response from external server has status code of 307
      3. Gateway Error: 403 Forbidden - With CSRF Token or 403 Forbidden - Without any CSRF Token
      4. Tag '' does not exist  /IWFND/CATALOGSERVICE_0002  /IWFND/MED195 
            
   3. SAC shows error:
      1. Access was denied ("code":"ERROR_ACCESS_DENIED)
      2. Tag 'SACEXPORTTOS4HANA' does not exist
      3. The following errors occurred during export: Access was denied status:403 Export failed. See details for rejected data.
      4. EPM_SERVICE JOB_RUNTIME_TIMEOUT 
      5. Export failed: XX lines were rejected.  The plan data couldn't be saved due to errors

Read more...

• SAP Analytics Cloud
• SAP S/4HANA
• SAP S/4HANA Cloud

SAP Analytics Cloud 1.0 ; SAP S/4HANA 1610 ; SAP S/4HANA 1709 ; SAP S/4HANA 1809 ; SAP S/4HANA 1909 ; SAP S/4HANA 2020 ; SAP S/4HANA 2021 ; SAP S/4HANA 2022 ; SAP S/4HANA 2023 ; SAP S/4HANA 2025 ; SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA, on-premise edition 1511

API_FINANCIALPLANDATA_SRV, Message ,FINS_ACDOC_PLANNING020, Write, API, ACDOCP, App Import ,Financial, Plan, Data, Export, of plan, data from, SAP Analytics Cloud ,to SAP ,S/4HANA, Import data, transaction data, master data, API ,gateway, PSM C_ACTYTYPEPLANCOSTRATE_SRV ,C_SKF_SRV API_JOURNALENTRYITEM,BASIC_SRV C_ACTYTYPECOSTRATECOMPSPLIT_SRV, No primary cost component, POST_ACTY_COST_RATE_COMP_SPLIT, API_STATISTICALKEYFIGURE_SRV, C_FINUNITOFMEASURE_SRV SAC, S4, HANA, integration, ODATA , SAP Analytics Cloud , S4HANA ,S4, ACDOCP, Planning, Data, export ,Data import , ERROR_FROM_EXTERNAL_SERVER Response from external server has status code of 404 Export failed: XX lines were rejected.  The plan data couldn't be saved due to errorsTag '' does not exist  /IWFND/CATALOGSERVICE_0002  /IWFND/MED195  FINS_ACDOC_PLANNING FINS_ACDOC_PLANNING 020 Customer <XXX> doesn't exist. Cost center XXX does not exist FINS_ACDOC_PLANNING 005 "Plan data scope doesn't contain value for field FIKRS."  Error occurred in derivation rule. CO-PA Characteristic Derivation K/111 Profit center  is locked in controlling area. KM089 Exported amount duplicated doubled Response from external server has status code of 404 Response from external server has status code of 307 Access was denied ("code":"ERROR_ACCESS_DENIED) FINS_ACDOC_PLANNING Data contains no valid plan category FINS_ACDOC_PLANNING009 Category XXX doesn't exist.  FINS_ACDOC_PLANNING  ACDOCP R_FINS_PLAN_DELETE_PLANDATA Delta Mode R_FINS_PLAN_TRANS_CO_S4H_2_ERP   staging (ACDOCP_DATA)  CL_FINS_PLANNING_API_WRITE MERGE_PACKAGE_RESULT  A_FinPlanItemStagingArea FinPlanDataTransactionType FINS_SAC_INTEGRATION  FIN_PLAN_DATA_IMPORT SAC_INT_PULL Delete Financial Plan Data app delta posting planning scope Import Financial Plan Data application Write back from SAC to S/4HANA Import Financial Plan Data App delta Derivation , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , CO-OM , Overhead Cost Controlling , OPU-GW-COR , Framework , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , FIN-CS , S/4HANA for Group Reporting , FIN-CS-2CL , S/4HANA for Group Reporting (Public Cloud) , CO-FIO-SAC-PL , SAC Planning Content , CO-OM-2CL , Overhead Cost Controlling (Public Cloud) , CO-FIO-OM-PL , Planning , Problem