Equipment master to upload to FTP - Methods

[Former Member]

Hello,

We have a requirement to upload the Equipment master file and changes / creations daily.

What is the best method to do it? Right now I have two options

1. Create an ABAP program to upload the initial file and delta changes daily
2. Run the transaction IE37 with a variant at background the get that file and send the file to FTP server. But I have a question about how to send the delta changes daily in this second option.

   Appreciate if anyone can give a feedback on this on the best and effective method.

Thanks,

Raneetha

[former_member196951]

1. to change a small numbers of Equipment, IE05/IE37 is suitable.

2. for mass equipments, it could be mapped with LSMW. identify the regular editable fields & make separate LSMW objects for different requirements (01 object for 3-4 fields i.e.Equipment no., FL, dismantled date/time etc).

[Former Member]

Praveen,

Thanks for the reply.  I need  to extract the changes in equipment masters daily and need to upload it to FTP server. May be I was not clear enough in my question. We need to upload all the equipment masters originally  to a FTP server and extract and upload the new equipment masters and changes to existing daily. 

Thanks,

Raneehta

[jogeswararao_kavala]

Hi Raneetha,

If I am correct, this as a requirement to update your web pages with the latest information of Equipment Master..

Decide a layout in IE37.

Daily download this IE37 output to an excel file on desktop.

Upload the same to your FTP server.

Means your webpage will be having excel web component and displaying this file you've uploaded to FTP server.

OR will be directly opening the excel file you have uploaded to FTP server, when a user clicks on the link.

Whatever said above is a manual way of doing it.

In case you are aiming a program to automate, I think ABAP communities will be better option to query.

Regards

Jogeswara Rao K

[jogeswararao_kavala]

The regular mass changes in Equipment master can be done through LSMW standard functionality (IE02 transaction)

OR

this can be done through another ABAP program ( using IE02 transaction), similar to the one you are using for Equipment creation (IE01).

Jogeswara Rao K