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

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

1

Open the SAP ECC home page and search for sq01. This SAP ECC view allows you query data.

2

Click the QuickViewer button. The QuickViewer screen displays.

3

Enter a name (e.g., pr_fairmarkit) for the query, and then click the Create button. The Create window displays.

4

Enter the following:

• Title: Enter a title for the query. (e.g . Fairmarkit PR query)

• Data Source: Select Table join.

5

Click the green check mark at the bottom of the window.

6

Add two tables using the Insert Table table icon. Use the EBAN and T001W tables.

7

Right-click on the existing link between the two tables and select Delete Link.

8

Use your mouse to draw a link between the WERKS field in the two tables.

9

Click the Back button. It is located in the upper corner of your screen next to the SAP logo.

The QuickViewer: Initial Screen displays.

10

Move all of the fields from Available fields to Fields in list.

11

In Export As, select local file.

12

Select the Selection Fields tab, add the Date of Last Change field to the Selection fields column.

13

From the menu, select Quickview > Execute > Execute to execute the query. The query displays.

14

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.

15

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.

16

Select the With column headers option.

17

Click the Transfer button. The file with the data is saved locally on your computer.

Upload data to Fairmarkit Files

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

1

Login to Fairmarkit Files (files.fairmarkit.com).

2

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/