Need to upload material master data

[Former Member]

I need to create a custom screen and give the user a provision to enter material master data...so that the data should be stored in mm01 tcode in the respective tabs. 

Kinldy throw some idea of how can I achieve this requirement ?

Is it possible to create all the fields in one screen?

your help is highly appreciated

Thanks!

Moderator message: please do more research before posting, explain what you have tried so far when posting.

Message was edited by: Thomas Zloch

[Former Member]

I need to create a custom screen and give the user a provision to enter material master data...so that the data should be stored in mm01 tcode in the respective tabs. 

Kinldy throw some idea of how can I achieve this requirement ?

Is it possible to create all the fields in one screen?

your help is highly appreciated

Thanks!

Moderator message: please do more research before posting, explain what you have tried so far when posting.

Message was edited by: Thomas Zloch

[former_member213851]

Hi SAM,

You need to write a Zprogram and  write stmt for direct database update and then  use COMMIT WORK stmt in it to write changes to database.

Eg:

     MARA-BRGEW = P_BRGEW.

     MODIFY MARA FRO MMARA .

     COMMIT WORK.

If large number of records needs to be uploaded then you can have Filepath on selection screen to update data in database via Excel /text file.

eg:

WHERE gt_outab contains the details uploaded via  Excel /text file using the FM GUI_UPLOAD :

loop at gt_outab into wa_outab.

    MARA-BRGEW = wa_outab-BRGEW.

     MODIFY MARA FRO MMARA .

     COMMIT WORK.

endloop.

Regards Sachin