Material transfer frailer in SMQ1.

[former_member560682]

Hello Everyone,

We are using extended classic scenario. We transfer data from R/3 to SRM but some materials are not able to transfer from R/3 to SRM and they are stuck in SMQ1 transaction.

So I am thinking that R/3 is transferring all the materials to SRM but SRM accepts only certain company code materials. So in SMQ1 we have material transfer frailer.

Is there any way that we can transfer certain company code data from R/3 to SRM?

Regards,

Khushbu.

[Former Member · Accepted solution]

For material replication always beeter to maintain filters such that only required materials will be replicated into SRM. There are filter tables to define the criteria. If you want any specific filters based on plant then define the relevant tables with filters. That way you can control the data.

Thanks,

Jagadish

[former_member560682 · Accepted solution]

Thanks Jagdish for your reply.

We want to filter materials based on plant so can you tell me which filter table I should see to set the filter? And on which side I should set the filter (R3 or SRM)?

I know that we can set the filter on SRM side to restrict the materials coming from the R3 through R3AC1 transaction. But here the issue is that we want to set the filter on R3 side because so many material transfer changes are failing to transfer in SMQ1 because R3 is sending everything.

Is there any way to filter materials on R3 side? Can you tell the steps in detail?

Thanks,

Khushbu.

Edited by: Khushbu Brahmbhatt on Dec 1, 2010 3:04 PM

[laurent_burtaire · Accepted solution]

Hello Khushbu,

There is no filter directly maintained in R/3: all filters are customized and generated in SRM for R/3 synchronization in CRMFILTAB table using R3AC1 SRM transaction. Maybe this synchronization is not correct.

Check is thread below could help you:

[Delta download and synchronization for materials|;

Concerning the use of MARC-PLANT as filter, it is not possible in standard. Indeed, MARC table does not exist among tables as filtering objects ( SMOFTABLES SRM table): did not check how to add MARC table.

Maybe, using method MAP_R3_TO_CRM_MATERIAL from BAdI PRODUCT_CUSTOMER2, you could cover your request: check import parameter IT_MARC.

Regards.

Laurent.

[Former Member · Accepted solution]

Check OSS note 497101 and it explains the same Badis as mentioned by laurent. By this you can do some enhancement to bring in MARC table in the filter and it is not an easy task.

Regards,

Jagadish

[former_member560682 · Accepted solution]

Thanks for the help Laurent and Jagdish.

After reading these I can understand now that we can only delete the SMQ1 entries once the material changes are failed to transfer.

So we can delete these entries by deleting each entry manually but is there any way we can write some code to clear these SMQ1 entries after every certain time(for example daily). If yes then where should I write code for this. Because we want to clear the entries in SMQ1.

Regards,

Khushbu.

Edited by: Khushbu Brahmbhatt on Dec 2, 2010 2:55 PM

[laurent_burtaire · Accepted solution]

Hello Khushbu,

Logical Units of Work for outbound queues are stored in TRFCQOUT table.

With a specific report, you could delete LUW with a 'SYSFAIL' qRFC condition, depending on date and time conditions (and other conditions if necessary).

To get more details about SMQS qOUT scheduler, check paragraph 7 from PDF file attached to OSS note 400330 - Outbound Scheduler-qOUT Scheduler.

Regards.

Laurent.

[former_member560682 · Accepted solution]

Thanks for the quick help Laurent. I will try this and post the update.

Regards,

Khushbu.

[laurent_burtaire · Accepted solution]

Hi again,

I just discovered standard report RSTRFCQDS for outbound queues deletion exists.

Have a look at OSS note 760113 - Delete unprocessed LUWs in the qRFC.

Regards.

Laurent.

[former_member560682 · Accepted solution]

Thanks Laurent. This is amazing solution for this problem. I think it will solve our problem.

Khushbu.

[former_member560682 · Accepted solution]

Hi Laurent,

Can you help me in understanding the below things?

When we set the filter in SRM the entries in the table CRMFILTAB will be generated for filtering the data at R3 side. Am I right?

Can you explain me how SMQ1 works?

I am thinking that R3 will try to send every material change update to the SRM. And it will go and check to the table CRMFILTAB and see the SRM filter specifications in this table. If it found that SRM does not want this change then system will fill these entries to SMQ1.

Am I right in my understanding? I want to know that how the SMQ1 is being populated?

Regards,

Khushbu.

[laurent_burtaire · Accepted solution]

Hello Khushbu.,

Filters behavior depends on wich sign you use for each one:

- if it is I (inclusive), then modified R/3 material will be transfered if filters cover its Material Master data (SMQ1 filled in),

- if it is E (exclusive), then modified R/3 material will not be transfered if filters cover its Material Master data (SMQ1 not filled in).

Check also if Inactive field is set or not.

Regards.

Laurent.

[former_member560682 · Accepted solution]

Thanks Laurent for the help. It is clear now.

[former_member560682 · Accepted solution]

Hi ,

In the R3AC1 transaction we have set up the filter settings based on MVKE table.

But in the Tables/structures within objects tab we have set this MVKE table inactive.

I want to understand that what is Inactive check box meance on this tab.

Thanks,

Khushbu.

Edited by: Khushbu Brahmbhatt on Dec 13, 2010 10:18 PM

[ricardo_cavedini]

Hello,

Have a look at the following notes. Perhaps they will be helpful.

872533

720819

Kind regards,

Ricardo

[Mustameer_Khan]

Hello,

Please go through the following links. These may be helpful.

Article: [Middleware Configuration and Monitoring for Master Data Transfer from SRM to ECC|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/309258e9-0da2-2d10-b598-bf27edb56a31?quicklink=index&overridelayout=true]

Blog: [How to replicate material master from R/3 to SRM|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/5728] [original link is broken] [original link is broken] [original link is broken];

Regards

Mustameer