> For the complete documentation index, see [llms.txt](https://docs.fairmarkit.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fairmarkit.com/buyers/integrations/sap-ecc-integration/purchase-requisition-sync/export-purchase-requisitions-from-sap-ecc-manually.md).

# Export purchase requisitions from SAP ECC manually

Using the following process, you can manually execute a query to retrieve purchase requisition data in SAP ECC and then upload the data to Fairmarkit’s SFTP. Once uploaded, Fairmarkit will automatically create request for quote events for your purchase requisitions.

### Query for purchase requisitions <a href="#queryforpurchaserequisitions" id="queryforpurchaserequisitions"></a>

Use the following process to search for and export your purchase requisitions for use in Fairmarkit.

{% stepper %}
{% step %}
Open the SAP ECC home page and search for *sq01*.\
This SAP ECC view allows you query data.
{% endstep %}

{% step %}
Click the **QuickViewer** button.\
The QuickViewer screen displays.
{% endstep %}

{% step %}
Enter a name (e.g., *pr\_fairmarkit*) for the query, and then click the **Create** button.\
The Create window displays.
{% endstep %}

{% step %}
Enter the following:

* **Title**: Enter a title for the query. (e.g . Fairmarkit PR query)
* **Data Source**: Select **Table join**.
  {% endstep %}

{% step %}
Click the green check mark at the bottom of the window.
{% endstep %}

{% step %}
Add two tables using the **Insert Table** table icon. Use the *EBAN* and *T001W* tables.
{% endstep %}

{% step %}
Right-click on the existing link between the two tables and select *Delete Link*.
{% endstep %}

{% step %}
Use your mouse to draw a link between the **WERKS** field in the two tables.
{% endstep %}

{% step %}
Click the **Back** button. It is located in the upper corner of your screen next to the SAP logo.

The QuickViewer: Initial Screen displays.
{% endstep %}

{% step %}
Move all of the fields from **Available fields** to **Fields in list.**
{% endstep %}

{% step %}
In **Export As**, select local file.
{% endstep %}

{% step %}
Select the **Selection Fields** tab, add the *Date of Last Change* field to the **Selection fields** column.
{% endstep %}

{% step %}
From the menu, select **Quickview > Execute > Execute** to execute the query.\
The query displays.
{% endstep %}

{% step %}
Enter the following information:

* **Program Selections**: Enter the data range to include purchase requisitions. Leave this blank to include all requistions.
* **Output Format**: Select **File Store**, and then enter the file name according to your Fairmarkit file pattern. Make sure to use the .csv extension.
  {% endstep %}

{% step %}
From the menu, select **Program > Execute**. Feel free to modify the maximum number of datasets to be read.\
The Transfer to a Local File window displays.
{% endstep %}

{% step %}
Select the **With column headers** option.
{% endstep %}

{% step %}
Click the **Transfer** button.\
The file with the data is saved locally on your computer.
{% endstep %}
{% endstepper %}

### Upload data to Fairmarkit Files <a href="#uploaddatatofairmarkitfiles" id="uploaddatatofairmarkitfiles"></a>

Use the following steps to upload your data to Fairmarkit. Within 15 minutes from uploading, your data will be available in Fairmarkit.

{% stepper %}
{% step %}
Login to Fairmarkit Files ([files.fairmarkit.com](https://files.fairmarkit.com/login)).
{% endstep %}

{% step %}
Add your file to the to\_fairmarkit folder for the environment (UAT, staging, or production) where you want to create your events.\
Example: *production/to\_fairmarkit/*
{% endstep %}
{% endstepper %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.fairmarkit.com/buyers/integrations/sap-ecc-integration/purchase-requisition-sync/export-purchase-requisitions-from-sap-ecc-manually.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.