regarding VIEW

[Former Member]

Hi,

I faced some problem with table maintanance. Create maintainance of any table through sm30. but some table accepts the table maintainance. How can i find out no of tables maintanance tables in sap that means we change value of that table entry. Any table is there that table accepting the maintance. my not understand please reply me.

mohan

[Former Member]

Hi Mohan,

the tables which are allowing to maintain using SM30 are custom tables means created by any abaper starting with Z or Y.standard tables will not allow you to maintain through sm30.

like mara,vbap,vbak etc.but the main point you have to notice is the tables which are allowing to maintain through Sm30 have the property display maintenance allowed with restrictions or not allowed.check the tables in se11.there in delivery/maintenance tab you will find this.if the property is allowed with restrictions the basis people have to give some authrizations.not allowed means at any time nobody is able to maintain the data using sm30.

reward points if helpful.

[Former Member]

Hi Mohan

Firstly think of Table maintenance generator purpose for a table.

It allows user to enter multiple entries at once rather than entering single entry through utilities - tablecontents - create.

How to enter multiple entries means, just we can copy the data from excel and paste it in TMG of a table.

Just try this and feel free to contact me.

Reward me, if it works out.

Thanks

Suren

[vinod_vemuru2]

Hi Mohan,

When ever u create any data base table then one entry will be created in table DD02L with all the attributes of that table.

Just execute this table by giving ur table name in field

TABNAME. If this table is maintainable(In SM30) then in the field MAINFLAG u will get X else u will get space.

If u are developing some program then u can write simple select query to find out what are all the tables that are maintainable in ur system like below.

DATA itab TYPE STANDARD TABLE OF dd02L.

SELECT * INTO TABLE itab FROM dd02L WHERE MAINFLAG EQ 'X'.

Now ur itab contains all maintainable tables in ur system.

Thanks,

Vinod.

[Former Member]

hi Mohan,

i agree with vinod above, do as he suggested and you wil hav no problems whatsoever.

Moreover, do note that only those tables which begin with a Z or Y have a table maintainance for them as they are created by users. the standard SAP tables provided by SAP are not meant to be changed by a simple user as a lot of information might be associated with them.

But that doesnt mean they cannot be changed.

Do reward if helpful.