topic Re: table maintanace in Application Development and Automation Discussions

table maintanace

Former Member — Fri, 18 Jan 2008 12:23:52 GMT

i have create one Z table in that i have 3 fileds .

whenever user insert the data 2 fileds data should be unique.

the table i have created as below .

Z_CABJN Z_VBELN Z_POSNR

x 1000 10

y 1000 20

z 1000 30

my table shou not accept

x 1000 40

for ever change of Z_VBELN / Z_POSNR i sholud have new

Z_CABJN.

Re: table maintanace

Former Member — Fri, 18 Jan 2008 12:40:18 GMT

hi Purva Kathuria ,

you can do one thing make the two fields as primary key then your problem will solved

Regards,

sree.....

Reward points if help full

Re: table maintanace

Former Member — Fri, 18 Jan 2008 12:41:51 GMT

Hi Purva,

Hi,

Go to SE11 enter table name ->change

Utilities-> Table Maintenance Generator

delete the Table maintenance by pressing delete button on menu,

then start creating it again.

Enter Auth.Group as &NC&

Enter function group < some name>

Maintenance Type -> One step

Overview screen -> some Number (1 or 2)

Press create

enter dev class and save, activate.

Go to SM 30 and check again.

kindly reward if found helpful.

cheers,

Hema.

Re: table maintanace

Former Member — Fri, 18 Jan 2008 14:09:11 GMT

Hi Purva Kathuria,

Your question is not so clear, as i understood you need the following.

The entries in fields Z_CABJN, Z_POSNR should be unique.

If it is so, below is the answer.

Mark the fields Z_CABJN Z_POSNR as primary key.

So that the entries in those fields will be unique.

I think this is the correct answer to your question.

If, don't forget to reward.

Regards,

Balaram

Re: table maintanace

Former Member — Fri, 18 Jan 2008 18:05:06 GMT

hi purva,

If u want any fields as unique, then make those fields as primary fields.

To make a field as primary, just click on the check box beside to the field name in the ztable.

regards.

shashikanth naram.

Re: table maintanace

Former Member — Fri, 18 Jan 2008 18:12:14 GMT

You can create a secondary index on just those two fields and specify that it is a unique undex.

Rob

Re: table maintanace

Former Member — Mon, 21 Jan 2008 06:26:26 GMT

Dear Purva,

Make Z_CABJN and A_POSNR as Primary keys and then use MODIFY statement. If the user makes an entry and if it doesnt exist then it will make a new entry in the database table and if it already exists then it will modify the existing entry.

Regards,

Tejomayi.