Material Master Replication R/3 to SRM

[Former Member]

Hello SRM Experts,

I am in a process of replicating MM from R/3 to SRM server.

This is not a new one,already some materials are loaded into SRM.

Ths issue what I am trying to understand is I have many materials,material Types and material groups added in R/3, but not all flowu2026

I just want to know if I add a new Material Type,Material Group and Materials on R/3 side how do I get them replicated?

What are the tasks that need to be performed on R/3 and SRM for their replication?

I have gone throgh the Blogs of material replication by Vipul,but this is not pointed.

In R3AM1 it is showing the below status...

Running DNL_CUST_BASIS3

Running DNL_CUST_PROD0

Running DNL_CUST_PROD1

Running DNL_CUST_SRVMAS

Done MATERIAL

Do I need to start the initial Load R3AS again?

Pls guide meu2026

Thanks

Arshad

[Former Member · Accepted solution]

Hello!

Check the system log in SRM and ECC system will see if any input queue or output stops. if yes enable it to complete the process (transaction SMQ1 and SMQ2).

You can also delete and start again but it's logical end queues that fails.

Regards

José Luis

[Former Member · Accepted solution]

Hello Jose,

Thanks for response...

I have made sure that i cleared all the queues in both systems

in SMW01 i found the below

________________________________________________________

Category for material group 4000 does not exist

Message no. COM_PRODUCT_API002

Diagnosis

If material groups are used in the SAP system, they must exist as categories in CRM/EBP before you import materials. When Customizing object DNL_CUST_PROD1 is imported, the material groups are imported automatically and created in the category hierarchy R3MATCLASS (material group).

Procedure

Check whether the material groups have been imported successfully and exist as categories.

Proceed

If necessary, import the Customizing object DNL_CUST_PROD1.

________________________________________________________

I tried restarting the DNL_CUST_PROD1 but this gives me below msg

-

---

Please read the OSS Note no. 212666 (QUEUE_ALREADY_EXITS:R3AI_DNL_CUST_PROD1*)

Message no. SMOF160

-

---

now what to do..?

Arshad

[laurent_burtaire · Accepted solution]

Hello Arshad,

Try to delete running objects in R3AM1 transaction.

Do the same in SMQ2 for concerned queues.

Check also R/3 queues with SMQ1.

Then, run again intial transfer for product categories.

Regards.

Laurent.

[laurent_burtaire · Accepted solution]

Message posted twice

Edited by: Laurent Burtaire on Jan 22, 2010 2:34 PM

[Former Member · Accepted solution]

Hello Laurent,thanks for your responseu2026

how do I delete the running objects in R3AM1?

I tried to cancel them and they are in Abort status(Red).

I see the bewlow entries in SRM as Outbound Queues(SMQ1)

R3AI_DNL_CUST_BASIS3

R3AI_DNL_CUST_PROD0

R3AI_DNL_CUST_PROD1

R3AI_DNL_CUST_SRVMAS

Do I also detele these?

Pls suggestu2026

[laurent_burtaire · Accepted solution]

>

(...)
> how do I delete the running objects in R3AM1?
> I tried to cancel them and they are in Abort status(Red).
> (...)

Being in canceled status, it should be OK.

>

(...)
> I see the bewlow entries in SRM as Outbound Queues(SMQ1)
> R3AI_DNL_CUST_BASIS3     
> R3AI_DNL_CUST_PROD0      
> R3AI_DNL_CUST_PROD1      
> R3AI_DNL_CUST_SRVMAS     
> Do I also detele these?
> Pls suggestu2026

qRFC you mentionned must be in inbound queues ( SMQ2 ) as data come from R/3...

You have a garbage can icon: select row you want to delete by setting it, then click onto this icon.

Do same thing in R/3 for outbound qRFC.

Regards.

Laurent.

[Former Member · Accepted solution]

Hello Laurent,

I did the same as said by you...

I didnot find any outbound queues as you mentioned ...

again restarted the same again by using R3AS,now the below are in running status.

Running DNL_CUST_BASIS3

Running DNL_CUST_PROD0

Running DNL_CUST_PROD1

Running DNL_CUST_SRVMAS

and only material status is green done.,do i need to cancel this also and restart it again>?

Arshad

[laurent_burtaire · Accepted solution]

