DATA

[Former Member]

can we do both Data Manipulation as well as Data Extraction for standard tables by means of Table Maintenance Generator or is it intended for only ztables.

[Former Member]

Hi Sandeep

For standard tables you cannot do DATA MANIPULATION unless for that table DISPLAy/MAITAINANCE ALLOWED is selected in the table attributes, but you can do DATA EXTRACTION by using Table Maintainance generator.

Open a standard table , goto table maintainance generator you can see that only DISPLAy is enabled and CREATE ENTRIES is disabled.

Pls Reward if help full.

Regards

Lakshman.

[former_member188770]

Hi ,

This access depends on the type of maintaince status maintained for the Table / View .

when you display the view/ table (for which the table maintainence is gereated) you will find a tab 'Maintainance status'

Here the following status can be defined

read only

read, change, delete and create (default setting)

read and change

read and change (time-dependent views)

Generally for customizing tables / views , you can create / change/ delete.

So table maintainance access does not depend on whether it is a Z table /view or a standard table / view , but the 'Maintaince status ' is has.

For example for a Z table also you can only restrict maintainence to 'read only '.

Check the below link for more details

http://help.sap.com/saphelp_47x200/helpdata/en/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

Hope this helps.

Reward points if helpful.

Thanks,

Poonam.

[Former Member]

Hai Sandeep,

We cann't do data manipulation in Standard tables using Table Maintenance Generator.It was only applicable for 'Z' tables.

Suppose ,if u try to do manipulations data in standard tables it asks for access key..

do one thing ....goto <b>se11</b> give standard table name...in that goto <b>utilities</b> in Menu bar and select <b> Table Maintenance Generator</b> and click , it opens another screen and it ask for Authorization group and <b> Fun group </b>, if u give ur Fun Grp and u press it ask for Access key.

Reward points if it is helpful.

withregards

Lokesh

Edited by: Lokesh rao on Apr 4, 2008 11:21 AM