Maintaining Filters

Objectives

After completing this lesson, you will be able to:

  • Maintain filters for the master data.

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:

  1. 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.
  2. Expand the Maintain Filters section and choose the IMG-Activity for Cross Application.
  3. On the Prefilters – Cross Application Master Data screen, choose Modify.
  4. 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
  5. Choose Save.
Parameter NameDescriptionSupported 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.

Log in to track your progress & complete quizzes