Solved: table maintainance generator

Former Member · ‎2007 Sep 11

hi thr

can anyone plz tell me whether we can a field in a ztable using table maintainance generator.if yes then how?

Former Member · ‎2007 Sep 11

The Table Maintenance Generator is used to create table maintenance program to add, modify or delete records in the database table. This can be accessed using transaction SE54 or in SE11 using the menu Utilities->Table Maintenance Generator.

U want to create a table maintenance generator or a new field to the table with maintenance generator???...question is not clear. If u r trying to create a new field to the table.. Its not possible...

Please reward points to the helpful answers...

Former Member · ‎2007 Sep 11

The Table Maintenance Generator is used to create table maintenance program to add, modify or delete records in the database table. This can be accessed using transaction SE54 or in SE11 using the menu Utilities->Table Maintenance Generator.

U want to create a table maintenance generator or a new field to the table with maintenance generator???...question is not clear. If u r trying to create a new field to the table.. Its not possible...

Please reward points to the helpful answers...

Former Member · ‎2007 Sep 11

Hi,

Table maintanance Generator is used to manually

input values using transaction sm30.The Table Maintenance Generator is used to create table maintenance program to add, modify or delete records in the database table. This can be accessed using transaction SE54 or in SE11 using the menu Utilities->Table Maintenance Generator

follow below steps

go to se11 check table maintanance check box under

attributes tab

utilities-table maintanance Generator->

create function group and assign it under

function group input box.

also assign authorization group default &NC& .

select standard recording routine radio in table

table mainitainence generator to move table

contents to quality and production by assigning

it to request.

select maintaience type as single step.

maintainence screen as system generated numbers

this dialog box appears when you click on create

button

save and activate table

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed2d446011d189700000e8322d00/content.htm

One step, two step in Table Maintenance Generator

Single step: Only overview screen is created i.e. the Table Maintenance Program will have only one screen where you can add, delete or edit records.

Two step: Two screens namely the overview screen and Single screen are created. The user can see the key fields in the first screen and can further go on to edit further details.

please check the link for getting information about table maintenance generator !

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=use%20of%20table%20maintenance%20generator&cat=...

http://www.sapdevelopment.co.uk/tips/tips_tabmaint_tcode.htm

http://www.sap-img.com/abap/create-a-table-maintance-program-for-a-z-table.htm

Regards,

Priyanka.

Former Member · ‎2007 Sep 11

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

regards,

srinivas

Former Member · ‎2007 Sep 12

Hi,

We can create a program through the table maintenance generator to add/delete/modify the records in the table, but it is not possible to add/delete/modify a field of the table.

If you are looking at adding/deleting/modifying the records then you can create an event as follows:

In the table maintenance screen of your table got to Environment --> Modification --> Events.

(ii)Select New entries & define the event.

(iii)Create a sub-routine.

(iii)Write the relevant code in the sub-routine thus created which takes care of the addition/deletion & modification of the records of the table.

Reward if useful.

Regards

Sayee

Former Member · ‎2007 Sep 12

Hi

Maintenance views

Maintenance views permit you to maintain the data distributed on several tables for one application object at one time.

A maintenance view permits you to maintain the data of an application object together.

The maintenance status determines which accesses to the data of the underlying tables are possible with the maintenance view.

Maintenance Status

The maintenance status of a view controls whether data records can also be changed or inserted in the tables contained in the view.

The maintenance status can be defined as follows:

Read only: Data can only be read through the view.

Read, change, delete, insert: Data of the tables contained in the view can be

changed, deleted, and inserted through the view.

Read and change: Existing view entries can be changed. However, records

cannot be deleted or inserted.

Read and change (time-dependent views): Only entries whose non-time

dependent part of the key is the same as that of existing entries may be

inserted.

Restrictions for Maintenance views

There are some restrictions for selecting the secondary tables of a maintenance view or help view. The secondary tables have to be in an N:1 dependency to the primary table or directly preceding secondary table. This ensures that there is at most one dependent record in each of the secondary tables for a data record in the primary table.

reward if usefull

Former Member · ‎2007 Sep 12

Hi,