Maintaining Filters

Maintaining filters in the SAP ECC or SAP S/4HANA on-premise refers to the process of configuring a precise set of values that you want to integrate with a particular SAP Ariba solution for a particular master data object. Filters are used to define a specific information, based on your requirement, for integration with any of the SAP Ariba Solutions. It's recommended to configure selection criteria to filter master data records to import for more than one SAP Ariba solution.

The Master Data records can be filtered with the following conditions:

Equality and Inclusion: Where Option is EQ and Sign is I.
Ranges and Exclusion: Where Option is BT and Sign is E.
Patterns and Comparisons: Where Option is CP and the Sign is I or E.

To maintain filters for more than one SAP Ariba solution, follow these steps:

Using the transaction code SPRO, navigate to Integration with Other SAP Components>Managed Gateway for Spend&Network for Buyer>Master Data Integration>General Settings>Maintain Filters.
Expand the Maintain Filters section and choose the IMG-Activity for Cross Application.
On the Prefilters – Cross Application Master Data screen, choose Modify.
Input the values in the following fields, as appropriate. Refer to the table provided in this lesson for guidance.
- Variable Name
- Field Name
- Type
- Number
- Variant
- Partition
- Sign
- Option
- Low
- High
Choose Save.

Parameter Name	Description	Supported Values
COMPANY_CODE_EXPORT	Configure a selection criteria to filter the company codes to export.	Variable Name: COMPANY_CODE_EXPORT Field Name: Field name that designates the company code in the table T001. Type: Enter S as the selection category. Number: 0000 Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ECC or SAP S/4HANA on-premise (for example, VREALM_2). Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ECC or SAP S/4HANA on-premise (for example, PREALM_2). Sign: Select as necessary. For example, enter I or E. Option: Select as necessary. For example, enter EQ, BT, and so on. Low: Enter the filter value for the criterion that you set for the field. High: Enter the filter value for the criterion that you set for the field. Blank if the option isn't BT.
MATERIAL_GROUP_EXPORT	Configure a selection criteria to filter the material group to export.	Variable Name: MATERIAL_GROUP_EXPORT Field Name: Field name that designates the company code in the table T023. Type: Enter S as the selection category. Number: 0000 Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ECC or SAP S/4HANA on-premise (for example, VREALM_2). Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ECC or SAP S/4HANA on-premise (for example, PREALM_2). Sign: Select as necessary. For example, enter I or E. Option: Select as necessary. For example, enter EQ, BT, and so on. Low: Enter the filter value for the criterion that you set for the field. High: Enter the filter value for the criterion that you set for the field. Blank if the option isn't BT.
PAYMENT_TERMS	Configure a selection criteria to filter the payment terms.	Variable Name: PAYMENT_TERMS Field Name: Field name that designates the company code in the table T052. Type: Enter S as the selection category. Number: 0000 Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ECC or SAP S/4HANA on-premise (for example, VREALM_2). Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ECC or SAP S/4HANA on-premise, (for example, PREALM_2). Sign: Select as necessary. For example, enter I or E. Option: Select as necessary. For example, enter EQ, BT, and so on. Low: Enter the filter value for the criterion that you set for the field. High: Enter the filter value for the criterion that you set for the field. Blank if the option isn't BT.
PLANT_EXPORT	Configure a selection criteria to filter the plant information to export.	Variable Name: PLANT_EXPORT Field Name: Field name that designates the company code in the table T001W. Type: Enter S as the selection category. Number: 0000 Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ECC or SAP S/4HANA on-premise (for example, VREALM_2). Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ECC or SAP S/4HANA on-premise (for example, PREALM_2). Sign: Select as necessary. For example, enter I or E. Option: Select as necessary. For example, enter EQ, BT, and so on. Low: Enter the filter value for the criterion that you set for the field. High: Enter the filter value for the criterion that you set for the field. Blank if the option isn't BT.
PLANT_PURCHASE_EXPORT	Configure a selection criteria to filter the plant and purchase organization information to export.	Variable Name: PLANT_PURCHASE_EXPORT Field Name: Field name that designates the company code in the table T024W. Type: Enter S as the selection category. Number: 0000 Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ECC or SAP S/4HANA on-premise (for example, VREALM_2). Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ECC or SAP S/4HANA on-premise (for example, PREALM_2). Sign: Select as necessary. For example, enter I or E. Option: Select as necessary. For example, enter EQ, BT, and so on. Low: Enter the filter value for the criterion that you set for the field. High: Enter the filter value for the criterion that you set for the field. Blank if the option isn’t BT.
PURCHASE_GROUP_EXPORT	Configure a selection criteria to filter the purchase group information to export.	Variable Name: PURCHASE_GROUP_EXPORT Field Name: Field name that designates the company code in the table T024. Type: Enter S as the selection category. Number: 0000 Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ECC or SAP S/4HANA on-premise (for example, VREALM_2). Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ECC or SAP S/4HANA on-premise (for example, PREALM_2). Sign: Select as necessary. For example, enter I or E. Option: Select as necessary. For example, enter EQ, BT, and so on. Low: Enter the filter value for the criterion that you set for the field. High: Enter the filter value for the criterion that you set for the field. Blank if the option isn’t BT.
PURCHASE_ORG_EXPORT	Configure a selection criteria to filter the purchase organization information to export.	Variable Name: PURCHASE_ORG_EXPORT Field Name: Field name that designates the company code in the table T024E. Type: Enter S as the selection category. Number: 0000 Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ECC or SAP S/4HANA on-premise (for example, VREALM_2). Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ECC or SAP S/4HANA on-premise (for example, PREALM_2). Sign: Select as necessary. For example, enter I or E. Option: Select as necessary. For example, enter EQ, BT, and so on. Low: Enter the filter value for the criterion that you set for the field. High: Enter the filter value for the criterion that you set for the field. Blank if the option isn't BT.