07-29-2008 3:00 PM
Hello,
If i delete MARA table is it deleted in database or application layer ?
07-30-2008 4:50 AM
Hi Bobby,
Deletes lines in a database table . You can specify the name of the database table either in the program itself with DELETE FROM dbtab u2026 or at runtime as the contents of the field dbtabname with DELETE FROM (dbtabname) u2026 . In both cases, the database table must be known in the ABAP/4 Dictionary. If you specify the name in the program, there must also be an appropriate TABLES statement. Only data from the current client is usually deleted. You can delete data using a view only if the view refers to a single table and was created in the ABAP/4 Dictionary with the maintenance status u201CNo restrictionu201D.
Hope it helps,
Thanks,
Vijay Duvvada
07-29-2008 3:01 PM
hi,
welcome to SDN.
It will be deleted from the database and the dictionary. Because a table means deletion of its all data and the definition. The data are store in database and definition in the ictionary. since the dictionary resides in application layer hence it will be deleted from both.
regards,
Anirban
07-30-2008 8:02 AM
for deletion of MARA table can i take any permission from Basis people and how to delete please let me know?
07-30-2008 8:05 AM
??? why u want to delete MARA Table..it is the back bone of MM module..seems very strange....
07-30-2008 8:45 AM
as a basis guy, u will be provided with an access key, enter that when sap prompts u while deleting the standard tables.
But this is just a procedure, never try doing this as this can affect production scenario.
Thanks!!
Rahul
07-29-2008 3:02 PM
07-29-2008 3:03 PM
All the tables are stored in another database table.
So, if you delete a table, an entry from the DD02L along with so many other dependent tables will be deleted.
If your question is deleting a table, yes the changes are affeceted at a Database level.
Regards,
ravi
07-29-2008 3:55 PM
07-30-2008 4:46 AM
HI
It will be deleted from the Data Base only but you cannot acces any values of the table from the LOGIN client (200) but if you want you can copy teh table from super client(000) to your client. But the data is lost.
Regards
Pavan
07-30-2008 4:49 AM
07-30-2008 4:50 AM
Hi Bobby,
Deletes lines in a database table . You can specify the name of the database table either in the program itself with DELETE FROM dbtab u2026 or at runtime as the contents of the field dbtabname with DELETE FROM (dbtabname) u2026 . In both cases, the database table must be known in the ABAP/4 Dictionary. If you specify the name in the program, there must also be an appropriate TABLES statement. Only data from the current client is usually deleted. You can delete data using a view only if the view refers to a single table and was created in the ABAP/4 Dictionary with the maintenance status u201CNo restrictionu201D.
Hope it helps,
Thanks,
Vijay Duvvada
07-30-2008 5:31 AM
Hi Bobby,
Its deleted from Database.
One thing are you deleteting contents of table or table itself.
if its table (se11--->table name shift+f2)I guess you need access key for the same and if its ides on your PC than you can try otherwise if its a dev please avoid and try to find some other way around,
Mohinder
07-30-2008 6:29 AM
Hi Bobby,
Any object that is created in sap is stored in the database layer of the R/3 system.So if you delete the table ,it is deleted from the database & it is difficult to retrieve the table with the same entries.
MARA being a standard SAP table, modification to it would require an acess key.
Best of luck,
Bhumika
07-30-2008 7:40 AM
07-30-2008 8:40 AM
hi bobby,
As far as the conceptual things go, the table will be deleted from the database which in turn means from the dictionaru,
The dictionary is stored in application layer, and there is no meaning of removing a table from application layer coz there is no such table existing there, only the dictionary is what exists there.
But, i am not very sure if as a developer u can delete standard tables especially MARA which is the master table for all materials.
Thanks!!!
Rahul
07-30-2008 5:20 PM
When SDN deletes a user ID for asking too many interview questions and not using the search because the person did not read [the rules|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/rulesofEngagement] then the ID is deleted from the database. However, it takes a few minutes for this to become visible as a Guest on the application layer due to caching.
Here is an example: . If you are fast enough, you can still see this caching effect taking place as we speak.
In many cases, you can also just try it yourself and see what happens. In this case (deleting the whole table), it is less recommended to test this just to see how it works and you should perhaps consider telling your interviewer that he / she is a fool. Not a very good career move, but at least honest.
Cheers,
Julius