Open the attachment and fetch the vendor data and paste in separate sheet

[former_member615046]

Dear Techies,

We are receiving requests from SAP SOLMAN. Every time we receive more number of Vendor creation requests. I have created an Universal LSMW template which can be used for all country vendor creations.

Now my question is, is it possible to get all the vendor creation requests with request numbers under one seperate excel sheet by using any scripts. that script should fetch the vendor creation data's of each and every requests. Is it possible..??

Kindly share your thoughts and experiences.!

Thanks,

Senthil Kumar.S

[Prasoon]

Hi,

In Solman, seems users will be writing the information in the free text field in which every user may create in his own sequence/understanding and it will be difficult to generalize and convert to upload-able format automatically. If you have a centralised master data team and you are getting more requests, Instead of fetching the free text data and running the script, I would suggest the following:

• Create a custom table to maintain the vendor creation request with required fields.
• Create a custom program and screen where the user can input the required info and submit to the master data team. The request data should be saved in the custom table.
• Use a BDC program to create the vendor master from the request based on the data in the custom table.
• You can create the workflows as required.
• You may also think of interactive adobe forms, if you have the license.

Regards,

[former_member615046]

Hi Prasoon,

Thanks for the reply.. Can you explain about Custom table and Custom program please..?