Despite having the standardized company procedures and centralized info shops furnished by SAP, Substantially corporate data nonetheless resides in spreadsheets. Taking facts in these spreadsheets and putting them into SAP remains among the list of thorny troubles going through quite a few company IT departments. Several business enterprise departments are
throwing away assets in manually reentering this data into SAP though introducing errors because of guide facts entry. Purposeful and technical analysts from the IT departments are inundated with requests from enterprise buyers to automate the upload of Excel details into SAP.
o Are you an SAP enterprise person looking to lower manual data entry for mass uploads or mass adjustments to SAP details, specifically when the information currently exists in Excel?
o Are you an IT functional or specialized analyst on the lookout for tips on how to company the end-user requests for details uploadd a lot more correctly?
o Will you be in search of ways that your business can help save time and assets in SAP details management?
Should you answered “Of course” to any of the above mentioned issues, then this informative article is to suit your needs. This article describes seven best practices in automating the add of Excel
details into SAP. Adopting these most effective practices will ease lots of the pains that company consumers and IT analysts confront in uploading Excel details to SAP.
1. Keep away from Programming. With all the several non-programming decisions available to hook up Excel and SAP, custom made programming in ABAP or VB really should be the absolute last resort for advertisement-hoc uploading Excel details to SAP. Don’t just programming is
high-priced and time consuming, a system that could be utilized just once or even every year is especially wasteful. Additional, developing robust programs demand a fair bit of tests and when a application has not been properly-examined, it may be unsafe and induce irreparable facts injury.
Use a scripting or a non-programming technique as much as is possible. SAP presented equipment for example BDC, CATT, LSMW, and third party instruments which include Winshuttle’s TxShuttle will allow you to avoid programming to a large extent.
2. Do not Add Straight to SAP tables. While this stage is quite clear, it
can not be overemphasized. Producing directly to SAP tables avoids all the info
validation and checks and balances that happen when producing info in the
normal SAP transactions. So, prevent employing any approach that writes straight to SAP
tables.
Generally add facts by using the pre-configured SAP transactions or BAPIs. Once again,
making use of instruments including BDC, CATT, or LSMW, or TxShuttle enables the upload of
information via SAP transactions instead of producing on to SAP tables.
three. Pick a File, Map, and Operate system. A record, map, and run strategy
frequently will involve initially recording an SAP transaction where by details needs to be
uploaded. The recording move is accompanied by a mapping phase in which the SAP data
fields captured in the course of the recording are mapped to your Excel fields. Eventually,
the transaction is run repeatedly yet again with different rows of data in
the Excel file. A Document, Map, and Run strategy is analogous to recording and
managing macros for automating regimen tasks.