How to delete a material completely?
Try MMDE transaction but be careful this will remove all material from Client.
What is the use of Tables in MM. i.e. How the tables get created?
Through SE11 you can create a new Table. In MM if you create a Material Master MARA, MARM, MARC,MARD, MBEW & MVKE will updated. In Vendor Master LFA1, LFB1 & LFM1 will be updated. The same applies to EKKO,EKPO for P.O, MSEG & MKPF for MIGO & RBKP for MIRO.
If in any error, only the message no. ! or the table no. is shown , then how to resolve the error using message no. or table no.?
Contact ABAP or BASIS person to resolve this.
How to create new transaction codes?
In transaction code SE93 you can create, Change & Display a Transaction Code.