# Export suppliers from SAP ECC manually

Using the following process, you can manually execute a query to retrieve supplier data in SAP ECC and then upload the data to Fairmarkit’s SFTP. Once uploaded, suppliers will be created or updated in Fairmarkit.

### 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., *supplier\_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 Supplier 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 LFA1 and ADR6 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 **ADRNR** field in the LFA1 table and the **ADDRNUMBER** field in the *ADR6* table.
{% 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 %}
From the menu, select **Quickview > Execute > Execute** to execute the query.\
The query displays.
{% endstep %}

{% step %}
In the **Output Format** area, 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: 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:

```
GET https://docs.fairmarkit.com/buyers/integrations/sap-ecc-integration/supplier-sync/export-suppliers-from-sap-ecc-manually.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.