SAP Knowledge Base Article - Public

2590508 - Import Data from SAP S/4HANA to SAP Analytics Cloud

Symptom

  • You want to establish a connection to import data from S/4HANA on premise or S/4HANA Cloud Edition
  • If you are looking for live data connecting to S/4HANA, you can use the KBA 2532706

Environment

  • SAP Analytics Cloud
  • SAP S/4HANA on-premise Edition
  • SAP S/4HANA Cloud Edition

Reproducing the Issue

  1. Create a new connection in SAP Analytics Cloud
  2. Choose Import Data Connection > S/4HANA
  3. Fill in the required information

Resolution

Use the OData Service URL as per Import Data Connection to SAP S/4HANA.

  • S/4HANA on-premise Edition

SAP Analytics Cloud import S/4HANA views exposed as OData. Steps required to import data from that CDS view exposed as OData:

  1. Use the notation @Data.publish:true on your CDS view
  2. Verify that you can connect using username and password to that CDS view 
  3. Create an entry in your SAP Cloud Platform Cloud Connector to map your S/4HANA system as indicated in the product's documentation. For example, for an internal system http://mys4hana.example.com:8000 we will create a Mapping Cloud to on-premise as follows.
    1. Add System Mapping > Other SAP System 
    2. Select protocol "HTTP"
    3. Internal host = mys4hana.example.com 
    4. Internal port = 8000
    5. Virtual Host = mys4hana
    6. Virtual Port = 8000
    7. Principal Type = "None"
    8. When that mapping is created, add the resources available: "/sap" including Patch and Sub-paths
  4. When these steps are completed, you can add a new connection in SAP Analytics Cloud:
    1. Create a New Connection > Import > SAP S/4HANA Connection
    2. Data Service URL = https//mys4hana:8000/sap/opu/odata/sap/API_PRODUCT_SRV
    3. Authentication Type = Basic Authentication

See Also

Keywords

s4, s4hana, import, odata, cloud connector, connect, SBOC, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, hybris, marketing , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , Problem

Product

SAP Analytics Cloud 1.0