topic remove key from field in Application Development and Automation Discussions

remove key from field

Former Member — Tue, 22 Dec 2009 04:49:12 GMT

Hi,

I have removed the key from master data table in sap bi system but while creating transformation I can still

see this field as key.

like costcenter , language are present in table as key

key unchecked for costcenter in master data table but while creating transformation I can still

view costcenter as key

please advise how to make key field as non key field so that it does not appear as key while creaing

transformation.

Regards,

Vivek

Re: remove key from field

Former Member — Tue, 22 Dec 2009 04:53:17 GMT

Hi,

Did u create the Table Maintenance Generator again after the change in Master Table? After any change the Table Maintenance Generator needs to be re-created to reflect the change.

Regards,

Bhavesh.

Re: remove key from field

Former Member — Tue, 22 Dec 2009 05:12:02 GMT

Hi,

Check whether the table is activated after the change. And delete your table maintanence generator and re create a new one.

Thanks,

Harini

Re: remove key from field

Former Member — Tue, 22 Dec 2009 05:16:06 GMT

You need to delete Table maintenance generator and create a new one.

Also , you need to check foregin key dependency of this field.

This field should not be used in any other table as foregin key.

Hope this helps you.

Re: remove key from field

Former Member — Tue, 22 Dec 2009 05:29:44 GMT

Hi,

What I should enter in function group in table maintenance generator??

Regards,

Vivek

Re: remove key from field

Former Member — Tue, 22 Dec 2009 05:33:36 GMT

Hi,

You can provide any name for the FUNCTION GROUP, mostly we just give the table name as the Function group.

SAP will create a Function Group, with the name that you provide, to include the code for maintaining the table.

Regards,

Bhavesh Solanki.

Re: remove key from field

Former Member — Tue, 22 Dec 2009 05:36:20 GMT

use the same name as your table name

Re: remove key from field

Former Member — Tue, 22 Dec 2009 05:38:14 GMT

Hi,

I have changed the given function grup as table name getting the message

You are changing a function group which does not belong to you

how to correct this??

Regards,

Vivek

Re: remove key from field

Former Member — Tue, 22 Dec 2009 05:45:57 GMT

Just click ok and continue with your saving operation.

Re: remove key from field

Former Member — Tue, 22 Dec 2009 05:53:03 GMT

Hi,

You can do one thing, Use transaction SE37 to create the function group and provide the name of this function group that

you create through Transaction SE37. Follow this path to create function group.

SE37

GOTO -> FUNCTION GROUP -> CREATE GROUP.

Also, just check if you have enough authorizations to create a function group.

Regards,

Bhavesh.