topic Re: Table Contents in Application Development and Automation Discussions

Table Contents

Former Member — Fri, 23 Feb 2007 06:19:25 GMT

Dear Colleagues,

I have a table which is Customer specific. I would like to create entries in certain columns as default, so that the customer cannot change it. Also I would like to make only 1 column as editable.

ie Customers should be able to enter contents in only 1 column with default contents in the rest of the columns that should not be modified.

Example Contents in Column A and Column B are to be fixed and not to be modified.

Contents in Column C can be added. There are say only 4 fixed rows.

Can a view help here?.

How can I achieve this?.

Thanks for a quick info.

Regards,

Praveen

Re: Table Contents

Former Member — Fri, 23 Feb 2007 06:21:43 GMT

Hi,

In the table mark the <b>key and Initial check box</b> for those fields u dont want to alter.

Refer TCURC table for refernce see the MANDT and WAERS field.

Reward if this helsp.

Re: Table Contents

Former Member — Fri, 23 Feb 2007 06:38:44 GMT

Hi Praveen,

I dont think such a facility is available in SAP.

However I can offer a temporary solution.

1. Create an additional field in your Z table of type C (default value Space ).

2. Whenever you are inserting / modifying the table check whether C = space.

If the value of C is space, dont insert.

But for this you have to change the table structure and programs associated with the table,

All the Best

Ravi

Re: Table Contents

Former Member — Fri, 23 Feb 2007 06:39:02 GMT

Thanks! for the quick reply