cancel
Showing results for 
Search instead for 
Did you mean: 

MDM_CLNT_EXTR

Former Member
0 Kudos

Hello,

When i execute the MDM_CLNT_EXTR transaction to extract customer or materials then it always returns no data selected.I have put the material number in the selection .However it never seems to work.

Has anyone been able to extract specific material or customer using this tcode? Is there some additional notes to be applied?

Any experience with this tcode will be of great help.

Thanks,

Prashanta Ghosh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Prashanta

I guess there are 2 ways to handle this;

1: Since it returns 'No Data Selected'; kindly check the material availability in the Transaction code 'MM03'.

For customer & Vendor : XD03 & XK03 respectively.

2: When you use the Txn code 'MDM_CLNT_EXTR', after entering the Input, its recommended to save the value by clicking SAVE button in the menu and then perform 'START EXTRACTION'.

Hope this might help; Please feel free to revert to me for further clarifications.

thanks

Alexander

P.S.Kindly reward the points,if found helpful.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

I had already checked the data and had saved the variant before executing it. However I found that some setting were missing on ALE side to get this running.

I was able to extract customer,vendor using DEBMDM,CREDMDM message type.

I will outline the ALE Settings .

1 WE21 : Set up the port in IDOC Processing

2 SM59 : Set the RFC Destination to XI and check it.

3 WE20 : Create a partner profile with Partner Type LS (Logical System) for XI

Include the message types : DEBMDM, MATMAS, MDMRECEIPT

4 BD64 : Create a Distribution model with Sender as SAP and receiver as XI.

Include the message type DEBMDM,MDMRECEIPT,MATMAS,/SAPSSLL/MATMAS_SLL

5 Generate partner profile. This will generate it in the receiving system.

Following transactions are useful for trouble shooting any idoc issues

WE02, WE20 ,BD87,SMQ2,SMQ3 and SALE->System Monitor->trfc check

After sending the IDOC check in transaction WE02 the status of outbound IDOC.

If it is at Status 3 and you still do not see the IDOC in receiving system then it is held up in trfc. Check the transaction BD87 and Display IDOC. Goto button Display Relationship and it will show Role,ObjType,ObjectID. Double click on Role and see if there is any error . After the idoc goes into the receiving system it uses function module INBOUND_IDOC_PROCESS IN RECEIVING SYSTEM. This may not get called due to incorrect login .Check the login specified in sm59.

If there are no such errors and the idoc is just sitting in trfc then it means that trfc call has not been executed. You can execute it by calling program RSARFCEX.

The Transaction smq2 monitor the inbound queue

The transaction smq3 monitors saved inbound queue .

If after executing SMQ2 you see some idocs then it means they are still not processed by trfc.

The correct Status is 12(Dispatch OK) in BD87

The Status 03(Data passed to port) in BD87 means that trfc has not been executed.

Execute program RBDMOIND with check box display idoc not sent to see the idoc.

Execute RSARFCEX. To restart trfc.

Former Member
0 Kudos

Hi Prashant ,

First create a variant & save the variant In Block size you can decide the number of records u want to extract.

Again select the variant & start extraction.

You can check whether IDOC is created or not using WE05 transaction.