Hello,

If your qRFC remain in 'RUNNING' status, check OSS note 1147192 - RFC queues remain in the status RUNNING.

Concerning middleware, check OSS note 872533 - FAQ: Middleware.

Regards.

Laurent.

[Former Member · Accepted solution]

Hello

Sorry for answer now but weekend...;)

For the answer I assume that the RFC's are well established between SRM and ECC OK.

Check this steps:

1.- You make a Site in SRM for ECC of type "R/3"

2.- Check Table "CRMRFCPAR" in ECC with step note´s "720819"

3.- Execute Report in SRM "BBP_PRODUCT_SETTINGS_MW" with user CRM NOTE 720819

First with Service Product Active

Second Service Product Inactive

4.- Execute again R3AS in SRM

5.- Now tell me if there has been running queue

6.- If the answer if yes, tell me if the queue is in SRM or ECC. Too tell me if the queue is inboud or output / SMQ1 or SMQ2

Regards

Jose Luis

[Former Member · Accepted solution]

Hello Laurent and Jose,

Thanks for your responses,

I will need some time to check and let you know my finindings...

mean while i found the below queues as Outbound in SRM (SMQ1),is this correct?

R3AI_DNL_CUST_BASIS3

R3AI_DNL_CUST_PROD0

R3AI_DNL_CUST_PROD1

R3AI_DNL_CUST_SRVMAS

Arshad

Edited by: arshad ahmed on Jan 25, 2010 2:54 PM

[Former Member · Accepted solution]

Hello Gurus,thanks for your responses,

I was able to replicate the material Groups,...

Now stuck with the Material Type replication.

DNL_CUST_PROD1 is still running ststus

I could find the material group added in the hierarchy :R3MATCLASS,

when i checked inbound queues in SRM,i could find queue realted to Materiall master i created and it pointed me to smw01,

Smw01 error : Category for material type MAT_4ROH does not exist

now what do i need to do for replication of this?

Arshad

Edited by: arshad ahmed on Jan 25, 2010 5:13 PM

[Former Member · Accepted solution]

Hello Arshad

Yes check where are the queues...

Regards

[Former Member · Accepted solution]

I checked the,

they are on trhe SRM side as inbound queues...

R3AD_MATERIA0000000080 1

Arshad

[Former Member · Accepted solution]

Ok Ok...

Do as follows...

step1 : delete all queues

step2 : execute R3as only with "DNL_CUST_PROD0"

step3: when the queue "DNL_CUST_PROD0" is green step 4

step4: execute r3as now with "MATERIAL"

Fail now?

regards

[Former Member · Accepted solution]

Hello Alfie

DNL_CUST_PROD0 is already in green...

do i need to start again?

Arshad

[Former Member · Accepted solution]

Yes! but follows step by step...

tell me if works...

[Former Member · Accepted solution]

yes I did the same as told...but

when i started for material it says Hierarchy for material types does not exist

?

Arshad

[Former Member · Accepted solution]

hello

But you get run MATERIAL in R3AS?

check SMQ2 and tell me if the queue is "Sysfail"

Jose

[Former Member · Accepted solution]

No More waiting or Sys Fail Queues...

I am done

Arshad

[Former Member · Accepted solution]

Hi,

I am trying to replicate material from Backend (R/3). When I performing R3AS with object "DNL_CUST_BASIS3", the R3AM1 status Shows as 'Running' but when I am checking in SMQ1, the status is "SYSFAIL".

I performed all the necessary steps and I am not able to find where I have done the mistake.

Can you help me?

Regards

[Former Member · Accepted solution]

Hello Arshad/Laurent/Alfie,

I'm facing the same issue now...the queues for BASIS3, PROD0 and PROD1 are being generated as OUTBOUND queues in SRM;

and obviously, they are in error.

Arshad, Can you please suggest how did you take care of this issue?

I have verified all the parameters in the tables CRMRFCPAR, CRMSUBTAB, CRMPAROLTP & CRMCONSUM.

From the issue, I'm guessing that this is something to do with the wrong assignment of the source and destination systems.

Can someone please suggest how to identify & rectify that?

Eagerly awaiting your valuable responses...

[Former Member]

Thanks for the support...

Really Appreciate your responses

[Former Member]

Well!!!

Best regards José Luis