cancel
Showing results for 
Search instead for 
Did you mean: 

Extraction Method from SAP ECC to SAP Analytics Cloud.

0 Kudos
1,187

Hello all,

I want to extract data from SAP ECC Tables like USR02(User login data) and USR03 (ADDRESS DATA) into single SAP Analytic Model .

Can any one explain the what exact procedure need to follow.?

Accepted Solutions (0)

Answers (2)

Answers (2)

mfoeken
Active Contributor
0 Kudos

Hi Venkata,

The is no data modeling environment in SAP Analytics Cloud where you can join 3 tables and create a single model. For this use case you need to look at SAP Datawarehouse Cloud: https://saphanacloudservices.com/data-warehouse-cloud/product/. With regards to SAC: you can create 3 separate models and link them in a story.

Kind regards,

Martijn van Foeken | Interdobs

TammyPowlas
Active Contributor
0 Kudos

Please see the SAP steps here to connect to SAP ERP from SAP Analytics Cloud: https://www.sapanalytics.cloud/guided_playlists/connect-sap-erp/

0 Kudos

Hi Tammy,

Thank you for your response.

Connection to ECC is fine, but the thing is how to extract data from selected fields of 3 tables which is having common field in 3 tables from SAP ECC to SAC.

My Question is like,

1. whether we need to extract separately from three different tables to SAC Models or is there any other way..?

TammyPowlas
Active Contributor
0 Kudos

One suggestion is to create a SAP Infoset/Query using the SQXX transactions and join the 2 tables

Is your end goal one model for the 2 tables?