Cleansing data from SAP into a useable format

Question

Hi  everyone,

I am hoping someone will be able to help me or has faced this problem before. I have this data from SAP. It is not in a user friendly format as i would like it stacked in a proper spreadsheet for further analysis however unsure how to proceed. please see below.

Original:

Desired format:

I have attached a copy of the extracted excel file .

Many thanks for any assistance in advance.

Price change wip.xlsx

Simon_TS · Answer

@ginda8 It looks like you want to extract data from a SAP Report into an Alteryx workfow. Theobald Software has a dedicated component called Xtract Report for exactly this. It makes it very easy to consume SAP data in a structured format in an automated way. You can check out more details here: https://help.theobald-software.com/en/xtract-for-alteryx/reports . There are also connectors for even more SAP sources such as SAP Queries, Tables, T-Codes, BAPIs, etc. A free trial is available on their homepage

Amol_Telore · Answer

@ginda8 I believe you are using ACS connectors for reading data from SAP. You can try below options to solve this problem

* I see that you do not need all the fields coming SAP report. Instead only few selective fields are needed. In this case, Open that report in SAP GUI application (front end) and create a layout with required fields only. You won't be changing the layout of original report. You are just creating another visualization view for that report. After layout is created, you can specify this layout ACS connectors. I hope by doing this you might get all the required fields in one single row as we are removing unnecessary fields.
* You can use ACS file tool to read and parse data from SAP extract.

If above two options doesn't work, can you share your extract in txt file. I would like to give it try from my side. Thanks.

ginda8 · Answer

Thanks Matthew, I have extracted in the text file but not sure it helps