hwo to create a custom table

[Former Member]

Dear Freinds,

I have four fields in my custom table....first field is key field and second one is non key (text descritpion of first field) , third fields is key field and fourth is again

as text field non key..

Field Data element

MANDT MANDT

ZZFAART FACHR (primary key)

FRTXT ZZFRTXT (char50)

ZZORGCODE ZZORGCODE (char10)

ZZORGTXT ZORGTXT (char60)

now when we are enteing from SM30 ... my requirement as per functional is

i have to make zzfaart field as primary key......... i have made it since that is first field.

now he wants zzorgcode as also primary key......... as per the table condtion i cannot

give zzorgcode as primary key as all the key fields should be in order..........but the functional say he wants in third place only............he saying we can see so many place in confiugration's in spro....where

when we enter first field the second field (text ) will be automatically populated.......

(this point iam able to do....) and the third field will be primary key...

however iam not able to do is to make the zzorgcode as primary key ............as he wants that tobe grated out as well once we enter the value and he wants it to make primary key so that no duplicates can be entered.

Please let me know how to do this point....

Regards

Syamala

[Former Member · Accepted solution]

As a principal, all key fields will come before non-key fields.

Regards,

Rajesh Banka

Reward suitable points.

• How to give points: Mark your thread as a question while creating it. In the answers you get, you can assign the points by clicking on the stars to the left. You also get a point yourself for rewarding (one per thread).