inserting records through Maintenance dialog

[Former Member]

hi all,

i have created a z table. now i want a maintenace dialog for it. i created maintenace dialog for it by going to the Utilities menu and selecting the table Maintenance generator. now when i go the maintenace dialog through sm30, i can only enter one record in the dialog. there are no buttons to create another record in the z table. when try to create a new record, it overwrites the previous record.

can anyone tell me what i am doing wrong? how can i enter more than one record in the table through maintenace dialog?

regards,

hamza

[Former Member]

Hi,

Actually it should not occur. Not sure why such issue is occuring.

A suggestion is to delete the maintenance generator and re-create it.

Hope this resolves your issue....

Regards,

Dilli

[Former Member]

Hi Hamza,

Can you tell what did you do in table maintanence generator. What options did you use. has the maintanence generation completed successfully.

I think the problem is with the table generation part itself. Just check with the table maintanence generator once again.

Hope this suggestion will be helpful. If any furhter queries, revert back to this thread.

Reward all the helpful answers.

Regards

Nagaraj

[Former Member]

hi

good

The followings are different types of views:

- Database View (SE11)

Database views are implement an inner join, that is, only records of the primary table (selected via the join operation) for which the corresponding records of the secondary tables also exist are fetched. Inconsistencies between primary and secondary table could, therefore, lead to a reduced selection set.

In database views, the join conditions can be formulated using equality relationships between any base fields. In the other types of view, they must be taken from existing foreign keys. That is, tables can only be collected in a maintenance or help view if they are linked to one another via foreign keys.

- Help View ( SE54)

Help views are used to output additional information when the online help system is called.

When the F4 button is pressed for a screen field, a check is first made on whether a matchcode is defined for this field. If this is not the case, the help view is displayed in which the check table of the field is the primary table. Thus, for each table no more than one help view can be created, that is, a table can only be primary table in at most one help view.

- Projection View

Projection views are used to suppress or mask certain fields in a table (projection), thus minimizing the number of interfaces. This means that only the data that is actually required is exchanged when the database is accessed.

A projection view can draw upon only one table. Selection conditions cannot be specified for projection views.

- Maintenance View ( SE54 )

Maintenance views enable a business-oriented approach to looking at data, while at the same time, making it possible to maintain the data involved. Data from several tables can be summarized in a maintenance view and maintained collectively via this view. That is, the data is entered via the view and then distributed to the underlying tables by the system.

Please have a look at below link. It will help you.

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

for more detailed info look on:

http://www.sap-img.com/abap/what-is-the-different-types-and-usage-of-views.htm

&

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abap+dictionary&;

Reward if helpful.

thank

mrutyun^

[Former Member]

thanks for the quick replies guys.

you were right,Nagaraj. the problem was with the generator itself. i was selecting the "No, or user, recording routine" option in the Recording Routine. When i selected the Standard Recording Routine, it worked fine. (But i dont know the reason for this).

Thanks once again, for setting me in the right direction.

regards,

Hamza