Multiple Key fields in the Z-table

[former_member632458]

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.

[former_member632458]

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.

[Former Member]

Hello

[Former Member]

Hi,

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

[Former Member]

HI,

See this link:

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

[Former Member]

Hi,

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

Thanks

[Former Member]

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]

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

Thankyou one & all.

Regards,

rajesh S.