Table view, how to create

[Former Member]

Hello Friends,

What is table view, how it is useful?... I have a table for which I want to create view.

What are the steps I need to follow to create a view for a table.

Thanks,

Shreekant

[former_member404244]

Hi,

cehck the below link..

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

Reward if helpful.

Regards,

Nagaraj

[Former Member]

HI

Table Maintenance generator is required to do Manual entries in the Table. If the requirement is to update the table only programmatically and not manually then table maint. generator is not required.

Manual entries in table can be maintained ( New record can be inserted / existing can be modified ) using transaction SM 30, if the table maintenance for the table is generated.

How to activate Table maint.

Goto SE11 and open the table.

Click UTILITIES -> Table Maint. Generator, Enter the details and click on Save. Then activate the table.

These are used to create small and low effort program to maintain a small volume of data, insuring whole respect of data specified in a table/view.

Look at Maintenance Views

generally, user doesnot have access to SE11...so they can't create table entries...

when u maintain a table maintenance view, users can go to SE30 and specify the name and can add/delete/modify the table entries...

You need to do Table Maintanence Generator......

1) Go to SE11 and check table maintanance check box under attributes tab.

2) Go to menu Utilities -> Table Maintanance Generator ->

Create function group and assign it under function group input box. You can enter same as table name for function group. Also assign authorization group default &NC& .

3) Select standard recording routine radio in table table mainitainence generator to move table contents to quality and production by assigning it to request.

4) Select maintenance type as single step.

5) Maintainence screen as system generated numbers this dialog box appears when you click on create button.

6) Save and activate table.

Then go to SM30 and enter table name.

chk a sample 1.

refer.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20im...

some more helps

Check out this thread:

http://help.sap.com/saphelp_erp2005/helpdata/en/a7/513520407a11d1893b0000e8323c4f/frameset.htm - a link for basics on Table Maintenance.

Also, Check out this weblog on table maintenance:

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance