I made the download creating a request via transaction R3AR2 but I have just looked at the filters on the material object via transaction R3AC1, and there is a lot of filter settings. Does those filters influence the request I created?
Filters that are set in txn:R3AC1 for the object would be applicable for all types of load including request load, delta load and initial load.
You can check tables CRMM_PR_SALESA CRMM_PR_SALESG for corresponding MVKE records of R/3.
What I could understand is that you have some problem with your filter conditions.
Hence forth, I would like to clarify the filter conditions and will try explain it to you how it works :
Case 1 :
In R3AC1 : Filter is VKORG : 1000
In R3AR2 : Filter is VKORG : 2000
On Request Download from R/3 to CRM, Data will get downloaded for the Request Filter.
Case 2 :
In R3AC1 : Filter is VKORG : 1000
KUNNR : 1000 - 2000
In R3AR2 : Filter is KUNNR : 1500 - 2500
On Request Download from R/3 to CRM, Data will get downloaded for KUNNR 1500 - 2500 with VKORG :1000 from R3AC1.
Case 3 :
In R3AC1 : Filter is VKORG : 1000
KUNNR : 1000 - 2000
In R3AR2 : Filter is VKORG : 2000
KUNNR : 1500 - 2500
On Request Download from R/3 to CRM, Data will get downloaded for KUNNR 1500 - 2500 with VKORG :2000 from R3AR2.
At the End of the Day, The filter works as follows :
1. SAME TABLE FIELD present in R3AC1 and R3AR2 :
Result : The filter conditions of request download will override the filter conditions of R3AC1.
2. DIFFERENT TABLE FILED present in R3AC1 and R3AR2 :
Result : The filter conditions of both R3AR2 and R3AC1 are considered and the data is filtered in the Request download. So , basically if the fields are different, THE AND condition is applied on the filter.
