Can anybody update,how to migrate and create 1000 specs using mass upload in SAP EHS.Is there any steps and process to upload through legacy system (spreadsheet) to create 1000 specs in SAP.Is there any steps for doing those uploading through LSMW or BDC.
Thanks and Regards,
C.Bharat Kumar Reddy
answer is "yes and no". LSMW or similar tools are used vary rarely to make uploads in EH&S. EH&S contains by it self a standard upload interface so normally LSMW is not used; further on tools like OCC are available on the top. Now in > 90% of the cases you need to perform "mappings" between old and new system structure. The reason is that normally the old system does have a different customizing set up in comparison to the new system and different phrases are used.
What does that mean? First important step in such a migration of data is therefore:
1.) analyse differenc in customizing (source target); included in this analysis is: is there the different in property tree?
2.) in most case there is a difference in used of phrases; therefore phrases need ot be mapped etc.
To use standard EH&S interface (export/import) is normally sufficient; the mapping steps are done different based on project and therefore different solutions exists.
Therefore the time consuming step is not the download (there is a standard EH&S export available as well) but the mapping
With best regards
PS: that means that EXCEL or other tools are in most cases not helpful to make down or uploads in SAP EH&S
PPS: Standard export / import is described here:
Tools (EHS-BD-TLS) Subchapter: Export / Import