SAP Knowledge Base Article - Public

3283793 - Selection criteria is not applied as a filter for the resultant export file in Export Master Data - Products App.

Symptom

Selection criteria is not applied as a filter for the resultant export file in Export Master Data - Products App.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP S/4Hana Cloud.

Reproducing the Issue

  1. Open App Export Master Data-Products.
  2. Maintain a selection criteria using the option "Select Specific Fields".
  3. Select Products for a Particular Plant.
  4. Press Export.
  5. Open Excel file.

Cause

'Use Selection Criteria as Filter' indicator is not marked.

Resolution

If you want your selection criteria also to be applied as a filter for the resultant export file, mark the Use Selection Criteria as Filter indicator. 

Example:
You have entered the following selection Criteria for a product:

Field    Operator    Value
Material Number (MARA-MATNR) contains    AB0000*
Plant (MARC-WERKS)contains    0001


If the Use Selection Criteria as Filter is not marked the following data is visible on the MARC - Plant Data tab:

SOURCE_ID WERKS
AB00001    0001
AB00002    0001
AB00003    0001
AB00001    0002
AB00001    0003


For AB00001 the plant 0001 data and also the plant 0002 and 0003 data is exported.

If the Use Selection Criteria as Filter is marked the following data is visible on the MARC - Plant Data tab:

SOURCE_ID  WERKS
AB000010001
AB00002 0001
AB000030001


For AB00001 only the plant 0001 data is exported.

See Also

SAP help portal link for the same

https://help.sap.com/docs/SAP_S4HANA_CLOUD/f86dc2eb1f8b48c880a7607213104b27/0041e0b5fc48496ca67157106eb341ea.html

Keywords

Select Products, Export Master Data- Products, Filter, Use Selection Criteria as Filter, LO-MD-MM, S/4Hana cloud. , KBA , LO-MD-MM , Material Master , Problem

Product

SAP S/4HANA Cloud all versions