Extraction Method from SAP ECC to SAP Analytics Cloud.

[#1]

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.?

[TammyPowlas]

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

[former_member604438]

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]

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?