Webclass 121: The Power Of Python to determine your SAP extraction

Q1. Why is it not a good idea to just download all fields for each table you need from SAP?

Because it will make the download very slow and heavy and might even get you in trouble with the IT department

Correct Incorrect Correct answer

Because you will get drowned in too many fields to analyze

Correct Incorrect Correct answer

Q2. What two factors impact the size of a data file?

The width (number of fields) and the length (number of records)

Correct Incorrect Correct answer

The total value of the numeric fields and the number of records

Correct Incorrect Correct answer

Q3. Why should you care about filtering your data before downloading it?

Because if you do not filter transactional data tables, then you will end up with too many records

Correct Incorrect Correct answer

Because if you do not filter master data records then you will end up with too many records

Correct Incorrect Correct answer

Q4. Why might you need a helper table?

Because it could be that you need to filter on a field that is not in the table that you are downloading (for example you need to filter on the date, but the date is not found in the detailed line items)

Correct Incorrect Correct answer

Because it could be that you need to filter on a row that is not in the data that you are downloading, for example, you do not want to get values above a certain threshold

Correct Incorrect Correct answer

Q5. If you would like your general ledger data to match the trial balance data for a particular month and you are in SAP ECC, which table would be your helper table, which fields would you join on and which field would you use to filter your helper table?

Table BKPF, join on GJAHR, BUKRS, BELNR and filter on BUDAT

Correct Incorrect Correct answer

Table BSEG, join on GJAHR, BUKRS, BELNR and filter on the period

Correct Incorrect Correct answer

Q6. Why might we want to automatically generate the definition of our extraction templates?

Because one day we might switch systems from ECC to S4 or we might decide to update the dates and values for a paritcular entity for all of our download templates

Correct Incorrect Correct answer

Because then we can see the data from SAP in a more transparent way and get better insights

Correct Incorrect Correct answer

Q7. Why do we need two SAP Excel matrix files?

Because the first one is mapping the tables and fields to the must-have data analytics and the second is mapping the tables and fields between each other

Correct Incorrect Correct answer

Because the first is showing us which data analytics to do and which filters to apply and the second is showing us which fields are the most important

Correct Incorrect Correct answer

Q8. Which option is a typical free code editor for python?

Visual Studio Code

Correct Incorrect Correct answer

ACL

Correct Incorrect Correct answer

Q9. How can you see the terminal in Visual Studio Code

Do View-> Terminal or type CTRL~

Correct Incorrect Correct answer

Do View-> Window or type CTRL+

Correct Incorrect Correct answer

Q10. What do we use the terminal for in Visual Studio Code?

To do the installation of python libraries or to see the running progress of the program

Correct Incorrect Correct answer

To view the python code

Correct Incorrect Correct answer

Q11. If we have yellow squiggles under the libraries that we import at the top of the script, what does that mean?

It means that you haven't opted in Manage to trust the script, or that you have not installed the python library

Correct Incorrect Correct answer

It means that your code has incorrect syntax

Correct Incorrect Correct answer

Q12. What does the openpyx library do and why is it important for our challenge?

It helps to read/write to Excel

Correct Incorrect Correct answer

It helps to find the path in the operating system

Correct Incorrect Correct answer

Q13. Why do we need pandas?

In order to be able to put data into dataframes so that we can analyze/ manipulate it

Correct Incorrect Correct answer

In order to be able to read data from Excel

Correct Incorrect Correct answer

Q14. Which of the following is an Object Oriented programming language?

Python

Correct Incorrect Correct answer

SQL

Correct Incorrect Correct answer

Q15. How is an Object Oriented programming language more suitable to our challenge?

Because it can help us to store values from our Excel Matrices into sets, arrays or objects and then read those out again into our final Excel file

Correct Incorrect Correct answer

Because it can help us to process the data column by column

Correct Incorrect Correct answer

Q16. What is one potential danger of your data team relying too heavily on Chat GPT?

They might use code from ChatGPT that they don't understand and loose focus on what they are trying to achieve with the program/ introduce errors that they are not aware of/ get lazy and loose the knowledge of the programming language, thus stunting their potential for creative problem solving

Correct Incorrect Correct answer

They might end-up putting too many comments into the code and making it too verbose

Correct Incorrect Correct answer

Webclass 121: The Power Of Python to determine your SAP extraction

Webclass 121: The Power Of Python to determine your SAP extraction

admin June 9, 2026

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

16. Question