Mass Publish of Suppliers

[Former Member]

Hello Experts,

Sytst SAP Sourcing wave 7.

I have requirement of migrating suppliers to Sourcing by upload using stanadard excel template. However, after uploading these suppliers to soucing we also need to publish all suppliers to ECC. I see no provision of triggering a 'mass publish' in Sourcing. Could you please help me to figure out if there is any way to achieve this or any work-around?

Best Regards,

Amit

[Former Member]

Hi

Since SAP ECC is the primary source of all master data including vendor master therfore there is no mass publish option available for suppliers.

Workaround could be to create a custom script to generate XML export of all the necessary supplier fields and sent it to ERP via FTP. In case you are looking to do this at regular intervals (not advisable) , job can be scheduled to send data at predetermined frequency.

Regards

Mudit Saini

[Former Member]

Thanks, Mudit.

We are indeed planning it as a 'one time activity' & exploring the possibility to generate xml using script. We are looking for following -

1. If there is any apis which I should be using to generate XML?

2. How can I send that XML files over FTP?

Best Regards,

Amit

[Former Member]

Hi Amit

For FTP transport you need to set up a shared folder (on same server as e sourcing or on seperate server ) accessible to ECC and e Sourcing/ CLM. If you have implemented integration, you can go and check FTP settings in System Setup-> Scheduled Task.

Since it is a one time data export, you can also retrive the data in the form of a report or csv/ flat file using scripting and send it over to ECC team . This would not require use of FTP folder and easier. However do make sure you keeping a record of the same at your end.

Regards

Mudit Saini

[Former Member]

Hi,

Please note if the vendor integration from Sourcing to ERP expects response back to update the ERP ID of Vendor in SAP Sourcing. if you are using the xml publish approach, try using some configure ERP vendor name ranges where you can pass the ERP ID for Vendor and make Sourcing state what is its ID in ERP.

Not sure if there any IAPI existing around "Publish to ERP" for vendor. if yes you can use it or request SAP for providing it explaining your case in an OSS message.

Thanks, Baski

[Former Member]

Hi Baksi,

Thanks for you response !

Could you please elaborate on your following comment-

"try using some configure ERP vendor name ranges where you can pass the ERP ID for Vendor and make Sourcing state what is its ID in ERP."

It would be great help if you explain what configuration options do we have on Sourcing or ECC side to synchronize the number range between Sourcing and ECC vendors?

Best Regards,

Amit

[Former Member]

Hi,

I am by no means an expert in ERP. How ever what I know is ERP there is way you can say for vendors of particaluar vendor account category, you can say IDs can be set by an extenal systems or by an user explicitly, without ERP dermining the ID. ERP guys in your team may know this better.

In SAP Sourcing side, you can create a vendor ventor account (under setup>master data) and set the account number range to be "External"

Thanks

Baski