> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.sfcodebot.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# ECP – Absences

This article will help you in generating workbook for Absences. The article demonstrate the correct format for applying the filters.

1.	To begin, click on the EC Payroll module.


![](https://storage.crisp.chat/users/helpdesk/website/5a53c0e6e1563400/image_ey7ape.png)


2.	Select your desired workspace.


![](https://storage.crisp.chat/users/helpdesk/website/5a53c0e6e1563400/image_4hjc29.png)


3.	Now, click on add new iteration, 


![](https://storage.crisp.chat/users/helpdesk/website/5a53c0e6e1563400/image_1nlt7kt.png)


4.	Add the iteration number, choose your workspace from the dropdown, then, add the host address, Instance type, client, username and description and click on submit form.


![](https://storage.crisp.chat/users/helpdesk/website/5a53c0e6e1563400/image_1bw5409.png)
![](https://storage.crisp.chat/users/helpdesk/website/5a53c0e6e1563400/image_1giyybb.png)


5.	The iteration has been created. Now, open the workbook.


![](https://storage.crisp.chat/users/helpdesk/website/5a53c0e6e1563400/image_1t0k59.png)


6.	Navigate to the Absences tab. Here, notice that the sheet is empty.


![](https://storage.crisp.chat/users/helpdesk/website/5a53c0e6e1563400/image_sjd6s0.png)


7.	Now navigate to the ECP Config tab. Here, make sure to type the correct “Country Code” in Column ‘C’ and then add the appropriate filters in Column ‘P’ “Absences Att./Absence type”. This allows the bot to retrieve only the specified information from the instance.. Now, close the workbook.


![](https://storage.crisp.chat/users/helpdesk/website/5a53c0e6e1563400/image_x0hz4h.png)

![](https://storage.crisp.chat/users/helpdesk/website/5a53c0e6e1563400/image_1rmmp49.png)


8.	Now, Back in CodeBot, click on the Hamburger menu, then, click on "Generate Workbook”.


![](https://storage.crisp.chat/users/helpdesk/website/5a53c0e6e1563400/image_1hd5j52.png)


9.	Enter the SAP SuccessFactors password, some execution notes and select Absences from the advance options, then, click on confirm and start to initiate the process.


![](https://storage.crisp.chat/users/helpdesk/website/5a53c0e6e1563400/image_8jeakg.png)


10.	The execution is now processing. Monitor its progress by clicking on the “i” icon.


![](https://storage.crisp.chat/users/helpdesk/website/5a53c0e6e1563400/image_1jyd0b3.png)

![](https://storage.crisp.chat/users/helpdesk/website/5a53c0e6e1563400/image_1crv89v.png)


11.	Once the execution is complete, open the workbook.


![](https://storage.crisp.chat/users/helpdesk/website/5a53c0e6e1563400/image_1413u7w.png)


12.	Click on the Absences tab, notice that the data has been successfully pulled down by the bot according to the applied filters.


![](https://storage.crisp.chat/users/helpdesk/website/5a53c0e6e1563400/image_141gtsf.png)