16
Views
2
Comments
UPDATE 4 TABLES DYNAMICALLY VIA EXCEL FILE IN ABAP
Question

I have a requirement to update the values of only a specific field present in 4 Ztables via an excel sheet. This has to be done without specifying the table name in the selection screen.Also i have to show a success or failure log for this.


Can anybody provide me with a solution since all the solutions i see are all taking the table name in selection screen and also updating all the fields instead of updating a single one.


THANKS IN ADVANCE.

2019-05-16 13-55-52
João Henriques

Hi Pornita,


My understanding of your issue is that you need a solution for update a specific field for a specific record id and that specific field is present on 4 tables.
However the user cannot see the table names on screen, but will have a button that will call a action that will update those fields for a specific record in those 4 tables.

Is my understanding correct?

UserImage.jpg
Pornita Ray

Hi.


Your understanding is correct. Only we need to create a tcode which will take the excel file as input and press F8 which will update the values for the tables.

Also we have to display a log after updating the values.The log has to mention the table names for which the values got updated along with some other fields.


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.