topic Re: maintainence view data getting duplicated in Application Development and Automation Discussions

maintainence view data getting duplicated

suba14 — Tue, 22 Oct 2019 05:42:41 GMT

i have a requirement that i need to edit some table field values through mainatainence view.

While achiving that the data is getting duplicated

Re: maintainence view data getting duplicated

former_member1716 — Tue, 22 Oct 2019 06:15:14 GMT

Hello suba R,

Can you explain your requirement more clear.

What do you mean by Duplicated? A standard table can never hold entries that are same?

Did you check the combination of Key fields, there must be a difference.

Regards!

Re: maintainence view data getting duplicated

Gourab_Dey — Tue, 22 Oct 2019 06:19:55 GMT

Hi suba R,

May be all the fields in the maintenance view is considered as key. Go to SE11 and check that.

You have to select the key fields of all the table involved first before selecting any non-key field. Else, entire field list will be considered as key.

For example, if you are creating a view on VBAK and VBAP, then you have to select the key of VBAK which is VBELN and then you have to include the key fields of VBAP which is POSNR(as VBELN is already include). Then only proceed for selecting of non-key field of VBAK and VBAP.

Hope this helps. Cheers!

Thanks,

Gourab

Re: maintainence view data getting duplicated

suba14 — Tue, 22 Oct 2019 11:10:28 GMT

it is a ztable

Re: maintainence view data getting duplicated

suba14 — Tue, 22 Oct 2019 11:11:19 GMT

i am creating for single ztable

Re: maintainence view data getting duplicated

Gourab_Dey — Tue, 22 Oct 2019 11:55:05 GMT

Why are you creating maintenance view on single Z-table. Simply you can create a "TMG" on the table.

Re: maintainence view data getting duplicated

suba14 — Wed, 23 Oct 2019 03:27:05 GMT

my requirement is like for some users i need to give Provide a authorization to edit the value of few fields alone.i need to Provide a sepate t-code for them.

Re: maintainence view data getting duplicated

Gourab_Dey — Wed, 23 Oct 2019 06:14:57 GMT

Please check the field list in the view. Select the key field first(including MANDT). Once you have selected key field, click "OK". Then again select the non-key fields. You are mentioning duplicate entry. It may be due to the "MANDT" field if you have multiple client in Dev system. Include the "MANDT" in the field list.

Thanks,

Gourab

Re: maintainence view data getting duplicated

suba14 — Fri, 25 Oct 2019 05:12:38 GMT

Hi Gourab,i am creating a selection screen for maintainence view to maintain few fields .in maintainenece view(se11) i have included mandt.

in sm30 i am not able see mandt..and also if i edit a field the value is getting duplicated like old value and new value

Re: maintainence view data getting duplicated

Gourab_Dey — Fri, 25 Oct 2019 06:05:19 GMT

Hi Suba,

Please share the screenshot of the tab "View Fields" of the maintain view. Also attached the screenshot of the duplicate values.

Thanks,

Gourab

Re: maintainence view data getting duplicated

ArthurParisius — Fri, 25 Oct 2019 06:16:04 GMT

In SM30 you normally never see the MANDT field since it will be filled by the system for the client your working in.

Re: maintainence view data getting duplicated

Jelena_Perfiljeva — Mon, 28 Oct 2019 19:31:50 GMT

What is the question? I'm confused...

It's impossible to create duplicate records with the same key fields. And SM30 (assuming that's what you used) won't allow duplicates.

Please provide more detailed information, including the table structure and data affected, as well as clarify what exactly is the question.

Re: maintainence view data getting duplicated

suba14 — Tue, 29 Oct 2019 04:24:35 GMT

There is one ztable with 30 fields . for a particular user i need to give access to edit 4 fields alone..i have created a selection Screen to get the particular value in sm30, so that he can edit the particular number. i have created a maintenance view,but while editing the value is getting duplicated.Instead of updation the old value remains additionally my new edited value is also present

Re: maintainence view data getting duplicated

Sandra_Rossi — Tue, 29 Oct 2019 08:26:39 GMT

Can you explain "value is getting duplicated.Instead of updation the old value remains additionally my new edited value is also present"?

I think it's better that you share screenshots before and after, so that to support what you say.

Re: maintainence view data getting duplicated

suba14 — Tue, 29 Oct 2019 10:00:25 GMT

1.png 2.png 3.png

Please find the attached Screen shots

Re: maintainence view data getting duplicated

suba14 — Tue, 29 Oct 2019 10:04:03 GMT

Hi Sathish i have included all the key fields

Re: maintainence view data getting duplicated

suba14 — Tue, 29 Oct 2019 11:55:59 GMT

i need to give write access for few fields only for a particular user alone

Re: maintainence view data getting duplicated

Sandra_Rossi — Tue, 29 Oct 2019 19:23:24 GMT

Thank you. It looks like as you said, a duplicate line, which is normally impossible. So, you did something weird, but I can't say what it can be.

Either your table, maintenance view or generated table maintenance dialog are not "aligned" (example: you have done everything and then you added a column to the table without regenerating everything), or you have hidden key fields with a GUID or something like that.

If you want us to help you, you should show every concerned object. If you want to find by yourself, I advise you to recreate/regenerate all objects from scratch, except the table.

Re: maintainence view data getting duplicated

DoanManhQuynh — Wed, 30 Oct 2019 01:25:07 GMT

May you check if any of your key field have conversion routine too.

Re: maintainence view data getting duplicated

suba14 — Wed, 30 Oct 2019 03:42:55 GMT

Hi Sandra could you please help me with the step by step procedure please