please let me know who create a custom as ..

[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]

Hi,

Key fields should be all together at start of the table.

Change the key (by changing the order) or maintain two tables.

Regards,

Srilatha.

[Former Member]

Dear,

Sri i have done the same , but the my functional has change and given

me that

order as

one key and one text

one key and one text.

so i cannot give in order........please could you elaborate more for thepoint you

have said maintain two tables.

please let me know what exactly you mean to say......... i have to deliver now

could you please give me in more clear steps what exactly i have to do.......

if i maintain in two tables how do i join.

please tell me clearly it would great help for me. it would kind enough if you give me

step by step.....how exactly i can solve my problem

my requiremnt is .................i have total four fields in my custom table

(A) key feild (B) non-key field(text) (c) key field (D)non-key field(text)

so if the user enters in first key field ........ i made through coding that non-key field(B) (text) will be filled automatically it is working ,

now my problem is when the user enters the third field i.e (c) key field manually .........this should also be made as key field .

Please help me

thanks in advance

for your help

regards

syamla

[Clemenss]

Hi syamala,

as already said: The key fields are always the first fields of a table. No way to change this.

But the display of fields in maintenance dialog may be changed by the user. After generating your maintenance dialog you can modify the screen rearranging your columns.

Regards,

Clemens

[Former Member]

Hi,

Do one thing. In the table maintenance generated screen, Modify that screen layout. Put the first as key field, and darg the text of the taht particular field to the second postion. you just adjust the screen with the required format through screen painter or se80.

regards,