topic Re: Table maintenance in Application Development and Automation Discussions

Table maintenance

Former Member — Thu, 13 Dec 2007 03:59:49 GMT

Hi,

I have to enter some records into a table.

This is possible if I have a maintenance view for that table.

I am trying to create one but while clicking on relationship after giving table name I am getting a message which says "No foreign key which can be used as a join is defined for the table."

Please suggest what could be done or anything alternative could be done.

Is there any means to find whether there is any maintenance view existing for a table ?

Regards,

Binay

Re: Table maintenance

Former Member — Thu, 13 Dec 2007 04:09:31 GMT

hi,

For maintaining entries in a table you have maintain a table maintenence generator. This is done as follows.

1.In transaction SE11 against the custom table go to utilities and select the table maintainence generator option.

2.Give authorization group as '&NC&'.

3.Give function group as table name itself.

4.Give your package name in package block.

5.Maintain screen numbe rby using propose screen option.

5.Press create button.

Now table maintenance is created.

You can go to SM30 and create a transaction for this table maintenence.

For creating a view you need minimum of two tables and there must be foreign key relationship between them(eg for VBK and VBAP vbeln is the foreign key).

Thanks,

Kasiraman.R

Re: Table maintenance

Former Member — Thu, 13 Dec 2007 04:39:58 GMT

Hi Binay,

For creating any type of view you need to have primary and foriegn key relation ship. Assaing a foriegn key for your table and try to create maintenace view. Foriegn key relation is noting but having same field i.e same datatype and domain and field values in both tables.

ex: if there is a ZCOMPANY table having fields empno, name , salary

and second table suppose ZDEPARTMENT table having fields , empno, dept, date.

in both the table empno is the comman field having same dataelement and domain and same field values are maintaind.

in Zompany-> empno is primary key where as in zdepartment-> empo is forieng key relation to zcompany.

if you want to create the maintence for your table just follow the steps posted eariler posted by one of the expert.

Hope this will clear your dbt.

<b>reward for useful answers</b>

Regards,

sunil kairam.

Message was edited by:

sunil kairam