remove key from field

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi,

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

Regards,

Vivek

[Former Member]

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.

[Former Member]

use the same name as your table name

[Former Member]

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

[Former Member]

Just click ok and continue with your saving operation.

[Former Member]

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.

[Former Member]

Hi,

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

Thanks,

Harini

[Former Member]

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.