topic Multiple Key fields in the Z-table in Application Development and Automation Discussions

Multiple Key fields in the Z-table

former_member632458 — Tue, 10 Mar 2009 05:16:59 GMT

Hi all,

In the Z table the fields are Serial No , Customer Code, Credit limit Additonal Credit limit,

in that my User requires :

Sno Customer Code Creditlimit Addtional

1 10001 2000 2100

2 10001 1000 1010

1 10010 2012 25400

2 10010 1451 1524

1 10002 2312 2500

1 10020 4152 4500

1 10025 1245 2456

Like above shown for each Customer they need to give serial No from 1. i have defined serial no as primary key in the beginning now am attempting to give Customer Code also as Primary Key,

its not working.

Could you please tell me how to handle this scenario.

Thanks ,

rajesh S.

Re: Multiple Key fields in the Z-table

Former Member — Tue, 10 Mar 2009 05:21:05 GMT

Hello

Re: Multiple Key fields in the Z-table

Former Member — Tue, 10 Mar 2009 05:21:40 GMT

Hi,

Make the Customer Code as first field in the table and then Sno as second field. Try now this should work.

Re: Multiple Key fields in the Z-table

Former Member — Tue, 10 Mar 2009 05:50:47 GMT

HI,

See this link:

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9f1f35c111d1829f0000e829fbfe/frameset.htm

Re: Multiple Key fields in the Z-table

Former Member — Tue, 10 Mar 2009 05:52:11 GMT

Hi,

For this Go to SE14 ie Data Base Utility and adjust data base and activate it will work....

Thanks

Re: Multiple Key fields in the Z-table

Former Member — Tue, 10 Mar 2009 07:23:42 GMT

Hi,

You add the filed as primary key, put all the key fields as first fields of the table and then ad the additionla field afterwords,

once it is done go to utility->database object-/ database utility.

say active and adjust database with save data rbutton clicked.

and after that u activate ur table, it will work.

Regards

Rajendra

Re: Multiple Key fields in the Z-table

former_member632458 — Tue, 10 Mar 2009 07:57:54 GMT

Th problem is resolved with the help of Mr.Avinash's Reply.

Thankyou one & all.

Regards,

rajesh S.