About WordPress
Log In

Search

Toggle Side Panel

Sign in

Search for:

Search for:

WC121 – The Power Of Python to determine your SAP extraction

0% Complete

0/0 Steps

Webclass 121: Take the quiz and get your CPE Certificate

1 Quiz
- Webclass 121: The Power Of Python to determine your SAP extraction
Webclass 121: Replay and PDF

Quizzes

Webclass 121: Secret Number

Participants 13

Bee
Be
admin
Claire
Hanh Huynh

Show more

Quiz 1 of 2

← Previous Next→

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

admin June 9, 2026

WC121 – The Power Of Python to determine your SAP extraction
Webclass 121: Take the quiz and get your CPE Certificate
Webclass 121: The Power Of Python to determine your SAP extraction

Time limit: 0

Quiz Summary

0 of 16 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 16 Questions answered correctly

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

Review
Answered
Correct
Incorrect

Question 1 of 16

1. Question

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

Correct

Incorrect
Question 2 of 16

2. Question

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

Correct

Incorrect
Question 3 of 16

3. Question

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

Correct

Incorrect
Question 4 of 16

4. Question

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

Correct

Incorrect
Question 5 of 16

5. Question

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

Correct

Incorrect
Question 6 of 16

6. Question

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

Correct

Incorrect
Question 7 of 16

7. Question

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

Correct

Incorrect
Question 8 of 16

8. Question

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

Visual Studio Code
Correct Incorrect Correct answer

ACL
Correct Incorrect Correct answer

Correct

Incorrect
Question 9 of 16

9. Question

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

Correct

Incorrect
Question 10 of 16

10. Question

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

Correct

Incorrect
Question 11 of 16

11. Question

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

Correct

Incorrect
Question 12 of 16

12. Question

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

Correct

Incorrect
Question 13 of 16

13. Question

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

Correct

Incorrect
Question 14 of 16

14. Question

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

Python
Correct Incorrect Correct answer

SQL
Correct Incorrect Correct answer

Correct

Incorrect
Question 15 of 16

15. Question

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

Correct

Incorrect
Question 16 of 16

16. Question

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

Correct

Incorrect