# Loading data in the SAP Connector for AppOne

> :::note
The information in this guide only applies to the **SAP Purchase-to-Pay Connector for AppOne** and **SAP Order-to-Cash Connector for AppOne**.
:::

:::note
The information in this guide only applies to the **SAP Purchase-to-Pay Connector for AppOne** and **SAP Order-to-Cash Connector for AppOne**.
:::

## Introduction

The input tables are used to load data into the SAP Connector. The following options are available to load data in an SAP Connector.

1. Connecting directly to the SAP database using the native SAP connection.
2. Loading `.csv` files that contain specific SAP data.
3. Loading data via an ODBC Connection.

### Setting the input type

In order to load data correctly you must set the input type in the SAP Connector.

:::note
By default the input type is set to ‘CSV’, which means the data is loaded from `.csv` files.
:::

Follow these steps to set the input type to use the native SAP connection or to use an ODBC connection.

| Step | Action |
| --- | --- |
| 1 | Open the SAP Connector in your development environment. |
| 2 | Go to the **Data** tab and select the **Connector_settings** table. |
| 3 | Double click on the `Input type` expression in the **Input** folder. |
| 4 | Switch the `Input type` to either `Const_Input_type_SAP` or `Const_Input_type_ODBC`.  See illustration below for an example. |
| 5 | Click on **OK**. |

   ![docs image](https://dev-assets.cms.uipath.com/assets/images/process-mining/process-mining-docs-image-57273-633518e5-e44812d3.webp)

## Limiting the number of rows

In cases where only a subset of the data is needed for analyzing or monitoring, it is recommended to limit the amount of data loaded, while this may improve the loading times. The number of rows that are extracted from SAP can be limited based on a date range. You can specify a start date in the `Extraction start date` expression and/or an end date in the `Extraction end date` expression in the **Output** folder in the **Connector_settings** table. See the illustration below.

   ![docs image](https://dev-assets.cms.uipath.com/assets/images/process-mining/process-mining-docs-image-54068-633f061b-10802b5c.webp)

:::note
By default, the `Extraction start date` expression applies a date filtering to only get data from the current year (starting at January 1st).
:::

See [Input Data of the SAP Order-To-Cash Connector for AppOne](https://docs.uipath.com/process-mining/standalone/2021.10/user-guide/input-data-of-the-sap-order-to-cash-connector-for-appone#input-data-of-the-sap-order-to-cash-connector-for-appone) or [Input Data of the SAP Purchase-to-Pay Connector for AppOne](https://docs.uipath.com/process-mining/standalone/2021.10/user-guide/input-data-of-the-sap-purchase-to-pay-connector-for-appone#input-data-of-the-sap-purchase-to-pay-connector-for-appone). In the **Filtering** column it is indicated which tables are filtered by the `Extraction start date` and the field that is used to filter (*Date*: `fieldname`).