topic Re: table maintenance generator in Application Development and Automation Discussions

table maintenance generator

venkatasap — Thu, 18 Feb 2010 07:23:32 GMT

Hi SapAll.

here while iam trying to create a table maintenance generator ,in delivery and maintenance tab(sell) i can see Data Browser as Display Maintenance allowed,not allowed,allowed with restrictions.

can any body explain me on what is the difference between all these 3.

and in the technical settings under the size category if i put 2 it says Data records expected: 22.000 to 88.000 but when i look at the other ztable for the same entry 2 there it says Data records expected: 6.800 to 27.000.

i also just want to know what for we use the indexes and append structure in real time scenarios.

regards.

Varma

Re: table maintenance generator

Abhijit74 — Thu, 18 Feb 2010 07:34:45 GMT

Hi,

It's better you search for a tutorial of TMG in Google as well as forum. You will get thousands of thread regarding this.

thnaks,

Abhijit

Re: table maintenance generator

Former Member — Tue, 23 Feb 2010 10:22:55 GMT

Hi Varma,

about your first question.

Maintenace allowed means that you can insert/delete/change recs even from SE16 transaction (you do not need the maintenance dialog generation).

Maintenance not allowed means that you can add/delete/change record from SE16.

Maintenace allowed with restriction....I really do not know

About your second question.

The number of records when you set the value "2" depends on the lenght of the table structure.

If table has only a few fields, you will see a larger numnber of records.

If table has lot of fields, the number of records will be less.

That value is only a statistical calculation that SAP performes using a standard amount of space, so dividing this amount of space by the lenght of the table structure, can produce different values.

Bye.

Re: table maintenance generator

Former Member — Thu, 25 Feb 2010 10:15:35 GMT

Secondary indexes are used for improving the performance i.e. a secondary index is created when we are using some non-key fields in your select query frequently. A secondary index internally forms a small table which holds the values of the fields specified in the secondary index. So, first the system will look for records in the secondary index and the performance improves.

Append structure is a technique to enhance the tables. Using append structure a table can be added with extra fields which is more relevant at customer's end. Hope your last 2 questions are answered..