how to construct the custom table as per below

[Former Member]

Dear Freinds,

i had same problem in my system when ever iam crateing a custom table or enhancing any infotype........thank your for giving me the soultion for this warning.

but i have one more question to you.

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]

Hello

one thing you can do is have two seperate master table

first containing

MANDT MANDT

ZZFAART FACHR (primary key)

FRTXT ZZFRTXT (char50)

and second containing

MANDT MANDT

ZZFAART FACHR (primary key) (check table above one)

ZZORGCODE ZZORGCODE (char10) (primary key)

ZZORGTXT ZORGTXT (char60)

and attach a search help from first table to second table for ZZFART so that while selecting ZZFART by f4 its text also will be displayed.

note in ztable you need not start fieldnames with zz.

if you still want single table then you will have to make frtxt as key field or make frtxt as 4th field below zzorgcode ( a bad idea make frtxt also a primary key. not recommended).

if you make orgcode as primary key it will automatically greyed out once u save the entry.

hope this helps you reward points if helpful