Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple Key fields in the Z-table

former_member632458
Participant
0 Kudos
395

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.

6 REPLIES 6

Former Member
0 Kudos
88

Hello

Former Member
0 Kudos
88

Hi,

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

Former Member

Former Member
0 Kudos
88

Hi,

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

Thanks

Former Member
0 Kudos
88

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

former_member632458
Participant
0 Kudos
88

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

Thankyou one & all.

Regards,

rajesh S.