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
- Open App Export Master Data-Products.
- Maintain a selection criteria using the option "Select Specific Fields".
- Select Products for a Particular Plant.
- Press Export.
- Open Excel file.
Cause
Indicator 'Use Selection Criteria as Filter' is not marked.
Resolution
If selection criteria needs to be applied as a filter for the resultant export file, mark the Use Selection Criteria as Filter indicator.
Example:
Enter 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 |
AB00001 | 0001 |
AB00002 | 0001 |
AB00003 | 0001 |
For AB00001 only the plant 0001 data is exported.
See Also
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