Custom Excel Upload for SAP By Design
Introduction
Custom excel Upload templates makes uploading mass data into SAP By Design easy at click of a button without signing in to By Design system. As SAP Partners, ERP Logic has designed and delivered custom excel templates for multiple Business Processes.
Benefits
The customized framework has the following advantages.
- Friendly row wise user key in or Copy Paste approach replacing SAP standard column wise inputs.
- Combining query/write/update of multiple objects whenever necessary is possible
- Tool can be framed for any standard / custom web service created for SAP objects.
- Apart from SAP standard covered scenarios, other custom scenarios can be handled e.g., Inter-company JEV, collaboration email update etc.
- Selection of Input values can be user friendly and given as drop downs wherever applicable
- Mass upload of data can be done within minutes
- Item and header parameter automation in easier way can be added as and when needed like configuration.
- Response capturing along with transaction validation to confirm success and failure of records.
- Auto indexing feature.
- Enriched features like availability stock check/credit block and many other By Design decision making features can be incorporated in the tool before pushing the record.
- Data validation checks which prevent user from doing manual errors.
- Color code-based success/failure log with meaningful failure messages.
- Hard stop of upload functions in case of wrong data/ missing mandatory parameters.
- Easy debug features and issue fix facilities.
- Proven and used by many customers across the globe.
Stock Transfer Excel Tool:
- The basic function of the tool is to upload bulk stock transfers to SAP By Design.
- The customized Stock transfer excel upload tool is faster, unique with customer specific validation, restrictions, drop down values collaborated with SAP standard reports.
- Multiple substructures update facility, bulk transfer, user friendly interface, Data/transaction creation checking facility, row wise easy approach and used by many customers.
Image Upload Tool:
- The basic function of Image upload tool is to read master data specification image data (Product/Business partner etc.) from test and update the same in production automatically to avoid manual activity.
- Tested with image type .JPG/.PNG.
- The customized Image upload excel upload tool is faster, unique with customer specific validation, restrictions, drop down values collaborated with SAP standard reports.
- Multiple substructures update facility, bulk transfer, user friendly interface, Data/transaction creation checking facility, row wise easy approach and used by many customers.
Quality Upload Tool:
- The basic function of quality upload tool is to read multiple layered quality testing team, parameters, and sub parameters and create quality inspection transactions in to By Design system to avoid manual activity.
- Quality team/parameters/sub parameters can be added dynamically and can be viewed in tool like configuration.
- The customized transaction tool allows multilayered loops and updated parent child architecture.
- Multiple substructures update facility, bulk transfer, user friendly interface, Data/transaction creation checking facility, row wise easy approach and used by many customers.
Conclusion : The custom excel uploads has transformed the traditional approach and has many customer success stories of customers using the functionality.user friendly custom tools can be developed for any SAP enabled object with validations.
Q&A : Feel free to write back to the post via Q&A section.
