|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
Handling Data in Excel In-place Display Using BDS
By Satyajit Mohapatra, HCL Technologies Ltd
The article demonstrates data handling in excel in-place display using BDS with the help of a program. The demo program maintains the entries in a database table through an excel in-place display.
Excel is the conventional way of storing and maintaining data. Sometimes, user
prefers to display report output in specific MS Excel templates; which contain
logos, user specific table formats, engineering drawings, diagrams and macros.
The data modified manually in these excel templates may be again transferred to
SAP for processing.
integration is required due to various reasons like avoiding user training on
newly developed custom programs and screens, use existing data templates, data
integration with legacy system.
(Business Document Services) is a convenient option for excel integration as
user specific MS Excel templates can be stored in it. These templates can be
called in an ABAP program at runtime to display data. Also, the data modified by
the user in MS Excel can be read into ABAP program for processing.
The functionality will be demonstrated through a demo program. The program will display the content of a custom table in excel in-place display. The user can change the non key fields displayed and the modified contents will be updated to the table after validation.
Defining a B
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards