topic Re: table maintenence in Application Development and Automation Discussions

table maintenence

Former Member — Wed, 29 Aug 2007 14:14:21 GMT

what is the use for table maintenence generator and where wil we use

plzz.

and also how to eleminate duplicate entries in internal table ?

Re: table maintenence

Former Member — Wed, 29 Aug 2007 14:16:54 GMT

Hi,

Table Maintenance Generator .

sm50 is the transaction for table maintainance generator it is used to add multiple entries in to the data base throw sm54 we can create table maintainace generator and some times ita is used for transporting also.

Well the purpose of table maintainence generator is to enable the table maintenance through SM30, and to implement and validation etc on table field inputs.

SE11->Utillities->table maintainence generator

You need to enter the values of following fields:

1. Table name

2. Authorization group , and authorization object (select the suitable one )

3. Function group and package

4. Maintainence type : single or double screen maintainence view depending on the option selected.

5. Maintain screen number : you may specify a value or let the system generate one for you.

The validation code for the table entry is written in the flow logic of this screen. Even some of the fields may be made display only , by adding suitable code in the logic or directly disabling the input in table control in the layout.

>> Activate

To elemeinate Duplicate entries:

Sort the internal table first then, use DELETE ADJACENT DUPLICATES FROM ITAB.

Then all the duplicate entries will be deleted

Regards

Sudheer

Re: table maintenence

Former Member — Wed, 29 Aug 2007 14:17:27 GMT

Hi Uttam,

Table maintenence is used to maintain the entries in table. Like adding, modifying and deleting etc. Goto SM30 to maintain.

For deleting duplicates:

Sort itab by key fields depending on what your criteria is to delete duplicates, then

Delete Adjacent duplicates comparing them.

SORT itab BY a , b, c.

DELETE ADJACENT DUPLICATES from itab comparing a b c.

Sri

Re: table maintenence

Former Member — Wed, 29 Aug 2007 14:19:17 GMT

Hello Uttam,

Use of table maintence generator..

Well the purpose of table maintainence generator is to enable the table maintenance through SM30, and to implement and validation etc on table field inputs.

SE11->Utillities->table maintainence generator

You need to enter the values of following fields:

1. Table name

2. Authorization group , and authorization object (select the suitable one )

3. Function group and package

4. Maintainence type : single or double screen maintainence view depending on the option selected.

5. Maintain screen number : you may specify a value or let the system generate one for you.

>> Activate

We can delete the duplicate entries in internal table as shown bellow...

sort itab.
delete adjacent duplicates from itab.

Reward If Useful.

Regards

Sasi.

Re: table maintenence

Former Member — Wed, 29 Aug 2007 14:20:04 GMT

T-code is SM30

if you want to enter data into database table you can go for se16 but there you can have access to enter record by record at a time

but in SM30 you can enter any number of records at a time

and total table maintance will be done under this

mostely we will use this for multiple data entry

reward if usefull

Re: table maintenence

Former Member — Wed, 29 Aug 2007 14:20:58 GMT

1. WHY Table Maintance ?

The MAIN purpose is to

allow ADD/EDIT/DELETE

of records in a TABLE.

2. Further to it,

thru table maintance generatro

and some extra work,

it is also possible to

use the events of it

and PUT SOME VALIDATIONS

while inserting / editing / deleting

the records.

3. The table maintance generator

uses the concept of function group

and AUTOMATICALLY GENERATES

THE SCREENS

BASED UPON THE FIELDS OF THAT TABLE.

HOW TO CREATE THE TABLE MAINTENANCE GENERATOR

Open SAP tables for direct maintenance

1 GO TO SE 11. ENTER THE TABLE NAME

2 GO TO UTILITIES - TABLE MAINTENANCE GENERATOR

3 GIVE AUTHERIZATION GROUP(&NC&)

4 GIVE FUNCTION GROUP and PACKAGE NAME

5 SELECT SCREEN NUMBER

6 SAVE

To delete entries in internal table.

sort itab by field.

delete adjacent duplicates from itab comparing field.

Re: table maintenence

Former Member — Wed, 29 Aug 2007 14:22:44 GMT

the purpose of table maintainence generator is to enable the table maintenance through SM30, and to implement and validation etc on table field inputs.

Here are the steps to create the table maitenance generator for a ZTable :-

1.SE11.

2.CHOOSE TABLE.

3.UTILITIES--->TABLE MAINT GENERATOR.

4.AUTH GRP : W/O AUTH.

5.FUNCTION GRP: PROJ DEPENDENT (SEE CREATE FUNC GROUP).

6.MAINT TYPE : 2 STEP.

7.MAINT. SCR NO. : CLICK APPL BUTTON | FIND SCR. NUMBER(S) |

8.CHOOSE PROPOSE SCREEN NO FROM POPUP.

9.REMEMBER OVERVIEW SCR NO.

10.CLICK CREATE BUTTON ON APPL TOOL BAR.

11.CLICK SAVE ON FUNC TOOL BAR.

12.GO TO SE93. TO CREATE TRANSACTION CODE.

13.WRITE SUTIABLE TRAN NAME..CLICK CREATE

14.CHOOSE TRANSACTION WITH PARAMETERS(LAST).

15.FILL SHORT TEXT.

16.OK

17.TRANSACTION : SM30.

18.CHECK SKIP INITAL SCREEN CHKBOX

19.SCREEN NO : FROM STEP 9.

20.IN TABLE BELOW

NAME OF SCREEN FIELD VALUE.

VIEWNAME [TABLENAME]

UPDATE X

21.SAVE

22.RUN TRAN CODE IN COMMAND BOX.

tcode is SM30

also see this

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8129f164-0a01-0010-2a8e-8765287250fc

regards,

srinivas

*reward for useful answers*