Material replication from R3 to CRM

[Former Member]

Hi,

I am trying to replicate materials from R3 to CRM.

I maintained product hierarchies in CRM similar to R3.

The initial load is done for all the 36 customizing objects specified by SAP Best practices including

DNL_CUST_PROD0, PROD1, PROD3, SPROD and DNL_PLANT.

Whenever, I try to replicate materials through initial load of "MATERIALS" , the adapter object is processed successfully in R3AM1. I have significant amount of data in "Block" also.

Also, i can see that BDoc's are generated successfully in SMW01 transaction.

However none of the R/3 materials are replicated as products in the table "COMM_PRODUCT".

Your suggestions are most welcome. ( Surely, points will be awarded for all the relevant answers...)

Thanks,

Aaru

[Former Member · Accepted solution]

Hello Aaru,

- Are there any erroneous BDoc in txn:SMW01.If yes whatz the error message says?

- Did you check the download status of object MATERIAL in txn:R3AM1?Is it in status 'Done' or 'Running'?

- Please check for the filters set in txn:R3AC1 for object MATERIAL

- Are any queue like R3AI_MAT* de-registered in txn:SMQR ?Also you can check in txn:SMQ2 for presence of waiting queues.

Hope this helps!

Best Regards,

Shanthala Kudva.

[Former Member · Accepted solution]

Hi ,

Thanks for ur inputs

1. There are no erraneous bdocs in txn SMW01. The generated Bdocs are showing processed successfully with green.

2.R3AM1 indicates Done with green.

3. I have used several combns of materials as filters. And also tried w/o filters. Even without filters it is running successfully with more than 1000 Blocks and finishes successfully. However no entries are created in the table "COMM_PRODUCT".

4. All queues are registered in SMQR. and thr are no waiting queues.

Is there anyother way??

Thanks,

Aaru

[Former Member · Accepted solution]

Hi Aaru,

Ok.Can you check the contents of the BDoc in txn:SMW01.

Are they empty BDocs without data or data exists.

If data exists then,it should have made an entry in CRM tables.

Secondly,is there any BADI in R/3 or CRM.

Please check.

Best Regards,

Shanthala Kudva.

[Former Member · Accepted solution]

In txn SMW01 if iI click on "Show BDoc trace",it is showing

Start of initial load

Start of data processing

End of initial load.

1.How can i check the data(Material number) of the BDoc type PRODUCT_MAT?

2.We havent activated any Badi in R/3 or CRM.

Thanks,

Aaru

[Former Member · Accepted solution]

Hello Aaru,

In txn:SMW01,select the PRODUCT_MAT BDocs and click on 'Show BDoc Message Ext.Data' tab.

You can see that data.If you enter Shift+F7 or click on tab 'Single Entry' you can see the data in detail.

Please check.

Best Regards,

Shanthala Kudva.

[Former Member · Accepted solution]

Hi Shanthala,

Thanks for your suggestions.

In SMW01, If I click on "Show Bdocc message Ext.Data' icon, i am getting the following line.

"No extended data for BDOC message "aaaabbbbccccddddeeeeffffgggghhhhiiiijjjj" found.

Also, if i reprocess a bdoc thru Shift+f7 then it is not reprocessing ( since the bdoc status is already in Green)

Can you please tell me wht and all table entries need to be maintained for successful replication of materials??

Thanks,

Aaru

[Former Member · Accepted solution]

Hello Aaru,

"No extended data in the BDoc " means that there is no data getting stored in CRM.

But cannot be sure whether data has got transferred correctly from R/3..!!!

Please check the following options:

- In CRM txn:R3AC1,are there any filters set for obejct MATERIAL?

-Are any R3AI_MAT* de-registered in CRM txn:SMQR

- Are there any waiting queue entries in txn:SMQ2 of CRM?

- Are there any user exits on R/3 side?If yes,please turn them off and try once again.

Best Regards,

Shanthala Kudva.

[Former Member · Accepted solution]

Hi,

Thanks again shanthala for ur help.

-There are no filters currently set for the adapter object MATERIAL

-I have registered all the inbound queues in SMQR ( Other adapter objects like BP is getting replicated)

-There are no waiting queues on SMQ2.

-I am not sure of whether some user exits are implemented in R3. How should i check it and turn off?

Also, we are integrating R3 (4.6B) with CRM6.0. Is there any SAP Notes needs to be applied for this?

[Former Member · Accepted solution]

Hi Aaru,

There is no specific note required for material replication.

Can you check the entry in R/3 table TPS32 for APPLK=BC-MID ? You would get a hint for user exit.

Are you good at debugging?If yes,I will guide you the steps.

Best Regards,

Shanthala Kudva.

[Former Member · Accepted solution]

Hi,

No entries exist on R/3 table TPS32 for APPLK=BC-MID .

Please guide me with the steps for debugging. i will chk it once.

Thanks,

Aaru

[Former Member · Accepted solution]

Hi Aaru,

Lets check the data in CRM first after data extraction from CRM:

- Deregister the R3AI_MAT* queue in CRM txn:SMQR(Hope you are doing an initial load.Correct?)

- Trigger the initial load in txn:R3AS for MATERIAL

- Goto txn:SMQ2 and select the queue entry R3AI_Mat* and click on 'Debug'.

-Shift+F7 to put a break poing in FM:COM_MAP_BAPIMTCS_TO_PROD_MAT

COM_MAP_BAPIMTCS_TO_PROD_MAT

MAP_BAPIMTCS_TO_MBDOC

MAP_DATA_AND_SET_UP_DTYPE

- Check the BAPI structure there.

Hope this helps!

Best Regards,

Shanthala Kudva,

[Former Member · Accepted solution]

Hi Shanthala,

Thanks for your quick helps.

There is some SAP Notes similar to this issue.

(OSS id # 582277)

Trying to apply it..

Thanks,

Aaru