topic Re: Key Field in Append Structure in Application Development and Automation Discussions

Key Field in Append Structure

Former Member — Mon, 13 Jan 2014 17:59:06 GMT

Hi,

Can I have a custom field in an SAP standard table and make it a key field?

If yes, please let me know the steps for the same.

Thanks,

Neeraj

Re: Key Field in Append Structure

Former Member — Mon, 13 Jan 2014 19:26:03 GMT

Hi,

I don't think it is possible.

Martin

Re: Key Field in Append Structure

former_member235395 — Mon, 13 Jan 2014 19:32:51 GMT

Hi Martin,

I think, your can do the append structure and then, create a new index using your new field.

Regards,

Re: Key Field in Append Structure

Former Member — Mon, 13 Jan 2014 19:53:51 GMT

Hi,

You could create a index with the field, but the field won't be part of the table's key.

Martin

Re: Key Field in Append Structure

former_member235395 — Mon, 13 Jan 2014 20:18:45 GMT

Yeah, it's true!

But, will have a new index when do you want do SQL operations on Table.

Regards,

Re: Key Field in Append Structure

Former Member — Mon, 13 Jan 2014 20:20:49 GMT

I think Martin is right. If I add the field using append and create an index for that field, how will I have multiple values for the same?

E.g if I want to add year to MARA. I can append a structure with year but if I create a material valid for 2 separate years, how would year be a key field? How will this scenario work by an index?

Can anyone throw some light on that?

Re: Key Field in Append Structure

Former Member — Tue, 14 Jan 2014 05:08:55 GMT

Hi Neeraj,

Martins answer is correct. You can add additional fields to standard tables using APPEND structures but you can't make them as KEY fields to the same standard table.

Purpose of having APPEND structure is to add new fields, use as foreign keys, attach search helps, etc.

You can create an index using the APPEND fields but this will only be helpful(speed up) when reading data from that table.

So could you tell me why you want to make your append field to be a part of the key to the table?

Chaminda

Re: Key Field in Append Structure

former_member192854 — Tue, 14 Jan 2014 05:39:28 GMT

Maybe you can consider using the year in the value range of your MARA table - off course this will not inflict your 'old' data. But if you archive it, then in the end you can have the year embedded in the number range.

Re: Key Field in Append Structure

Former Member — Wed, 15 Jan 2014 19:01:29 GMT

The year is a part of our process and needs to be added as a key field for calculations of quantities. I know creating an Index would speed up the query part but that would not help in creating multiple entries of the same part in the table and the requirement is that.

Re: Key Field in Append Structure

Former Member — Wed, 15 Jan 2014 19:02:00 GMT

Can you please explain what you mean by value range in MARA table?

Re: Key Field in Append Structure

former_member192854 — Wed, 15 Jan 2014 19:35:55 GMT

Via transaction MMNR you can maintain the intervals. I suggest that when you change the interval each year to another 201300000000000001 201399999999999999 (this year into: 201400000000000001 201499999999999999). Then you don't need to have this additional year field.